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 

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