CustomerOrderLineItem

Entity Definition

Logical Name : CustomerOrderLineItem
Physical Name : DO_CTOLTM

A line item component of a Customer placed order.

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)
CustomerOrderLineItemSequenceNumber (PK) A unique system assigned identifier for the LineItem within the confines of the CustomerOrder. IC_OR_LTM LineNumber smallint
TransactionID (FK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32) RetailTransactionLineItem(TR_LTM_RTL_TRN)
RetailTransactionLineItemSequenceNumber (FK) The sequence number of line item within the context of this RetailTransaction. IC_LN_ITM LineNumber smallint RetailTransactionLineItem(TR_LTM_RTL_TRN)
RelativeOrder A retailer assigned relative order number, showing the relative order of this LineItem with respect to the other LineItems in the CustomerOrder. This allows the retailer to modify the order of line items within the context of the CustomerOrder - during the Order's life-cycle. IC_RL_ORD LineNumber smallint
LineItemNumber Relative line sequence number within an order. Provides mechanism to order how CustomerOrderLineItem instances are displayed when presenting a CustomerOrder. IC_SHPPG_CRT_LN_ITM_ORG LineNumber smallint
CustomerOrderLineItemTypeCode (FK) A retailer assigned code denoting which sub-type of CustomerOrderLineItem this particular line item is. CD_CT_ORD_LN_ITM_TYP Code varchar(20) CustomerOrderLineItemType(CO_CT_ORD_LN _ITM_TYP)

Relationships

Parent Entity Verb Phrase Child Entity
CustomerOrderLineItemType classifies CustomerOrderLineItem
CustomerOrder has CustomerOrderLineItem
RetailTransactionLineItem originated in CustomerOrderLineItem
CustomerOrderLineItem is child of AssociatedCustomerOrderLineItem
CustomerOrderLineItem is parent AssociatedCustomerOrderLineItem
CustomerOrderLineItem was source for RetailTransactionLineItem
CustomerOrderLineItem is assigned CustomerOrderLineItemStateAssignment
CustomerOrderLineItem is posted by CustomerAccountJournal
CustomerOrderLineItem is updated by CustomerOrderControlTransactionLineItem
CustomerOrderLineItem can be a CustomerOrderTaxLineItem
CustomerOrderLineItem can be a CustomerOrderProductLineItem
CustomerOrderLineItem can be a CustomerOrderFreeTextLineItem
CustomerOrderLineItem can be a CustomerOrderTenderPreAuthorization
CustomerOrderLineItem can be a CustomerOrderChargeLineItem
CustomerOrderLineItem can be a CustomerOrderPaymentLineItem

Logical Views containing CustomerOrderLineItem

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
Logical 10400 - Enterprise - Channels