Entity Definition

Logical Name : CustomerOrderStateAssignment
Physical Name : CO_ASGMT_STE_CTORD

Record of a CustomerOrder being in a particular state for a period of time.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CustomerOrderID (FK)(PK) A unique system assigned identifier for the CustomerOrder. ID_ORD Identity integer CustomerOrder(DO_CTORD)
CustomerOrderStateCode (FK)(PK) A unique retailer assigned code denoting a potential state for a CustomerOrder. Eg: Create, DeleteItem, AddItem, ChangeItem, PartialDelivery, DeliveryComplete, PartialPickup, PickupComplete etc... CD_STE_CTORD Code2 char(2) CustomerOrderState(CO_STE_CTORD)
EffectiveDateTime Date a given CustomerOrderStateAssignment becomes effective. This is used to facilitate a time lapsed view of customer order state changes. DT_EF EffectiveDateTime datetime
ExpirationDateTime Date a given CustomerOrderStateAssignment expires. This is used to facilitate a time lapsed view of customer order state changes. DT_EP ExpirationDateTime datetime


Parent Entity Verb Phrase Child Entity
CustomerOrderState is assigned via CustomerOrderStateAssignment
CustomerOrder is assigned CustomerOrderStateAssignment

Logical Views containing CustomerOrderStateAssignment

Logical View
Logical 02309 - Retail Transaction Delivery
Logical 02315 - Retail Transaction - Customer Order
Logical 02316 - Distributed Order Management View
Logical 07600 - Customer Order - Macro View
Logical 07610 - Customer Order - Maintenance View