External Lookup
Overview
The External Lookup subject area is used to manage reference values that originate from external systems but are required within the application for processing. It provides a mechanism to store and map external codes or identifiers, such as payment codes, status values, or classification types, to their corresponding internal values used by the system. Each external lookup record typically contains the external system name, the external value, the mapped internal value, and effective dates.
Conforming Layers
The only conforming layer of this subject is F1_EXT_LOOKUP_OBJ.
F1_EXT_LOOKUP_OBJ
| Column | Description | Data Type | Data Length |
|---|---|---|---|
| BUS_OBJ_CD | Business object code which this external lookup value applies. | VARCHAR | 30 |
| F1_EXT_LOOKUP_VALUE | External lookup value used by integrations or rules to map external codes to internal meanings. | VARCHAR | 254 |
| F1_EXT_LOOKUP_USAGE_FLG | Indicator of the usage or applicability of the external lookup value. | VARCHAR | 4 |
| BO_DATA_AREA | Serialized business object data associated with the lookup value for workflow or technical context. | VARCHAR | 254 |
| BASE_BO_DATA_AREA | Serialized data for the base business object context of the lookup value that is used internally for inheritance or defaults. | VARCHAR | 254 |
| DESCR | Description for the external lookup value displayed in UIs and reports. | VARCHAR | 60 |
| DESCR_OVRD | Override description that supersedes the base description when provided. | VARCHAR | 60 |
| DESCRLONG | Extended free-text description giving detailed context or guidance for the lookup value. | VARCHAR | 4000 |
| CDC_FLAG | Type of data change captured in the record during the Change Data Capture (CDC) process. | VARCHAR | 1 |
| CDC_LOAD_DTTM | Date and time when the record was loaded into the system through the Change Data Capture (CDC) process. | TIMESTAMP | |
| CREATE_DTTM | Date and time when the record was created in the system. | TIMESTAMP | |
| UPDATE_DTTM | Date and time when the record was last updated. | TIMESTAMP | |
| COMPOSITE_KEY | Unique identifier in the BUS_OBJ_CD | F1_EXT_LOOKUP_VALUE format. This is the primary key. |
VARCHAR | 300 |