OBP24_HST_FLX_AC_ARREAR_TXN_LOG_DTLS_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ACCOUNT_ID CHARACTER VARYING(16) 16
2 TXN_REF_NO CHARACTER VARYING(32) 32
3 ARREAR_ASSESSED_AMT DOUBLE PRECISION 8
4 ARREAR_DUE_AMT DOUBLE PRECISION 8
5 ARREAR_WAIVED_AMT DOUBLE PRECISION 8
6 LAST_PYMT_DATE TIMESTAMP 8
7 DUE_DATE TIMESTAMP 8
8 ASSESSED_DATE TIMESTAMP 8
9 ARREAR_CANCELLATION_DATE TIMESTAMP 8
10 IS_ARREAR_PAID CHARACTER(1) 1
11 ARREAR_TYPE CHARACTER VARYING(10) 10
12 CREATION_DATE TIMESTAMP 8
13 LAST_UPDATED_BY CHARACTER VARYING(254) 254
14 LAST_UPDATED_DATE TIMESTAMP 8
15 OBJECT_VERSION_NUMBER INTEGER 4
16 OBJECT_STATUS_FLAG CHARACTER(1) 1
17 CREATED_BY CHARACTER VARYING(254) 254
18 WRITE_OFF_AMT DOUBLE PRECISION 8
19 WRITE_OFF_DATE TIMESTAMP 8
20 SERIAL_NO DOUBLE PRECISION 8
21 LAST_PAID_AMT DOUBLE PRECISION 8
22 PRICE_DEFINITION_ID CHARACTER VARYING(40) 40
23 IS_ARREAR_SUSPENDED CHARACTER(1) 1
24 IS_NON_CAPITALIZED CHARACTER(1) 1
25 SUB_ARREAR_TYPE CHARACTER VARYING(5) 5
26 ACCOUNT_TYPE CHARACTER VARYING(5) 5
27 CAPITALIZED_ARREARS_AMT DOUBLE PRECISION 8
28 CURRENCY_CODE CHARACTER VARYING(3) 3
29 BILL_REFERENCE_DATE TIMESTAMP 8
30 PENALTY_GRACE_EXPIRY_DATE TIMESTAMP 8
31 INSTALLMENT_POSTPND_ON_DATE TIMESTAMP 8
32 INSTALLMENT_NUM DOUBLE PRECISION 8
33 INSURANCE_ID DOUBLE PRECISION 8
34 INSURANCE_POLICY_CODE CHARACTER VARYING(120) 120
35 SERVICE_CHARGE_CODE CHARACTER VARYING(20) 20
36 SERVICE_CHARGE_NAME CHARACTER VARYING(120) 120
37 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
38 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
39 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
40 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8