Financial Transaction GL Detail
Module: Customer Analytics
Type: Fact
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| FT_ID | VARCHAR2 | 12 | Financial Transaction | ||||
| GL_SEQ_NBR | NUMBER | 3 | 0 | GL Sequence Number | |||
| SOURCE_RECORD_ID | VARCHAR2 | 51 | Source Record Id | ||||
| ACCOUNTING_DT | DATE | 0 | Accounting Date | ||||
| ACCT_ID | VARCHAR2 | 10 | Account | DW_EWB_X_EWDI_BASE_CI_ACCT_D | ACCT_ID | ||
| ADJ_ID | VARCHAR2 | 12 | Adjustment | DW_EWC_X_EWDI_CUST_CI_ADJ_D | ADJ_ID | ||
| BF_CHAR_TYPE_CD | VARCHAR2 | 38 | Bill Factor Characteristic Type | ||||
| BF_CHAR_VAL | VARCHAR2 | 38 | Bill Factor Characteristic Value | ||||
| BILL_ID | VARCHAR2 | 38 | Bill | DW_EWC_X_EWDI_CUST_CI_BILL_D | BILL_ID | ||
| BSEG_ID | VARCHAR2 | 12 | Bill Segment | DW_EWC_X_EWDI_CUST_CI_BSEG_D | BSEG_ID | ||
| CIS_DIVISION | VARCHAR2 | 5 | CIS Division | DW_EWC_X_EWDI_CUST_CI_CIS_DIVISION_D | CIS_DIVISION | ||
| CRE_DT | NUMBER | 38 | 0 | Creation Date | |||
| CRE_TM | NUMBER | 38 | 0 | Creation Time | |||
| DST_ID | VARCHAR2 | 10 | Distribution Code | DW_EWC_X_EWDI_CUST_CI_DST_CODE_D | DST_ID | ||
| FREEZE_DT | NUMBER | 38 | 0 | Freeze Date | |||
| FREEZE_TM | NUMBER | 38 | 0 | Freeze Time | |||
| FSC_ACCOUNTING_DT | DATE | 0 | Fiscal Accounting Date | DW_EWB_X_EWDI_BASE_DW_FISCAL_DAY_D | FISCAL_DAY_DATE | ||
| FT_CURRENCY_CD | VARCHAR2 | 3 | Currency | ||||
| FT_GL_AMT | NUMBER | 15 | 2 | GL Amount | |||
| FT_GL_CNT | NUMBER | 1 | 0 | Count | |||
| FT_GL_CREDIT_AMT | NUMBER | 15 | 2 | Credit Amount | |||
| FT_GL_DEBIT_AMT | NUMBER | 15 | 2 | Debit Amount | |||
| FT_GL_REV_AMT | NUMBER | 15 | 2 | Revenue Amount | |||
| FT_GL_TAX_AMT | NUMBER | 15 | 2 | Tax Amount | |||
| FT_TYPE_FLG | VARCHAR2 | 2 | Financial Transaction Type | ||||
| GL_ACCT | VARCHAR2 | 254 | GL Account | ||||
| GL_DIVISION | VARCHAR2 | 5 | GL Division | DW_EWC_X_EWDI_CUST_CI_GL_DIVISION_D | GL_DIVISION | ||
| PAY_SEG_ID | VARCHAR2 | 12 | Pay Segment | DW_EWC_X_EWDI_CUST_CI_PAY_SEG_D | PAY_SEG_ID | ||
| PER_ID | VARCHAR2 | 10 | Person | DW_EWB_X_EWDI_BASE_CI_PER_D | PER_ID | ||
| PREM_ID | VARCHAR2 | 38 | Premise | DW_EWB_X_EWDI_BASE_CI_PREM_D | PREM_ID | ||
| RS_CD | VARCHAR2 | 38 | Rate | DW_EWB_X_EWDI_BASE_CI_RS_D | RATE_SCHEDULE_CD | ||
| SA_ID | VARCHAR2 | 10 | Service Agreement | DW_EWB_X_EWDI_BASE_CI_SA_D | SA_ID | ||
| STATISTICS_CD | VARCHAR2 | 38 | Statistics Code | ||||
| STATISTIC_AMT | NUMBER | 38 | 6 | Statistic Amount | |||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |