design question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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,
 
thanks, this helped.

Haris Rashid said:
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,
Click to expand...
 
Back
Top