PurchaseOrdersByVendorReport
Generated schema file.
Table Specific Information
Select
The 本製品 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' comparison.
- Status supports the 'IN' comparison.
The rest of the filter is executed client-side in the 本製品.
For example:
SELECT * FROM PurchaseOrdersByVendorReport 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.
使用できる値は次のとおりです。Today, ThisWeek, ThisMonth, ThisQuarter, ThisYear, PreviousDay, PreviousWeek, PreviousMonth, PreviousQuarter, PreviousYear and CustomDate | |
ToDate | Date | To Date | |
FromDate | Date | From Date | |
Status | String | Status
使用できる値は次のとおりです。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 |