| Nihit Kaul [MSFT] 2006-08-09, 1:21 am |
| One LineItem cannot belong to multiple Shipments. There is a Shipments table that stores all the Shipments in this Order (you can also use the Customer and Orders Manager to view the Order details).
Each Shipment can contain multiple LineItems and the number of LineItems in each Shipment is not stored in an explicit column, so you cannot see it directly in SQL. Only the list of indexes of the LineItems contained
in this Shipment are stored (and that too in the BLOB). You can however view the number of items in each Shipment very easily using the Customer and Orders Manager UI.
Thanks,
Nihit Kaul[MSFT]
Commerce Server
http://blogs.msdn.com/nihitk
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm
--------------------
Thread-Topic: Commerce Server 2007 - Shipment Details of line items
thread-index: Aca1ei/M4Q3/37/1RS6pAX0ZcsOGMg==
X-WBNR-Posting-Host: 203.200.33.34
From: =?Utf-8?B?TWFuaQ==?= <Mani@discussions.microsoft.com>
Subject: Commerce Server 2007 - Shipment Details of line items
Date: Tue, 1 Aug 2006 07:53:01 -0700
Lines: 5
Message-ID: <57116534-B5F8-4275-86B2-A071E66D1230@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
Newsgroups: microsoft.public.commerceserver.solutionsites
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.solutionsites:124
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.commerceserver.solutionsites
Commerce Server 2007 - When an Order is placed and shipment is done, all line
items are being stored in Line Items table. The Ordered qty is being stored
in this table. Where is the quantity shipped being stored? One line item can
go in multiple shipments. Where is Commerce server database maintaining the
quantity shipped?
|