Financial Transaction GL Detail
Module: Work Asset Analytics
Type: Fact
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| W1_FT_ID | VARCHAR2 | 14 | Financial Transaction | DW_EWWA_X_EWDI_WACS_W1_FT_D | W1_FT_ID | ||
| W1_GL_SEQ_NBR | NUMBER | 3 | 0 | Sequence Number | |||
| SOURCE_RECORD_ID | VARCHAR2 | 53 | Source Record Id | ||||
| AMT | NUMBER | 17 | 3 | Amount | |||
| CHAR_TYPE_CD | VARCHAR2 | 38 | Characteristic Type | ||||
| CHAR_VAL | VARCHAR2 | 38 | Characteristic Value | ||||
| COST_CENTER_CD | VARCHAR2 | 30 | Cost Center | DW_EWWA_X_EWDI_WACS_W1_COST_CENTER_D | COST_CENTER_CD | ||
| DISTRIBUTION_CD | VARCHAR2 | 30 | Asset Distribution Code | DW_EWWA_X_EWDI_WACS_W1_DIST_CODE_D | W1_DISTRIBUTION_CD | ||
| EXPENSE_CD | VARCHAR2 | 30 | Expense Code | DW_EWWA_X_EWDI_WACS_W1_EXPENSE_CD_D | EXPENSE_CD | ||
| PROJECT_ID | VARCHAR2 | 38 | Project | ||||
| VERSION | NUMBER | 5 | 0 | Version | |||
| W1_GL_ACCOUNT | VARCHAR2 | 254 | GL Account | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |