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

Post New Answer

More Oracle Apps Financial Interview Questions

Can two users use same payable document simultaneously? If yes, which user will get the document number assigned first?

2 Answers  


4. accounting entry at PO level with tax

1 Answers   Arihant,


What is Aging Periods?

2 Answers   HCL, IBM, TCS,


encumbrence set ups?

1 Answers   ABC, Hexaware,


can we create purchase order without requisition ?

6 Answers   TCS,


What are the various Implementation method for oracle apps

5 Answers   GTL,


What is ment by Roll back depreciation?

2 Answers  


Why system asks enter valid cost center while Creating internet Expenses but i entred my cost center system ask same question could u please give me answer

1 Answers  


what is MOAC?

2 Answers   ABC, Ness Technologies,


What is price break and what are the different types of price breaks ?

3 Answers   FIC,


can you explain aim methodology, what are the documents need to be prepare as functional consultant, explain about gap.

2 Answers   Oracle,


What is terms date basis?

2 Answers  


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • 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 (114)