Untitled
unknown
plain_text
2 years ago
4.5 kB
4
Indexable
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 | | +----------------------------+--------------+------+-----+---------+----------------+
Editor is loading...