Module: Customer Analytics
Type: Dimension
BILL_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| BILL_ID | VARCHAR2 | 12 | True | Bill | |||
| SOURCE_RECORD_ID | VARCHAR2 | 12 | Source Record Id | ||||
| A1_BILL_ARCHIVE_SW | VARCHAR2 | 38 | Archived FTs | ||||
| ALLOW_REOPEN_SW | VARCHAR2 | 1 | Allow Reopen | ||||
| ALT_BILL_ID | NUMBER | 14 | 0 | Seq Bill Number | |||
| APAY_AMT | NUMBER | 15 | 2 | Auto Pay Amount | |||
| APAY_CRE_DT | DATE | 0 | Auto Pay Creation Date | ||||
| APAY_STOP_AMT | NUMBER | 15 | 2 | Auto Pay Stop Amount | |||
| APAY_STOP_CRE_DT | DATE | 0 | Auto Pay Stop Creation Date | ||||
| APAY_STOP_DTTM | TIMESTAMP | 0 | 6 | Auto Pay Stop Date/Time | |||
| BILL_DT | DATE | 0 | Bill Date | ||||
| BILL_SIGN | VARCHAR2 | 400 | Digitial Bill Signature | ||||
| BILL_STAT_FLG | VARCHAR2 | 2 | Bill Status | ||||
| COMPLETE_DTTM | TIMESTAMP | 0 | 6 | Completion Date/Time | |||
| DOC_ID | VARCHAR2 | 30 | Document Number | ||||
| DOC_TYPE_FLG | VARCHAR2 | 38 | Document Type | ||||
| DUE_DT | DATE | 0 | Due Date | ||||
| LATE_PAY_CHARGE_DT | DATE | 0 | Late Payment Charge Date | ||||
| LATE_PAY_CHARGE_SW | VARCHAR2 | 1 | Late Payment Charge | ||||
| NEXT_CR_RVW_DT | DATE | 0 | Next Credit Review Date | ||||
| OFFCYC_BGEN_ID | VARCHAR2 | 38 | Off Cycle Bill Generator ID | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |