VendorPayments
Retrieves list of all the payments made to your vendor.
Table Specific Information
Select
The add-in uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators:
- VendorId supports the '=' comparison.
- VendorName supports the '=' comparison.
- Amount supports the '=,<,<=,>,>=' comparisons.
- Date supports the '=,<,>' comparisons.
- Description supports the '=' comparison.
- LastModifiedTime supports the '=' comparison.
- PaymentMode supports the '=' comparison.
- PaymentNumber supports the '=' comparison.
- ReferenceNumber supports the '=' comparison.
- VendorPaymentFilter supports the '=' comparison.
- Notes supports the '=' comparison.
The rest of the filter is executed client-side in the add-in.
For example:
SELECT * FROM VendorPayments WHERE Amount >= 98 AND Date < '2019-07-07'
SELECT * FROM VendorPayments WHERE PaymentNumber = 1;
SELECT * FROM VendorPayments WHERE CONTAINS (PaymentMode, 'sh')
Columns
| Name | Type | References | SupportedOperators | Description |
| PaymentId [KEY] | String | Id of a payment. | ||
| VendorId | String | Id of the vendor the vendor payment has been made. Search payments by vendor id. | ||
| VendorName | String | Name of the vendor the vendor payment has been made. Search payments by vendor name. | ||
| AchGwTransactionId | String | Id of a ACH GW Transaction. | ||
| Amount | Decimal | =,<,<=,>,>= | Payment amount made to the vendor. Search payments by payment amount. | |
| Balance | Decimal | Balance of vendor payment. | ||
| BcyAmount | Decimal | Amount of Base Currency. | ||
| BcyBalance | Decimal | Balance of Base Currency. | ||
| CheckDetailsCheckId | String | Id of a check. | ||
| CheckDetailsCheckNumber | String | Number of a check. | ||
| Date | Date | =,<,> | Date the payment is made. Search payments by payment made date. | |
| Description | String | Description of a vendor payment. | ||
| HasAttachment | Boolean | Check if a vendor payment has attachment. | ||
| LastModifiedTime | Datetime | Last Modified Time of the Vendor Payment. | ||
| PaymentMode | String | Mode through which payment is made. Search payments by payment mode. | ||
| PaymentNumber | String | Number through which payment is made. Search with Payment Number. | ||
| ReferenceNumber | String | Reference number of a a bill. | ||
| AchPaymentStatus | String | Status of ACH Payment. | ||
| CheckDetailsCheckStatus | String | Status of check. | ||
| CheckDetailsMemo | String | Memo of check details. | ||
| CreatedTime | Datetime | Time at which the vendor payment was created. | ||
| CurrencyCode | String | Currency code of the vendor payment. | ||
| CurrencyId | String |
Currencies.CurrencyId | Currency Id of the vendor payment currency. | |
| ExchangeRate | Decimal | Exchange rate of a vendor payment. | ||
| IsAchPayment | Boolean | Check if the payment is done with ACH payment. | ||
| IsAdvancePayment | Boolean | Check if the payment is an advance payment. | ||
| IsPaidViaPrintCheck | Boolean | Check if vendor payment paid via print check. | ||
| PaidThroughAccountId | String |
BankAccounts.AccountId | Account Id from which vendor payment has been made. | |
| PaidThroughAccountName | String | Account name from which vendor payment has been made. | ||
| ProductDescription | String | Description of the product. | ||
| Status | String | Status of the vendor payment. | ||
| BillNumbers | String | Bill numbers associated with the vendor payment. |
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 | |
| VendorPaymentFilter | String | Filter payments by mode.
The allowed values are PaymentMode.All, PaymentMode.Check, PaymentMode.Cash, PaymentMode.BankTransfer, PaymentMode.Paypal, PaymentMode.CreditCard, PaymentMode.GoogleCheckout, PaymentMode.Credit, PaymentMode.Authorizenet, PaymentMode.BankRemittance, PaymentMode.Payflowpro, PaymentMode.Others.. | |
| Notes | String | Notes of vendor payments.. |