Which interface tables are used for Invoice Import , give
the important columns?
Answer / 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 |
What is pay date basis?
Explain the Document Method ?
What are the setup steps that need to be defined for GL budgets
What are the types of receipts?
What is the process (including setups) of Assets from PO module to Assets Module in Oracle Financials?
How to see the structure of organization?ie which LE connected to which ledger and which OU connected to which LE?
What is Debit Memo & Credit Memo in Payables?
27 Answers Cognizant, HCL, IBM, TCS,
Why shud we run Expense report import programme in AP..where are we importing from??
7. what is reconciliation
encumbrence set ups?
What is the difference between Rollup Groups and Summary Accounts? What is the use of those?
What are the Distribution Type while entering the Invoice?