Monday 30 January 2012

BANK INFORMATION TO SUPPLIERS

select * from IBY_EXTERNAL_PAYEES_ALL

select * from IBY_EXT_BANK_ACCOUNTS


select * from IBY_EXT_PARTY_PMT_MTHDS

select * from IBY_EXT_BANK_ACCOUNTS

select * from IBY_ACCOUNT_OWNERS

select * from IBY_PMT_INSTR_USES_ALL


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 .This information is stored in the following iPayment (IBY) tables:

No comments:

Post a Comment