Use this transaction to retrieve new invoices in your Oracle Application system. You can retrieve invoices by creation date range, organization ID, billable customer name, site use code, and transaction number. Only invoices that are completed and have the printing option turned on with a status of printing pending will be returned. The acknowledgment SQL marks the specified invoice so that the functional query will not retrieve it a second time.

The inputs are used to limit what Invoices you want to retrieve. These SQL inputs are exposed as service inputs.

The output contains all invoices returned by the query. Each invoice consists of 1 header with 1 to N lines and each line contains 1 to N line tax records. The results look like the following:

The following table shows the details of an invoice header. The content of most fields can be determined by their name. Where necessary, a description is provided.

The following table shows the details of an invoice line item. The content of most fields can be determined by their names. Where necessary, a description is provided.

The following table shows the details of an invoice line item tax record. The content of most fields can be determined by their names. Where necessary, a description is provided.

Updates the specified invoice to show it has been processed and printed.

The inputs define which PO to update.

There is no output generated by this SQL.

Invoices are retrieved using the TRANSACTION_NUMBER field, but they are acknowledged using the TRANSACTION_ID field.