It appears that trackingNumber is an obsolete artifact in the OrderItemShipGroup table. It may be used but I don't see where.
The UPS and DHL shipping label components save the tracking number into the ShipmentPackageRouteSeg entity. This provides a better normalization and supports the possibility that an item of multiple quantity can be shipped and tracked seperately. John On 2/8/07, David Shere <[EMAIL PROTECTED]> wrote:
Shouldn't it be in ShipmentPackage? Even in a "Box 1 of 2, Box 2 of 2" shipment, each box has its own tracking number (right?), since they could get separated and have to be tracked independently. As it is, if two boxes are in the same OrderItemShipGroup, then they both have the same tracking number. Is this right? OrderItemShipGroup doesn't seem to be an entity described in the Data Model Resource book (I read the whole chapter on Shipments) so I guess I'm confused as to exactly what the entity is supposed to represent in the process. -- David Shere Information Technology Services Steele Rubber Products www.SteeleRubber.com
