OBP24_HST_FLX_TD_TRANSACTION_DETAIL

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 TRANSACTION_REFERENCE_NO CHARACTER VARYING(40) 40
2 TRANSACTION_SEQUENCE_NO DOUBLE PRECISION 8
3 TRANSACTION_AMT DOUBLE PRECISION 8
4 ACCOUNT_AMT DOUBLE PRECISION 8
5 ACCOUNT_TRANSITION_RATE DOUBLE PRECISION 8
6 TRANSACTION_CURRENCY_ID CHARACTER VARYING(3) 3
7 ACCOUNT_CURRENCY_ID CHARACTER VARYING(3) 3
8 TRANSACTION_DESC CHARACTER VARYING(256) 256
9 NARRATION CHARACTER VARYING(256) 256
10 EVENT_ID CHARACTER VARYING(30) 30
11 TRANSACTION_BRANCH_ID CHARACTER VARYING(10) 10
12 TRANSACTION_DATE TIMESTAMP 8
13 POSTING_DATE TIMESTAMP 8
14 VALUE_DATE TIMESTAMP 8
15 TRANSACTION_TYPE CHARACTER VARYING(25) 25
16 SETTLEMENT_REFERENCE_NO CHARACTER VARYING(40) 40
17 TRANSACTION_STATUS CHARACTER VARYING(25) 25
18 TASK_CODE CHARACTER VARYING(25) 25
19 TELLER_ID CHARACTER VARYING(25) 25
20 DEPOSIT_ID DOUBLE PRECISION 8
21 ACCOUNT_ID CHARACTER VARYING(40) 40
22 REMAINING_AMT DOUBLE PRECISION 8
23 UNSETTLED_AMT DOUBLE PRECISION 8
24 REMAINING_CURRENCY_ID CHARACTER VARYING(3) 3
25 UNSETTLED_CURRENCY_ID CHARACTER VARYING(3) 3
26 INTEREST_AMT DOUBLE PRECISION 8
27 INTEREST_CURRENCY_ID CHARACTER VARYING(3) 3
28 TAX_AMT DOUBLE PRECISION 8
29 TAX_CURRENCY_ID CHARACTER VARYING(3) 3
30 PRINCIPAL_AMT DOUBLE PRECISION 8
31 PRINCIPAL_CURRENCY_ID CHARACTER VARYING(3) 3
32 PRIMARY_REASON_CODE CHARACTER VARYING(10) 10
33 SECONDARY_REASON_CODE CHARACTER VARYING(10) 10
34 REDEMPTION_TYPE CHARACTER VARYING(25) 25
35 REDEEM_PRINC_AMT DOUBLE PRECISION 8
36 REDEEM_PRINC_CCY_ID CHARACTER VARYING(3) 3
37 REDEEM_INT_AMT DOUBLE PRECISION 8
38 REDEEM_INT_CCY_ID CHARACTER VARYING(3) 3
39 REDEEM_TAX DOUBLE PRECISION 8
40 REDEEM_TAX_CCY_ID CHARACTER VARYING(3) 3
41 REDEEM_FEE_AMT DOUBLE PRECISION 8
42 REDEEM_FEE_CCY_ID CHARACTER VARYING(3) 3
43 REDEEM_PENALTY_AMT DOUBLE PRECISION 8
44 REDEEM_PENALTY_CCY_ID CHARACTER VARYING(3) 3
45 WAIVE_ADMN_FEE_AMT DOUBLE PRECISION 8
46 WAIVE_ADMN_FEE_CCY CHARACTER VARYING(3) 3
47 ADMN_FEE_REC_FRM_PRINCIPAL DOUBLE PRECISION 8
48 ADMN_FEE_REC_FRM_PRINCIPAL_CCY CHARACTER VARYING(3) 3
49 ECO_COST_REC_FRM_PRINCIPAL DOUBLE PRECISION 8
50 ECO_COST_REC_FRM_PRINCIPAL_CCY CHARACTER VARYING(3) 3
51 UNRECOVERED_ADMN_FEE DOUBLE PRECISION 8
52 UNRECOVERED_ADMN_FEE_CCY CHARACTER VARYING(3) 3
53 WAIVE_ECO_COST DOUBLE PRECISION 8
54 WAIVE_ECO_COST_CCY CHARACTER VARYING(3) 3
55 UNRECOVERED_ECO_COST DOUBLE PRECISION 8
56 IS_REVERSAL_TRANSACTION CHARACTER VARYING(1) 1
57 UNRECOVERED_ECO_COST_CCY CHARACTER VARYING(3) 3
58 WAIVER_REASON_CODE CHARACTER VARYING(10) 10
59 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
60 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
61 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
62 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8