Re: transaction and Payment relation
- From: Tim Ferguson <FergusonTG@xxxxxxxxxxxx>
- Date: Thu, 22 Dec 2005 01:21:08 -0800
"SF" <socfund@xxxxxxxxxxxxx> wrote in
news:eCbxqzsBGHA.1008@xxxxxxxxxxxxxxxxxxxx:
> a/ Costumer pays a lumpsum for several open transactions
> b/ Customer pays several installment per open transaction
>
> I create 2 tables (see below) for this, but I cannot figures out how
> to relate these 2 tables to the transaction (mark each transaction as
> completed once the payment has been received)
>
What happens when a customer has several open transactions, and makes a
couple of partial payments? Do you have a rule that pays up the oldest
transactions first; or is the money split proportionately; or does the
customer get to choose ("I'll pay for the diary and the calendar, but not
for the pen because it doesn't write properly")?
It may well be that you need a new table called Contributions, which will
list how much of each Payment contributes to each Transaction. But it's a
lot of overhead given that most of the time a single customer will buy a
single thing and pay for it with a single payment!
An alternative approach would be to separate the outgoings and incomings
completely: the amount people owe you is the difference between the total
of the transactions and the total of the payments. As you can tell, I
don't know enough about business to know whether you _have_ to attach
payments to sales, or just to people who owe you stuff.
B Wishes
Tim F
.
- References:
- transaction and Payment relation
- From: SF
- transaction and Payment relation
- Prev by Date: Re: Database Driven Website Design
- Next by Date: Re: Database Driven Website Design
- Previous by thread: Re: transaction and Payment relation
- Next by thread: Re: transaction and Payment relation
- Index(es):
Relevant Pages
|
