PAYMENT table

 

PAYMENT – This table stores the payments made to an invoice in the Track-IT pro database.

Ÿ      ID – The unique ID for the payment on an invoice. (PK)

Ÿ      INVOICE – The ID for the invoice the payment was made on. (FK)

Ÿ      AMOUNT – The amount of the payment.

Ÿ      DATE – The date the payment was made.

Ÿ      CHECKNO – The Check Number for the payment.