FND Design Data [Home] [Help]

Table: IBY_DOCUMENTS_PAYABLE_H

Product: IBY - Payments
Description: IBY_DOCUMENTS_PAYABLE_H stores historical snapshots of documents payable. This table contains denormalized versions of documents payable from specific points in time, such as when the payment for this document was submitted to a payment sys
Implementation/DBA Data: TableIBY.IBY_DOCUMENTS_PAYABLE_H
Primary Key: IBY_DOCUMENTS_PAYABLE_H_PK
  1. ColumnDOCUMENT_PAYABLE_HISTORY_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
IBY_DOCUMENTS_PAYABLE_H FK Joins to TableIBY_ACCT_PMT_PROFILES_B IBY_DOCUMENTS_PAYABLE_H.PAYMENT_PROFILE_ID
IBY_DOCUMENTS_PAYABLE_H FK Joins to TableIBY_PAYMENTS_ALL IBY_DOCUMENTS_PAYABLE_H.PAYMENT_ID
IBY_DOCUMENTS_PAYABLE_H FK Joins to TableIBY_PAYMENTS_H IBY_DOCUMENTS_PAYABLE_H.PAYMENT_HISTORY_ID
IBY_DOCUMENTS_PAYABLE_H FK Joins to TableIBY_PAYMENT_METHODS_B IBY_DOCUMENTS_PAYABLE_H.PAYMENT_METHOD_CODE
IBY_DOCUMENTS_PAYABLE_H FK Joins to TableIBY_TRXN_TYPES_B IBY_DOCUMENTS_PAYABLE_H.CALLING_APP_ID
IBY_DOCUMENTS_PAYABLE_H.PAY_PROC_TRXN_TYPE_CODE
IBY_DOCUMENTS_PAYABLE_H FK Joins to TableIBY_PAY_SERVICE_REQUESTS IBY_DOCUMENTS_PAYABLE_H.PAYMENT_SERVICE_REQUEST_ID
IBY_DOCUMENTS_PAYABLE_H FK Joins to TableFND_TERRITORIES IBY_DOCUMENTS_PAYABLE_H.COUNTRY
TableIBY_DOCUMENT_LINES_H FK Joins to IBY_DOCUMENTS_PAYABLE_H IBY_DOCUMENT_LINES_H.DOCUMENT_PAYABLE_HISTORY_ID