PurchaseOrdersByVendorReport
Generated schema file.
Table Specific Information
Select
The adapter uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators:
- PODate supports the '=' comparison.
- ToDate supports the '=' comparison.
- FromDate supports the '=' comparison.
- VendorId supports the 'IN, NOT IN' comparisons.
- Status supports the 'IN' comparison.
The rest of the filter is executed client-side in the adapter.
For example:
SELECT * FROM PurchaseOrdersByVendorReport WHERE PODate = 'Today'
SELECT * FROM PurchaseOrdersByVendorReport WHERE ToDate = '2022-10-31'
SELECT * FROM PurchaseOrdersByVendorReport WHERE FromDate = '2022-10-10' AND ToDate = '2022-10-31'
SELECT * FROM PurchaseOrdersByVendorReport WHERE Status IN ('draft')
SELECT * FROM PurchaseOrdersByVendorReport WHERE VendorId IN ('3285934000000104023')
Columns
| Name | Type | References | SupportedOperators | Description |
| Amount | Integer | Amount. | ||
| Count | Integer | Count. | ||
| FcyAmount | Integer | Fcy Amount. | ||
| VendorCompanyName | String | Vendor CompanyName. | ||
| VendorCreatedBy | String | Vendor Created By. | ||
| VendorCreatedTime | Datetime | Vendor Created Time. | ||
| VendorDepartment | String | Vendor Department. | ||
| VendorDesignation | String | Vendor Designation. | ||
| VendorEmail | String | Vendor Email. | ||
| VendorFacebook | String | Vendor Facebook. | ||
| VendorFirstName | String | Vendor First Name. | ||
| VendorLastModifiedTime | Datetime | Vendor Last ModifiedTime. | ||
| VendorLastName | String | Vendor Last Name. | ||
| VendorMobilePhone | String | Vendor Mobile Phone. | ||
| VendorNotes | String | Vendor Notes. | ||
| VendorOutstandingPayableAmount | Integer | Vendor Outstanding Payable Amount. | ||
| VendorOutstandingPayableAmountBcy | Integer | Vendor Outstanding Payable Amount Bcy. | ||
| VendorPaymentTerms | String | Vendor Payment Terms. | ||
| VendorPhone | String | Vendor Phone. | ||
| VendorSkype | String | Vendor Skype. | ||
| VendorStatus | String | Vendor Status. | ||
| VendorTwitter | String | Vendor Twitter. | ||
| VendorUnusedCreditsPayableAmount | Integer | Vendor Unused Credits Payable Amount. | ||
| VendorUnusedCreditsPayableAmountBcy | Integer | Vendor Unused Credits Payable Amount Bcy. | ||
| VendorWebsite | String | Vendor Website. | ||
| VendorName | String | Vendor Name. | ||
| VendorId | String | IN, NOT IN | Vendor Id. |
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 | |
| PODate | String | Filter transaction by any purchase order date.
The allowed values are Today, ThisWeek, ThisMonth, ThisQuarter, ThisYear, PreviousDay, PreviousWeek, PreviousMonth, PreviousQuarter, PreviousYear and CustomDate. | |
| ToDate | Date | To Date. | |
| FromDate | Date | From Date. | |
| Status | String | Status.
The allowed values are draft, pending_approval, approval_overdue, approved, rejected, open, billed, billed_not_received, cancelled, partially_billed, issued, partially_received, received, received_not_billed, manually_received, drop_shipped, closed, accepted, signed. |