Entity Definition

Logical Name : CustomerOrderControlTransactionLineItem
Physical Name : TR_LTM_CTL_CTORD

A component of an OrderControlTransaction, recording a change in state for a particular OrderLineItem, by an Operator.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32) CustomerOrderControlTransaction(TR_CTL_CTORD)
CustomerOrderControlTransactionLineItemSequenceNumber (PK) Designates the line item within a CustomerOrderControlTransaction. The values are incremented by 1 for each line item appended to the transaction. IC_LN_ITM LineNumber smallint
CustomerOrderID (FK) A unique system assigned identifier for the CustomerOrder that is being changed by the transaction line item. ID_ORD Identity integer CustomerOrderLineItem(DO_CTOLTM)
CustomerOrderLineItemSequenceNumber (FK) A unique system assigned identifier for the LineItem from the CustomerOrder that is being changed by the transaction line item. IC_OR_LTM LineNumber smallint CustomerOrderLineItem(DO_CTOLTM)
AddressID (FK) A unique system allocated identifier for the Address. ID_ADS Identity integer Address(LO_ADS)
NewItemID (FK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32) Item(AS_ITM)
NewOrderLineItemStateCode (FK) A unique retailer assigned code denoting a the state for the CustomerOrderLineItem being changed by the transaction line item. CD_STE_CTOLM Code2Status char(2) CustomerOrderLineItemState(CO_STE_CTOLM)
NewQuantityOrdered The quantity of ordered Items, that's being assigned to the customer order by the transaction line item. QU_ORD Quantity DECIMAL(9,3)


Parent Entity Verb Phrase Child Entity
Item is set via CustomerOrderControlTransactionLineItem
CustomerOrderControlTransaction has CustomerOrderControlTransactionLineItem
CustomerOrderLineItem is updated by CustomerOrderControlTransactionLineItem
CustomerOrderLineItemState is set via CustomerOrderControlTransactionLineItem
Address is set via CustomerOrderControlTransactionLineItem

Logical Views containing CustomerOrderControlTransactionLineItem

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 07610 - Customer Order - Maintenance View