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
What is the Invoicing System in Oracle R12
Re: While you are in implemenation what are u faced the issues ? tell me what some ap & GL issues?
can we define 2 different currency revaluation at a time??
what r issues faced in gl
payment types and payment methods.
Provide an overview of AR cash receipt processing.
how we can stop the transaction for not transfer to the reporting ledger at the time of entering the transaction in pl
What is gap analysis, what are the pre-requisities?
encumbrence set ups?
What do you mean by Category Set ? and what is its Relevance ?
I have created an invoice and made the payment in Accounts payable. Now the payment status is Negotiable and accounting status is processed. I reconciled the transaction in Cash Mgmt, The status changed from negotiable to Reconciled in CM. I checked the payment status for the invoice in payment window(AP), the payment status changed to RECONCILED UNACCOUNTED i.e correct but the accounting status is remain processed which is not the correct. I hope the transaction will be correct if the accounting status would have changed to PERTIAL . Please suggest any solution for the above query.
What kind of necessary ap information you gather from the client?
What do you mean by controlling buyers workload?
difference between tds and income tax (India)
What are the inventory report to check inventory status.