eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: IBY_TRXN_SUMMARIES_ALL

Product:	IBY - Payments
Description:	IBY_TRXN_SUMMARIES_ALL contains information about each payment request. This table is used for both online and offline payment transactions. The information contained in this table is generic in nature to cover the various payment inst
Implementation/DBA Data:	IBY.IBY_TRXN_SUMMARIES_ALL

Primary Key: IBY_TRXN_SUMMARIES_ALL_PK

TRXNMID

Primary Key: IBY_TRXN_SUMMARY_PK

TRXNMID

Foreign Keys

Table	Foreign Table	Foreign Key Column
IBY_TRXN_SUMMARIES_ALL	IBY_PAYEE	IBY_TRXN_SUMMARIES_ALL.MPAYEEID
IBY_TRXN_SUMMARIES_ALL	IBY_CC_ISSUER_RANGES	IBY_TRXN_SUMMARIES_ALL.CC_ISSUER_RANGE_ID
IBY_TRXN_SUMMARIES_ALL	%	IBY_TRXN_SUMMARIES_ALL.INSTRNUM_SEC_SEGMENT_ID
IBY_TRXN_SUMMARIES_ALL	IBY_PMT_INSTR_USES_ALL	IBY_TRXN_SUMMARIES_ALL.PAYER_INSTR_ASSIGNMENT_ID
IBY_TRXN_SUMMARIES_ALL	AR_RECEIPT_METHODS	IBY_TRXN_SUMMARIES_ALL.AR_RECEIPT_METHOD_ID
IBY_TRXN_SUMMARIES_ALL	IBY_FNDCPT_TX_EXTENSIONS	IBY_TRXN_SUMMARIES_ALL.INITIATOR_EXTENSION_ID
IBY_TRXN_SUMMARIES_ALL	IBY_BATCHES_ALL	IBY_TRXN_SUMMARIES_ALL.MBATCHID
IBY_TRXN_SUMMARIES_ALL	IBY_BEPINFO	IBY_TRXN_SUMMARIES_ALL.BEPID
IBY_TRXN_SUMMARIES_ALL	IBY_TANGIBLE	IBY_TRXN_SUMMARIES_ALL.MTANGIBLEID
IBY_TRXN_SUMMARIES_ALL	HZ_CUST_ACCOUNTS	IBY_TRXN_SUMMARIES_ALL.CUST_ACCOUNT_ID
IBY_TRXN_SUMMARIES_ALL	HZ_PARTIES	IBY_TRXN_SUMMARIES_ALL.SALES_REP_PARTY_ID
IBY_TRXN_SUMMARIES_ALL	IBY_PAYEE_SUBKEYS	IBY_TRXN_SUMMARIES_ALL.SUB_KEY_ID
IBY_TRXN_SUMMARIES_ALL	IBY_PAYEE	IBY_TRXN_SUMMARIES_ALL.MPAYEEID
IBY_TRXN_SUMMARIES_ALL	IBY_BEPINFO	IBY_TRXN_SUMMARIES_ALL.BEPID
IBY_TRXN_SUMMARIES_ALL	IBY_TANGIBLE	IBY_TRXN_SUMMARIES_ALL.MTANGIBLEID
IBY_F_T_CRDT_APPS_ALL_B	IBY_TRXN_SUMMARIES_ALL	IBY_F_T_CRDT_APPS_ALL_B.TRXN_SUMMARY_ID
IBY_G_T_MESSAGES	IBY_TRXN_SUMMARIES_ALL	IBY_G_T_MESSAGES.TRXN_SUMMARY_ID
IBY_TRXN_CORE	IBY_TRXN_SUMMARIES_ALL	IBY_TRXN_CORE.TRXNMID
IBY_TRXN_DOCUMENTS	IBY_TRXN_SUMMARIES_ALL	IBY_TRXN_DOCUMENTS.TRXNMID
IBY_TRXN_EXTENDED	IBY_TRXN_SUMMARIES_ALL	IBY_TRXN_EXTENDED.TRXNMID
IBY_TRXN_EXTENSIBILITY	IBY_TRXN_SUMMARIES_ALL	IBY_TRXN_EXTENSIBILITY.TRXNMID
IBY_TRXN_FI	IBY_TRXN_SUMMARIES_ALL	IBY_TRXN_FI.TRXNMID