Module: Customer Analytics
Type: Dimension
BSEG_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| BSEG_ID | VARCHAR2 | 12 | True | Bill Segment | |||
| SOURCE_RECORD_ID | VARCHAR2 | 12 | Source Record Id | ||||
| BSEG_STAT_FLG | VARCHAR2 | 2 | Bill Segment Status | ||||
| CLOSING_BSEG_SW | VARCHAR2 | 1 | Closing Bill Segment | ||||
| END_DT | DATE | 0 | End Date | ||||
| EST_SW | VARCHAR2 | 1 | Estimate | ||||
| ITEM_OVERRIDE_SW | VARCHAR2 | 1 | Item Override | ||||
| MDM_END_DTTM | TIMESTAMP | 0 | 6 | MDM End Date/Time | |||
| MDM_START_DTTM | TIMESTAMP | 0 | 6 | MDM Start Date/Time | |||
| SQ_OVERRIDE_SW | VARCHAR2 | 1 | SQ Override | ||||
| START_DT | DATE | 0 | Start Date | ||||
| STAT_CHG_DTTM | TIMESTAMP | 0 | 6 | Status Change Date/Time | |||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |