Entity Definition

Logical Name : TillTaxHistory
Physical Name : LE_HST_TL_TX

A collection of tax totals for a tax authority by till for a tender reconciliation period.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TaxGroupRuleID (FK)(PK) System assigned unique identifier for the TaxGroupRule. ID_RU_TX_GRP Identity integer TaxRateRule(RU_TX_RT)
TillID (FK)(PK) The unique identifier for the TENDER RESPOSITORY. ID_RPSTY_TND Identity integer TillSettlementDocument(LE_HST_TL)
TaxRateRuleSequenceNumber (FK)(PK) A squential number for theTaxRateRule, denoting the order of creation of the rules. AI_TX_RT_RU LineNumber smallint TaxRateRule(RU_TX_RT)
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32) TillSettlementDocument(LE_HST_TL)
TaxCollectedTotalAmount The total monetary amount of tax collected by TILL for each REPORTING PERIOD. CP_TX_CLT_TOT Money decimal(16,5)
TaxableSaleTotalAmount The total monetary amount of taxable sales by TILL for each REPORTING PERIOD. CP_SLS_TX_TOT Money decimal(16,5)
TaxExemptSaleTotalAmount The total monetary amount of tax exempt sales by TILL for each REPORTING PERIOD. CP_SLS_TX_EXM_TOT Money decimal(16,5)
TaxExemptTransactionCount The total number of tax exempt transactions by TILL for each REPORTING PERIOD. QU_TRN_TX_EXM QuantityTransactionCount decimal(7,0)


Parent Entity Verb Phrase Child Entity
TillSettlementDocument may include TillTaxHistory
TaxRateRule is summarized in TillTaxHistory

Logical Views containing TillTaxHistory

Logical View
Logical 03160 - Reporting - Store Operations - Till View
Logical 05000 - Taxation - Macro View
Logical 05400 - Taxation - Reporting View - Tax Rule Reference