ShipmentContainerMerchandiseLineItem

Entity Definition

Logical Name : ShipmentContainerMerchandiseLineItem
Physical Name : TR_LTM_SHP_CNR_MR

An association between a SHIPMENT CONTAINER and an INVENTORY CONTROL DOCUMENT MERCHANDISE LINE ITEM. This association describes which container a specific item is being shipped in to the store.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
InventoryControlDocumentID (FK)(PK) The reference number that uniquely identifies the InventoryControlDocument. ID_ICD Identity integer ICDMerchandiseLineItem(DO_LTM_ICD_MR)
InventoryControlDocumentLineItemID (FK)(PK) A unique system assigned identifier for the LineItem within the confines of the InventoryControlDocument. IC_LTM_ICD LineNumber smallint ICDMerchandiseLineItem(DO_LTM_ICD_MR)
FreightBillID (FK)(PK) The carrier-assigned shipping document number ID_BL_FRGT Identity integer ShipmentContainer(AS_CNR_SHP)
FreightBillLineNumber (FK)(PK) The line number on the FREIGHT BILL to which this particular shipment container applies. IC_BL_FRGT LineNumber smallint ShipmentContainer(AS_CNR_SHP)
ShipmentContainerPackUnitCount The standard number of packs in each CONTAINER. QU_PCK_SHP_CNR Quantity DECIMAL(9,3)

Relationships

Parent Entity Verb Phrase Child Entity
ShipmentContainer may include ShipmentContainerMerchandiseLineItem
ICDMerchandiseLineItem may be shipped in ShipmentContainerMerchandiseLineItem

Logical Views containing ShipmentContainerMerchandiseLineItem

Logical View
Logical 02100 - Item Inventory - Macro View
Logical 02130 - Item Inventory - Receiving View
Logical 02309 - Retail Transaction Delivery
Logical 21000 - Fresh Item Management Macro View