Entity Definition

Logical Name : TaxLineItem
Physical Name : TR_LTM_TX

A line item component of a RetailTransaction that records the charging and offsetting liability credit for sales tax on merchandise items and services sold by the store or debit for merchandise returned to the store.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32)
RetailTransactionLineItemSequenceNumber (FK)(PK) The sequence number of line item within the context of this RetailTransaction. IC_LN_ITM LineNumber smallint
ReasonCode (FK) A unique retailer defined reason code for an action that is taken (or not taken) at a Workstation. e.g. Return reason codes - Past Use By Date, Defective Merchandise, etc. POSNoSale reason Codes - Customer Change Query CD_RSN Code varchar(20) Reason(CO_CD_RSN)
ExceptionalTaxRuleFlag A flag denoting that a special TaxGroupRule has been invoked rather than the normal one. FL_TX_RU_EXC Flag integer
TaxIncludedInPricesFlag A flag denoting that all applicable taxes are included in the prices for this line item, and that therefore this SaleReturnTaxLineItem is merely a summary of those taxes, FL_TX_INCL_PR Flag integer
TaxAtSourceFlag A flag denoting that the goods being sold and shipped have been taxed according to the TaxAuthorityShippingRule. FL_TX_SRC Flag integer
TaxablePercent The percentage of the taxable amount that is liable for tax. Usually this is 100% but where an aggregate item contains taxed and non-taxed goods this value may be less than 100%. PE_TXBLE Percent decimal(7,4)
TaxableAmount The monetary value of the transaction for which tax is being calculated. MO_TXBL Money decimal(16,5)
TaxPercent The percentage of the taxable amount that should is tax. Derived by applying the appropriate TaxGroupRule and TaxRateRule. PE_TXBL Percent decimal(7,4)
TaxAmount The monetary amount of sales Tax calculated by applying the appropriate TaxGroupRule and TaxRateRule. MO_TX Money decimal(16,5)
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
TaxGroupRule applies to TaxLineItem
Reason classifies TaxLineItem
TaxLineItem is overridden by TaxOverrideModifier
TaxLineItem is exempted by TaxExemptionModifier
RetailTransactionLineItem can be a TaxLineItem

Logical Views containing TaxLineItem

Logical View
Logical 02300 - Retail Transaction - Macro View
Logical 02315 - Retail Transaction - Customer Order
Logical 02316 - Distributed Order Management View
Logical 02320 - Retail Transaction - Taxation View
Logical 04100 - Financial Ledger - Retail Transaction View
Logical 05000 - Taxation - Macro View
Logical 05200 - Taxation - Retail Transaction View
Logical 05400 - Taxation - Reporting View - Tax Rule Reference