OBP24_HST_FLX_AC_WRTOFF_HISTORY_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ACCOUNT_CODE CHARACTER VARYING(40) 40
2 WRT_OFF_DATE TIMESTAMP 8
3 TOTAL_WRT_OFF_AMT DOUBLE PRECISION 8
4 CUM_WRT_OFF_AMT DOUBLE PRECISION 8
5 CUM_PRINCIPAL_WRT_OFF_AMT DOUBLE PRECISION 8
6 TOTAL_OUTSTANDING_AMT DOUBLE PRECISION 8
7 PRINCIPAL_OUTSTANDING_AMT DOUBLE PRECISION 8
8 PROVISION_DRAWDOWN_AMT DOUBLE PRECISION 8
9 REASON_1 CHARACTER VARYING(255) 255
10 REASON_2 CHARACTER VARYING(255) 255
11 CREATED_BY CHARACTER VARYING(254) 254
12 APPROVED_BY CHARACTER VARYING(64) 64
13 TRANSACTION_REF_NO CHARACTER VARYING(40) 40
14 IS_FULL_WRT_OFF CHARACTER(1) 1
15 CURRENCY CHARACTER VARYING(3) 3
16 TOTAL_PRINC_WRT_OFF_AMT DOUBLE PRECISION 8
17 SERIAL_NO DOUBLE PRECISION 8
18 IS_RECOVERABLE CHARACTER(1) 1
19 CUM_RECOVERY_INELIGIBLE_AMT DOUBLE PRECISION 8
20 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
21 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
22 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
23 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8