OBP24_HST_FLX_TD_STMT_GEN_ITEMS

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 STMT_REQ_ID CHARACTER VARYING(50) 50
2 SEQUENCE_NUMBER CHARACTER VARYING(50) 50
3 STMT_ITEM_TYPE CHARACTER VARYING(50) 50
4 ACCOUNT_CODE CHARACTER VARYING(50) 50
5 SERVICE_ID CHARACTER VARYING(50) 50
6 EVENT_ID CHARACTER VARYING(50) 50
7 PRICING_TICKET_NO CHARACTER VARYING(50) 50
8 NON_FIN_CODE CHARACTER VARYING(50) 50
9 EVENT_DESC CHARACTER VARYING(200) 200
10 TXN_REF_NO CHARACTER VARYING(50) 50
11 SUB_SEQ_NO DOUBLE PRECISION 8
12 TXN_CHANNEL CHARACTER VARYING(50) 50
13 TXN_BRANCH CHARACTER VARYING(10) 10
14 TXN_MNEMONIC CHARACTER VARYING(50) 50
15 TXN_DESC CHARACTER VARYING(100) 100
16 USER_REF_NO CHARACTER VARYING(50) 50
17 USER_NO CHARACTER VARYING(50) 50
18 TXN_LITERAL CHARACTER VARYING(50) 50
19 AUTHORIZER_CODE CHARACTER VARYING(50) 50
20 TRACE_NO CHARACTER VARYING(50) 50
21 CLEARING_TYPE CHARACTER VARYING(50) 50
22 CHEQUE_NO CHARACTER VARYING(50) 50
23 MSG_TYPE CHARACTER VARYING(50) 50
24 TXN_TYPE CHARACTER VARYING(50) 50
25 TXN_AMOUNT_TCY DOUBLE PRECISION 8
26 TCY_CODE CHARACTER VARYING(3) 3
27 TXN_AMOUNT_ACY DOUBLE PRECISION 8
28 ACY_CODE CHARACTER VARYING(3) 3
29 POSTING_DATE TIMESTAMP 8
30 VALUE_DATE TIMESTAMP 8
31 TRANSACTION_DATE TIMESTAMP 8
32 DEPOSIT_NUMBER DOUBLE PRECISION 8
33 ACCOUNT_RUNNING_AMT DOUBLE PRECISION 8
34 DEPOSIT_RUNNING_AMT DOUBLE PRECISION 8
35 SETTLEMENT_REF_ID CHARACTER VARYING(40) 40
36 CHEQUE_DEPOSIT_DATE CHARACTER VARYING(50) 50
37 CHEQUE_VALUE_DATE CHARACTER VARYING(50) 50
38 NARRATION CHARACTER VARYING(500) 500
39 PRICING_DEF_ID CHARACTER VARYING(50) 50
40 END_POINT_SEGMENT_ID CHARACTER VARYING(40) 40
41 CARD_REF_NO CHARACTER VARYING(50) 50
42 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
43 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
44 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
45 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8