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






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 ?    9 Yes 0 No

Post New Answer




More Oracle Apps Financial Interview Questions

What are the Setups required for payable invoice approval.

3 Answers  


What is meant by pay on receipt auto invoice?

4 Answers  


what is MOAC?

2 Answers   ABC, Ness Technologies,


We are running Oracle EBS 11i and yesterday whilst doing my month-end I forgot to select "calculate finance charge" on form ARXSUPST AR Print Statement run. I am struggling to get to My Oracle and was hoping someone out there might have experienced or heard of a similar problem. What are my options to rectify this situation... I look forward to you inputs..... Thank you Regards Salie

0 Answers  


Hi all, I have setup my AP and created 3 invoice batches which as seen validated yet when i try to make payment i get the following error"APP-SQL - 10006: the date you entered is not an open accounting period." I have opened the calendar for that month yet it giving me this error. Any help will be appreciated.

4 Answers   IBM,






What are the setup steps that need to be defined for GL budgets

1 Answers   Pfizer,


What is meant by quotation and quotation analysis?

1 Answers  


where will you enter tax in ap module

1 Answers   UST,


What is write off Accruals? what is the use of this?

1 Answers   Genesis,


what is CCID in oracle apps ? how it works explain detail ?

1 Answers  


What is the difference between Currency Translation, conversion and revaluation?

2 Answers   Oracle,


What is use Security list maintain program

3 Answers  






Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (503)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (774)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (82)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (137)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (13)