/
Datamart Revision History

Datamart Revision History

April 28, 2016

Table: ItemSale, Column added

Name

Data type

Description

Name

Data type

Description

ExtendedPrice

decimal, not null

Represents the amount which was charged for this item. This should be approximately equal to:

Price × Quantity - PromoAmount - CompAmount - VoidAmount

SUM(ExtendedPrice) for all items on a check should be equal to the payments made on that check.

 

August 4, 2014

Table: Cashouts, Column(s) added

Name

Data Type

Description 

Name

Data Type

Description 

Id

PK, bigint

 

ObjectId

uniqueidentifier

 

CashoutNumber

int

 

Account_ObjectId

uniqueidentifier

 

BusinessDate

date

 

Employee_ObjectId

uniqueidentifier

 

EmployeeNumber

int

 

EmployeeFullName

nvarchar(max)

 

Job_ObjectId

int

 

JobName

nvarchar(max)

 

JobNumber

int

 

GrossSales

money

 

NetSales

money

 

TipShareQualifyingSales

money

 

TipShareAmount

money

 

Site_ObjectId

uniqueidentifier

 

ModifiedOn

datetimeoffset(7)

 

7/2/14

Table: ItemSale, Column(s) added

Name

Data Type

Allow Nulls

Default

Notes 

Name

Data Type

Allow Nulls

Default

Notes 

TaxExempt

bool

True

Null

Negates an order item was marked tax exempt. i.e. the staff member made a tax adjustment and set

the order item to be tax exempt.

  • When an order item is marked tax exempt an ItemSaleAdjustment record is add with AdjustmentTypeName="TaxExempt"

TaxForgiven

Decimal

True

0

The amount of Tax which was forgiven due to T