IBY_TRANSACTIONS_V

Details

• Schema: FUSION

• Object owner: IBY

• Object type: VIEW

Columns

Name
ORDER_ID BEPKEY MERCHANT_ID VENDOR_ID TRXN_TYPE AMOUNT CURRENCY TIME STATUS PAYMENT_TYPE MERCHBATCHID PAYMENT_NAME AUTHCODE AVSCODE REFERENCECODE ERROR_LOCATION VENDOR_CODE ACQUIRER VENDOR_MESSAGE AUXMSG TERMINALID TRACENUMBER ORG_ID

Query

SQL_Statement

SELECT TangibleID order_id, Bepkey, PayeeID merchant_id, BEPID vendor_id, TrxntypeID trxn_type, Amount, CurrencyNameCode currency, UpdateDate time, Status, PaymentMethodName payment_type, BatchID MerchBatchID, InstrName payment_name, AuthCode, AVSCode, ReferenceCode, ErrorLocation error_location, BEPCode vendor_code, Acquirer, BEPMessage vendor_message, Auxmsg, Terminalid, Tracenumber, org_id FROM IBY_TRXN_SUMMARIES_ALL ,IBY_TRXN_CORE WHERE iby_trxn_summaries_all.TrxnMID = iby_trxn_core .TrxnMID