Datamart Revision History

8/4/14

Table: Cashouts, Column(s) added

Name	Data Type	Default	Notes
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

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 TaxExempt being true.

The TaxAmount column will report 0 when the TaxForgiven column has a value.

Table: ItemSaleAdjustment, Enumeration added

Column

Enum Value

Notes

AdjustmentTypeName

"TaxExempt"

Each time the staff applies a tax exempt adjustment to an order item a record is added to the ItemSaleAdjustment table. The AdjustmentTypeName is set to "TaxExempt"

Note: You should block "TaxExempt" adjustments from your application if it's reporting all records in the ItemSaleAdjustment table for Sales Adjustment calculations,

2/17/14

Table: ItemSale, Column(s) added

Name

Data Type

Allow Nulls

Default

Notes

ParentObjectId

Guid

True

Null

Used to relate children ItemSale records to a parent ItemSale record.

i.e. A combo named "Lunch Meal Deal" is sold which consists of Burger, Fries, Drink.

The ItemSale data output will consist of:

1 ItemSale record which represents the combo "Lunch Meal Deal".
3 ItemSale records with a ParentObjectId which equals the ObjectId of the "Lunch Meal Deal"
- The 3 ItemSale records represent the Burger, Fries, and Drink.