Payables Invoice Import Definitions
To understand how Payables Invoice Import works, you should be familiar with the following definitions.
Payables Invoice Import Program
The Payables process that you submit to import invoice information from interface tables into the appropriate AP tables, thereby creating invoices from the imported invoice information. You can use Payables Invoice Import to create invoices from Payables, Oracle Projects, and Oracle Web Employees expense reports or from invoice information from another accounting system.
Invoice Import Interface Tables
The tables in Payables to which you load the invoice data in your invoice flat file. You use SQL*Loader to load the invoice information into these tables. The interface tables also store information for your Payables, Oracle Projects, and Oracle Web Employees expense reports.
Import Program
The program that you create to compile invoice data from your non-Oracle accounting system(s) and produce the invoice flat file that you load into Payables.
Invoice Flat File
The output from your import program. The file must contain all the necessary data, such as invoice number, invoice amount, and expense accounts, for creating invoices in Payables.
Control File
The SQL*Loader file you create for loading the data in your invoice flat file into the Invoice Import interface tables. The control file serves as a guide for formatting the data in the invoice flat file into the standard format used by the columns in the interface tables.