AssociatedCustomerOrderLineItem

Entity Definition

Logical Name : AssociatedCustomerOrderLineItem
Physical Name : ST_ASCTN_CTOLTM

Records various relationships between CustomerOrderLineItems. The nature of the relationship is determined by the retailer depending on their specific requirements. Eg: Presence of ChargeLineItem is required by the presence of certain ProductLineItems.

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_PRNT Identity integer CustomerOrderLineItem(DO_CTOLTM)
CustomerOrderID (FK)(PK) A unique system assigned identifier for the CustomerOrder. ID_ORD_CLD Identity integer CustomerOrderLineItem(DO_CTOLTM)
ParentLineItemID (FK)(PK) A unique system assigned identifier for the LineItem within the confines of the CustomerOrder. IC_OR_LTM_PRNT LineNumber smallint CustomerOrderLineItem(DO_CTOLTM)
ChildLineItemID (FK)(PK) A unique system assigned identifier for the LineItem within the confines of the CustomerOrder. IC_OR_LTM_CLD LineNumber smallint CustomerOrderLineItem(DO_CTOLTM)
AssociationTypeCode A retailer assigned code denoting how the two CustomerOrderLineItems are related to each other. TY_ASCTN Code2 char(2)

Relationships

Parent Entity Verb Phrase Child Entity
CustomerOrderLineItem is child of AssociatedCustomerOrderLineItem
CustomerOrderLineItem is parent AssociatedCustomerOrderLineItem

Logical Views containing AssociatedCustomerOrderLineItem

Logical View
Logical 02309 - Retail Transaction Delivery
Logical 02316 - Distributed Order Management View
Logical 07610 - Customer Order - Maintenance View
Logical 07620 - Customer Order - Inventory Control View