OBP24_HST_FLX_TD_FIN_STMT_LOGS

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 TXN_REF_NO CHARACTER VARYING(50) 50
2 SUB_SEQ_NO DOUBLE PRECISION 8
3 ACCOUNT_CODE CHARACTER VARYING(50) 50
4 TXN_CHANNEL CHARACTER VARYING(50) 50
5 TXN_BRANCH CHARACTER VARYING(10) 10
6 TXN_DESC CHARACTER VARYING(100) 100
7 SERVICE_ID CHARACTER VARYING(50) 50
8 EVENT_ID CHARACTER VARYING(50) 50
9 USER_REF_NO CHARACTER VARYING(50) 50
10 USER_NO CHARACTER VARYING(50) 50
11 AUTHORIZER_CODE CHARACTER VARYING(50) 50
12 CHEQUE_NO CHARACTER VARYING(50) 50
13 MSG_TYPE CHARACTER VARYING(50) 50
14 TXN_TYPE CHARACTER VARYING(50) 50
15 TXN_AMOUNT_TCY DOUBLE PRECISION 8
16 TCY_CODE CHARACTER VARYING(3) 3
17 TXN_AMOUNT_ACY DOUBLE PRECISION 8
18 ACY_CODE CHARACTER VARYING(3) 3
19 POSTING_DATE TIMESTAMP 8
20 VALUE_DATE TIMESTAMP 8
21 TRANSACTION_DATE TIMESTAMP 8
22 DEPOSIT_NUMBER DOUBLE PRECISION 8
23 ACCOUNT_RUNNING_AMT DOUBLE PRECISION 8
24 DEPOSIT_RUNNING_AMT DOUBLE PRECISION 8
25 PRICING_TICKET_NO CHARACTER VARYING(50) 50
26 SETTLEMENT_REF_ID CHARACTER VARYING(100) 100
27 CHEQUE_DEPOSIT_DATE CHARACTER VARYING(50) 50
28 CHEQUE_VALUE_DATE CHARACTER VARYING(50) 50
29 NARRATION CHARACTER VARYING(500) 500
30 END_POINT_SEGMENT_ID CHARACTER VARYING(100) 100
31 PRICING_DEF_ID CHARACTER VARYING(50) 50
32 PROCESS_DATE TIMESTAMP 8
33 OBJECT_VERSION_NUMBER DOUBLE PRECISION 8
34 ATM_NARRATION CHARACTER VARYING(500) 500
35 TXN_LITERAL CHARACTER VARYING(5) 5
36 CHEQUE_DATE TIMESTAMP 8
37 CARD_REF_NO CHARACTER VARYING(50) 50
38 FX_RATE 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