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

Explain the Document Method ?

1 Answers   TCS,


you have received excess money from the customer. now you want to refund the excess money. what is the set up for that?

4 Answers   Conacent,


How do you adjust receivables?

0 Answers   IBM,


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,


As a functional consultant how much knowledge i should have about tools used in oracle apps r12.

1 Answers  






Can you create an Invoice in USD, while the Standard PO has been created in EUR?

4 Answers   Deloitte, Genpact, Siotel, Sitel,


MIN and MAX number of segments in Chart of accounts ?

10 Answers   FIC, Wipro,


As Supplier Header Information can share from another operating unit. Not Sites and other information...... but for a supplier if one OU(1) has made a prepayment..and other OU(2) of the same balancing segment has to make a payment to the same supplier..the prepayment available with that supplier is overlooked or not considered….is it true

1 Answers  


What is the Mondatory profile options used in Multi Org ?

2 Answers   FIC,


What are the various statuses of Transactions

1 Answers   Accenture,


What is the significance of Line Ordering and Line Grouping? Explain.

1 Answers   Cap Gemini,


What are the asset types in FA Module?

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