IBY_TRANS_FI_V

Details

• Schema: FUSION

• Object owner: IBY

• Object type: VIEW

Columns

Name
TRANSACTIONID PAYEEID BEPID ECAPPID TRXNMID PAYERID PAYERINSTRID PAYEEINSTRID REQDATE REQTYPE STATUS SETTLEDATE UPDATEDATE TRXNTYPE ERRORLOCATION BEPCODE BEPMESSAGE BATCHID NEEDSUPDT DESTURL PAYMENTMETHODNAME AMOUNT CURRENCYNAMECODE ACCTNO REFINFO MEMO TANGIBLEID PMTSCHEMEID REFERENCECODE SRVID PSREQID ORG_ID NLSLANG NAME ORDER_MEDIUM EFT_AUTH_METHOD

Query

SQL_Statement

SELECT b.TransactionId, b.PayeeId, b.BEPID, b.ECAppID, b.trxnMID, b.payerid, b.payerinstrid, b.payeeinstrid, b.ReqDate, b.ReqType, b.Status, b.SettleDate, b.UpdateDate, b.TrxnTypeid, b.ErrorLocation, b.BEPCode, b.BEPMessage, b.BatchID , b.NeedsUpdt, b.destURL, b.PaymentMethodName, round(t.amount,2) amount, t.currencynamecode, t.acctno, t.refinfo, t.memo, t.TangibleId, e.PmtSchemeId, c.ReferenceCode, c.SrvID, c.PsReqId, b.org_id, b.nlslang, p.name, t.order_medium, t.eft_auth_method from iby_trxn_summaries_all b, iby_trxn_fi c, iby_pmtschemes e, iby_tangible t, iby_payee p WHERE t.mtangibleid = b.mtangibleid and b.trxnMID = c.trxnMID and b.bepid = e.bepid and p.payeeid = b.payeeid and e.pmtschemename = 'FI'