DW_EB_X_EBS_COMMON_W_PARTY_ORG_DH
Party Organization Dimension Hierachy Table
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 | 10 | Data Source Number | |||
| INTEGRATION_ID | VARCHAR2 | 80 CHAR | Integration Id | |||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | Auxillary Chnaged on date | |||
| AUX2_CHANGED_ON_DT | TIMESTAMP | 6 | Auxillary Chnaged on date | |||
| AUX3_CHANGED_ON_DT | TIMESTAMP | 6 | Auxillary Chnaged On date | |||
| AUX4_CHANGED_ON_DT | TIMESTAMP | 6 | Auxillary changed on date | |||
| BASE_LVL_ACCNT_LOC | VARCHAR2 | 250 CHAR | Basic Level Party Account Location | |||
| BASE_LVL_NAMED_ACCT_FLG | VARCHAR2 | 1 CHAR | Is Basic Level Party a Named Account? | |||
| BASE_LVL_PARTY_ID | VARCHAR2 | 80 CHAR | Base Level Party Id | |||
| BASE_LVL_PARTY_NAME | VARCHAR2 | 360 CHAR | Base Level Party Name | |||
| BASE_LVL_SALES_ACCNT_FLG | VARCHAR2 | 1 CHAR | Is Basic Level Party a Sales Account? | |||
| BASE_LVL_SALES_ACCNT_TYPE_CODE | VARCHAR2 | 80 CHAR | Base Level Sales Account Type Code | |||
| CHANGED_BY_WID | NUMBER | 38 | Changed user id | |||
| CHANGED_ON_DT | TIMESTAMP | 6 | Changed on date | |||
| CREATED_BY_WID | NUMBER | 38 | Creator User Id | |||
| CREATED_ON_DT | TIMESTAMP | 6 | Creation date | |||
| DELETE_FLG | VARCHAR2 | 1 CHAR | can this record be deleted? | |||
| EFFECTIVE_FROM_DT | TIMESTAMP | 6 | Effective from date | |||
| EFFECTIVE_TO_DT | TIMESTAMP | 6 | Effective to date | |||
| ETL_PROC_WID | NUMBER | 38 | ETL Process Id | |||
| FIXED_HIER_LEVEL | NUMBER | 10 | Fixed Hierarchy Level | |||
| LVL1ANC_ACCNT_LOC | VARCHAR2 | 250 CHAR | Account Unique Name at Level 1 of an account hierarchy | |||
| LVL1_NAMED_ACCT_FLG | VARCHAR2 | 1 CHAR | Is Level 1 Party a Named Account? | |||
| LVL1_PARTY_ID | VARCHAR2 | 80 CHAR | Party Organization Dimension Hierarchy table | |||
| LVL1_PARTY_NAME | VARCHAR2 | 360 CHAR | Name of account at Level1 of an account hierarchy | |||
| LVL1_SALES_ACCNT_FLG | VARCHAR2 | 1 CHAR | Is Level1 Party a Sales Account? | |||
| LVL1_SALES_ACCNT_TYPE_CODE | VARCHAR2 | 80 CHAR | Level 1 Sales Account Type Code | |||
| LVL2ANC_ACCNT_LOC | VARCHAR2 | 250 CHAR | Account Unique Name at Level 2 of an account hierarchy | |||
| LVL2_NAMED_ACCT_FLG | VARCHAR2 | 1 CHAR | Is Level 2 Party a Named Account? | |||
| LVL2_PARTY_ID | VARCHAR2 | 80 CHAR | Id of account at Level 2 of an account hierarchy | |||
| LVL2_PARTY_NAME | VARCHAR2 | 360 CHAR | Name of account at Level2 of an account hierarchy | |||
| LVL2_SALES_ACCNT_FLG | VARCHAR2 | 1 CHAR | Is Level 2 Party a Sales Account? | |||
| LVL2_SALES_ACCNT_TYPE_CODE | VARCHAR2 | 80 CHAR | Level 2 Sales Account Type Code | |||
| LVL3ANC_ACCNT_LOC | VARCHAR2 | 250 CHAR | Account Unique Name at Level 3 of an account hierarchy | |||
| LVL3_NAMED_ACCT_FLG | VARCHAR2 | 1 CHAR | Is Level 3 Party a Named Account? | |||
| LVL3_PARTY_ID | VARCHAR2 | 80 CHAR | Id of account at Level 3 of an account hierarchy | |||
| LVL3_PARTY_NAME | VARCHAR2 | 360 CHAR | Name of account at Level 3 of an account hierarchy | |||
| LVL3_SALES_ACCNT_FLG | VARCHAR2 | 1 CHAR | Is Level 3 Party a Sales Account? | |||
| LVL3_SALES_ACCNT_TYPE_CODE | VARCHAR2 | 80 CHAR | Level 3 Sales Account Type Code | |||
| LVL4ANC_ACCNT_LOC | VARCHAR2 | 250 CHAR | Account Unique Name at Level 4 of an account hierarchy | |||
| LVL4_NAMED_ACCT_FLG | VARCHAR2 | 1 CHAR | Is Level 4 Party a Named Account? | |||
| LVL4_PARTY_ID | VARCHAR2 | 80 CHAR | Id of account at Level 4 of an account hierarchy | |||
| LVL4_PARTY_NAME | VARCHAR2 | 360 CHAR | Name of account at Level 3 of an account hierarchy | |||
| LVL4_SALES_ACCNT_FLG | VARCHAR2 | 1 CHAR | Is Level 4 Party a Sales Account? | |||
| LVL4_SALES_ACCNT_TYPE_CODE | VARCHAR2 | 80 CHAR | Level 4 Sales Account Type Code | |||
| LVL5ANC_ACCNT_LOC | VARCHAR2 | 250 CHAR | Account Unique Name at Level 5 of an account hierarchy | |||
| LVL5_NAMED_ACCT_FLG | VARCHAR2 | 1 CHAR | Is Level 5 Party a Named Account? | |||
| LVL5_PARTY_ID | VARCHAR2 | 80 CHAR | Id of account at Level 5 of an account hierarchy | |||
| LVL5_PARTY_NAME | VARCHAR2 | 360 CHAR | Name of account at Level 5 of an account hierarchy | |||
| LVL5_SALES_ACCNT_FLG | VARCHAR2 | 1 CHAR | Is Level 5 Party a Sales Account? | |||
| LVL5_SALES_ACCNT_TYPE_CODE | VARCHAR2 | 80 CHAR | Level 5 Sales Account Type Code | |||
| LVL6ANC_ACCNT_LOC | VARCHAR2 | 250 CHAR | Account Unique Name at Level 6 of an account hierarchy | |||
| LVL6_NAMED_ACCT_FLG | VARCHAR2 | 1 CHAR | Is Level 6 Party a Named Account? | |||
| LVL6_PARTY_ID | VARCHAR2 | 80 CHAR | Id of account at Level 6 of an account hierarchy | |||
| LVL6_PARTY_NAME | VARCHAR2 | 360 CHAR | Name of account at Level 6 of an account hierarchy | |||
| LVL6_SALES_ACCNT_FLG | VARCHAR2 | 1 CHAR | Is Level 6 Party a Sales Account? | |||
| LVL6_SALES_ACCNT_TYPE_CODE | VARCHAR2 | 80 CHAR | Level 6 Sales Account Type Code | |||
| LVL7ANC_ACCNT_LOC | VARCHAR2 | 250 CHAR | Account Unique Name at Level 7 of an account hierarchy | |||
| LVL7_NAMED_ACCT_FLG | VARCHAR2 | 1 CHAR | Is Level 7 Party a Named Account? | |||
| LVL7_PARTY_ID | VARCHAR2 | 80 CHAR | Id of account at Level 7 of an account hierarchy | |||
| LVL7_PARTY_NAME | VARCHAR2 | 360 CHAR | Name of account at Level 7 of an account hierarchy | |||
| LVL7_SALES_ACCNT_FLG | VARCHAR2 | 1 CHAR | Is Level 7 Party a Sales Account? | |||
| LVL7_SALES_ACCNT_TYPE_CODE | VARCHAR2 | 80 CHAR | Level 7 Sales Account Type Code | |||
| LVL8ANC_ACCNT_LOC | VARCHAR2 | 250 CHAR | Account Unique Name at Level 8 of an account hierarchy | |||
| LVL8_NAMED_ACCT_FLG | VARCHAR2 | 1 CHAR | Is Level 8 Party a Named Account? | |||
| LVL8_PARTY_ID | VARCHAR2 | 80 CHAR | Id of account at Level 8 of an account hierarchy | |||
| LVL8_PARTY_NAME | VARCHAR2 | 360 CHAR | Name of account at Level 8 of an account hierarchy | |||
| LVL8_SALES_ACCNT_FLG | VARCHAR2 | 1 CHAR | Is Level 8 Party a Sales Account? | |||
| LVL8_SALES_ACCNT_TYPE_CODE | VARCHAR2 | 80 CHAR | Level 8 Sales Account Type Code | |||
| ROW_WID | NUMBER | 38 | Row Id | |||
| SRC_EFF_FROM_DT | TIMESTAMP | 6 | Source effective from date | |||
| SRC_EFF_TO_DT | TIMESTAMP | 6 | Source effective to date | |||
| TENANT_ID | VARCHAR2 | 80 CHAR | Tenant Id | |||
| TOP_LVL_ACCNT_LOC | VARCHAR2 | 250 CHAR | Top Level Party Account Location | |||
| TOP_LVL_NAMED_ACCT_FLG | VARCHAR2 | 1 CHAR | Is Top Level Party a Named Account? | |||
| TOP_LVL_PARTY_ID | VARCHAR2 | 80 CHAR | Id of account at Top Level of an account hierarchy | |||
| TOP_LVL_PARTY_NAME | VARCHAR2 | 360 CHAR | Name of account at Top Level of an account hierarchy | |||
| TOP_LVL_SALES_ACCNT_FLG | VARCHAR2 | 1 CHAR | Is Top Level Party a Sales Account? | |||
| TOP_LVL_SALES_ACCNT_TYPE_CODE | VARCHAR2 | 80 CHAR | Top Level Sales Account Type Code | |||
| X_CUSTOM | VARCHAR2 | 10 CHAR | Customized column | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |