OBP24_HST_FLX_DD_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 STMT_SEQ_NO DOUBLE PRECISION 8
4 ACCOUNT_CODE CHARACTER VARYING(50) 50
5 TXN_CHANNEL CHARACTER VARYING(50) 50
6 TXN_BRANCH CHARACTER VARYING(10) 10
7 TXN_DESC CHARACTER VARYING(360) 360
8 SERVICE_ID CHARACTER VARYING(50) 50
9 EVENT_ID CHARACTER VARYING(50) 50
10 USER_REF_NO CHARACTER VARYING(50) 50
11 USER_NO CHARACTER VARYING(50) 50
12 AUTHORIZER_CODE CHARACTER VARYING(50) 50
13 CHEQUE_NO CHARACTER VARYING(50) 50
14 MSG_TYPE CHARACTER VARYING(50) 50
15 TXN_TYPE CHARACTER VARYING(50) 50
16 TXN_AMOUNT_TCY DOUBLE PRECISION 8
17 TCY_CODE CHARACTER VARYING(3) 3
18 TXN_AMOUNT_ACY DOUBLE PRECISION 8
19 ACY_CODE CHARACTER VARYING(3) 3
20 POSTING_DATE TIMESTAMP 8
21 VALUE_DATE TIMESTAMP 8
22 TRANSACTION_DATE TIMESTAMP 8
23 PRICING_TICKET_NO CHARACTER VARYING(50) 50
24 CLEAR_BAL_AMT DOUBLE PRECISION 8
25 UTILIZED_OD_AMT DOUBLE PRECISION 8
26 AUF_AMT DOUBLE PRECISION 8
27 OVER_LINE_AMT DOUBLE PRECISION 8
28 TOD_AMT DOUBLE PRECISION 8
29 SYSTEM_HOLD_AMT DOUBLE PRECISION 8
30 USER_HOLD_AMT DOUBLE PRECISION 8
31 UNCLEARED_AMT DOUBLE PRECISION 8
32 TD_SWEEP_IN_AMT DOUBLE PRECISION 8
33 SETTLEMENT_REF_ID CHARACTER VARYING(100) 100
34 CHEQUE_DEPOSIT_DATE TIMESTAMP 8
35 CHEQUE_VALUE_DATE TIMESTAMP 8
36 NARRATION CHARACTER VARYING(500) 500
37 END_POINT_SEGMENT_ID CHARACTER VARYING(100) 100
38 PRICING_DEF_ID CHARACTER VARYING(50) 50
39 OBJECT_VERSION_NUMBER DOUBLE PRECISION 8
40 ADJUSTMENT_AMT DOUBLE PRECISION 8
41 PROCESS_DATE TIMESTAMP 8
42 ATM_NARRATION CHARACTER VARYING(500) 500
43 TXN_LITERAL CHARACTER VARYING(5) 5
44 TEMPORARY_EXCESS_AMT DOUBLE PRECISION 8
45 PSEUDO_ENTRY CHARACTER VARYING(4) 4
46 USER_REFERENCE_NUMBER CHARACTER VARYING(50) 50
47 IS_USER_INIT_TXN CHARACTER VARYING(1) 1
48 IS_TXN_REVERSED CHARACTER VARYING(1) 1
49 CHEQUE_DATE TIMESTAMP 8
50 CREDIT_REFERENCE_NUMBER CHARACTER VARYING(50) 50
51 CARD_REF_NO CHARACTER VARYING(50) 50
52 FX_RATE DOUBLE PRECISION 8
53 PARTY_NOTE CHARACTER VARYING(2048) 2048
54 BILLER_ID CHARACTER VARYING(20) 20
55 TAGS CHARACTER VARYING(1024) 1024
56 EMAIL CHARACTER VARYING(1024) 1024
57 CONTACT_PHONE_1 CHARACTER VARYING(40) 40
58 LATITUDE DOUBLE PRECISION 8
59 LONGITUDE DOUBLE PRECISION 8
60 LINE1 CHARACTER VARYING(1024) 1024
61 CITY CHARACTER VARYING(255) 255
62 STATE CHARACTER VARYING(255) 255
63 COUNTRY CHARACTER VARYING(255) 255
64 ZIP CHARACTER VARYING(40) 40
65 FEE_NAME CHARACTER VARYING(40) 40
66 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
67 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
68 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
69 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8