OBP24_HST_FLX_LN_ACCT_SPLIT_INSTR_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PARENT_ACCOUNT_ID CHARACTER VARYING(40) 40
2 SPLIT_INSTR_SEQUENCE_NUM BIGINT 8
3 SPLIT_INSTRUCTION_TYPE_FLAG CHARACTER(1) 1
4 SPLIT_DATE TIMESTAMP 8
5 MATURITY_DATE TIMESTAMP 8
6 CURRENCY_CODE CHARACTER VARYING(3) 3
7 PRODUCT_GROUP_NAME CHARACTER VARYING(5) 5
8 PRODUCT_CODE CHARACTER VARYING(30) 30
9 OFFER_NAME CHARACTER VARYING(105) 105
10 OFFER_CODE CHARACTER VARYING(30) 30
11 SPLIT_AMOUNT DOUBLE PRECISION 8
12 SPLIT_ACCOUNT_TERM_MONTHS BIGINT 8
13 ACCOUNT_OPENING_DATE TIMESTAMP 8
14 SCHEDULE_TYPE_NAME CHARACTER VARYING(105) 105
15 SCHEDULE_CODE CHARACTER VARYING(40) 40
16 FIXED_RATE_TERM_MONTHS BIGINT 8
17 REMARKS CHARACTER VARYING(200) 200
18 ARRANGEMENT_ID CHARACTER VARYING(40) 40
19 RATE_LOCK_ID CHARACTER VARYING(16) 16
20 DEDUCTION_MODE_TYPE CHARACTER VARYING(10) 10
21 PRICING_TICKET_NUMBER CHARACTER VARYING(128) 128
22 PROCESSED_FLAG CHARACTER(1) 1
23 SPLIT_ACCOUNT_ID CHARACTER VARYING(40) 40
24 ERROR_CODE CHARACTER VARYING(120) 120
25 ERROR_DESCRIPTION_TXT CHARACTER VARYING(2000) 2000
26 COST_CENTRE_BRANCH_CODE CHARACTER VARYING(10) 10
27 ECONOMIC_COST_AMOUNT DOUBLE PRECISION 8
28 CREATED_BY CHARACTER VARYING(254) 254
29 CREATION_DATE TIMESTAMP 8
30 LAST_UPDATED_BY CHARACTER VARYING(254) 254
31 LAST_UPDATE_DATE TIMESTAMP 8
32 OBJECT_VERSION_NUMBER BIGINT 8
33 OBJECT_STATUS CHARACTER(1) 1
34 BUNDLE_ID CHARACTER VARYING(40) 40
35 BUNDLE_REFERENCE_ID CHARACTER VARYING(40) 40
36 IS_ACCT_NOMINATED_FOR_BUNDLE CHARACTER(1) 1
37 AVAILABLE_RPA_AMOUNT DOUBLE PRECISION 8
38 XFER_RPA_AMOUNT DOUBLE PRECISION 8
39 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
40 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
41 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
42 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8