In order to bring you the best possible user experience, this site uses Javascript. If you are seeing this message, it is likely that the Javascript option in your browser is disabled. For optimal viewing of this site, please ensure that Javascript is enabled for your browser.
Login  |   On Demand  |   Home  |   qad.com




Establishing Generalized Codes
When you install a new database, a number of system and reference fields accept any kind of data, as long as it does not exceed the field length. You can customize the user interface by adding generalized codes and lookups.
Before implementing a module or a particular functional area, the implementation team should determine which fields should have generalized codes and lookups.
Generalized codes are domain specific since these codes may vary widely based on the type and location of the business operation. For example, customer types, sales distribution channels, and buyer/planner codes could differ between a domain representing a business in England and one in Germany.
Important: Some programs that update system-wide data such as User Maintenance (36.3.1) reference generalized codes. These generalized codes must exist in all domains or you may encounter errors editing a user record depending on what your current working domain is.
When using generalized codes, you can control three different conditions:
What the acceptable values in a field are. Define these values in Generalized Codes Maintenance (36.2.13).
Whether a list of acceptable values displays in a look-up browse on the field. Specify this in Drill Down/Lookup Maintenance (36.20.1).
Whether the codes you have created are the only acceptable codes (that is, whether the list is validated). This may require you to add a validation expression to the data dictionary. See Adding Validation.