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
Can Adjustments be imported?
encumbrence set ups?
How to do the analysis of discounts lost and fixing the root cause?
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.
What are the inventory report to check inventory status.
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.
Re: While you are in implemenation what are u faced the issues ? tell me what some ap & GL issues?
SLA usage ans how to define setups?
Please post the setups required to approve the payable invoice in AP.
What is Reporting of financial data in a project.
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.
how to do customization while doing oracle implementation. what is the role of functional consultant in customization?
What is meaning of deprecation?
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
On what different real time issues you worked while doing P2P cycle implementation?