Page Comparison

...

Table: ItemSale, Column added

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.

Table: Cashouts, Column(s) added

Name	Data TypeDefault	Description	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)

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.

Added labor tables:

Versions Compared