OBP24_FLX_LN_CONTRIBUTION_INSTR_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ACCOUNT_ID CHARACTER VARYING(40) 40
2 INSTRUCTION_ID CHARACTER VARYING(50) 50
3 INSTRUCTION_SETUP_DATE TIMESTAMP 8
4 CONTRIBUTION_AMOUNT DOUBLE PRECISION 8
5 CONTRIBUTION_AMOUNT_CCY CHARACTER VARYING(3) 3
6 COMP_PREF_ID CHARACTER VARYING(50) 50
7 EXECUTION_DATE TIMESTAMP 8
8 EXECUTION_STATUS CHARACTER VARYING(15) 15
9 CONTRIBUTION_STATUS CHARACTER VARYING(15) 15
10 CREATED_BY CHARACTER VARYING(254) 254
11 CREATION_DATE TIMESTAMP 8
12 LAST_UPDATED_BY CHARACTER VARYING(254) 254
13 LAST_UPDATE_DATE TIMESTAMP 8
14 VERSION_NUM BIGINT 8
15 OBJECT_STATUS CHARACTER(1) 1
16 TRANSACTION_REFERENCE CHARACTER VARYING(16) 16
17 DOMAIN_OBJECT_EXTN CHARACTER VARYING(100) 100
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