OBP24_FLX_AC_ST_PAYOUT_ITEM_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 INSTRUCTION_ID CHARACTER VARYING(40) 40
2 EXECUTION_DATE TIMESTAMP 8
3 SETTLEMENT_PAYOUT_AMOUNT DOUBLE PRECISION 8
4 INSTRUCTION_EXECUTION_STATUS CHARACTER VARYING(20) 20
5 COMP_PREF_ID CHARACTER VARYING(40) 40
6 CURRENCY_CODE CHARACTER VARYING(3) 3
7 INSTRUCTION_SETUP_DATE TIMESTAMP 8
8 PAYOUT_SETUP_ID CHARACTER VARYING(100) 100
9 LINKAGE_TYPE CHARACTER VARYING(100) 100
10 LINKAGE_VALUE CHARACTER VARYING(100) 100
11 ACCOUNT_TYPE CHARACTER VARYING(100) 100
12 LEGAL_FEE DOUBLE PRECISION 8
13 BANK_FEE DOUBLE PRECISION 8
14 LMI_PREMIUM DOUBLE PRECISION 8
15 NOMINATED_ACCOUNT CHARACTER VARYING(40) 40
16 DOMAIN_OBJECT_EXTN CHARACTER VARYING(100) 100
17 INTERNAL_REFINANCE_DETAILS CHARACTER VARYING(200) 200
18 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
19 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
20 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
21 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8