Entity Definition

Logical Name : ICDAllowanceLineItem
Physical Name : DO_LTM_ICD_ALW

A type of ICDLineItem that records allowances applicable to the whole 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)
Amount The monetary allowance made by the supplier against a specific line on the INVENTORY CONTROL DOCUMENT. MO_ITM_LN_ALW Money decimal(16,5)
TypeCode This code defines the type of allowance. For ARTS purposes the UCC-defined codes, data elements 150 and 340, are used as the basis for the domain of this attribute. TY_ITM_LN_ALW Code2 char(2)
ReasonCode The reason code for applying the allowance. RC_ALW_IDC Code2 char(2)
SupplierAllowanceNumber The number or identifier assigned by the supplier referencing an allowance, promotion or deal. ID_ALW_SPR IdentityAlphaNumeric varchar(20)
RetailerSerialFormID An idenfier for this document, usually preprinted on the form stock prior to being filled out. ID_FRM_RTL IdentityAlphaNumeric varchar(20)


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

Logical Views containing ICDAllowanceLineItem

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