OBP24_FLX_LN_SPLIT_ACCT_INSTR_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 AGREEMENT_ID CHARACTER VARYING(50) 50
2 ACCOUNT_ID CHARACTER VARYING(40) 40
3 CUSTOMER_ID CHARACTER VARYING(40) 40
4 SPLIT_INSTRUCTION_SEQUENCE_NUM BYTEINT 1
5 PRODUCT_CODE INTEGER 4
6 COST_CENTRE_BRANCH_CODE CHARACTER VARYING(10) 10
7 FACE_VALUE_AMT DOUBLE PRECISION 8
8 PRODUCT_CODEUCER_ID DOUBLE PRECISION 8
9 FIXED_RATE_TERM DOUBLE PRECISION 8
10 VARIABLE_INTEREST_RATE_TERM DOUBLE PRECISION 8
11 MATURITY_DATE TIMESTAMP 8
12 AGREEMENT_SIGNING_DATE TIMESTAMP 8
13 ACCOUNT_OPENING_DATE TIMESTAMP 8
14 NET_RATE DOUBLE PRECISION 8
15 INSTALLMENT_FREQ DOUBLE PRECISION 8
16 VARIANCE_CURRENT_RATE DOUBLE PRECISION 8
17 CURRENCY_CODE CHARACTER VARYING(3) 3
18 FLOOR_RATE DOUBLE PRECISION 8
19 APPLIED_ACCOUNT_RATE NUMERIC(22,0) 19
20 RATE_LOCKED_FLAG CHARACTER(1) 1
21 ACCRUAL_BASIS_FLAG CHARACTER(1) 1
22 PROCESSED_FLAG CHARACTER(1) 1
23 RATE_LOCK_FEES_AMT DOUBLE PRECISION 8
24 RATE_LOCK_DATE TIMESTAMP 8
25 NET_LOCKED_RATE DOUBLE PRECISION 8
26 SCHEDULE_CODE CHARACTER VARYING(40) 40
27 POSTING_DATE TIMESTAMP 8
28 PROCESS_DATE TIMESTAMP 8
29 SPLIT_ACCOUNT_ID CHARACTER VARYING(40) 40
30 CONTRIBUTION_AMT NUMERIC(38,0) 19
31 ACCOUNT_DATE_BASIS_CODE NUMERIC(38,0) 19
32 SPLIT_INSTRUCTION_TYPE_FLAG CHARACTER VARYING(1) 1
33 ERROR_CODE CHARACTER VARYING(120) 120
34 ERROR_DESCRIPTION_TXT CHARACTER VARYING(200) 200
35 REPAYMENT_FREQUENCY NUMERIC(38,0) 19
36 TERM_MONTHS_QTY NUMERIC(38,0) 19
37 OFFER_LETTER_DATE TIMESTAMP 8
38 FIXED_MARGIN_CODE BIGINT 8
39 VARIABLE_MARGIN_CODE BIGINT 8
40 RATE_CHART_CODE BIGINT 8
41 DISCOUNT_CODE BIGINT 8
42 DATE_RUN CHARACTER(1) 1
43 LTV_RATIO BIGINT 8
44 FIXED_RATE_TERM_MONTHS BIGINT 8
45 CREATED_BY CHARACTER VARYING(64) 64
46 CREATION_DATE TIMESTAMP 8
47 LAST_UPDATED_BY CHARACTER VARYING(64) 64
48 LAST_UPDATE_DATE TIMESTAMP 8
49 OBJECT_VERSION_NUMBER INTEGER 4
50 OBJECT_STATUS CHARACTER VARYING(5) 5
51 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
52 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
53 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
54 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8