...
April 28, 2016
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
|
August 4, 2014
Table: Cashouts, Column(s) added
| Name | Data Type | Default | Notes Description |
|---|---|---|---|
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
...