How open invoice interface works in receivables?
Hi,
We are in version 12.1.3
I'm working on data conversion on open invoices in Receivables.
Following tables are used by AutoInvoice import.
1. RA_INTERFACE_LINES_ALL
2. RA_DISTRIBUTIONS_LINES_ALL
I need following clarifications.
Assume there are five lines for an invoice in the legacy system.
i. In that case, should there be 5 lines in RA_INTERFACE_LINES_ALL, with header value repeating for each line?
ii. Will lines belonging to header be identified by RA_INTERFACE_LINES_ALL.TRX_DATE?
iii. Which column is used to link RA_INTERFACE_LINES_ALL and RA_DISTRIBUTIONS_LINES_ALL
We are in version 12.1.3
I'm working on data conversion on open invoices in Receivables.
Following tables are used by AutoInvoice import.
1. RA_INTERFACE_LINES_ALL
2. RA_DISTRIBUTIONS_LINES_ALL
I need following clarifications.
Assume there are five lines for an invoice in the legacy system.
i. In that case, should there be 5 lines in RA_INTERFACE_LINES_ALL, with header value repeating for each line?
ii. Will lines belonging to header be identified by RA_INTERFACE_LINES_ALL.TRX_DATE?
iii. Which column is used to link RA_INTERFACE_LINES_ALL and RA_DISTRIBUTIONS_LINES_ALL
0