Tables Used in Auto Invoice Master Program

When the Auto invoice program is run, data is populated into the tables listed below.

1. RA_BATCHES_ALL

2. RA_CUSTOMER_TRX_ALL

3. RA_CUSTOMER_TRX_LINES_ALL

4. RA_CUST_TRX_LINE-GL_DIST_ALL

5. RA_CUST_TRX_LINE_SALESREPS_ALL

6. AR_RECEIVABLE_APPLICATIONS_ALL

7. AR_PAYMENT_SCHEDULES_ALL

8. AR_PAYMENT_SCHEDULES_ALL

9. RA_INTERFACE_ERRORS_ALL

Query to check Invoices in Error

SELECT ria.line_type, ria.description, ria.currency_code, ria.amount,

ria.trx_date, ria.quantity, ria.quantity_ordered, ria.sales_order,

ria.sales_order_line, ria.sales_order_date, ria.inventory_item_id,

riea.interface_line_id, riea.MESSAGE_TEXT, riea.org_id

FROM ra_interface_errors_all riea, ra_interface_lines_all ria

WHERE riea.interface_line_id = ria.interface_line_id

AND riea.org_id = ria.org_id

Advertisements

One thought on “Tables Used in Auto Invoice Master Program

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s