VendorPaymentBills
Retrieves bills related to vendor payments.
Table Specific Information
Select
The cmdlet uses the Zoho Books API to process WHERE clause conditions built with the PaymentId column, which supports '=,IN' comparisons.The rest of the filter is executed client-side in the cmdlet.
For example:
SELECT * FROM VendorPaymentBills WHERE PaymentId = '3255827000000099005' SELECT * FROM VendorPaymentBills WHERE PaymentId IN ('3255827000000101458', '3255827000000099005')
Columns
Name | Type | References | SupportedOperators | Description |
BillPaymentId [KEY] | Long | The Bill Payment Id. | ||
PaymentId | String |
VendorPayments.PaymentId | The Vendor Payment Id. | |
AmountApplied | Integer | The Amount Applied to the bill. | ||
BillId | String |
Bills.BillId | The Bill Id. | |
TaxAmountWithheld | Integer | The tax amount which has been withheld. |