Entity Definition

Logical Name : ICDFreightLineItem
Physical Name : DO_LTM_ICD_FRGT

A type of ICDLineItem that records the type and amount of freight cost incurred on an 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
ICDChargeAllowanceProcessingRuleID (FK) A unique system assigned identifier for the rule denoting how a particular Charge or Allowance in an InventoryControlDocument is to be treated in the financial reporting systems. ID_ICD_CHG_ALW_RU Identity integer ICDChargeAllowanceProcessingRule(RU_ICD_CHG_ALW)
CostCode A code to signify whether the freight cost is met by the retailer or supplier. LU_CST_FRGT Code2 char(2)
CostAmount The freight charges. MN_CST_FRGT Money decimal(16,5)


Parent Entity Verb Phrase Child Entity
ICDChargeAllowanceProcessingRule defines processing for ICDFreightLineItem
ICDLineItem can be a ICDFreightLineItem

Logical Views containing ICDFreightLineItem

Logical View
Logical 02100 - Item Inventory - Macro View
Logical 02120 - Item Inventory - Order View
Logical 02130 - Item Inventory - Receiving View
Logical 04300 - Financial Ledger - Inventory Control View