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) |