Entity Definition

Logical Name : CustomerOrderChargeLineItem
Physical Name : DO_CTOLTM_CHG

A line item component of a Customer placed order, recording any extra charge that is added as part of the ordering process.

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
CustomerOrderLineItemSequenceNumber (FK)(PK) A unique system assigned identifier for the LineItem within the confines of the CustomerOrder. IC_OR_LTM LineNumber smallint
ItemID (FK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32) MiscellaneousFee(TR_FE_MSC)


Parent Entity Verb Phrase Child Entity
MiscellaneousFee is ordered via CustomerOrderChargeLineItem
CustomerOrderChargeLineItem is charged with CustomerOrderChargeTaxLineItem
CustomerOrderChargeLineItem has CustomerOrderChargePriceModifier
CustomerOrderLineItem can be a CustomerOrderChargeLineItem

Logical Views containing CustomerOrderChargeLineItem

Logical View
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