| Name | Description | Type | Additional information |
|---|---|---|---|
| SaleItemID |
Primary Key |
integer |
None. |
| SaleHeaderID |
Link to StoreSaleHeader table |
integer |
None. |
| PLU | integer |
None. |
|
| PluG_UId | Collection of byte |
None. |
|
| PluGuid | globally unique identifier |
None. |
|
| AccountID | Collection of byte |
None. |
|
| AccountIDGuid | globally unique identifier |
None. |
|
| NormalPrice | integer |
None. |
|
| OriginalSellingPrice | integer |
None. |
|
| DiscountPrice | integer |
None. |
|
| Unit | integer |
None. |
|
| Quantity | integer |
None. |
|
| TotalCents | integer |
None. |
|
| FixedPrice | integer |
None. |
|
| TranType | integer |
None. |
|
| Processed | integer |
None. |
|
| DiscountType | integer |
None. |
|
| Cost | integer |
None. |
|
| CostDecimals | integer |
None. |
|
| Markdown | integer |
None. |
|
| ManualQuantity | integer |
None. |
|
| ManualPrice | integer |
None. |
|
| ManualMode | integer |
None. |
|
| Active | integer |
None. |
|
| Barcode | string |
String length: inclusive between 0 and 128 |
|
| Offline | integer |
None. |
|
| KeyedSale | integer |
None. |
|
| DiscountedID | integer |
None. |
|
| FuelID | integer |
None. |
|
| SerialNumber | string |
String length: inclusive between 0 and 64 |
|
| BestOrExpire | date |
None. |
|
| BestOrExpireType | integer |
None. |
|
| RefundG_UID | Collection of byte |
None. |
|
| RefundGuid | globally unique identifier |
None. |
|
| ProviderName | string |
String length: inclusive between 0 and 16 |
|
| Campaign | string |
String length: inclusive between 0 and 64 |
|
| CampaignType | integer |
None. |
|
| ModifiedID | integer |
None. |
|
| OmittedIngredient | integer |
None. |
|
| TaxPercent | decimal number |
None. |
|
| TaxAmount | decimal number |
None. |
|
| RefundablePrice | decimal number |
None. |
|
| ShowDiscounts | boolean |
None. |
|
| OrderPrinted | boolean |
None. |
|
| Note | string |
None. |
|
| ModifierName | string |
None. |
|
| ModifierSetName | string |
None. |
|
| TotalValueWasScanned |
For roaming sales we keep this so we don't show weight calculation |
boolean |
None. |
| Sold |
For split bills, this item is paid for |
boolean |
None. |
| CampaignPrice |
The price came from a campaign type CampaignOrSale |
boolean |
None. |
| ScannedValue |
Embedded price (total value) |
integer |
None. |
| CampaignName |
If a discount, the campaign name |
string |
None. |
| ComboDiscount |
Total amount of a combo discount |
integer |
None. |