APInvoiceOpen
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
AP Invoice Open Import Transaction
Open Interface Tables
Open interface table(s) exposed by the transaction are as follows:
- AP_INVOICES_INTERFACE
- AP_INVOICE_LINES_INTERFACE
Error SQL
Open interface table(s) queried by the error SQL are as follows:
- AP_INTERFACE_REJECTIONS
- AP_INVOICES_INTERFACE
- AP_LOOKUP_CODES
- AP_INVOICE_LINES_INTERFACE
| Field | Description |
|---|---|
| WM_USER | User ID of the person who initiated the transaction; that is, the user ID in the CREATED_BY field in the transaction. |
| 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. |
| DESCRIPTION | Error code description. |
Usage Comments
To import Items, run the Open Interface Invoices function, under Invoices, which is under the Payables module.