Entity Definition

Logical Name : TaxExemptionModifier
Physical Name : CO_MDFR_TX_EXM

A line item modifier to the TaxLineItem 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) TaxLineItem(TR_LTM_TX)
RetailTransactionLineItemSequenceNumber (FK)(PK) The sequence number of line item within the context of this RetailTransaction. IC_LN_ITM LineNumber smallint TaxLineItem(TR_LTM_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 that the Customer is exempt from. MO_EXM_TXBL MoneyShortRetail decimal(7,2)
ExemptTaxAmount The amount of Tax the Customer is exempt from paying. MO_EXM_TX Money decimal(16,5)
ReasonCode (FK) A reason code for the tax exemption. Typically the Customer belongs a special group, such foreign diplomats, religious bodies, etc. 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_CT_EXM Name varchar(40)
CertificateNumber The certificate number assigned to a purchaser by a TaxAuthority exempting the purchaser from tax in that aurhority. ID_CF_TX_EXM IdentityAlphaNumeric varchar(20)
CertificateHolderName The name of the individual or organization who holds the tax exemption certificate. NM_HLDR_TX_EXM_CF Name varchar(40)


Parent Entity Verb Phrase Child Entity
TaxCertificate applies to TaxExemptionModifier
TaxLineItem is exempted by TaxExemptionModifier
Reason classifies TaxExemptionModifier

Logical Views containing TaxExemptionModifier

Logical View
Logical 02315 - Retail Transaction - Customer Order
Logical 02320 - Retail Transaction - Taxation View
Logical 05000 - Taxation - Macro View
Logical 05200 - Taxation - Retail Transaction View