Bills
Retrieves list of bills.
Table Specific Information
Select
The 本製品 will use the Zoho Books API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the 本製品.
- BillNumber supports the '=' comparison.
- Date supports the '=,<,>' comparisons.
- LastModifiedTime supports the '=' comparison.
- ReferenceNumber supports the '=' comparison.
- Status supports the '=' comparison.
- Total supports the '=,<,<=,>,>=' comparisons.
- VendorId supports the '=' comparison.
- VendorName supports the '=' comparison.
- PurchaseOrderId supports the '=' comparison.
- RecurringBillId supports the '=' comparison.
- BillFilter supports the '=' comparison.
- ItemId supports the '=' comparison.
- ItemDescription. supports the '=' comparison.
SELECT * FROM Bills WHERE Total < 100 AND Total <= 98 SELECT * FROM Bills WHERE Date < '2018-07-03' SELECT * FROM Bills WHERE CONTAINS(BillNumber,'Bi')
Columns
Name | Type | References | SupportedOperators | Description |
BillId [KEY] | String | Id of a bill. | ||
BillNumber | String | Number of bill. | ||
Balance | Decimal | Amount of bill. | ||
CreatedTime | Datetime | Time at which the bill was created. | ||
Date | Date | =,<,> | Date of a bill. | |
DueDate | Date | Delivery date to pay the bill. | ||
DueDays | String | Due days to pay the bill. | ||
HasAttachment | Boolean | Check if the bill has attachment. | ||
LastModifiedTime | Datetime | Last Modified Time of bill. | ||
ReferenceNumber | String | Reference number of a bill. | ||
Status | String | Status of a bill.
使用できる値は次のとおりです。paid, open, overdue, void, partially_paid | ||
TdsTotal | Decimal | Total amount of TDS applied. | ||
Total | Decimal | =,<,<=,>,>= | Total of bills. Search by bill total. | |
VendorId | String | ID of the vendor the bill has been made. Search bills by Vendor ID. | ||
VendorName | String | Name of the vendor the bill has been made. Search bills by vendor name. |
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 | |
PurchaseOrderId | String | Id of a Purchase Order. | |
RecurringBillId | String | Id of a Recurring Bill. | |
BillFilter | String | Filter bills by any status.
使用できる値は次のとおりです。Status.All, Status.PartiallyPaid, Status.Paid, Status.Overdue, Status.Void, Status.Open | |
ItemId | String | Id of an Item. | |
ItemDescription | String | Description of a bill. |