Which interface tables are used for Invoice Import , give
the important columns?

Answer Posted / ritesh gakher

Interface Tables are:

AP_INVOICES_INTERFACE

Important Columns are:
INVOICE_ID, GL_DATE, INVOICE_AMOUNT, INVOICE_DATE,
INVOICE_NUM, INVOICE_TYPE_LOOKUP_CODE, ORG_ID, TERMS_ID,
VENDOR_ID, VENDOR_SITE_ID, ACCTS_PAY_CODE_COMBINATION_ID

AP_INVOICE_LINES_INTERFACE

Important Columns are:
INVOICE_ID, INVOICE_LINE_ID, LINE_TYPE_LOOKUP_CODE,
LINE_NUMBER, AMOUNT, ACCOUNTING_DATE,
DIST_CODE_COMBINATION_ID, ORG_ID


Is This Answer Correct ?    10 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can Adjustments be imported?

1901


encumbrence set ups?

2263


How to do the analysis of discounts lost and fixing the root cause?

830


There is employee X and employee Y (who is supervisor of X); when Y submits expenses how will the system ensures that this should not go to X even if he has the approval authority.

4830


What are the inventory report to check inventory status.

2221


I am currently working in reputed Org as a Oracle apps end user (AR). Learned R12 functional course, but no real time exp as in support or implementation project.Please guide. thank you.

1922


Re: While you are in implemenation what are u faced the issues ? tell me what some ap & GL issues?

2145


SLA usage ans how to define setups?

2405


Please post the setups required to approve the payable invoice in AP.

2024


What is Reporting of financial data in a project.

1807


explain with examples what r the roles & Responsiblities of a functional consultant who reviews the Test Scripts, Test Cases and Test Execution Results of AP, FA and GL.

2290


how to do customization while doing oracle implementation. what is the role of functional consultant in customization?

2408


What is meaning of deprecation?

792


How to refund for a customer who returns goods and wants a refund for $600 in R12 In above scenarios customer does not want Credit Memo or On- Account Credit, he wants refund check . and as we know we do not issue check from AR. How can we issue Check from AP and how offsetting is done for the same in R12

6957


On what different real time issues you worked while doing P2P cycle implementation?

1240