ERPstuff - Oracle EBS Community

Posted: **Fri Sep 04, 2009 3:29 am**

Hi everybody,

I have to create bank transfer letter for giving instruction to our bank to transfer money in our suppliers bank account. For this we need following information:

Bank Name
IFSC CODE
Account holder name (External bank owner name as in account name)
External bank account number
Type of Account
Branch

Now I am not getting all infromation in any table.

Please help me as soon as possible. Its really really urgent.

Thanks,

Posted: **Fri Sep 04, 2009 5:09 am**

So you will be generating a bank transfer letter for every payment made to a supplier right ?

Since you have not mentioned any specific version, i assume you are in release 11, following table names might help you..
AP_BANK_BRANCHES
AP_BANK_ACCOUNTS_ALL
AP_Checks_All
AP_Invoice_Payments_All

Also refer to metalink note 148388.1 and download sample aplist which contains all payment related table names along with columns ....

NOTE: Make sure all of your suppliers are assigned to an supplier bank account , else it will be difficult to satisfy the requirement..

ERPstuff - Oracle EBS Community

Table 4 Extrnl bank a/c holder name and a/c number

Table 4 Extrnl bank a/c holder name and a/c number