PurchaseOrdersByVendorReport
Generated schema file.
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 本製品.
- PODate supports the '=' comparison.
- ToDate supports the '=' comparison.
- FromDate supports the '=' comparison.
- VendorId supports the 'IN, NOT IN' comparison.
- Status supports the 'IN' comparison.
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 |