Entity Definition

Logical Name : SessionTax
Physical Name : LE_TX_SSN

A collection of tax totals for a tax authority by operator workstation session for a tender reconciliation period.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
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)
TaxGroupRuleID (FK)(PK) System assigned unique identifier for the TaxGroupRule. ID_RU_TX_GRP Identity integer TaxRateRule(RU_TX_RT)
SessionID (FK)(PK) A unique token ID for a Session instance. ID_SSN Identity integer Session(CO_SSN)
TaxOnSalesTotalAmount The total monetary amount of tax collected by SESSION. CP_TX_CLT_TOT Money decimal(16,5)
TaxableSalesTotalAmount The total monetary amount of taxable sales by SESSION.. CP_SLS_TX_TOT Money decimal(16,5)
TaxExemptSalesTotalAmount The total monetary amount of taxable sales by SESSION. CP_SLS_TX_EXM_TOT Money decimal(16,5)
TaxExemptSalesCount The total number of tax exempt transactions by SESSION QU_TRN_TX_EXM QuantityTransactionCount decimal(7,0)


Parent Entity Verb Phrase Child Entity
Session may include SessionTax
TaxRateRule is summarized in SessionTax

Logical Views containing SessionTax

Logical View
Logical 02410 - Control Transaction - Sign On Off View
Logical 03130 - Reporting - Store Operations - Session View
Logical 05000 - Taxation - Macro View
Logical 05400 - Taxation - Reporting View - Tax Rule Reference
Logical 11160 - Worker - Reporting View