Invoices

Return a list of invoices

Select

The driver will use the Xero WorkflowMax API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the driver. Specifically, the following are processed server-side:

CreatedDate supports the '<=,<,=,>,>=' operators.

All filterable columns allow multiple values to be specified by using the IN operator. Response time from the server can be improved by identifying only the rows you want to retrieve.

SELECT * FROM Invoices WHERE CreatedDate >= '2019-08-07' AND CreatedDate <= '2019-08-07'
SELECT * FROM Invoices WHERE CreatedDate >= '2019-08-07'
SELECT * FROM Invoices WHERE CreatedDate = '2019-08-07'

Notes:
-When executing a simple SELECT * query the driver will retrieve only your current Invoices.
-When specifying CreatedFrom and CreatedTo the driver will retrieve the current and archived Invoices.

Columns


Name	Type	Description
ID [KEY]	String	The name of the category
Type	String	Determines the type of the invoice.
Status	String	Status of the invoice Approved, Paid, Draft, Cancelled
JobID	String	Id of the job associated with this Invoice.
CreatedDate	Date	Determines the date when the invoice was created.
DueDate	Date	Determines the due date for the invoice.
Amount	Float	The amount to pay.
AmountTax	Float	The tax amount to pay.
AmountIncludingTax	Float	The total amount to pay including tax.
AmountPaid	Float	Determine the amount which has already been paid.
AmountOutstanding	Float	Determines the amount thats left to pay.
ClientUUID	String	Client identifier related to the invoice.
ClientName	String	Client name related to teh invoice.
ContactUUID	String	Contact identifier of the client related to the invoice.
ContactName	String	Contact name of the client related to the invoice.

JDBC Driver for Xero WorkflowMax

Invoices

Select

Columns