OBP24_HST_FLX_DD_TRANSACTION_DAY_LOG

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ACCOUNT_CODE CHARACTER VARYING(40) 40
2 TRAN_REF_NO CHARACTER VARYING(16) 16
3 EVENT_ID CHARACTER VARYING(40) 40
4 TRAN_AMT BIGINT 8
5 CCY_CODE CHARACTER VARYING(10) 10
6 TRAN_BRANCH CHARACTER VARYING(10) 10
7 TRAN_CHANNEL CHARACTER VARYING(20) 20
8 TRAN_DATE TIMESTAMP 8
9 TRAN_DESC CHARACTER VARYING(750) 750
10 TRAN_LIT CHARACTER VARYING(50) 50
11 TRAN_MNEMONIC CHARACTER VARYING(4) 4
12 TRAN_SUB_SEQ_NO BIGINT 8
13 TRAN_TYPE CHARACTER VARYING(10) 10
14 TIME_IN_MILLIS BIGINT 8
15 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
16 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
17 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
18 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8