DW_EB_X_EBS_COMMON_W_PARTY_ORG_ADDL_ATTR_D
No table description is available in the supplied metadata.
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 | 22 | DATASOURCE_NUM_ID | |||
| INTEGRATION_ID | VARCHAR2 | 80 CHAR | INTEGRATION_ID | |||
| SCD1_WID | NUMBER | 38 | SCD1_WID | DW_EB_X_EBS_COMMON_W_PARTY_ORG_D | ||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | AUX1_CHANGED_ON_DT | |||
| AUX2_CHANGED_ON_DT | TIMESTAMP | 6 | AUX2_CHANGED_ON_DT | |||
| AUX3_CHANGED_ON_DT | TIMESTAMP | 6 | AUX3_CHANGED_ON_DT | |||
| AUX4_CHANGED_ON_DT | TIMESTAMP | 6 | AUX4_CHANGED_ON_DT | |||
| CHANGED_BY_WID | NUMBER | 38 | CHANGED_BY_WID | |||
| CHANGED_ON_DT | TIMESTAMP | 6 | CHANGED_ON_DT | |||
| CREATED_BY_WID | NUMBER | 38 | CREATED_BY_WID | |||
| CREATED_ON_DT | TIMESTAMP | 6 | CREATED_ON_DT | |||
| ETL_PROC_WID | NUMBER | 38 | ETL_PROC_WID | |||
| PARTY_ORG_ATTR10_CHAR | VARCHAR2 | 255 CHAR | PARTY_ORG_ATTR10_CHAR | |||
| PARTY_ORG_ATTR10_DATE | TIMESTAMP | 6 | PARTY_ORG_ATTR10_DATE | |||
| PARTY_ORG_ATTR10_NUM | NUMBER | 22,4 | PARTY_ORG_ATTR10_NUM | |||
| PARTY_ORG_ATTR11_CHAR | VARCHAR2 | 255 CHAR | PARTY_ORG_ATTR11_CHAR | |||
| PARTY_ORG_ATTR11_NUM | NUMBER | 22,4 | PARTY_ORG_ATTR11_NUM | |||
| PARTY_ORG_ATTR12_CHAR | VARCHAR2 | 255 CHAR | PARTY_ORG_ATTR12_CHAR | |||
| PARTY_ORG_ATTR12_NUM | NUMBER | 22,4 | PARTY_ORG_ATTR12_NUM | |||
| PARTY_ORG_ATTR13_CHAR | VARCHAR2 | 255 CHAR | PARTY_ORG_ATTR13_CHAR | |||
| PARTY_ORG_ATTR13_NUM | NUMBER | 22,4 | PARTY_ORG_ATTR13_NUM | |||
| PARTY_ORG_ATTR14_CHAR | VARCHAR2 | 255 CHAR | PARTY_ORG_ATTR14_CHAR | |||
| PARTY_ORG_ATTR14_NUM | NUMBER | 22,4 | PARTY_ORG_ATTR14_NUM | |||
| PARTY_ORG_ATTR15_CHAR | VARCHAR2 | 255 CHAR | PARTY_ORG_ATTR15_CHAR | |||
| PARTY_ORG_ATTR15_NUM | NUMBER | 22,4 | PARTY_ORG_ATTR15_NUM | |||
| PARTY_ORG_ATTR16_CHAR | VARCHAR2 | 255 CHAR | PARTY_ORG_ATTR16_CHAR | |||
| PARTY_ORG_ATTR16_NUM | NUMBER | 22,4 | PARTY_ORG_ATTR16_NUM | |||
| PARTY_ORG_ATTR17_CHAR | VARCHAR2 | 255 CHAR | PARTY_ORG_ATTR17_CHAR | |||
| PARTY_ORG_ATTR17_NUM | NUMBER | 22,4 | PARTY_ORG_ATTR17_NUM | |||
| PARTY_ORG_ATTR18_CHAR | VARCHAR2 | 255 CHAR | PARTY_ORG_ATTR18_CHAR | |||
| PARTY_ORG_ATTR18_NUM | NUMBER | 22,4 | PARTY_ORG_ATTR18_NUM | |||
| PARTY_ORG_ATTR19_CHAR | VARCHAR2 | 255 CHAR | PARTY_ORG_ATTR19_CHAR | |||
| PARTY_ORG_ATTR19_NUM | NUMBER | 22,4 | PARTY_ORG_ATTR19_NUM | |||
| PARTY_ORG_ATTR1_CHAR | VARCHAR2 | 255 CHAR | PARTY_ORG_ATTR1_CHAR | |||
| PARTY_ORG_ATTR1_DATE | TIMESTAMP | 6 | PARTY_ORG_ATTR1_DATE | |||
| PARTY_ORG_ATTR1_NUM | NUMBER | 22,4 | PARTY_ORG_ATTR1_NUM | |||
| PARTY_ORG_ATTR20_CHAR | VARCHAR2 | 255 CHAR | PARTY_ORG_ATTR20_CHAR | |||
| PARTY_ORG_ATTR20_NUM | NUMBER | 22,4 | PARTY_ORG_ATTR20_NUM | |||
| PARTY_ORG_ATTR21_CHAR | VARCHAR2 | 255 CHAR | PARTY_ORG_ATTR21_CHAR | |||
| PARTY_ORG_ATTR22_CHAR | VARCHAR2 | 255 CHAR | PARTY_ORG_ATTR22_CHAR | |||
| PARTY_ORG_ATTR23_CHAR | VARCHAR2 | 255 CHAR | PARTY_ORG_ATTR23_CHAR | |||
| PARTY_ORG_ATTR24_CHAR | VARCHAR2 | 255 CHAR | PARTY_ORG_ATTR24_CHAR | |||
| PARTY_ORG_ATTR25_CHAR | VARCHAR2 | 255 CHAR | PARTY_ORG_ATTR25_CHAR | |||
| PARTY_ORG_ATTR26_CHAR | VARCHAR2 | 255 CHAR | PARTY_ORG_ATTR26_CHAR | |||
| PARTY_ORG_ATTR27_CHAR | VARCHAR2 | 255 CHAR | PARTY_ORG_ATTR27_CHAR | |||
| PARTY_ORG_ATTR28_CHAR | VARCHAR2 | 255 CHAR | PARTY_ORG_ATTR28_CHAR | |||
| PARTY_ORG_ATTR29_CHAR | VARCHAR2 | 255 CHAR | PARTY_ORG_ATTR29_CHAR | |||
| PARTY_ORG_ATTR2_CHAR | VARCHAR2 | 255 CHAR | PARTY_ORG_ATTR2_CHAR | |||
| PARTY_ORG_ATTR2_DATE | TIMESTAMP | 6 | PARTY_ORG_ATTR2_DATE | |||
| PARTY_ORG_ATTR2_NUM | NUMBER | 22,4 | PARTY_ORG_ATTR2_NUM | |||
| PARTY_ORG_ATTR30_CHAR | VARCHAR2 | 255 CHAR | PARTY_ORG_ATTR30_CHAR | |||
| PARTY_ORG_ATTR3_CHAR | VARCHAR2 | 255 CHAR | PARTY_ORG_ATTR3_CHAR | |||
| PARTY_ORG_ATTR3_DATE | TIMESTAMP | 6 | PARTY_ORG_ATTR3_DATE | |||
| PARTY_ORG_ATTR3_NUM | NUMBER | 22,4 | PARTY_ORG_ATTR3_NUM | |||
| PARTY_ORG_ATTR4_CHAR | VARCHAR2 | 255 CHAR | PARTY_ORG_ATTR4_CHAR | |||
| PARTY_ORG_ATTR4_DATE | TIMESTAMP | 6 | PARTY_ORG_ATTR4_DATE | |||
| PARTY_ORG_ATTR4_NUM | NUMBER | 22,4 | PARTY_ORG_ATTR4_NUM | |||
| PARTY_ORG_ATTR5_CHAR | VARCHAR2 | 255 CHAR | PARTY_ORG_ATTR5_CHAR | |||
| PARTY_ORG_ATTR5_DATE | TIMESTAMP | 6 | PARTY_ORG_ATTR5_DATE | |||
| PARTY_ORG_ATTR5_NUM | NUMBER | 22,4 | PARTY_ORG_ATTR5_NUM | |||
| PARTY_ORG_ATTR6_CHAR | VARCHAR2 | 255 CHAR | PARTY_ORG_ATTR6_CHAR | |||
| PARTY_ORG_ATTR6_DATE | TIMESTAMP | 6 | PARTY_ORG_ATTR6_DATE | |||
| PARTY_ORG_ATTR6_NUM | NUMBER | 22,4 | PARTY_ORG_ATTR6_NUM | |||
| PARTY_ORG_ATTR7_CHAR | VARCHAR2 | 255 CHAR | PARTY_ORG_ATTR7_CHAR | |||
| PARTY_ORG_ATTR7_DATE | TIMESTAMP | 6 | PARTY_ORG_ATTR7_DATE | |||
| PARTY_ORG_ATTR7_NUM | NUMBER | 22,4 | PARTY_ORG_ATTR7_NUM | |||
| PARTY_ORG_ATTR8_CHAR | VARCHAR2 | 255 CHAR | PARTY_ORG_ATTR8_CHAR | |||
| PARTY_ORG_ATTR8_DATE | TIMESTAMP | 6 | PARTY_ORG_ATTR8_DATE | |||
| PARTY_ORG_ATTR8_NUM | NUMBER | 22,4 | PARTY_ORG_ATTR8_NUM | |||
| PARTY_ORG_ATTR9_CHAR | VARCHAR2 | 255 CHAR | PARTY_ORG_ATTR9_CHAR | |||
| PARTY_ORG_ATTR9_DATE | TIMESTAMP | 6 | PARTY_ORG_ATTR9_DATE | |||
| PARTY_ORG_ATTR9_NUM | NUMBER | 22,4 | PARTY_ORG_ATTR9_NUM | |||
| SRC_EFF_FROM_DT | TIMESTAMP | 6 | SRC_EFF_FROM_DT | |||
| SRC_EFF_TO_DT | TIMESTAMP | 6 | SRC_EFF_TO_DT | |||
| TENANT_ID | VARCHAR2 | 80 CHAR | TENANT_ID | |||
| X_CUSTOM | VARCHAR2 | 80 CHAR | X_CUSTOM | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |