Supplier Invoice Import (Payables Open Interface import)

Hi all now its time for ap invoice interface.You can use this interface table to insert invoice information into
oracle application table.Check it out!!

For header level entry

Insert into AP_INVOICES_INTERFACE (INVOICE_ID=>ap_invoices_interface_s.nextval,
INVOICE_NUM,
INVOICE_TYPE_LOOKUP_CODE,
INVOICE_DATE,
VENDOR_ID,
VENDOR_SITE_ID,
INVOICE_AMOUNT,
INVOICE_CURRENCY_CODE,
TERMS_ID,
DESCRIPTION,
SOURCE,
GROUP_ID,
PAYMENT_METHOD_LOOKUP_CODE,
PAY_GROUP_LOOKUP_CODE,
ACCTS_PAY_CODE_COMBINATION_ID,
ORG_ID,
LEGAL_ENTITY_ID,
OPERATING_UNIT,
PAYMENT_METHOD_CODE)

for line level entrt
Insert into AP_INVOICE_LINES_INTERFACE(

INVOICE_ID=>ap_invoices_interface_s.nextval,,
INVOICE_LINE_ID=>ap_invoice_lines_interface_s.nextval,
LINE_NUMBER,
LINE_TYPE_LOOKUP_CODE,
AMOUNT ,
DESCRIPTION
)


Note that while submitting :
parameter=>source:should be "Quick Invoices"
Use "payables open interface import" in ap responsibility to import payables information.

good luck!!