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
How do write a discoverer report to identify zero dollar suppliers/invoices where the supplier is on hold?
On what different real time issues you worked while doing P2P cycle implementation?
1)What cannot be consolidated in GCS? 2) When you setup calendar in GL is it possible to change it?
what is the use of hr: security profile, while configure multiorg?
What kind of necessary ap information you gather from the client?
Explain Customization process?
What is Difference between Auto Copy Journal and recurring journal?
what is the steps to customization ?
What is gap analysis, how do you defined?
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 is the use of mo: security profile, while configure multiorg?
What is meant RD020
Re: what are the Issue that we face in Gl,PO and AP while Supporting
What is the procedure for requition import?
While assigning the security by book in oracle assets..i am unable ot get the asset org in security profile form.This asset org was already defined in org description window.