Entity Definition

Logical Name : ICDFreeText
Physical Name : DO_LTM_ICD_TXT

A type of ICDLineItem that records supplementary text from the InventoryControlDocument.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
InventoryControlDocumentID (FK)(PK) The reference number that uniquely identifies the InventoryControlDocument. ID_ICD Identity integer
InventoryControlDocumentLineItemID (FK)(PK) A unique system assigned identifier for the LineItem within the confines of the InventoryControlDocument. IC_LTM_ICD LineNumber smallint
Text A short narrative from the InventoryControlDocument. DE_TXT DescriptionNarrative varchar(4000)


Parent Entity Verb Phrase Child Entity
ICDLineItem can be a ICDFreeText

Logical Views containing ICDFreeText

Logical View
Logical 02120 - Item Inventory - Order View
Logical 02130 - Item Inventory - Receiving View