Entity Definition

Logical Name : CustomerOrder
Physical Name : DO_CTORD

A document that describes a request by a Customer to purchase merchandise and/or service items from a retailer on agreed terms and conditions (price, delivery, payments schedule, cancellation policy, etc.)

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CustomerOrderID (PK) A unique system assigned identifier for the CustomerOrder. ID_ORD Identity integer
CustomerOrderTypeCode (FK) A unique retailer assigned code denoting a type of CustomerOrder Examples include: LAYAWAY ORDER FOR DELIVERY ORDER FOR PICKUP Eg: Layaway, Order for Delivery, Order for Pickup, etc... CD_TYP_CTORD Code2 char(2) CustomerOrderType(CO_TYP_CTORD)
EstimatedAvailabilityDate The date the merchandise being ordered is expected to be available for delivery to the Customer or pickup by the Customer. DC_AVLB_EST DateCalendar date
ActualAvailabilityDate The date all the merchandise being ordered was made available for delivery to the Customer or pickup by the Customer. Where the merchandise becomes available over a period of time - this field holds the date the last ordered product was available for delivery or pickup. DC_AVLB_ACT DateCalendar date
CustomerID (FK) A unique system assigned identifier for the Customer. ID_CT Identity integer Customer(PA_CT)
SpecialOrderID An separate identifier (from that of a customer order id) for a special order ID_ORD_SPL IdentityAlphaNumeric varchar(20)
ChannelID (FK) Token Identifier for a channel instance ID_CHNL Identity integer Channel(CO_CHNL)
ISOCurrencyCode (FK) Currency code designated by ISO to identify national currency CD_CNY_ISO_4217 ISO_4217_CurrencyCode_char(3) char(3) ISO4217-CurrencyType(LU_CNY_ISO_4217)
CustomerAccountID (FK) A unique identifier for a customer account. ID_CTAC Identity integer CustomerOrderAccount(LE_CT_ORD_ACNT)


Parent Entity Verb Phrase Child Entity
ISO4217-CurrencyType is used in CustomerOrder
CustomerOrderAccount places CustomerOrder
Customer places CustomerOrder
Channel is vehicle for CustomerOrder
CustomerOrderType categorizes CustomerOrder
CustomerOrder marks occurence of ConversionEvent
CustomerOrder has CustomerOrderLineItem
CustomerOrder is assigned CustomerOrderStateAssignment
CustomerOrder is updated by CustomerOrderControlTransaction

Logical Views containing CustomerOrder

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