OBP24_HST_FLX_ACCOUNT_TXN_AUDIT_ITEM

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 TRANSACTION_REFERENCE_NUMBER CHARACTER VARYING(16) 16
2 SEQUENCE_NUMBER SMALLINT 2
3 ACCOUNT_NUMBER CHARACTER VARYING(40) 40
4 PRODUCT_CODE CHARACTER VARYING(30) 30
5 DEPOSIT_NUMBER BIGINT 8
6 USER_REFERENCE_NUMBER CHARACTER VARYING(120) 120
7 FROM_ACCOUNT_BRANCH CHARACTER VARYING(10) 10
8 ORIGINAL_REFERENCE_NUMBER CHARACTER VARYING(16) 16
9 ORIGINAL_USER_REF_NUMBER CHARACTER VARYING(40) 40
10 PARTY_ID CHARACTER VARYING(40) 40
11 USER_ID CHARACTER VARYING(264) 264
12 LAST_APPROVER_ID CHARACTER VARYING(264) 264
13 CHANNEL_TYPE CHARACTER VARYING(10) 10
14 POSTING_DATE TIMESTAMP 8
15 VALUE_DATE TIMESTAMP 8
16 TRANSACTION_DATE TIMESTAMP 8
17 CONTRA_ACCOUNT_NUMBER CHARACTER VARYING(40) 40
18 CONTRA_DEPOSIT_NUMBER BIGINT 8
19 CONTRA_BRANCH CHARACTER VARYING(10) 10
20 MESSAGE_TYPE CHARACTER VARYING(30) 30
21 TRANSACTION_TYPE CHARACTER VARYING(30) 30
22 TRANSACTION_BRANCH CHARACTER VARYING(10) 10
23 TRANSACTION_MNEMONIC CHARACTER VARYING(45) 45
24 TRANSACTION_LITERAL CHARACTER VARYING(45) 45
25 TRANSACTION_DESCRIPTION CHARACTER VARYING(500) 500
26 ORIGINAL_MESSAGE_TYPE CHARACTER VARYING(30) 30
27 EVENT_ID CHARACTER VARYING(30) 30
28 TRANSACTION_AMOUNT DOUBLE PRECISION 8
29 TRANSACTION_CURRENCY CHARACTER VARYING(3) 3
30 ACCOUNT_AMOUNT DOUBLE PRECISION 8
31 ACCOUNT_CURRENCY CHARACTER VARYING(3) 3
32 TXN_TO_ACCT_RATE DOUBLE PRECISION 8
33 INSTRUMENT_TYPE CHARACTER VARYING(45) 45
34 INSTRUMENT_NUMBER CHARACTER VARYING(45) 45
35 INSTRUMENT_DATE TIMESTAMP 8
36 INSTRUMENT_CURRENCY CHARACTER VARYING(3) 3
37 INSTRUMENT_ACCOUNT_NUMBER CHARACTER VARYING(40) 40
38 MICR_NUMBER CHARACTER VARYING(45) 45
39 DRAWER_ACCOUNT CHARACTER VARYING(40) 40
40 PAYEE_ACCOUNT CHARACTER VARYING(40) 40
41 LIQUIDATION_DATE TIMESTAMP 8
42 ROUTING_NUMBER CHARACTER VARYING(45) 45
43 EXTERNAL_REFERENCE_NUMBER CHARACTER VARYING(40) 40
44 PRIMARY_ACCOUNT_NUMBER CHARACTER VARYING(40) 40
45 RENEWAL_NUMBER BIGINT 8
46 ORIGINAL_DEPOSIT_NUMBER BIGINT 8
47 CONTRA_RENEWAL_NUMBER BIGINT 8
48 CONTRA_ORIGINAL_DEPOSIT_NUMBER BIGINT 8
49 FINANCIAL_EVENT_TYPE CHARACTER VARYING(20) 20
50 REPRESENTATIVE_TYPE CHARACTER VARYING(20) 20
51 REPRESENTATIVE_NAME CHARACTER VARYING(45) 45
52 IDENTIFICATION_NUMBER CHARACTER VARYING(30) 30
53 TELEPHONE_NUMBER CHARACTER VARYING(10) 10
54 STD_CODE CHARACTER VARYING(10) 10
55 ISD_CODE CHARACTER VARYING(10) 10
56 EXTENSION CHARACTER VARYING(10) 10
57 FEE_CODE CHARACTER VARYING(20) 20
58 PRICE_TICKET_NUMBER CHARACTER VARYING(40) 40
59 REVERSAL_FLAG CHARACTER(1) 1
60 MODULE_TYPE CHARACTER VARYING(30) 30
61 CARD_REF_NO CHARACTER VARYING(45) 45
62 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
63 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
64 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
65 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8