Financial Transaction
Module: Customer Analytics
Type: Fact
FT_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| FT_ID | VARCHAR2 | 12 | True | Financial Transaction | |||
| SOURCE_RECORD_ID | VARCHAR2 | 12 | Source Record Id | ||||
| A1_BSEG_END_DT | NUMBER | 38 | 0 | Bill Segment End Date | |||
| A1_BSEG_START_DT | NUMBER | 38 | 0 | Bill Segment Start Date | |||
| A1_GL_DISTRIB_STATUS_FLG | VARCHAR2 | 1 | GL Distribution Status | ||||
| 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 | ||
| ARS_DT | NUMBER | 38 | 0 | Arrears Date | |||
| 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 | |||
| CUR_AMT | NUMBER | 38 | 2 | Current Amount | |||
| 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_SW | VARCHAR2 | 1 | Frozen (Posted to Account) | ||||
| FREEZE_TM | NUMBER | 38 | 0 | Freeze Time | |||
| FREEZE_USER_ID | VARCHAR2 | 38 | Frozen By User | DW_EWB_X_EWDI_BASE_SC_USER_D | USER_ID | ||
| FSC_ACCOUNTING_DT | DATE | 0 | Fiscal Accounting Date | DW_EWB_X_EWDI_BASE_DW_FISCAL_DAY_D | FISCAL_DAY_DATE | ||
| FT_CNT | NUMBER | 1 | 0 | Count | |||
| FT_GL_REV_AMT | NUMBER | 15 | 2 | Revenue Amount | |||
| FT_GL_TAX_AMT | NUMBER | 15 | 2 | Tax Amount | |||
| FT_OTHER_AMT | NUMBER | 15 | 2 | Other Amount | |||
| FT_TYPE_FLG | VARCHAR2 | 2 | Financial Transaction Type | ||||
| 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 | ||
| SCHED_DISTRIB_DT | NUMBER | 38 | 0 | Scheduled Distribution Date | |||
| TOT_AMT | NUMBER | 38 | 2 | Payoff Amount | |||
| XFER_TO_GL_DT | NUMBER | 38 | 0 | Transfer to GL Date | |||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |