OBP24_FLX_LN_AMORT_DEDN_DETLS

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ACCOUNT_ID CHARACTER VARYING(16) 16
2 COST_CENTRE_BRANCH_CODE CHARACTER VARYING(10) 10
3 DEDUCTION_TYPE BIGINT 8
4 DEDUCTION_CURRENCY_CODE CHARACTER VARYING(3) 3
5 SERVICE_CHARGE_CODE CHARACTER VARYING(20) 20
6 AMORTIZATION_FREQ BIGINT 8
7 DEDUCTION_TXN_CURRENCY_AMT DOUBLE PRECISION 8
8 AMORTIZED_TXN_CURR_AMT DOUBLE PRECISION 8
9 LAST_AMORTIZED_TXN_CURR_AMT DOUBLE PRECISION 8
10 POSTING_DATE TIMESTAMP 8
11 LAST_AMORTIZED_DATE TIMESTAMP 8
12 HOST_USER_ID BIGINT 8
13 HOST_BATCH_NUM BIGINT 8
14 SERIAL_NUM BIGINT 8
15 DEDUCTION_MODE_FLAG CHARACTER VARYING(10) 10
16 SYSTEM_HOST_TXN_NUM CHARACTER VARYING(100) 100
17 ACCOUNT_TERM_IN_DAYS BIGINT 8
18 DEDUCTION_BASE_AMT DOUBLE PRECISION 8
19 AMORT_BASE_ACCOUNT_TERM_DAYS BIGINT 8
20 ACCOUNT_IRR_RATE BIGINT 8
21 SERVICE_CHARGE_PROPORTION BIGINT 8
22 ACCOUNT_SERVICE_CHARGES_QTY BIGINT 8
23 AMORTIZATION_METHOD_CODE BIGINT 8
24 VALUE_DATE TIMESTAMP 8
25 SERVICE_CHARGE_CURR_CODE CHARACTER VARYING(3) 3
26 CREATED_BY CHARACTER VARYING(254) 254
27 LAST_UPDATED_BY CHARACTER VARYING(254) 254
28 LAST_UPDATED_DATE TIMESTAMP 8
29 CREATION_DATE TIMESTAMP 8
30 VERSION_NUM BIGINT 8
31 OBJECT_STATUS CHARACTER(1) 1
32 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
33 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
34 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
35 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8