Untitled

mail@pastecode.io avatar
unknown
plain_text
a year ago
4.5 kB
1
Indexable
Never
DESCRIBE ORS_DS_NAPAS_IBFT_TC_RSLT;
+----------------------------+--------------+------+-----+---------+----------------+
| Field                      | Type         | Null | Key | Default | Extra          |
+----------------------------+--------------+------+-----+---------+----------------+
| id                         | int(11)      | NO   | PRI | NULL    | auto_increment |
| REPORT_DATE                | date         | YES  |     | NULL    |                |
| DATE_INPUT                 | date         | YES  |     | NULL    |                |
| USER_INPUT                 | varchar(100) | YES  |     | NULL    |                |
| mapping_date               | date         | YES  |     | NULL    |                |
| mapping_result             | varchar(300) | YES  |     | NULL    |                |
| OTHER_ACCT_NO              | varchar(300) | YES  |     | NULL    |                |
| OTHER_ACCT_T24             | varchar(300) | YES  |     | NULL    |                |
| AMOUNT                     | varchar(300) | YES  |     | NULL    |                |
| CREDIT_THEIR_REF           | varchar(300) | YES  |     | NULL    |                |
| DEBIT_THEIR_REF            | varchar(300) | YES  |     | NULL    |                |
| PAYMENT_DETAILS            | varchar(300) | YES  |     | NULL    |                |
| CURRENCY                   | varchar(300) | YES  |     | NULL    |                |
| BOOKING_DATE               | varchar(300) | YES  |     | NULL    |                |
| DEVICE_TYPE                | varchar(300) | YES  |     | NULL    |                |
| T24_TRANSACTION_ID         | varchar(300) | YES  |     | NULL    |                |
| TRANSACT_DATE              | varchar(300) | YES  |     | NULL    |                |
| DATETIME_STMT              | varchar(300) | YES  |     | NULL    |                |
| TRANSACT_TIME              | varchar(300) | YES  |     | NULL    |                |
| BEN_ACCT_NO                | varchar(300) | YES  |     | NULL    |                |
| TRACE_NO                   | varchar(300) | YES  |     | NULL    |                |
| AUTH_IDENT_RESP            | varchar(300) | YES  |     | NULL    |                |
| INPUTTER_ID                | varchar(300) | YES  |     | NULL    |                |
| AUTHORISE_ID               | varchar(300) | YES  |     | NULL    |                |
| ACQ_INS_CODE               | varchar(300) | YES  |     | NULL    |                |
| TRADE                      | varchar(300) | YES  |     | NULL    |                |
| CARD_ACCEPTTER_ID          | varchar(300) | YES  |     | NULL    |                |
| UNIQUE_TRANS_ID            | varchar(300) | YES  |     | NULL    |                |
| DEBIT_ACCOUNT              | varchar(300) | YES  |     | NULL    |                |
| VALUE_DATE                 | varchar(300) | YES  |     | NULL    |                |
| CREDIT_ACCOUNT             | varchar(300) | YES  |     | NULL    |                |
| SML_RESPONSE               | varchar(300) | YES  |     | NULL    |                |
| CARD_NO                    | varchar(300) | YES  |     | NULL    |                |
| TRANS_DATE                 | varchar(300) | YES  |     | NULL    |                |
| TRAN_DATE_COMPARE          | varchar(300) | YES  |     | NULL    |                |
| CARDHOLDER_CONVERSION_RATE | varchar(300) | YES  |     | NULL    |                |
| POS_ENTRY_MODE_CODE        | varchar(300) | YES  |     | NULL    |                |
| POS_CONDITION_CODE         | varchar(300) | YES  |     | NULL    |                |
| CARD_ACCEPTOR_TERMINAL_ID  | varchar(300) | YES  |     | NULL    |                |
| ACQ                        | varchar(300) | YES  |     | NULL    |                |
| ISS                        | varchar(300) | YES  |     | NULL    |                |
| MID                        | varchar(300) | YES  |     | NULL    |                |
| BNB                        | varchar(300) | YES  |     | NULL    |                |
| BANK_TRANSACT_ID           | varchar(300) | YES  |     | NULL    |                |
| TRN                        | varchar(300) | YES  |     | NULL    |                |
| DEBIT_CREDIT               | varchar(300) | YES  |     | NULL    |                |
| RTA                        | varchar(300) | YES  |     | NULL    |                |
+----------------------------+--------------+------+-----+---------+----------------+