Module: Common
Type: Dimension
ACCT_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| ACCT_ID | VARCHAR2 | 10 | True | Account | |||
| SOURCE_RECORD_ID | VARCHAR2 | 10 | Source Record Id | ||||
| A1_ACTIVE_SA_CNT | NUMBER | 38 | 0 | Active Service Agreement Count | |||
| A1_HAS_APAY | VARCHAR2 | 1 | Autopay | ||||
| A1_HAS_BB | VARCHAR2 | 1 | Budget Billing | ||||
| A1_HAS_EBILL | VARCHAR2 | 1 | E-Bill | ||||
| A1_HAS_NBB | VARCHAR2 | 1 | Non-Billed Budget | ||||
| A1_HAS_PA | VARCHAR2 | 1 | Payment Arrangement | ||||
| A1_HAS_PP | VARCHAR2 | 1 | Pay Plan | ||||
| ALERT_INFO | VARCHAR2 | 4000 | Alert Information | ||||
| BILL_AFTER_DT | DATE | 0 | Bill After | ||||
| BILL_CYC_CD | VARCHAR2 | 4 | Bill Cycle | ||||
| BUS_ACT_REQ_SW | VARCHAR2 | 1 | Business Activity Required | ||||
| CASH_ONLY_PTS_THRS | NUMBER | 5 | 0 | Cash-Only Threshold | |||
| CIS_DIVISION | VARCHAR2 | 5 | CIS Division | ||||
| CIS_DIV_RESTRICT_FLG | VARCHAR2 | 4 | Restrict to Account CIS Division | ||||
| CR_RAT_THRS | NUMBER | 5 | 0 | Credit Rating Threshold | |||
| CR_REVIEW_DT | DATE | 0 | Last Credit Review Date | ||||
| CUST_CL_CD | VARCHAR2 | 8 | Customer Class | ||||
| INT_CR_REVIEW_SW | VARCHAR2 | 1 | Internal Credit Review | ||||
| NON_CIS_PAYMENT_SW | VARCHAR2 | 1 | Non CIS Payment | ||||
| NO_DEP_RVW_SW | VARCHAR2 | 1 | No Deposit Review Switch | ||||
| OPEN_ITEM_SW | VARCHAR2 | 1 | Open Item Accounting | ||||
| OVRD_CRRT_CASH_SW | VARCHAR2 | 1 | Override Credit Rating/Cash Only | ||||
| POSTPONE_CR_RVW_DT | DATE | 0 | Postpone Credit Review Until | ||||
| PROTECT_CYC_SW | VARCHAR2 | 1 | Protect Bill Cycle | ||||
| PROTECT_DIV_SW | VARCHAR2 | 1 | Protect CIS Division | ||||
| PROTECT_PREM_SW | VARCHAR2 | 1 | Protect Mailing Premise | ||||
| SETUP_DT | DATE | 0 | Set Up Date | ||||
| START_CASH_ONL_PTS | NUMBER | 5 | 0 | Beginning Cash-Only Score | |||
| START_CR_RAT_PTS | NUMBER | 5 | 0 | Beginning Credit Rating | |||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |