Entity Definition

Logical Name : SaleReturnTaxLineItem
Physical Name : TR_LTM_SLS_RTN_TX

A Line Item to record taxation implications of a single SaleOrReturnLineItem rather than an entire RetailTransaction

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) SaleReturnLineItem(TR_LTM_SLS_RTN)
RetailTransactionLineItemSequenceNumber (FK)(PK) The sequence number of line item within the context of this RetailTransaction. IC_LN_ITM LineNumber smallint SaleReturnLineItem(TR_LTM_SLS_RTN)
SalesTaxSequenceNumber (PK) A sequentially assigned number used to ensure a unique identity for SaleReturnTaxLineItem instances. IC_SLS_TX_SQN_NMB LineNumber smallint
TaxGroupRuleID (FK) System assigned unique identifier for the TaxGroupRule. ID_RU_TX_GRP Identity integer TaxGroupRule(RU_TX_GP)
UsageCode (FK) Retailer defined mnemonic code identifying the CustomerIntendedUsage. Eg: EatIn, TakeOut, consumption, resale CD_TYP_TX_INTD_USE Code4 char(4) TaxIntendedUsageType(CO_TYP_TX_INTD_USE)
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)
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 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
TaxableAmount The monetary amount for which tax is applicable. MO_TXBL_RTN_SLS Money decimal(16,5)
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_TXBL Percent decimal(7,4)
TaxPercent The percentage of the taxable portion of the taxable amount that is being collected as tax by this LineItem. PE_TX Percent decimal(7,4)
TaxAmount The monetary value tax that is being collected by this LineItem. MO_TX_RTN_SLS Money decimal(16,5)


Parent Entity Verb Phrase Child Entity
TaxGroupRule applies to SaleReturnTaxLineItem
TaxIntendedUsageType is used for SaleReturnTaxLineItem
SaleReturnLineItem is charged with SaleReturnTaxLineItem
Reason classifies SaleReturnTaxLineItem
SaleReturnTaxLineItem is exempted by SaleReturnTaxExemptionModifier
SaleReturnTaxLineItem is overridden by SaleReturnTaxOverrideModifier

Logical Views containing SaleReturnTaxLineItem

Logical View
Logical 02300 - Retail Transaction - Macro View
Logical 02310 - Retail Transaction - Item Sale View
Logical 02311 - Retail Transaction Item KIT Sale View
Logical 02315 - Retail Transaction - Customer Order
Logical 02316 - Distributed Order Management View
Logical 02320 - Retail Transaction - Taxation View
Logical 02370 - Retail Transaction - Rental 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