Bills
Retrieves list of bills.
Table Specific Information
Select
The 本製品 uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators:
- 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.
The rest of the filter is executed client-side in the 本製品.
For example:
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. | ||
| AttachmentName | String | Name of an attachment. | ||
| ClientViewedTime | Datetime | Time when client viewed. | ||
| ColorCode | String | Color code. | ||
| CurrencyCode | String | Currency code of the customer's currency. | ||
| CurrencyId | String |
Currencies.CurrencyId | Currency Id of the customer's currency. | |
| CurrentSubStatus | String | Current sub status of a bill. | ||
| CurrentSubStatusId | String | Current sub status Id of a bill. | ||
| EntityType | String | Entity type of the bill. | ||
| ExchangeRate | Decimal | Exchange rate of the currency. | ||
| IsBillReconciliationViolated | Boolean | Indicates if there is a violation in the bill reconciliation process | ||
| IsTallyBill | Boolean | Indicates if the bill was imported from Tally accounting software | ||
| IsUberBill | Boolean | Indicates if the bill is from Uber for Business integration | ||
| IsViewedByClient | Boolean | Check if bill is viewed by client. | ||
| PricePrecision | Integer | The precision for the price. | ||
| UnprocessedPaymentAmount | Decimal | Unprocessed payment amount. |
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. |