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

difference between 11i&r12

0 Answers  


Can you cancel the invoice? If yes, explain?

6 Answers  


What are the mandatory setups in AP?

13 Answers  


What are the types of journal categories available in the AP?

2 Answers   DELL,


What is the Mondatory profile options used in Multi Org ?

2 Answers   FIC,






What is the use of requition template?

3 Answers  


how the asset flow to FA module.and it steps?

2 Answers  


What is a Hold and Release

3 Answers   Tech Mahindra,


what r the errors we will get while oracle financial implementation in accounts payable and please how u have solved those errors

1 Answers  


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.

0 Answers   TCS,


Hi All, My name is Prashant ..I want to know good institutes in Bangalore which provide training on Oracle Apps Financials..AP,AR,GL,CM,...Mail me at prashant09itagi@gmail.com

9 Answers   ABM, Wipro,


how to transfer the retained earning amount from curret year to next year? what is the path in apps financial

3 Answers   TCS,






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 (138)
  • 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)