PurchaseOrders
Retrieves list of all purchase orders.
Table Specific Information
Select
The connector 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 connector.
- Date supports the '=' comparison.
- LastModifiedTime supports the '=' comparison.
- PurchaseorderNumber supports the '=' comparison.
- ReferenceNumber supports the '=' comparison.
- Status supports the '=' comparison.
- Total supports the '=,<,<=,>,>=' comparisons.
- VendorId supports the '=' comparison.
- VendorName supports the '=' comparison.
- PurchaseOrderFilter supports the '=' comparison.
- ItemId supports the '=' comparison.
- ItemDescription supports the '=' comparison.
SELECT * FROM PurchaseOrders WHERE VendorId = 1894553000000077963 SELECT * FROM PurchaseOrders WHERE Total < 300 SELECT * FROM PurchaseOrders WHERE CONTAINS(PurchaseorderNumber,'PO-')
Columns
Name | Type | References | SupportedOperators | Description |
PurchaseorderId [KEY] | String | ID of a purchase order. | ||
BilledStatus | String | Billed status of a purchase order. | ||
ClientViewedTime | Datetime | Last time when the client has viewed purchase order. | ||
ColorCode | String | Color code of this purchase order. | ||
CompanyName | String | Name of the company. | ||
CreatedTime | Datetime | Time at which the purchase order was created. | ||
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 purchase order. | ||
CurrentSubStatusId | String | Current sub status ID of a purchase order. | ||
Date | Date | The date the purchase order is created. | ||
DeliveryDate | Date | Delivery date of the order. | ||
HasAttachment | Boolean | Check if the purchase order has attachment. | ||
IsDropShipment | Boolean | Check if it has drop shipment. | ||
IsViewedByClient | Boolean | Check if the purchase order is viewed by client. | ||
LastModifiedTime | Datetime | Last modified time of a purchase order. | ||
OrderStatus | String | Status of purchase order. | ||
PricePrecision | String | The precision for the price. | ||
PurchaseorderNumber | String | Number of the purchase order. | ||
QuantityYetToReceive | Decimal | Number of quantity yet to receive from purchase order. | ||
ReferenceNumber | String | Reference number of a purchase order. | ||
Status | String | Status of a purchase order.
使用できる値は次のとおりです。draft, open, billed, cancelled | ||
Total | Decimal | =,<,<=,>,>= | Total of purchase orders. Search by purchase order total. | |
VendorId | String | ID of the vendor the purchase orders has been made. Search by vendor id. | ||
VendorName | String | Name of the vendor the purchase orders has been made. Search 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 | |
PurchaseOrderFilter | String | Filter purchase order by any status.
使用できる値は次のとおりです。Status.All, Status.Draft, Status.Open, Status.Billed, Status.Cancelled | |
ItemId | String | Id of an item. | |
ItemDescription | String | Description of an item. |