Entity Definition

Logical Name : ItemUnitDateType
Physical Name : CO_ITM_UN_DT_TYP

A cross refrence of ItemDateTypes to Item Lot, allowing for the tracking of multiple dates such as package date, production date, etc. for a lot or batch of items.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ItemDateTypeCode (FK)(PK) Three/four character lookup code TY_DT_ITM Code4 CHAR(4) ItemDateType(LY_ITM_DT_TY)
ItemTraceableUnitID (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_ITM_UN_TRC IdentityUUID CHAR(32) ItemTraceableUnit(AS_ITM_TRCBL_UN)
DateTime A date (and optionall a time) for a specific item's date type. For example, an item might have a Packaged Date of 27 June 2009 or a Best Before Date of 27 June 2009 12 noon. TS_ITM_UN AuditDateTime datetime


Parent Entity Verb Phrase Child Entity
ItemTraceableUnit is described by ItemUnitDateType
ItemDateType categorizes ItemUnitDateType

Logical Views containing ItemUnitDateType

Logical View
Logical 21000 - Fresh Item Management Macro View