Invoices

Retrieves list of all invoices.

Table Specific Information

Select

The component uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators:

InvoiceNumber supports the '=' comparison.
ProjectId supports the '=' comparison.
Balance supports the '=' comparison.
CustomerId supports the '=' comparison.
CustomerName supports the '=' comparison.
Date supports the '=,<,>' comparisons.
DueDate supports the '=,<,>' comparisons.
LastModifiedTime supports the '=' comparison.
ReferenceNumber supports the '=' comparison.
Status supports the '=' comparison.
Total supports the '=' comparison.
Email supports the '=' comparison.
RecurringInvoiceId supports the '=' comparison.
ItemId supports the '=' comparison.
ItemName supports the '=' comparison.
ItemDescription supports the '=' comparison.
InvoiceFilter supports the '=' comparison.

The rest of the filter is executed client-side in the component.

For example:

    SELECT * FROM Invoices WHERE InvoiceNumber = 'INV-000057' AND CustomerName = 'OldTech Industries' AND Date = '2016-03-02'

    SELECT * FROM Invoices WHERE DueDate > '2019-07-02'

    SELECT * FROM Invoices ORDER BY CreatedTime DESC

Columns


Name	Type	References	SupportedOperators	Description
InvoiceId [KEY]	String			Id of an invoice.
InvoiceNumber	String			Number of an invoice.
Adjustment	Decimal			Adjustments made to the invoices.
Balance	Decimal			The unpaid amount.
CompanyName	String			Name of the conpany.
CreatedTime	Datetime			Time at which the invoice was created.
CustomerId	String	Contacts.ContactId		Id of the customer the invoice has to be created.
CustomerName	String			The name of the customer.
Date	Date		=,<,>	Date of an invoice.
DueDate	Date		=,<,>	Date of when the invoice is due.
DueDays	String			Number of due day left for invoice.
HasAttachment	Boolean			Check if the invoice has attachment.
InvoiceURL	String			URL of Invoice.
LastModifiedTime	Datetime			The time of last modification of the invoice.
ProjectName	String			Name of the project.
ReferenceNumber	String			The reference number of the invoice.
Status	String			Status of the invoice. The allowed values are sent, draft, overdue, paid, void, unpaid, partially_paid, viewed.
Total	Decimal			Total of invoices.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Email	String		Email address of an invoice.
RecurringInvoiceId	String		Id of the recurring invoice from which the invoice is created.
ItemId	String		Id of an item.
ItemName	String		Name of an item.
ItemDescription	String		Description of an item.
InvoiceFilter	String		Filter invoices by any status or payment expected date. The allowed values are Status.All, Status.Sent, Status.Draft, Status.OverDue, Status.Paid, Status.Void, Status.Unpaid, Status.PartiallyPaid, Status.Viewed, Date.PaymentExpectedDate.

SSIS Components for Zoho Books

Invoices

Table Specific Information

Select

Columns

Pseudo-Columns