Entity Definition

Logical Name : CustomerOrderProductSpecialInstructions
Physical Name : CO_CTOLM_PDT_INSTR

A line item component of a Customer placed order, recording any special instructions the Customer may have for the product being ordered. Eg: paint color, or other alterations.

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 CustomerOrderProductLineItem(DO_CTOLTM_PDT)
CustomerOrderLineItemSequenceNumber (FK)(PK) A unique system assigned identifier for the LineItem within the confines of the CustomerOrder. IC_OR_LTM LineNumber smallint CustomerOrderProductLineItem(DO_CTOLTM_PDT)
InstructionNarrative Instructional narrative text. NA_INSTR DescriptionNarrative varchar(4000)


Parent Entity Verb Phrase Child Entity
CustomerOrderProductLineItem has CustomerOrderProductSpecialInstructions

Logical Views containing CustomerOrderProductSpecialInstructions

Logical 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