OBP24_FLX_LN_FIN_STMT_LOGS
Description
Synonyms
SDSNZP05_BANK..CBA_OBP_FLX_LN_FIN_STMT_LOGS
SDSNZP05_BANK..CBP_OBP_FLX_LN_FIN_STMT_LOGS
SDSNZP05_BANK..NROD_OBP_FLX_LN_FIN_STMT_LOGS
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | TXN_REF_NO | CHARACTER VARYING(50) | 50 |
| 2 | SUB_SEQ_NO | DOUBLE PRECISION | 8 |
| 3 | ACCOUNT_CODE | CHARACTER VARYING(50) | 50 |
| 4 | TXN_CHANNEL | CHARACTER VARYING(50) | 50 |
| 5 | TXN_BRANCH | CHARACTER VARYING(10) | 10 |
| 6 | TXN_DESC | CHARACTER VARYING(500) | 500 |
| 7 | SERVICE_ID | CHARACTER VARYING(50) | 50 |
| 8 | EVENT_ID | CHARACTER VARYING(50) | 50 |
| 9 | USER_REF_NO | CHARACTER VARYING(50) | 50 |
| 10 | USER_NO | CHARACTER VARYING(50) | 50 |
| 11 | AUTHORIZER_CODE | CHARACTER VARYING(50) | 50 |
| 12 | CHEQUE_NO | CHARACTER VARYING(50) | 50 |
| 13 | MSG_TYPE | CHARACTER VARYING(50) | 50 |
| 14 | TXN_TYPE | CHARACTER VARYING(50) | 50 |
| 15 | TXN_AMOUNT_TCY | DOUBLE PRECISION | 8 |
| 16 | TCY_CODE | CHARACTER VARYING(3) | 3 |
| 17 | TXN_AMOUNT_ACY | DOUBLE PRECISION | 8 |
| 18 | ACY_CODE | CHARACTER VARYING(3) | 3 |
| 19 | POSTING_DATE | TIMESTAMP | 8 |
| 20 | VALUE_DATE | TIMESTAMP | 8 |
| 21 | TRANSACTION_DATE | TIMESTAMP | 8 |
| 22 | PRICING_TICKET_NO | CHARACTER VARYING(50) | 50 |
| 23 | SETTLEMENT_REF_ID | CHARACTER VARYING(40) | 40 |
| 24 | CHEQUE_DEPOSIT_DATE | TIMESTAMP | 8 |
| 25 | CHEQUE_VALUE_DATE | TIMESTAMP | 8 |
| 26 | NARRATION | CHARACTER VARYING(500) | 500 |
| 27 | END_POINT_SEGMENT_ID | CHARACTER VARYING(100) | 100 |
| 28 | PRICING_DEF_ID | CHARACTER VARYING(50) | 50 |
| 29 | ATM_NARRATION | CHARACTER VARYING(40) | 40 |
| 30 | TXN_LITERAL | CHARACTER VARYING(100) | 100 |
| 31 | SEARCH_SUMMARY | CHARACTER VARYING(500) | 500 |
| 32 | OBJECT_VERSION_NUMBER | DOUBLE PRECISION | 8 |
| 33 | PROCESS_DATE | TIMESTAMP | 8 |
| 34 | PARTY_ID | CHARACTER VARYING(40) | 40 |
| 35 | PARTY_NAME | CHARACTER VARYING(100) | 100 |
| 36 | ACCOUNT_TITLE | CHARACTER VARYING(120) | 120 |
| 37 | SANCTIONED_AMT | DOUBLE PRECISION | 8 |
| 38 | SANCTIONED_TERM_MONTHS | BIGINT | 8 |
| 39 | TOTAL_DISBURSED_AMT | DOUBLE PRECISION | 8 |
| 40 | OUTSTANDING_PRINCIPAL_BAL | DOUBLE PRECISION | 8 |
| 41 | STATEMENT_PERIOD_START_DATE | TIMESTAMP | 8 |
| 42 | STATEMENT_PERIOD_END_DATE | TIMESTAMP | 8 |
| 43 | TRANSACTION_TIME | TIMESTAMP | 8 |
| 44 | TRANSACTION_KEYWORD | CHARACTER VARYING(40) | 40 |
| 45 | TOTAL_OUTSTANDING_BAL | DOUBLE PRECISION | 8 |
| 46 | RUNNING_BAL | DOUBLE PRECISION | 8 |
| 47 | PAYMENT_DETAILS | CHARACTER VARYING(120) | 120 |
| 48 | RPA_OR_ALL_ARREAR_AMT | DOUBLE PRECISION | 8 |
| 49 | CHEQUE_DATE | TIMESTAMP | 8 |
| 50 | CARD_REF_NO | CHARACTER VARYING(50) | 50 |
| 51 | FX_RATE | DOUBLE PRECISION | 8 |
| 52 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 53 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 54 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 55 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |