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

1. what is receipt class

1 Answers   Arihant,


What is difference between consolidation and revaluation?

1 Answers   Deloitte,


Grouping Rules and Line Ordering Rules

1 Answers  


How to do the analysis of discounts lost and fixing the root cause?

0 Answers  


What all elements is set for the Responsibilities ?

3 Answers   IBM,






What is Reccuring Invoice ? What is the default invoice date for reccuring invoices ?

2 Answers   KPIT,


What is the report used to identify duplicate suppliers?

2 Answers   Oracle,


What will accrue in Payables?

4 Answers   HCL, IBM, TCS,


what are flexfields in Asset?

6 Answers  


What r the Documents We can create while implementation?

2 Answers   TCS,


What is Cross Journal?

1 Answers   Accenture,


Hi all, I'm confused when it comes the financial handling of transactions. What is the difference between an accounting entry and a journal entry in oracle eBS.

2 Answers   Copac,


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)