R12 Payment Tables

The new table which hold the bank information are as:

1. CE_BANK_ACCOUNT:stores bank account attributes
2. CE_BANK_ACCT_USES_ALL : This stores the bank account use attributes specific to Operating Unit (AR, AP) and Legal Entity (Treasury).
3. CE_GL_ACCOUNTS_CCID :The accounting data pertaining to the bank account use will be stored in the table.

• IBY_EXTERNAL_PAYEES_ALL : This stores supplier information and customer information
• IBY_EXT_BANK_ACCOUNTS : This storage for bank accounts
• IBY_EXT_PARTY_PMT_MTHDS: This storage for payment method usage rules.
• IBY_CREDITCARD : stores the credit card information for a customer
• IBY_EXT_BANK_ACCOUNTS: This Stores external bank accounts. These records have bank_account_type = Supplier
• IBY_ACCOUNT_OWNERS :stores the joint account owners of a bank account
• IBY_PMT_INSTR_USES_ALL : This stores data from AP_BANK_ACCOUNT_USES_ALL for payment instruments assignments .