Entity Definition

Logical Name : CustomerOrderFreeTextLineItem
Physical Name : DO_CTOLTM_TXT

Some free form text that is associated with the CustomerOrder.

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


Parent Entity Verb Phrase Child Entity
CustomerOrderLineItem can be a CustomerOrderFreeTextLineItem

Logical Views containing CustomerOrderFreeTextLineItem

Logical View
Logical 02315 - Retail Transaction - Customer Order
Logical 02316 - Distributed Order Management View
Logical 07610 - Customer Order - Maintenance View