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_PAYMENTS_H

Product:	IBY - Payments
Description:	IBY_PAYMENTS_H table stores historical snapshots of payments. This table contains denormalized versions of payments from specific points in time, including when the payment was submitted to a payment system. Different snapshots of the same
Implementation/DBA Data:	IBY.IBY_PAYMENTS_H

Primary Key: IBY_PAYMENTS_H_PK

PAYMENT_HISTORY_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
IBY_PAYMENTS_H	IBY_BANK_INSTRUCTIONS_B	IBY_PAYMENTS_H.BANK_INSTRUCTION1_CODE
IBY_PAYMENTS_H	IBY_PAYMENT_REASONS_B	IBY_PAYMENTS_H.PAYMENT_REASON_CODE
IBY_PAYMENTS_H	IBY_PAY_INSTRUCTIONS_ALL	IBY_PAYMENTS_H.PAYMENT_INSTRUCTION_ID
IBY_PAYMENTS_H	IBY_PAY_SERVICE_REQUESTS	IBY_PAYMENTS_H.PAYMENT_SERVICE_REQUEST_ID
IBY_PAYMENTS_H	IBY_PAY_INSTRUCTIONS_H	IBY_PAYMENTS_H.PAYMENT_INSTRUCTION_HISTORY_ID
IBY_PAYMENTS_H	IBY_BANK_INSTRUCTIONS_B	IBY_PAYMENTS_H.BANK_INSTRUCTION2_CODE
IBY_PAYMENTS_H	FND_TERRITORIES	IBY_PAYMENTS_H.COUNTRY
IBY_DOCUMENTS_PAYABLE_H	IBY_PAYMENTS_H	IBY_DOCUMENTS_PAYABLE_H.PAYMENT_HISTORY_ID