Entity Definition

Logical Name : ItemDateType
Physical Name : LY_ITM_DT_TY

A categorization of dates for an item or inventory item. Examples include production date, packaging date, available for sale date, sell by date, expiration date.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ItemDateTypeCode (PK) A code that identifies a categorization of date types for an item. TY_DT_ITM Code4 CHAR(4)
Name Name of the item date type NM_TY_ITM_DT Name VARCHAR(40)
Description Short description DE_ITM_DT DescriptionShort VARCHAR(255)


Parent Entity Verb Phrase Child Entity
ItemDateType categorizes ItemUnitDateType

Logical Views containing ItemDateType

Logical View
Logical 21000 - Fresh Item Management Macro View