OBP24_HST_CI_ACCT_ARS

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ACCT_ID CHARACTER(10) 10
2 REFERENCE_VAL CHARACTER VARYING(50) 50
3 ARS_TYPE CHARACTER VARYING(40) 40
4 ARS_ASSESSED_AMT NUMERIC(36,18) 19
5 ARS_PAID_AMT NUMERIC(36,18) 19
6 ARS_DUE_DT TIMESTAMP 8
7 LAST_PAYMENT_DT TIMESTAMP 8
8 DAYS_IN_ARS SMALLINT 2
9 VERSION INTEGER 4
10 BUS_OBJ_CD CHARACTER(30) 30
11 BO_STATUS_CD CHARACTER(12) 12
12 BO_DATA_AREA CHARACTER VARYING(2000) 2000
13 STATUS_UPD_DTTM TIMESTAMP 8
14 ARS_DUE_AMT NUMERIC(36,18) 19
15 INSTALLMENT_NUM INTEGER 4
16 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
17 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
18 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
19 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8