Entity Definition

Logical Name : ICDStateAssignment
Physical Name : CO_ASGMT_STE_ICD

A record of the states that a particular InventoryControlDocument was in during a particular time period.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
InventoryControlDocumentStateCode (FK)(PK) A unique retailer assigned identifier for the stages in the life-cycle of an InventoryControlDocument. CD_ST_ICD Code2 char(2) ICDState(CO_ST_ICD)
InventoryControlDocumentID (FK)(PK) The reference number that uniquely identifies the InventoryControlDocument. ID_ICD Identity integer InventoryControlDocument(DO_ICD)
EffectiveDateTime (PK) The date from which the assignment applies. DC_EF EffectiveDateTime datetime
ExpirationDateTime The date until which the assignment applies. DC_EP ExpirationDateTime datetime


Parent Entity Verb Phrase Child Entity
InventoryControlDocument is assigned ICDStateAssignment
ICDState classifies ICDStateAssignment

Logical Views containing ICDStateAssignment

Logical View
Logical 02120 - Item Inventory - Order View
Logical 02130 - Item Inventory - Receiving View
Logical 02316 - Distributed Order Management View