Entity Definition

Logical Name : ICDLineItem
Physical Name : DO_LTM_ICD

A detail line on an InventoryControlDocument that identifies the StockItem, and unit of measure exchanged, or the freight, charges, taxes, and allowances applicable to a particular inventory control event and action.

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 InventoryControlDocument(DO_ICD)
InventoryControlDocumentLineItemID (PK) A unique system assigned identifier for the LineItem within the confines of the InventoryControlDocument. IC_LTM_ICD LineNumber smallint
RelativeOrder A retailer assigned relative order number, showing the relative order of this LineItem with respect to the other LineItems in the InventoryControlDocument. This allows the retailer to modifiy the order of LineItems within the context of the InventoryControlDocument - during it's life-cycle. AI_RL_ORD LineNumber smallint
LineItemTypeCode The DOCUMENT LINE ITEM CODE TYPE CODE specifies the item type. TY_ITM_DCM_LN Code2 char(2)


Parent Entity Verb Phrase Child Entity
InventoryControlDocument is composed of ICDLineItem
ICDLineItem is referred to ICDLineItemReference
ICDLineItem refers to ICDLineItemReference
ICDLineItem can be a ICDFreightLineItem
ICDLineItem can be a ICDFreeText
ICDLineItem can be a ICDTaxLineItem
ICDLineItem can be a ICDAllowanceLineItem
ICDLineItem can be a ICDMerchandiseLineItem
ICDLineItem can be a ICDChargeLineItem

Logical Views containing ICDLineItem

Logical View
Logical 02100 - Item Inventory - Macro View
Logical 02110 - Item Inventory - Location View
Logical 02120 - Item Inventory - Order View
Logical 02130 - Item Inventory - Receiving View
Logical 02309 - Retail Transaction Delivery
Logical 02316 - Distributed Order Management View
Logical 04300 - Financial Ledger - Inventory Control View
Logical 05000 - Taxation - Macro View
Logical 05300 - Taxation - Inventory Control Document View
Logical 07620 - Customer Order - Inventory Control View
Logical 21000 - Fresh Item Management Macro View