Entity Definition

Logical Name : SaleReturnTaxExemptionModifier
Physical Name : TR_MDFR_SLS_TX_EXM

A line item modifier to the SaleReturnTaxLineItem component of a RetailTransaction that provides supplementary data regarding tax exemptions.

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) SaleReturnTaxLineItem(TR_LTM_SLS_RTN_TX)
RetailTransactionLineItemSequenceNumber (FK)(PK) The sequence number of line item within the context of this RetailTransaction. IC_LN_ITM LineNumber smallint SaleReturnTaxLineItem(TR_LTM_SLS_RTN_TX)
SalesTaxSequenceNumber (FK)(PK) A sequentially assigned number used to ensure a unique identity for SaleReturnTaxLineItem instances. IC_SLS_TX_SQN_NMB LineNumber smallint SaleReturnTaxLineItem(TR_LTM_SLS_RTN_TX)
IssuedToPartyID (FK) A unique, system assigned identity for a Party. ID_PRTY_ISS_TO Identity integer TaxCertificate(PA_TX_CF)
TaxCertificateSequenceNumber (FK) A sequential counter used to uniquely identify a tax certificate for a specific party. AI_PA_TX_CF LineNumber smallint TaxCertificate(PA_TX_CF)
ExemptTaxableAmount The Taxable amount which the customer would've been liable to pay tax on had they not been granted this exemption. MO_EXM_TXBL MoneyShortRetail decimal(7,2)
ExemptTaxAmount The amount of tax that the customer would've been liable to pay had thus TaxExemption not been granted. MO_EXM_TX MoneyShortRetail decimal(7,2)
ReasonCode (FK) A retailer assigned code denoting why this TaxExemption was granted. CD_RSN Code varchar(20) Reason(CO_CD_RSN)
CustomerExemptionID Identifier presented by Customer to get this tax exemption. Not used if Customer presents an individualised tax exemption certificate. e.g. Flight Number in Duty Free stores at Airport. ID_EXM_CT IdentityAlphaNumeric varchar(20)
CertificateNumber A unique identifier taken from the TaxExemption Certificate that the customer presented in order to get this Tax Exemption. ID_CF_TX_EXM IdentityAlphaNumeric varchar(20)
CertificateHolderName The Customer name taken from the TaxExemption Certificate that the customer presented in order to get this Tax Exemption. NM_CF_HLDR Name varchar(40)


Parent Entity Verb Phrase Child Entity
Reason classifies SaleReturnTaxExemptionModifier
SaleReturnTaxLineItem is exempted by SaleReturnTaxExemptionModifier
TaxCertificate applies to SaleReturnTaxExemptionModifier

Logical Views containing SaleReturnTaxExemptionModifier

Logical View
Logical 02310 - Retail Transaction - Item Sale View
Logical 02311 - Retail Transaction Item KIT Sale View
Logical 02315 - Retail Transaction - Customer Order
Logical 02320 - Retail Transaction - Taxation View
Logical 05000 - Taxation - Macro View
Logical 05200 - Taxation - Retail Transaction View