OBP24_FLX_TD_TRANSACTION_DETAIL
Description
Synonyms
SDSNZP05_BANK..CBP_OBP_FLX_TD_TRANSACTION_DETAIL
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 |