BillPayments
Payments are a record of the payments made on your invoices.
Table Specific Information
Insert
To insert, BillID, PaidDate,Amount, PaymentType and Code fields are required.The below example illustrates how to insert in BillPayments table:
INSERT Into BillPayments (BillID, PaidDate, Amount, PaymentType, Code) Values ('12435', '2023-11-02', 2, 'Cash', 'INR')
Update
To update, the Id value is required in the WHERE clause.For example:UPDATE BillPayments set PaymentType = 'Check' where id = 8082
Delete
To delete, Id value is required in the WHERE clause.DELETE from BillPayments where Id = '26157'
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | Integer | True |
The unique identifier of the payment. |
BillId | Integer | False |
The identifier of the related bill. |
Amount | Decimal | False |
Amount paid on invoice to two decimal places. |
Code | String | False |
Three-letter currency code of payment. |
PaidDate | Date | False |
Date the payment was made. (YYYY-MM-DD) |
MatchedWithExpense | Boolean | True |
Indicates whether or not the payment was converted from a credit on a client's account. |
Note | String | False |
Notes on payment, often used for credit card reference number. |
PaymentType | String | False |
The type of the payment: 'Check', 'Credit', 'Cash', etc. |
VisState | Integer | True |
0 for active, 1 for deleted. |