Billed Usage
Module: Customer Analytics
Type: Fact
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| BILLED_USAGE_SQI_CD | VARCHAR2 | 38 | Service Quantity Identifier | DW_EWC_X_EWDI_CUST_CI_SQI_D | SERVICE_QTY_IDENTIFIER_CD | ||
| BSEG_ID | VARCHAR2 | 12 | Bill Segment | ||||
| FT_ID | VARCHAR2 | 12 | Financial Transaction | ||||
| RS_CD | VARCHAR2 | 38 | Rate | DW_EWB_X_EWDI_BASE_CI_RS_D | RATE_SCHEDULE_CD | ||
| TOU_CD | VARCHAR2 | 30 | Time of Use | DW_EWC_X_EWDI_CUST_CI_TOU_D | TOU_CD | ||
| UOM_CD | VARCHAR2 | 30 | Unit of Measure | DW_EWC_X_EWDI_CUST_CI_UOM_D | UOM_CD | ||
| SOURCE_RECORD_ID | VARCHAR2 | 165 | Source Record Id | ||||
| ACCOUNTING_DT | NUMBER | 38 | 0 | Accounting Date | |||
| ACCT_ID | VARCHAR2 | 10 | Account | DW_EWB_X_EWDI_BASE_CI_ACCT_D | ACCT_ID | ||
| BILLED_AMT | NUMBER | 38 | 2 | Billed Amount | |||
| BILL_CRE_DT | NUMBER | 38 | 0 | Bill Creation Date | |||
| BILL_CRE_TM | NUMBER | 38 | 0 | Bill Creation Time | |||
| BILL_ID | VARCHAR2 | 12 | Bill | DW_EWC_X_EWDI_CUST_CI_BILL_D | BILL_ID | ||
| BILL_LAG_DAYS | NUMBER | 38 | 0 | Bill Segment Freeze Lag (in days) | |||
| BILL_SQ | NUMBER | 38 | 6 | Billed Quantity | |||
| BSEG_DAYS | NUMBER | 38 | 0 | Bill Segment Period (in days) | |||
| BSEG_END_DT | NUMBER | 38 | 0 | Bill Segment End Date | |||
| BSEG_SQ_CNT | NUMBER | 38 | 0 | Count | |||
| BSEG_START_DT | DATE | 0 | Bill Segment Start Date | ||||
| FREEZE_DT | NUMBER | 38 | 0 | Freeze Date | |||
| FREEZE_TM | NUMBER | 38 | 0 | Freeze Time | |||
| FT_TYPE_FLG | VARCHAR2 | 2 | Financial Transaction Type | ||||
| 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 | ||
| SA_ID | VARCHAR2 | 10 | Service Agreement | DW_EWB_X_EWDI_BASE_CI_SA_D | SA_ID | ||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |