Entity Definition

Logical Name : CustomerDeliveryPreference
Physical Name : CO_CT_DV_PRFC

A specific location, service level, payment type and other customer preferences for where, when, and how merchandise is to be delivered. Specifies WHERE and WHEN a CustomerDeliveryInstruction related shipment is to be dropped off at a customer's location. It complements the CustomerDeliveryInstruction and because it can occur multiple times for a given delivery allows retailers to specify alternate delivery locations. Typically there will be only one occurence.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CustomerDeliveryID (FK)(PK) A TOKEN identifier for a CustomerDelivery entity type instance. ID_CT_DV Identity integer CustomerDeliveryInstruction(CO_CT_DV_INSTR)
CustomerDeliverySequenceNumber (PK) A sequence number used to distinguish specific ship to instructions associated with a CustomerDelivery. As an example, Walmart's Web store allows a customer to specifiy multiple delivery preferences for an order so one order and delivery can be split into multiple different destinations, ship times, etc. IC_CT_DV_SQN_NMB LineNumber smallint
RequestedDeliveryDate Requested delivery date to define the day a customer wants goods in an order delivered. TS_DV_PRFC DateCalendar datetime
SpecialInstructions Narrative text, giving special delivery instructions that apply only to this specific CustomerDeliveryPreference. This is used in scenarios where a customer order specifies that in addition to NA_INST_SPL DescriptionNarrative varchar(4000)
RequestedDeliveryTo (FK) A token identifier for a PartyContactMethod entity type instance. ID_PRTY_CNCT_MTH Identity integer PartyContactMethod(CO_MTH_CNCT_PTY)
PrimaryDeliverBeforeAfterCode Indicates if the preferred delivery time is before DeliverTime or after DeliverTime. Sample values: BEFORE AFTER CD_DV_BFR_OR_AFT Code varchar(20)
PrimaryDeliverTime Preferred time of day for a delivery to occur on the RequestedDeliveryDate specified in CustomerDeliveryPreference. DT_DV_PRFC Time datetime
SecondaryDeliverTime Secondary preference for a delivery time if the primary delivery time is not available. DT_SCNDRY_DV_TM Time datetime
SecondaryDeliverBeforeAfterCode Indicates if the preferred delivery time is before SecondaryDeliverTime or after SecondaryDeliverTime. Sample values: BEFORE AFTER CD_SCNDRY_DV_BFR_AFT Code varchar(20)


Parent Entity Verb Phrase Child Entity
CustomerDeliveryInstruction delivered to CustomerDeliveryPreference
PartyContactMethod requested deliver to CustomerDeliveryPreference
CustomerDeliveryPreference delivery time set by Z_CustomerDeliveryPreferenceTime

Logical Views containing CustomerDeliveryPreference

Logical View
Logical 02309 - Retail Transaction Delivery
Logical 02315 - Retail Transaction - Customer Order
Logical 02316 - Distributed Order Management View
Logical 02340 - Retail Transaction - Shipping View