View: IBY_TRANSACTIONS_V

Product:	IBY - Payments
Description:
Implementation/DBA Data:	APPS.IBY_TRANSACTIONS_V

View Text

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

Columns