Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

April 28, 2016

Table: ItemSale, Column added

NameData typeDescription
ExtendedPricedecimal, 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

NameData TypeDescription 

Id

PK, bigint

 

ObjectIduniqueidentifier

 

CashoutNumberint 
Account_ObjectIduniqueidentifier 
BusinessDatedate 
Employee_ObjectIduniqueidentifier 
EmployeeNumberint 
EmployeeFullNamenvarchar(max) 
Job_ObjectIdint 
JobNamenvarchar(max) 
JobNumberint 
GrossSalesmoney 
NetSalesmoney 
TipShareQualifyingSalesmoney 
TipShareAmountmoney 
Site_ObjectIduniqueidentifier 
ModifiedOndatetimeoffset(7) 

7/2/14

Table: ItemSale, Column(s) added

NameData TypeAllow NullsDefaultNotes 

TaxExempt

boolTrueNull

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"
TaxForgivenDecimalTrue0

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

ColumnEnum ValueNotes 

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

NameData TypeAllow NullsDefaultNotes 

ParentObjectId

GuidTrueNull

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. 


7/3/17

Added labor tables:

  • Punches
  • PunchAdjustments
  • Tips
  • TipAdjustments