Datamart Revision History

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.

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)

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.

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,

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.