Supplier Site Bank Account 表关系

1.IBY_EXTERNAL_PAYEES_ALL
     This table contains payment details of an external payee automatically created by the source product. For example when supplier or supplier site is created manually system automatically inserts row in to the IBY_EXTERNAL_PAYEES_ALL table.
A party can have multiple payees at following levels -
Party or
Site or
Address or
Address operating unit
This table contains the details of all such payees.
IBY_EXTERNAL_PAYEES_ALL stores payment-related attributes for the funds disbursement payment process for external party payees

2.IBY_EXT_BANK_ACCOUNTS
"This table contains records of the external bank accounts entered manually. This table corresponds to the Banking details page of supplier or customer.
This table contains bank, branch, masking, encryption details of the external bank accounts.
This table should not be translated for any columns. This is a common table used by both Funds disbursement and funds Capture module."

3.IBY_PMT_INSTR_USES_ALL
"This table contains records of the relationship between payment instruments and Payer/Payee. Data can be entered manually.
IBY_PMT_INSTR_USES_ALL table assigns payment instruments to external party payers and payees. This table is shared by both the funds disbursement and funds capture modules of Oracle Payments. The payment instruments can be credit cards, bank accounts, etc."

 

Supplier Site Bank.JPG

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/17087603/viewspace-759249/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/17087603/viewspace-759249/