OBP24_FLX_LN_ACCT_SCHEDULE_H

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 AMENDMENT_NUM BIGINT 8
2 AMENDMENT_DATE TIMESTAMP 8
3 REASON_CODE CHARACTER VARYING(10) 10
4 REASON_DESCRIPTION_TXT CHARACTER VARYING(120) 120
5 ACCOUNT_ID CHARACTER VARYING(40) 40
6 SCHEDULE_CODE CHARACTER VARYING(40) 40
7 SCHEDULE_TYPE_NAME CHARACTER VARYING(120) 120
8 STAGE_NUM BIGINT 8
9 STAGE_NAME CHARACTER VARYING(120) 120
10 STAGE_START_DATE TIMESTAMP 8
11 STAGE_END_DATE TIMESTAMP 8
12 PRINCIPAL_REPAYMENT_AMT DOUBLE PRECISION 8
13 STAGE_TERM BIGINT 8
14 CAPITALIZED_ARREARS_AMT DOUBLE PRECISION 8
15 ROLLOVER_INTEREST_AMT DOUBLE PRECISION 8
16 INSTALLMENT_RULE_ID CHARACTER VARYING(40) 40
17 INSTALLMENT_AMT DOUBLE PRECISION 8
18 FIRST_INSTALLMENT_DATE TIMESTAMP 8
19 INSTALLMENT_NUM BIGINT 8
20 INSTALLMENT_FREQ CHARACTER VARYING(30) 30
21 CALENDER_PLAN_ID BIGINT 8
22 INTEREST_AMT DOUBLE PRECISION 8
23 FIRST_INTEREST_CHARGE_DATE TIMESTAMP 8
24 INTEREST_FREQ CHARACTER VARYING(30) 30
25 INTEREST_REPAYMENTS_NUM BIGINT 8
26 SERVICE_CHARGE_CODE CHARACTER VARYING(20) 20
27 SERVICE_CHARGE_AMT DOUBLE PRECISION 8
28 FIRST_SERVICE_CHARGE_DATE TIMESTAMP 8
29 CHARGE_FREQ BIGINT 8
30 CHARGE_NUM BIGINT 8
31 PENALTY_FREQ CHARACTER VARYING(30) 30
32 INTEREST_COMPOUNDING_FREQ CHARACTER VARYING(30) 30
33 FIRST_COMPOUNDING_DATE TIMESTAMP 8
34 REST_PERIOD_FREQ CHARACTER VARYING(30) 30
35 FIRST_REST_PERIOD_DATE TIMESTAMP 8
36 PENALTY_COMPOUNDING_FREQ CHARACTER VARYING(30) 30
37 ARREAR_COMP_FREQ CHARACTER VARYING(30) 30
38 END_PERIOD_TREATMENT_CODE CHARACTER VARYING(30) 30
39 COA_RULE_CODE BIGINT 8
40 COA_FREQ BIGINT 8
41 YEAR_BASE_TYPE_CODE BIGINT 8
42 YEAR_BASE_FOR_INTEREST BIGINT 8
43 YEAR_BASE_FOR_FEE BIGINT 8
44 INTEREST_CAP_FRQ CHARACTER VARYING(30) 30
45 FIRST_INTEREST_CAP_DATE TIMESTAMP 8
46 FEE_CAP_FRQ CHARACTER VARYING(30) 30
47 FIRST_FEE_CAP_DATE TIMESTAMP 8
48 OBJECT_STATUS CHARACTER(1) 1
49 MAKER_NAME CHARACTER VARYING(36) 36
50 CHECKER_NAME CHARACTER VARYING(36) 36
51 LAST_UPDATE_DATE TIMESTAMP 8
52 OBJECT_VERSION_NUMBER BIGINT 8
53 MIN_DUE_PLAN_ID BIGINT 8
54 BILLING_GRACE_DAYS BIGINT 8
55 TERM_VALIDATION_RULE_CODE BIGINT 8
56 BILLING_GRACE_CYCLE BIGINT 8
57 INSTALLMENT_DATE_DAY_PART_NUM BIGINT 8
58 CURRENCY_CODE CHARACTER VARYING(3) 3
59 PERIODIC_FEE_TREATMENT_TYPE CHARACTER VARYING(30) 30
60 EVENT_NUMBER CHARACTER VARYING(128) 128
61 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
62 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
63 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
64 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8