OBP24_FLX_WL_WORKITEM
Description
Synonyms
SDSNZP05_BANK..CBP_OBP_FLX_WL_WORKITEM
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | ID | CHARACTER VARYING(50) | 50 |
| 2 | COD_TASK | CHARACTER VARYING(12) | 12 |
| 3 | DAT_POST | TIMESTAMP | 8 |
| 4 | COD_INITIATOR_ID | CHARACTER VARYING(254) | 254 |
| 5 | COD_CC_BRN | CHARACTER VARYING(10) | 10 |
| 6 | COD_CHANNEL_ID | CHARACTER VARYING(12) | 12 |
| 7 | COD_MNT_ACTION | CHARACTER(1) | 1 |
| 8 | COD_VERSION | CHARACTER VARYING(12) | 12 |
| 9 | COD_MSG_TYP | CHARACTER VARYING(12) | 12 |
| 10 | REFERENCE_NUMBER | CHARACTER VARYING(50) | 50 |
| 11 | ORG_REFERENCE_NUMBER | CHARACTER VARYING(50) | 50 |
| 12 | APPROVAL_CONFIRMATION_VALUE | CHARACTER VARYING(50) | 50 |
| 13 | COD_LAST_APPROVER_ID | CHARACTER VARYING(254) | 254 |
| 14 | COD_CURRENT_APPROVER_ID | CHARACTER VARYING(254) | 254 |
| 15 | COD_ACQUIRER_ID | CHARACTER VARYING(254) | 254 |
| 16 | STATUS | CHARACTER VARYING(50) | 50 |
| 17 | PROCESSING_STATUS | CHARACTER VARYING(15) | 15 |
| 18 | COD_ENTITY_KEY | CHARACTER VARYING(500) | 500 |
| 19 | LAST_UPDATED_BY | CHARACTER VARYING(254) | 254 |
| 20 | BATCH_ID | CHARACTER VARYING(50) | 50 |
| 21 | EXT_REF_NUM | CHARACTER VARYING(50) | 50 |
| 22 | VERSION | DOUBLE PRECISION | 8 |
| 23 | ACCOUNT_CODE | CHARACTER VARYING(50) | 50 |
| 24 | TXN_DESC | CHARACTER VARYING(500) | 500 |
| 25 | USER_REF_NO | CHARACTER VARYING(50) | 50 |
| 26 | USER_NO | CHARACTER VARYING(50) | 50 |
| 27 | CHEQUE_NO | CHARACTER VARYING(50) | 50 |
| 28 | DEBIT_CARD_NO | CHARACTER VARYING(50) | 50 |
| 29 | TXN_TYPE | CHARACTER VARYING(50) | 50 |
| 30 | CHEQUE_DEPOSIT_DATE | TIMESTAMP | 8 |
| 31 | CHEQUE_VALUE_DATE | TIMESTAMP | 8 |
| 32 | END_POINT_SEGMENT_ID | CHARACTER VARYING(100) | 100 |
| 33 | PROCESS_DATE | TIMESTAMP | 8 |
| 34 | SERVICE_ID | CHARACTER VARYING(1024) | 1024 |
| 35 | EVENT_ID | CHARACTER VARYING(50) | 50 |
| 36 | PRICING_TICKET_NO | CHARACTER VARYING(50) | 50 |
| 37 | PRICING_DEF_ID | CHARACTER VARYING(50) | 50 |
| 38 | NARRATION | CHARACTER VARYING(500) | 500 |
| 39 | ATM_NARRATION | CHARACTER VARYING(40) | 40 |
| 40 | TXN_LITERAL | CHARACTER VARYING(100) | 100 |
| 41 | MODULE_TYPE | CHARACTER VARYING(10) | 10 |
| 42 | TXN_AMOUNT_TCY | DOUBLE PRECISION | 8 |
| 43 | TCY_CODE | CHARACTER VARYING(3) | 3 |
| 44 | TXN_AMOUNT_ACY | DOUBLE PRECISION | 8 |
| 45 | ACY_CODE | CHARACTER VARYING(3) | 3 |
| 46 | CASH_TYPE | CHARACTER VARYING(1) | 1 |
| 47 | VALUE_DATE | TIMESTAMP | 8 |
| 48 | TRANSACTION_DATE | TIMESTAMP | 8 |
| 49 | REVERSAL_SUPPORTED | CHARACTER VARYING(1) | 1 |
| 50 | ACCOUNT_STATUS | CHARACTER VARYING(40) | 40 |
| 51 | INSTRUMENT_CODE | CHARACTER VARYING(5) | 5 |
| 52 | INSTRUMENT_TYPE | CHARACTER VARYING(25) | 25 |
| 53 | TITLE | CHARACTER VARYING(1024) | 1024 |
| 54 | SYSTEM_DATE | TIMESTAMP | 8 |
| 55 | SERVICING_PARTY_CODE | CHARACTER VARYING(40) | 40 |
| 56 | TRANSACTING_PARTY_CODE | CHARACTER VARYING(40) | 40 |
| 57 | ARRANGEMENT_ID | CHARACTER VARYING(40) | 40 |
| 58 | TXN_AMOUNT | DOUBLE PRECISION | 8 |
| 59 | TXN_CCY_CODE | CHARACTER VARYING(3) | 3 |
| 60 | COD_INITIATOR_ROLE | CHARACTER VARYING(40) | 40 |
| 61 | MARKET_ENTITY | CHARACTER VARYING(1024) | 1024 |
| 62 | BUSINESS_UNIT | CHARACTER VARYING(40) | 40 |
| 63 | REASON_CODES | CHARACTER VARYING(1024) | 1024 |
| 64 | FEE_AMOUNT | DOUBLE PRECISION | 8 |
| 65 | FEE_CCY_CODE | CHARACTER VARYING(3) | 3 |
| 66 | COD_BANK | CHARACTER VARYING(3) | 3 |
| 67 | TIME_INITIATION | TIMESTAMP | 8 |
| 68 | DAT_LAST_UPDATE | TIMESTAMP | 8 |
| 69 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 70 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 71 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 72 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |