Cmdlets for Zoho Books

Build 24.0.9062

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' comparisons.
  • Status supports the 'IN' comparison.

The rest of the filter is executed client-side in the 本製品.

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.

使用できる値は次のとおりです。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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062