Manufacturer Maintenance

Manufacturer data is maintained from the CAWIS Admin menu, however the full list of data sources for manufacturer data is available at : Manufacturer/Model Tables, Data Sources and Usage

Options :

1. query manufacturer

2. modify manufacturer

3. delete manufacturer

4. Add new manufacturer

1. Query Manufacturer - enter full or partial manufacturer name then select from list

2. Modify manufacturer - The Inspectors occasionally update a manufacturer spelling, or country. A spelling change requires that the auto-correct tables be updated first. All instances of the old spelling of that manufacturer need to be updated on Z980 in the To_txt column. A future enhancement should auto-update the TO_txt column to the new manufacturer value, without having the user enter the Term Conversion module.

3. Delete manufacturer - this works well for “new” entries made in error, but raises an exception for manufacturers in use on any table but Y60. This function is rarely used

4. Add new manufacturer

Fill in the form as seen above - Note: Legal name is not used or viewed anywhere in CAWIS, and is generally filled in with common-name.

If the manufacturer being entered exists in the from_txt of the Z980_term_conversion tables, but points to another existing manufacturer, this page will raise a “duplicate” error. When this occures, go to the Term_conversion module, and either :

a) delete all instances of the desired “new manufacturer” in the from_txt or

b) update all instances of the To_txt to the “new manufacturer” where that value exists in “From_txt”

Note: there is always one row on Z980 where from_txt = to_txt for each manufacturer listed on y60

Then simply return to the manufacturer module and enter the new manufacturer, as desired.