tables populated

[prema]

Hi everybody

Can anybody tell me which tables are populated(at header and line level) in AP and AR when the Open Interface Standard programs are executed

regards
prema

[SIVAKUMAR_G]

Hi

To import invoices through the open interface, you must
populate the AP_INVOICES_INTERFACE and
AP_INVOICE_LINES_INTERFACE tables.
Once the import process is complete, the data from the
interface tables will be in the AP_INVOICES_ALL and
AP_INVOICE_DISTRIBUTIONS_ALL tables.

For AR

You Need to populate
ra_interface_lines_all
RA_INTERFACE_DISTRIBUTIONS_ALL
RA_INTERFACE_SALESCREDITS_ALL

Hope this helps

Regards
Sivakumar

[ramkic]

Hi,
The following base tables will be populated with data for AP and AR Invoices Interfaces:
For AP:
1) ap_batches_all (if batch controll is using)
2) ap_invoices_all
3) ap_invoice_distributions_all
4) ap_payment_schedules_all

For AR:
1) ra_batches_all
2) ra_customer_trx_all
3) ra_customer_trx_lines_all
4) ra_cust_trx_line_gl_dist
5) ra_cust_trx_line_salesreps
6) ar_payment_schedules_all
7) ar_receivable_applications
ar_adjustments

Hope this will hwlp

Thanks
Best Regards
ramkic

[prema]

thanks a lot