OBP24_HST_CI_ACCT

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Synonyms

SDSNZP05_BANK..CBP_OBP_HST_CI_ACCT

Columns
# Name Data Type Length
1 ACCT_ID CHARACTER(10) 10
2 BILL_CYC_CD CHARACTER(4) 4
3 SETUP_DT TIMESTAMP 8
4 CURRENCY_CD CHARACTER(3) 3
5 ACCT_MGMT_GRP_CD CHARACTER(10) 10
6 ALERT_INFO CHARACTER VARYING(250) 250
7 BILL_AFTER_DT TIMESTAMP 8
8 PROTECT_CYC_SW CHARACTER(1) 1
9 CIS_DIVISION CHARACTER(5) 5
10 MAILING_PREM_ID CHARACTER(10) 10
11 PROTECT_PREM_SW CHARACTER(1) 1
12 COLL_CL_CD CHARACTER(10) 10
13 CR_REVIEW_DT TIMESTAMP 8
14 POSTPONE_CR_RVW_DT TIMESTAMP 8
15 INT_CR_REVIEW_SW CHARACTER(1) 1
16 CUST_CL_CD CHARACTER(8) 8
17 BILL_PRT_INTERCEPT CHARACTER(255) 255
18 NO_DEP_RVW_SW CHARACTER(1) 1
19 BUD_PLAN_CD CHARACTER(8) 8
20 VERSION INTEGER 4
21 PROTECT_DIV_SW CHARACTER(1) 1
22 ACCESS_GRP_CD CHARACTER(12) 12
23 ACCT_DATA_AREA CHARACTER VARYING(2000) 2000
24 EC_EXPIRY_SCHEDULE_CD CHARACTER(12) 12
25 BILL_LEAD_DAYS INTEGER 4
26 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
27 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
28 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
29 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8