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
tables populated
-
- Posts: 194
- Joined: Tue May 15, 2007 7:45 am
- Location: United Arab Emirates
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
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
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
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
Who is online
Users browsing this forum: No registered users and 1 guest