BillPayments

Payments are a record of the payments made on your invoices.

Table Specific Information

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')

To update, the Id value is required in the WHERE clause.For example:

UPDATE BillPayments set PaymentType = 'Check' where id = 8082

To delete, Id value is required in the WHERE clause.

DELETE from BillPayments where Id = '26157'


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.