Entity Definition

Logical Name : ICDTaxLineItem
Physical Name : DO_LTM_ICD_TX

A type of ICDLineItem that records sales, use and value added taxes 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)
TaxableAmount The taxable amount for which tax is to be paid MO_TXBL MoneyShortRetail decimal(7,2)
TaxAmount The amount of tax that is being paid MO_TX MoneyShortRetail decimal(7,2)
TaxGroupRuleID (FK) System assigned unique identifier for the TaxGroupRule. ID_RU_TX_GRP Identity integer TaxGroupRule(RU_TX_GP)


Parent Entity Verb Phrase Child Entity
ICDChargeAllowanceProcessingRule defines processing for ICDTaxLineItem
TaxGroupRule applies to ICDTaxLineItem
ICDTaxLineItem is modified by ICDTaxExemptionModifier
ICDLineItem can be a ICDTaxLineItem

Logical Views containing ICDTaxLineItem

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