DW_EB_X_EBS_COMMON_W_CONTRACT_LINE_D
Imported from database
Details
Module: Common Tables (EBS_COMMON)
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 | |||
| AT_RISK_FLG | VARCHAR2 | 100 CHAR | ||||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| AUX2_CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| AUX3_CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| AUX4_CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| CHANGED_BY_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_USER_D | |||
| CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| CONTRACT_HEADER_ID | VARCHAR2 | 100 CHAR | ||||
| CONTRACT_LINE_DESC | VARCHAR2 | 100 CHAR | ||||
| CONTRACT_LINE_END_DT | TIMESTAMP | 6 | ||||
| CONTRACT_LINE_ID | VARCHAR2 | 100 CHAR | ||||
| CONTRACT_LINE_NUM | VARCHAR2 | 100 CHAR | ||||
| CONTRACT_LINE_START_DT | TIMESTAMP | 6 | ||||
| CONTRACT_LINE_STATUS_CODE | VARCHAR2 | 100 CHAR | ||||
| CONTRACT_LINE_STATUS_NAME | VARCHAR2 | 100 CHAR | ||||
| CONTRACT_LINE_TYPE_CODE | VARCHAR2 | 100 CHAR | ||||
| CREATED_BY_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_USER_D | |||
| CREATED_ON_DT | TIMESTAMP | 6 | ||||
| DELETE_FLG | VARCHAR2 | 100 CHAR | ||||
| ETL_PROC_WID | NUMBER | 38 | ||||
| INTEGRATION_ID | VARCHAR2 | 100 CHAR | ||||
| INTER_COMPANY_FLG | VARCHAR2 | 100 CHAR | ||||
| INTER_PROJECT_FLG | VARCHAR2 | 100 CHAR | ||||
| INVOICE_LIMIT_FLG | VARCHAR2 | 100 CHAR | ||||
| PROJECT_CONTRACT_FLG | VARCHAR2 | 100 CHAR | ||||
| REVENUE_LIMIT_FLG | VARCHAR2 | 100 CHAR | ||||
| ROW_WID | NUMBER | 38 | ||||
| TENANT_ID | VARCHAR2 | 100 CHAR | ||||
| UOM_CODE | VARCHAR2 | 100 CHAR | ||||
| W_CONTRACT_LINE_STATUS_CODE | VARCHAR2 | 100 CHAR | ||||
| W_CONTRACT_RECORD_TYPE | VARCHAR2 | 100 CHAR | ||||
| W_INSERT_DT | TIMESTAMP | 6 | ||||
| W_UPDATE_DT | TIMESTAMP | 6 | ||||
| X_CUSTOM | VARCHAR2 | 100 CHAR | ||||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |