DW_EB_X_EBS_PR_W_CST_COST_ORG_BOOK_D
Has the cost organization, cost book code based on the definitions above. For a given cost org, one cost book is set as the primary book
Details
Module: Profitability (EBS_PR)
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 | 10 | ||||
| INTEGRATION_ID | VARCHAR2 | 80 CHAR | ||||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| AUX2_CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| AUX3_CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| CHANGED_BY_WID | NUMBER | 38 | ||||
| CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| COST_BOOK_CODE | VARCHAR2 | 50 CHAR | ||||
| COST_ORG_ID | VARCHAR2 | 100 CHAR | ||||
| CREATED_BY_WID | NUMBER | 38 | ||||
| CREATED_ON_DT | TIMESTAMP | 6 | ||||
| CURRENT_FLG | VARCHAR2 | 1 CHAR | ||||
| DELETE_FLG | VARCHAR2 | 1 CHAR | ||||
| EFFECTIVE_FROM_DT | TIMESTAMP | 6 | ||||
| EFFECTIVE_TO_DT | TIMESTAMP | 6 | ||||
| ETL_PROC_WID | NUMBER | 38 | ||||
| PRIMARY_BOOK_FLG | VARCHAR2 | 1 CHAR | ||||
| ROW_WID | NUMBER | 38 | ||||
| TENANT_ID | VARCHAR2 | 80 CHAR | ||||
| X_CUSTOM | VARCHAR2 | 10 CHAR | ||||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |