APInvoices
Use this transaction to create invoices for existing purchase orders. The Payables Open Interface Import program creates invoices to import into Payables, using invoice data stored in the Payables open interface tables.
For more information about this transaction, see your Oracle Applications documentation.
Oracle Applications Module
Payables
Open Interface
Payables Open Interface
Open Interface Tables
The open interface tables exposed by this transaction are:
- AP_INVOICES_INTERFACE
- AP_INVOICE_LINES_INTERFACE
Error SQL
| Field | Description |
|---|---|
| SOURCE | A value to match against the SOURCE column in a corresponding AP_INVOICES_INTERFACE row. This parameter will accept wild cards. % returns all errors. |
| Field | Description |
|---|---|
| PO_NUMBER | Purchase order number associated with the Invoice. |
| VENDOR_ID | Vendor ID. |
| VENDOR_NUM | Vendor number. |
| VENDOR_NAME | Vendor name. |
| VENDOR_SITE_ID | Vendor site ID. |
| VENDOR_SITE_CODE | Vendor site code. |
| INVOICE_NUM | Invoice number. |
| INVOICE_ID | Invoice ID. |
| LINE_NUMBER | Invoice line number. |
| DISPLAYED_FIELD | Error code display value. |