OBP24_FLX_PC_TXN_INQUIRY_LOG_B
Description
Synonyms
SDSNZP05_BANK..CBP_OBP_FLX_PC_TXN_INQUIRY_LOG_B
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | REF_NO | CHARACTER VARYING(40) | 40 |
| 2 | SERIAL_NO | DOUBLE PRECISION | 8 |
| 3 | LIFE_CYCLE_ID | CHARACTER VARYING(32) | 32 |
| 4 | TXN_TYPE | CHARACTER VARYING(32) | 32 |
| 5 | MSG_ID | CHARACTER VARYING(32) | 32 |
| 6 | ACCT_NO | CHARACTER VARYING(32) | 32 |
| 7 | MODULE_TYPE | CHARACTER VARYING(25) | 25 |
| 8 | ACCT_CCY | CHARACTER VARYING(3) | 3 |
| 9 | QUEUE | CHARACTER VARYING(32) | 32 |
| 10 | REJECT_CODES | CHARACTER VARYING(500) | 500 |
| 11 | PARTY_ID | CHARACTER VARYING(40) | 40 |
| 12 | PARTY_NAME | CHARACTER VARYING(250) | 250 |
| 13 | BRANCH_CODE | CHARACTER VARYING(10) | 10 |
| 14 | POSTING_DATE | TIMESTAMP | 8 |
| 15 | ACTV_DATE | TIMESTAMP | 8 |
| 16 | VALUE_DATE | TIMESTAMP | 8 |
| 17 | BANK_VALUE_DATE | TIMESTAMP | 8 |
| 18 | RETURN_DATE | TIMESTAMP | 8 |
| 19 | MAX_RESP_DATE | TIMESTAMP | 8 |
| 20 | FLOAT_EXTN_DAYS | DOUBLE PRECISION | 8 |
| 21 | INSTR_NO | CHARACTER VARYING(32) | 32 |
| 22 | TXN_AMT | DOUBLE PRECISION | 8 |
| 23 | TXN_AMT_CCY | CHARACTER VARYING(3) | 3 |
| 24 | CLRD_AMT | DOUBLE PRECISION | 8 |
| 25 | CLRD_AMT_CCY | CHARACTER VARYING(3) | 3 |
| 26 | FUNDS_CLEARED_DATE | TIMESTAMP | 8 |
| 27 | NARRATIVE | CHARACTER VARYING(255) | 255 |
| 28 | ENDPOINT_ID | CHARACTER VARYING(32) | 32 |
| 29 | SEGMENT_ID | CHARACTER VARYING(32) | 32 |
| 30 | PAYMENT_TYPE | CHARACTER VARYING(25) | 25 |
| 31 | COLL_TYPE | CHARACTER VARYING(25) | 25 |
| 32 | TEMPLATE_ID | CHARACTER VARYING(32) | 32 |
| 33 | CATEGORY_ID | CHARACTER VARYING(32) | 32 |
| 34 | CLG_TYPE | CHARACTER VARYING(25) | 25 |
| 35 | MSG_STATE | CHARACTER VARYING(25) | 25 |
| 36 | ACCT_STATE | CHARACTER VARYING(25) | 25 |
| 37 | ITEM_STATUS | CHARACTER VARYING(25) | 25 |
| 38 | TXN_STATE | CHARACTER VARYING(25) | 25 |
| 39 | AUTH_STATE | CHARACTER VARYING(25) | 25 |
| 40 | MSG_DISP_STATE | CHARACTER VARYING(25) | 25 |
| 41 | MSG_DISPATCH_DATE | TIMESTAMP | 8 |
| 42 | ORG_BRANCH | CHARACTER VARYING(32) | 32 |
| 43 | INST_ID_TYPE | CHARACTER VARYING(32) | 32 |
| 44 | INST_ID_VALUE | CHARACTER VARYING(32) | 32 |
| 45 | OUR_CORRES_ID_TYPE | CHARACTER VARYING(32) | 32 |
| 46 | OUR_CORRES_ID_VALUE | CHARACTER VARYING(32) | 32 |
| 47 | PAYABLE_AT_ID_TYPE | CHARACTER VARYING(32) | 32 |
| 48 | PAYABLE_AT_ID_VALUE | CHARACTER VARYING(32) | 32 |
| 49 | CLR_BRANCH_BANK_ID | CHARACTER VARYING(14) | 14 |
| 50 | CLR_BRANCH_BRANCH_ID | CHARACTER VARYING(32) | 32 |
| 51 | OUTGOING_COLL_STATUS | CHARACTER VARYING(25) | 25 |
| 52 | INCOMING_COLL_STATUS | CHARACTER VARYING(25) | 25 |
| 53 | CTRPARTY_ACCT_NO | CHARACTER VARYING(40) | 40 |
| 54 | CTRPARTY_NAME | CHARACTER VARYING(250) | 250 |
| 55 | MAKER | CHARACTER VARYING(32) | 32 |
| 56 | BATCH_ID | CHARACTER VARYING(32) | 32 |
| 57 | IS_REJECT_QUEUE | CHARACTER(1) | 1 |
| 58 | ARRANGEMENT_ID | CHARACTER VARYING(40) | 40 |
| 59 | BUSINESS_UNIT | CHARACTER VARYING(40) | 40 |
| 60 | ARRANGEMENT_MODULE_TYPE | CHARACTER VARYING(25) | 25 |
| 61 | CHANNEL_REF_NO | CHARACTER VARYING(40) | 40 |
| 62 | REFUSAL_TXN_TYPE | CHARACTER VARYING(10) | 10 |
| 63 | BUS_TXN_FLAG | CHARACTER VARYING(1) | 1 |
| 64 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 65 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 66 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 67 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |