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 are steps included in auto accounting rule?

1 Answers  


I have requirement where the Invoice given by supplier is in USD, but the payment can be done in GBP. Is it possible in AP?

4 Answers  


Client's requirement is that first invoice would be a proforma invoice. Second invoice would be Tax invoice. Presently, we are unable to use this approach of payment?

1 Answers  


What is Flow of Account Receivables,Payables and Fixed Assets?

0 Answers   Doyensys, Wipro,


Multi Currency payments?

1 Answers  






Payment Methods?

5 Answers  


In Accounts Payable credit memo and debit memo are entered with -ve amount but in Accounts Receivable why credit memo has -ve amonut and debit memo + ve?

6 Answers   Silicon Valley,


what is the diffrence between 11i and R12 ?

2 Answers   Wipro,


How to transfer the funds between internal banks

3 Answers   TCS,


How to Reconciliation AP to CM ? How to Reconciliation AR to CM ?

0 Answers   TCS,


Can you end-date the SOB's in 11i or in R12 version?

5 Answers   Oracle,


what is the profile options

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