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

There are many available reports in Oracle Apps so you can discuss the requirements related to these reports here.
Post Reply
Number13
Posts: 89
Joined: Mon Sep 17, 2007 2:16 am
Location: India

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

Post by Number13 »

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,
karthikeyanp1981
Posts: 463
Joined: Thu Nov 09, 2006 4:50 pm
Location: India
Contact:

Post by karthikeyanp1981 »

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..
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests