Lookup - Main
Select Admin > Database > Lookup to maintain lookup values.
Use the Lookup Query portal to search for an existing lookup. Once a lookup is selected, you are brought to the maintenance portal to view and maintain the selected record.
Description of Page
Field Name is the name of the field whose lookup values are maintained in the grid. If you need to add a new lookup field, you must first add the lookup field here, then navigate to the Field page to create a field with a data type of Character and an extended data type of Flag.
Owner indicates if this lookup field is owned by the base package or by your implementation (Customer Modification). This information is display-only.
Custom switch is used to indicate whether you are allowed to add valid values for a lookup field whose owner is not Customer Modification.
• If this switch is turned on, you may add new values to the grid for system owned lookup fields.
• If this switch is turned off, you may not add, remove or change any of the values for system owned lookup fields, with the exception of the override description.
This field is always protected for system owned lookup fields because you may not change a field from customizable to non-customizable (or vice versa).
Java Field Name indicates the name of the field as it is referenced in Java code.
The grid contains the lookup values for a specific field. The following fields are visible:
Field Value is the unique identifier of the lookup value. If you add a new value, it must begin with an X or Y (in order to allow future upgrades to differentiate between your implementation-specific values and base-package values).
Description is the name of the lookup value that appears on the various transactions in the system
Java Value Name indicates the unique identifier of the lookup value as it is referenced in Java code.
Status indicates if the value is Active or Inactive. The system does not allow Inactive values to be used (the reason we allow Inactive values is to support historical data that references a value that is no longer valid).
Detailed Description is the detailed description for a lookup value, which is provided in certain cases.
Override Description is provided if your implementation wishes to override the description of the value provided by the product.
Owner indicates if this lookup value is owned by the base package or by your implementation (Customer Modification). The system sets the owner to Customer Modification when you add lookup values to a field. This information is display-only.