[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
Re: [ic] multiple shipping address
Hi kyle,
Its true that the shipping address details are maintained in the userdb
table in
a column named address_book, but i want to clarify how shipping address
details for orders made are maintained. Suppose i buy 3 items, i can ship
all the 3 items to three different shipping addresses.
There are no fields available as of now in the orderline table.
Do u have any idea of the same ?
Balaji
----- Original Message -----
From: fctmaillist <fctmaillist@megasoft.com>
To: <interchange-users@interchange.redhat.com>
Sent: Friday, October 19, 2001 12:03 PM
Subject: [ic] multiple shipping address
> Hi,
> Can someone plz clearly state me about the two database files namely
> transactions and Orderline. As far as the document specifies it says
that
> each and every item of an order are
> stored in the orderline table whereas a summary of the order is stored
in
> the transactions table.
>
> I.e., There lies a one to many relation between the transactions and
> orderline wherein every parent
> record in the transaction table there is one or many child records
> available
> in the orderline table.
>
> I guess iam clear in my understanding. If not pls correct me.
>
> Well, my question is, if this is the case then how multiple shipping
> locations are taken care.
> Coz the current structure of the orderline table doesn't seem to have
> sufficient columns for the same. Moreover the demo avl (foundation
> catalog)
> seem to accept ship
> address for each and every item purchased, but at checkout it still asks
> for a shipping
> address.
>
> Can someone plz do correct me if iam misunderstood ??
> Thnx in advance.
> Balaji
>
>
>
>
> _______________________________________________
> interchange-users mailing list
> interchange-users@interchange.redhat.com
> http://interchange.redhat.com/mailman/listinfo/interchange-users
_______________________________________________
interchange-users mailing list
interchange-users@interchange.redhat.com
http://interchange.redhat.com/mailman/listinfo/interchange-users