Entity Definition

Logical Name : CustomerOrderLineItemStateAssignment
Physical Name : CO_ASGMT_STE_CTOLM

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

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
OrderLineItemStateCode (FK)(PK) A unique retailer assigned code denoting a potential state for a CustomerOrderLineItem. Eg: Deleted, Pending, PartialDelivery, DeliveryComplete, PartialPickup, PickupComplete etc... SC_OR_LTM Code2Status char(2) CustomerOrderLineItemState(CO_STE_CTOLM)
CustomerOrderID (FK)(PK) A unique system assigned identifier for the CustomerOrder. ID_ORD Identity integer CustomerOrderLineItem(DO_CTOLTM)
CustomerOrderLineItemSequenceNumber (FK)(PK) A unique system assigned identifier for the LineItem within the confines of the CustomerOrder. IC_OR_LTM LineNumber smallint CustomerOrderLineItem(DO_CTOLTM)
EfffectiveDateTime Date the line item state is in effect. DT_EF AuditDateTime datetime
ExpirationDateTime Date the line item state is out of effect DT_EP AuditDateTime datetime


Parent Entity Verb Phrase Child Entity
CustomerOrderLineItemState is assigned via CustomerOrderLineItemStateAssignment
CustomerOrderLineItem is assigned CustomerOrderLineItemStateAssignment

Logical Views containing CustomerOrderLineItemStateAssignment

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