DW_EB_X_EBS_COMMON_W_CONTRACT_LINE_D_TL
Stores language-specific descriptive attributes for contract lines.
Details
Module: Common Tables (EBS_COMMON)
Business Name: Contract Line Translation Dimension
Key Columns
Key column information is not documented in the supplied metadata.
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table |
|---|---|---|---|---|---|---|
| DATASOURCE_NUM_ID | NUMBER | 38 | True | Identifier of the source system from which the record was extracted. | ||
| SOURCE_RECORD_ID | VARCHAR2 | 38 CHAR | Identifier of the record in the source system. | |||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | Last modification date and time of auxiliary source record 1 used by the ETL process. | |||
| AUX2_CHANGED_ON_DT | TIMESTAMP | 6 | Last modification date and time of auxiliary source record 2 used by the ETL process. | |||
| AUX3_CHANGED_ON_DT | TIMESTAMP | 6 | Last modification date and time of auxiliary source record 3 used by the ETL process. | |||
| AUX4_CHANGED_ON_DT | TIMESTAMP | 6 | Last modification date and time of auxiliary source record 4 used by the ETL process. | |||
| CHANGED_BY_ID | VARCHAR2 | 100 CHAR | Identifier of the user or process that last changed the record. | |||
| CHANGED_ON_DT | TIMESTAMP | 6 | Date and time when the record was last changed. | |||
| CONTRACT_LINE_DESCR | VARCHAR2 | 100 CHAR | ||||
| CONTRACT_LINE_NAME | VARCHAR2 | 100 CHAR | ||||
| CREATED_BY_ID | VARCHAR2 | 100 CHAR | Identifier of the user or process that created the record. | |||
| CREATED_ON_DT | TIMESTAMP | 6 | Date and time when the record was created. | |||
| ETL_PROC_WID | NUMBER | 38 | Warehouse identifier of the ETL process that loaded the record. | |||
| INTEGRATION_ID | VARCHAR2 | 100 CHAR | Unique identifier of the record in the source system; it may contain concatenated values for composite keys. | |||
| LANGUAGE_CODE | VARCHAR2 | 100 CHAR | Code identifying the language in which translated attributes are stored. | |||
| ROW_WID | NUMBER | 38 | Warehouse-generated surrogate key that uniquely identifies the record. | |||
| SRC_LANGUAGE_CODE | VARCHAR2 | 100 CHAR | Code identifying the original language of the source record. | |||
| TENANT_ID | VARCHAR2 | 100 CHAR | Identifier of the tenant associated with the record. | |||
| W_INSERT_DT | TIMESTAMP | 6 | ||||
| W_UPDATE_DT | TIMESTAMP | 6 | ||||
| X_CUSTOM | VARCHAR2 | 100 CHAR |