Entity Definition

Logical Name : CustomerOrderProductAssignment
Physical Name : CO_ASGMT_CTORD_GRP

An associative entity recording where and how a particular item ordered by a Customer is to be processed by the retailer.

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 CustomerOrderProductLineItem(DO_CTOLTM_PDT)
CustomerOrderLineItemSequenceNumber (FK)(PK) A unique system assigned identifier for the LineItem within the confines of the CustomerOrder. IC_OR_LTM LineNumber smallint CustomerOrderProductLineItem(DO_CTOLTM_PDT)
CustomerOrderGroupID (FK)(PK) A unique system assigned identifier for the group of line items from a Customer placed order, recording how the Customer wishes the StockItems that have been orderd are to be given to the Customer. ID_CTORD_GRP Identity integer CustomerOrderProductGroup(CO_CTORD_GRP)
CustomerOrderProductAssignmentQuantity The number of items from the OrderProductLineItem that are included in the OrderProductGroup. QU_QTY Quantity DECIMAL(9,3)


Parent Entity Verb Phrase Child Entity
CustomerOrderProductLineItem is assigned to CustomerOrderProductAssignment
CustomerOrderProductGroup assigns CustomerOrderProductAssignment
CustomerOrderProductAssignment tentative shipment documented by CustomerOrderShipmentItem

Logical Views containing CustomerOrderProductAssignment

Logical View
Logical 02200 - Transaction Macro 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
Logical 07620 - Customer Order - Inventory Control View