1. Categories >> Software >> ERP CRM >> Oracle Apps >> Oracle Apps Financial
  2. Suggest New Category

Which interface tables are used for Invoice Import , give
the important columns?

Question Posted / ritesh gakher

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Substitute receipts and Unordered Receipts

2884

I am currently working in reputed Org as a Oracle apps end user (AR). Learned R12 functional course, but no real time exp as in support or implementation project.Please guide. thank you.

1629

What is difference between primary and secondary ledger

615

There is employee X and employee Y (who is supervisor of X); when Y submits expenses how will the system ensures that this should not go to X even if he has the approval authority.

4313

Charge Back Setups ?

1706




I am created credit memo in at but while trying to complete it showing error message-hz_party_location

962

Can I do a payment of 50 bills on a post date. If yes, then how?

1317

Define the activities of the Configuration Manager (AP,GL,FA) in the team. Give examples

2012

explain with examples what r the roles & Responsiblities of a functional consultant who reviews the Test Scripts, Test Cases and Test Execution Results of AP, FA and GL.

2080

how service tax work.

1966

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

645

What is gap analysis, how do you defined?

649

Can Adjustments be imported?

1716

please explain with examples the below mentioned "Creating the end to end business scenarios and executing the scenarios to perform the regression testing".

1741

We are running Oracle EBS 11i and yesterday whilst doing my month-end I forgot to select "calculate finance charge" on form ARXSUPST AR Print Statement run. I am struggling to get to My Oracle and was hoping someone out there might have experienced or heard of a similar problem. What are my options to rectify this situation... I look forward to you inputs..... Thank you Regards Salie

2158