BillPayments
Get payments of the bills.
Table Specific Information
Select
The add-in 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 add-in.
- 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. |