OBP24_HST_FLX_AC_ARREAR_DETAILS_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 IS_ARREAR_SUSPENDED CHARACTER(1) 1
12 ARREAR_TYPE CHARACTER VARYING(10) 10
13 SUB_ARREAR_TYPE CHARACTER VARYING(10) 10
14 CREATION_DATE TIMESTAMP 8
15 LAST_UPDATED_BY CHARACTER VARYING(254) 254
16 LAST_UPDATED_DATE TIMESTAMP 8
17 OBJECT_VERSION_NUMBER INTEGER 4
18 OBJECT_STATUS_FLAG CHARACTER(1) 1
19 CREATED_BY CHARACTER VARYING(254) 254
20 WRITE_OFF_AMT DOUBLE PRECISION 8
21 WRITE_OFF_DATE TIMESTAMP 8
22 SERIAL_NO DOUBLE PRECISION 8
23 AST_PAID_AMT DOUBLE PRECISION 8
24 PRICE_DEFINITION_ID CHARACTER VARYING(40) 40
25 IS_NON_CAPITALIZED CHARACTER(1) 1
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 CAP_DATE TIMESTAMP 8
33 INSTALLMENT_NUM DOUBLE PRECISION 8
34 INSURANCE_ID DOUBLE PRECISION 8
35 INSURANCE_POLICY_CODE CHARACTER VARYING(120) 120
36 SERVICE_CHARGE_CODE CHARACTER VARYING(20) 20
37 SERVICE_CHARGE_NAME CHARACTER VARYING(120) 120
38 LAST_PAID_AMT DOUBLE PRECISION 8
39 ACCRUAL_BASIS_FLAG CHARACTER VARYING(10) 10
40 INT_CYCLE_NUM DOUBLE PRECISION 8
41 FEE_RECOGNITION_BRANCH_TYPE CHARACTER VARYING(10) 10
42 FEE_RECOGNITION_BRANCH_ID CHARACTER VARYING(10) 10
43 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
44 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
45 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
46 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8