design question

[rodchar]

Hey all,

i think i understand the concept of an invoice and invoice details table ok
but how do the payments and/or receipts fit into the design.

is there usually a payments table and receipt table all tied together by an
invoiceID?
i guess what i'm asking is if a person pays the invoice what table would
this information belong to? How do partial payments work?

thanks,
rodchar

 

[Haris Rashid]

hi Rodchar,

For each invoice there can be one or more payments. One if all the amount is
paid once and many if there are multiple partial payments. Each record in
payments table will include the Invoice ID, linking the payment to the
involce against which the payment is made. If anyone pays against the invoice
the information will be recorded in the payments table. Invoice table will
show the amount that was billed and the payments table will show the actual
payments against the billed amount (or the invoice).

Kind regards,

 

[rodchar]

thanks, this helped.

hi Rodchar,

For each invoice there can be one or more payments. One if all the amount is
paid once and many if there are multiple partial payments. Each record in
payments table will include the Invoice ID, linking the payment to the
involce against which the payment is made. If anyone pays against the invoice
the information will be recorded in the payments table. Invoice table will
show the amount that was billed and the payments table will show the actual
payments against the billed amount (or the invoice).

Kind regards,