AP to PA Integration Technical Functional Flow
1) Enter AP Invoice Distributions.
2) Run : Supplier Cost Interface - This will pick the eligible AP Inv Dist , it check PA_ADDITION column. This insert data into pa_transactions_interface.
3) Run : PRC Transaction Imports :- This will pick data from pa_transactions_interface and insert into Expenditure base table.
4) In Expenditure Table we have 3 types of Invoice Source:
a) AP INVOICE
b) AP ERV
c) AP DISCOUNT
Link between PA Expenditure and AP Invoice
pa_expenditure_item.document_header_id = Invoice_id
pa_expenditure_item.document_distribution_id = invoice_distribution_id
Main Table of PA Expenditure:-
PA_EXPENDITURE_ALL
PA_EXPENDITURE_ITEMS_ALL
