[ic] multiple shipping address

fctmaillist interchange-users@interchange.redhat.com
Fri Oct 19 04:50:00 2001


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