Entity Definition

Logical Name : ICDTaxExemptionModifier
Physical Name : DO_LTM_ICD_TX_MDFR

A line item modifier to the ICDDocumentTaxLineItem that provides supplementary data regarding tax exemptions that have been applied.

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 ICDTaxLineItem(DO_LTM_ICD_TX)
InventoryControlDocumentLineItemID (FK)(PK) A unique system assigned identifier for the LineItem within the confines of the InventoryControlDocument. IC_LTM_ICD LineNumber smallint ICDTaxLineItem(DO_LTM_ICD_TX)
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)
ExemptionAmount The monetary amount of the tax exemption MO_TX_EXM MoneyShortRetail decimal(7,2)
ReasonCode A reason code for the tax exemption. Typically the CUSTOMER belongs a special group, such foreign diplomats, religious bodies, etc. The bearer must have a certificate to qualify for the tax exemption. AUTHORITY. RC_TX_EXM Code2 char(2)


Parent Entity Verb Phrase Child Entity
ICDTaxLineItem is modified by ICDTaxExemptionModifier
ICDChargeAllowanceProcessingRule defines processing for ICDTaxExemptionModifier

Logical Views containing ICDTaxExemptionModifier

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
Logical 05000 - Taxation - Macro View
Logical 05300 - Taxation - Inventory Control Document View