OBP24_HST_FLX_PC_TXN_LOG_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 REF_NO CHARACTER VARYING(40) 40
2 SERIAL_NO DOUBLE PRECISION 8
3 LIFE_CYCLE_ID CHARACTER VARYING(40) 40
4 TXN_TYPE CHARACTER VARYING(1) 1
5 MSG_BATCH_ID CHARACTER VARYING(40) 40
6 ACCT_NO CHARACTER VARYING(20) 20
7 MODULE_TYPE CHARACTER VARYING(25) 25
8 ACCT_CCY CHARACTER VARYING(3) 3
9 PARTY_ID CHARACTER VARYING(40) 40
10 PARTY_NAME CHARACTER VARYING(250) 250
11 TXN_AMT DOUBLE PRECISION 8
12 TXN_AMT_CCY CHARACTER VARYING(3) 3
13 NARRATIVE CHARACTER VARYING(255) 255
14 ORG_BRANCH CHARACTER VARYING(32) 32
15 BRANCH_CODE CHARACTER VARYING(10) 10
16 ACCT_STATE CHARACTER VARYING(25) 25
17 POSTING_DATE TIMESTAMP 8
18 ACTV_DATE TIMESTAMP 8
19 COLL_TYPE CHARACTER VARYING(25) 25
20 CATEGORY_ID CHARACTER VARYING(32) 32
21 PAYMENT_TYPE CHARACTER VARYING(25) 25
22 TRANSFER_TYPE CHARACTER VARYING(25) 25
23 NTWRK_ACCT_STATE CHARACTER VARYING(25) 25
24 MSG_TYPE CHARACTER VARYING(10) 10
25 CHANNEL_ID CHARACTER VARYING(32) 32
26 CHANNEL_REF_NO CHARACTER VARYING(40) 40
27 ENDPOINT_REF_NO CHARACTER VARYING(40) 40
28 MOD_REF_NO CHARACTER VARYING(40) 40
29 OFFSET_TXN_REF_NO CHARACTER VARYING(40) 40
30 IS_RETURN_ADVICE_REQRD CHARACTER VARYING(32) 32
31 CONSOL_REQD_FLG CHARACTER(1) 1
32 TRACER_DETAIL_REQD_FLG CHARACTER(1) 1
33 CASH_LETR_REF CHARACTER VARYING(32) 32
34 IS_GUARANTEE CHARACTER(1) 1
35 BANK_PRIORITY CHARACTER VARYING(32) 32
36 CHRG_MODE CHARACTER VARYING(32) 32
37 MSG_GEN_OPT CHARACTER VARYING(32) 32
38 MSG_GEN_DATE TIMESTAMP 8
39 TXN_SOURCE CHARACTER VARYING(32) 32
40 BATCH CHARACTER VARYING(10) 10
41 PROXY_ACCT_NO CHARACTER VARYING(40) 40
42 OVER_DRAFT_ALLOWED CHARACTER(1) 1
43 INCLUDE_COVER CHARACTER(1) 1
44 MAX_COUNT DOUBLE PRECISION 8
45 CURRENT_COUNT DOUBLE PRECISION 8
46 CREATION_DATE TIMESTAMP 8
47 LAST_UPDATED_DATE TIMESTAMP 8
48 OBJECT_VERSION_NUMBER DOUBLE PRECISION 8
49 ORG_TXN_REF_NO CHARACTER VARYING(40) 40
50 ARRANGEMENT_ID CHARACTER VARYING(40) 40
51 ORIGIN_ACCT_NO CHARACTER VARYING(40) 40
52 ORIGIN_ACCT_TYPE CHARACTER VARYING(25) 25
53 BUSINESS_UNIT CHARACTER VARYING(40) 40
54 ARRANGEMENT_MODULE_TYPE CHARACTER VARYING(25) 25
55 USER_REF_NO CHARACTER VARYING(50) 50
56 DIRECT_ENTRY_NO CHARACTER VARYING(50) 50
57 TOTAL_FEE_AMT_CCY CHARACTER VARYING(3) 3
58 TOTAL_FEE_AMT DOUBLE PRECISION 8
59 NET_TXN_AMT DOUBLE PRECISION 8
60 NET_TXN_AMT_CCY CHARACTER VARYING(3) 3
61 TRACE_ACCOUNT CHARACTER VARYING(20) 20
62 TRACE_ACCOUNT_MODULE CHARACTER VARYING(25) 25
63 BUSINESS_TXN_REF_NO CHARACTER VARYING(40) 40
64 HOLD_REF_NO CHARACTER VARYING(40) 40
65 INITIATOR_NAME CHARACTER VARYING(250) 250
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