VendorPaymentBills
Get bills related to vendor payments.
Table Specific Information
Select
The 本製品 uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators:
- PaymentId supports the '=,IN' comparison.
The rest of the filter is executed client-side in the 本製品.
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 | Bill Payment Id | ||
PaymentId | String |
VendorPayments.PaymentId | Vendor Payment Id | |
AmountApplied | Integer | Amount Applied to the bill | ||
BillId | String |
Bills.BillId | Bill Id | |
TaxAmountWithheld | Integer | The tax amount which has been withheld |