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

Expalin sequence in brief in R12 in general Ledger module. what are major changes around this functionality?

2 Answers  


What is Cross Journal?

1 Answers   Accenture,


Explain the concept of reccuring journals ?

4 Answers   Oracle,


2. what is receipt method.

2 Answers   Arihant,


What Are Important Reports In AP,AR?

3 Answers   Wipro,






types of valuesets

1 Answers  


It is mandatory to difine Approval Suppliers ?

3 Answers   FIC,


Difference between header level tax calculation and line level tax calculation?

2 Answers  


I am working on PPR process to print checks. Currently the checks are printing for each supplier, supplier site and payment method group. My requirement is the invoice level one DFF is available (like A and B are the input values). Please let me know how include this DFF at invoice grouping level.

0 Answers  


What are the depreciation methods used in FA module?

2 Answers  


Can any tell me about R2R FINANCIAL PROCESS?

5 Answers   Accenture,


How can we Integrate AP,AR,CM & FA to GL? What is the procedure need to fallow as a functional consultant?

1 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)