DW_EB_X_EBS_SLA_W_SLA_SUPPORT_REF_D
DW_EB_X_EBS_SLA_W_SLA_SUPPORT_REF_D dimension table stores information about subledger accounting supporting references.The grain of this table is at the combination of supporting reference combination id and attribute 1-60. This is designed to be Type 1 dimension.
Details
Module: Subledger Accounting (EBS_SLA)
Key Columns
Key column information is not documented in the supplied metadata.
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table |
|---|---|---|---|---|---|---|
| ROW_WID | NUMBER | 38 | True | ROW_WID | ||
| ATTRIBUTE1 | VARCHAR2 | 30 CHAR | ATTRIBUTE1 | |||
| ATTRIBUTE10 | VARCHAR2 | 30 CHAR | ATTRIBUTE10 | |||
| ATTRIBUTE11 | VARCHAR2 | 30 CHAR | ATTRIBUTE11 | |||
| ATTRIBUTE12 | VARCHAR2 | 30 CHAR | ATTRIBUTE12 | |||
| ATTRIBUTE13 | VARCHAR2 | 30 CHAR | ATTRIBUTE13 | |||
| ATTRIBUTE14 | VARCHAR2 | 30 CHAR | ATTRIBUTE14 | |||
| ATTRIBUTE15 | VARCHAR2 | 30 CHAR | ATTRIBUTE15 | |||
| ATTRIBUTE16 | VARCHAR2 | 30 CHAR | ATTRIBUTE16 | |||
| ATTRIBUTE17 | VARCHAR2 | 30 CHAR | ATTRIBUTE17 | |||
| ATTRIBUTE18 | VARCHAR2 | 30 CHAR | ATTRIBUTE18 | |||
| ATTRIBUTE19 | VARCHAR2 | 30 CHAR | ATTRIBUTE19 | |||
| ATTRIBUTE2 | VARCHAR2 | 30 CHAR | ATTRIBUTE2 | |||
| ATTRIBUTE20 | VARCHAR2 | 30 CHAR | ATTRIBUTE20 | |||
| ATTRIBUTE21 | VARCHAR2 | 30 CHAR | ATTRIBUTE21 | |||
| ATTRIBUTE22 | VARCHAR2 | 30 CHAR | ATTRIBUTE22 | |||
| ATTRIBUTE23 | VARCHAR2 | 30 CHAR | ATTRIBUTE23 | |||
| ATTRIBUTE24 | VARCHAR2 | 30 CHAR | ATTRIBUTE24 | |||
| ATTRIBUTE25 | VARCHAR2 | 30 CHAR | ATTRIBUTE25 | |||
| ATTRIBUTE26 | VARCHAR2 | 30 CHAR | ATTRIBUTE26 | |||
| ATTRIBUTE27 | VARCHAR2 | 30 CHAR | ATTRIBUTE27 | |||
| ATTRIBUTE28 | VARCHAR2 | 30 CHAR | ATTRIBUTE28 | |||
| ATTRIBUTE29 | VARCHAR2 | 30 CHAR | ATTRIBUTE29 | |||
| ATTRIBUTE3 | VARCHAR2 | 30 CHAR | ATTRIBUTE3 | |||
| ATTRIBUTE30 | VARCHAR2 | 30 CHAR | ATTRIBUTE30 | |||
| ATTRIBUTE31 | VARCHAR2 | 30 CHAR | ATTRIBUTE31 | |||
| ATTRIBUTE32 | VARCHAR2 | 30 CHAR | ATTRIBUTE32 | |||
| ATTRIBUTE33 | VARCHAR2 | 30 CHAR | ATTRIBUTE33 | |||
| ATTRIBUTE34 | VARCHAR2 | 30 CHAR | ATTRIBUTE34 | |||
| ATTRIBUTE35 | VARCHAR2 | 30 CHAR | ATTRIBUTE35 | |||
| ATTRIBUTE36 | VARCHAR2 | 30 CHAR | ATTRIBUTE36 | |||
| ATTRIBUTE37 | VARCHAR2 | 30 CHAR | ATTRIBUTE37 | |||
| ATTRIBUTE38 | VARCHAR2 | 30 CHAR | ATTRIBUTE38 | |||
| ATTRIBUTE39 | VARCHAR2 | 30 CHAR | ATTRIBUTE39 | |||
| ATTRIBUTE4 | VARCHAR2 | 30 CHAR | ATTRIBUTE4 | |||
| ATTRIBUTE40 | VARCHAR2 | 30 CHAR | ATTRIBUTE40 | |||
| ATTRIBUTE41 | VARCHAR2 | 30 CHAR | ATTRIBUTE41 | |||
| ATTRIBUTE42 | VARCHAR2 | 30 CHAR | ATTRIBUTE42 | |||
| ATTRIBUTE43 | VARCHAR2 | 30 CHAR | ATTRIBUTE43 | |||
| ATTRIBUTE44 | VARCHAR2 | 30 CHAR | ATTRIBUTE44 | |||
| ATTRIBUTE45 | VARCHAR2 | 30 CHAR | ATTRIBUTE45 | |||
| ATTRIBUTE46 | VARCHAR2 | 30 CHAR | ATTRIBUTE46 | |||
| ATTRIBUTE47 | VARCHAR2 | 30 CHAR | ATTRIBUTE47 | |||
| ATTRIBUTE48 | VARCHAR2 | 30 CHAR | ATTRIBUTE48 | |||
| ATTRIBUTE49 | VARCHAR2 | 30 CHAR | ATTRIBUTE49 | |||
| ATTRIBUTE5 | VARCHAR2 | 30 CHAR | ATTRIBUTE5 | |||
| ATTRIBUTE50 | VARCHAR2 | 30 CHAR | ATTRIBUTE50 | |||
| ATTRIBUTE51 | VARCHAR2 | 30 CHAR | ATTRIBUTE51 | |||
| ATTRIBUTE52 | VARCHAR2 | 30 CHAR | ATTRIBUTE52 | |||
| ATTRIBUTE53 | VARCHAR2 | 30 CHAR | ATTRIBUTE53 | |||
| ATTRIBUTE54 | VARCHAR2 | 30 CHAR | ATTRIBUTE54 | |||
| ATTRIBUTE55 | VARCHAR2 | 30 CHAR | ATTRIBUTE55 | |||
| ATTRIBUTE56 | VARCHAR2 | 30 CHAR | ATTRIBUTE56 | |||
| ATTRIBUTE57 | VARCHAR2 | 30 CHAR | ATTRIBUTE57 | |||
| ATTRIBUTE58 | VARCHAR2 | 30 CHAR | ATTRIBUTE58 | |||
| ATTRIBUTE59 | VARCHAR2 | 30 CHAR | ATTRIBUTE59 | |||
| ATTRIBUTE6 | VARCHAR2 | 30 CHAR | ATTRIBUTE6 | |||
| ATTRIBUTE60 | VARCHAR2 | 30 CHAR | ATTRIBUTE60 | |||
| ATTRIBUTE7 | VARCHAR2 | 30 CHAR | ATTRIBUTE7 | |||
| ATTRIBUTE8 | VARCHAR2 | 30 CHAR | ATTRIBUTE8 | |||
| ATTRIBUTE9 | VARCHAR2 | 30 CHAR | ATTRIBUTE9 | |||
| 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 | |||
| DATASOURCE_NUM_ID | NUMBER | 10 | DATASOURCE_NUM_ID | |||
| DELETE_FLG | VARCHAR2 | 1 CHAR | DELETE_FLG | |||
| ETL_PROC_WID | NUMBER | 38 | ETL_PROC_WID | |||
| INTEGRATION_ID | VARCHAR2 | 1600 CHAR | INTEGRATION_ID | |||
| SUPPORT_REF_CODE | VARCHAR2 | 80 CHAR | SUPPORT_REF_CODE | |||
| TENANT_ID | VARCHAR2 | 80 CHAR | TENANT_ID | |||
| X_CUSTOM | VARCHAR2 | 10 CHAR | X_CUSTOM | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |