ItemTraceableUnitComponent

Entity Definition

Logical Name : ItemTraceableUnitComponent
Physical Name : CO_ITM_TRCBL_UN_COM

A record of the bill of materials for an inventory item that requires traceability reporting for itself or any of its components. This bill of materials is composed of ItemTracableUnits along with quantities and unit of measures. Like the ItemTraceableUnit it is built on, this entity complements the other ARTS item assembly entity types. Here is a brief illustration of ItemTracableUnitComponent Retailer ITEM - Deli tray - itself has a ItemTraceableUnitID of DELI28883. The Deli tray item is composed of: -Item Carrots - ItemTracableUnit (Lot) of PRD39998 lot 20101218 (from California) -Item Sliced Apples - ItemTraceableUnit (Lot) of PRD63387 (from Washington State) -Item Cheese - ItemTraceableUnit of DRY477873 (prepacke discrete item) (from Brookwork Farms, Wisconsin) -Item DeliPlate - Retail SKU (it is itself not traceable but part of the DELI28883 ItemTraceableUnit It is imporant to keep in mind that this bill of materials is for traceability reporting. So if there is a problem with the PRD63387 (Sliced Apples) the retailer knows to recall this specific deli tray DELI28883 as well as other deli trays that contain apple slices from that lot.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ParentItemUnitID (FK)(PK) A universally unique identifier used to identify an instance of a distinguisable instance of a retail item. The item traceable unit ID is similar to a serial number in that it allows each selling unit to be explicitly identified and distinguished from other sellling units of the same Item. ID_UN_TRC_PRNT IdentityUUID CHAR(32) ItemTraceableUnit(AS_ITM_TRCBL_UN)
ChildItemUnitID (FK)(PK) A universally unique identifier used to identify an instance of a distinguisable instance of a retail item. The item traceable unit ID is similar to a serial number in that it allows each selling unit to be explicitly identified and distinguished from other sellling units of the same Item. ID_UN_TRC_CHLD IdentityUUID CHAR(32) ItemTraceableUnit(AS_ITM_TRCBL_UN)
Quantity The number of traceable child unit identifiable item instances in a parent item unit. This captures the component count and is used to calculate the total count of traceable units used as components in higher level traceable units. QU_UN Quantity DECIMAL(9,2)
UnitOfMeasureCode The code used to specify the units in which a value is being expressed, or manner in which a measurement has been taken. This code relates to the UCC data element 355. LU_UOM Code2 CHAR(2)

Relationships

Parent Entity Verb Phrase Child Entity
ItemTraceableUnit is part of ItemTraceableUnitComponent
ItemTraceableUnit comprises ItemTraceableUnitComponent

Logical Views containing ItemTraceableUnitComponent

Logical View
Logical 21000 - Fresh Item Management Macro View