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

What is UAT and where we can Apply ?

3 Answers   Tesco,


what is accounting entries of p2p

5 Answers   Ernst Young,


Can multiple Sales Orders be invoiced under one Invoice?

2 Answers  


what is the difference between initial mass copy and periodic mass copy?

1 Answers   BirlaSoft, Cap Gemini, IBM,


can u make payment across two legal entity ? ex:- one primary ledger, two legal entity and one legal entity have "A" operating unit and another legal entity have "B" Operating unit .. i posted invoice in "A" OU, can i make payment through "B" OU ? if Yes what is mandatory setups ?

2 Answers   Cap Gemini,






What is the entry in oracle apps ap,ar,gl for following transations1.one pipe purchase at rs.1002.one pipe sales at rs.150

0 Answers  


wat is project accounting & wat is GL

1 Answers   TCS,


On account credit memo in AR needs to refunded, How ? and what are the steps required?

2 Answers  


wat is mass allocation and when it is used

2 Answers   Meru Cabs,


1. what is receipt class

1 Answers   Arihant,


What is Tolerance?

4 Answers   HCL, IBM, TCS,


Hi, Friends i need some Accounts Payable, General Ledger, Cash Management study material. Please if u have some material kindly send to my id itsaqueelahmed@gmail.com. i will be very thankful to u .

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