BillPayments
Get payments of the bills.
Table Specific Information
Select
The connector will use the Zoho Inventory API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the connector.
- BillId supports the '=' comparison.
- BillPaymentId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM BillPayments WHERE BillId = '3350895000000089001' SELECT * FROM BillPayments WHERE BillPaymentId = '3350895000000089001'
Columns
| Name | Type | References | Description |
| Amount | Integer | Amount paid for the payment. | |
| BillId | Long |
Bills.Id | Unique ID generated by the server. |
| BillPaymentId [KEY] | Long | Bill payment ID. | |
| Date | Date | Date of the Bill. | |
| Description | String | Description for the line item. | |
| ExchangeRate | Integer | Exchange rate of the currency, with respect to the base currency. | |
| IsPaidViaPrintCheck | Boolean | Checks whether payment is done via check. | |
| IsAchPayment | Boolean | Is Ach Payment. | |
| IsSingleBillPayment | Boolean | Checks whether the payment is for single bills or multiple bills. | |
| PaidThroughAccountId | Long | ID for the account through which the payment is made. | |
| PaidThroughAccountName | String | Name of the account. | |
| PaymentId | Long | Unique ID generated by the server. | |
| PaymentMode | String | Mode of payment for the Bill. | |
| PaymentNumber | Integer | Number of the payment. | |
| ReferenceNumber | String | Reference number for the Bill. | |
| Status | String | Status for the Bill. |