Entity Definition

Logical Name : CustomerOrderShipmentItem
Physical Name : TR_ITM_RTL_SHP

A associative entity that relates a particular item sale to a the Shipment that was used to deliver the merchandise to the Customer's shipping address(es)

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ShipmentLineItemSequenceNumber (PK) A unique, non-significant, automatically assigned sequential number used to identify this item within the context of the RetailTransactionShipment. IC_LTM_SHP_RTL_TRN Identity integer
RetailTransactionLineItemSequenceNumber (FK) The sequence number of line item within the context of this RetailTransaction. IC_LN_ITM LineNumber smallint SaleReturnLineItem(TR_LTM_SLS_RTN)
Quantity Denotes how many of the items in the relevant SaleReturnLineItem are to be delivered in this shipment. The implication being that one may purchase more than one of an item in a single SaleReturnLineItem and each instance of the item purchased may be shipped to a different address. QU_ITM_SHP Quantity DECIMAL(9,3)
TransactionID (FK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32) SaleReturnLineItem(TR_LTM_SLS_RTN)
CustomerOrderID (FK) A unique system assigned identifier for the CustomerOrder. ID_ORD Identity integer CustomerOrderProductAssignment(CO_ASGMT_CTORD_GRP)
CustomerOrderLineItemSequenceNumber (FK) A unique system assigned identifier for the LineItem within the confines of the CustomerOrder. IC_OR_LTM LineNumber smallint CustomerOrderProductAssignment(CO_ASGMT_CTORD_GRP)
CustomerOrderGroupID (FK) A unique system assigned identifier for the group of line items from a Customer placed order, recording how the Customer wishes the StockItems that have been orderd are to be given to the Customer. ID_CTORD_GRP Identity integer CustomerOrderProductAssignment(CO_ASGMT_CTORD_GRP)
ShipmentContainerID (FK) Token identifier used to uniquely identify this ShippingContainer instance. ID_CT_ORD_SHPMT_CNR Identity integer CustomerOrderShipmentContainer(AS_CT_ORD_SHPMT_CNR)


Parent Entity Verb Phrase Child Entity
CustomerOrderProductAssignment tentative shipment documented by CustomerOrderShipmentItem
CustomerOrderShipmentContainer contains CustomerOrderShipmentItem
SaleReturnLineItem is shipped as CustomerOrderShipmentItem

Logical Views containing CustomerOrderShipmentItem

Logical View
Logical 02020 - Item Inventory - Selling View
Logical 02200 - Transaction Macro View
Logical 02300 - Retail Transaction - Macro View
Logical 02309 - Retail Transaction Delivery
Logical 02315 - Retail Transaction - Customer Order
Logical 02316 - Distributed Order Management View
Logical 02340 - Retail Transaction - Shipping View