...
| DataMart.Check | |||
|---|---|---|---|
| OrderTypeName | OrderTypeExternalCode | TransactionTypeName | TransactionTypeExternalCode |
| Unknown | -1 | Sale | 0 |
| DineIn | 1 | NoSale | 1 |
| Takeout | 2 | Refund | 2 |
| Delivery | 3 | Paidout | 3 |
| PreOrder | 5 | ||
| OnlineOrder | 6 |
| DataMart.Payment | |||||
|---|---|---|---|---|---|
| TenderType | TenderTypeName | TenderOption | TenderOptionName | CredtiCardType | AuthorizationStatus |
| DataMart.ItemSaleAdjustment | |
|---|---|
| AdjustmentType_ObjectId | AdjustmentTypeName |
| 00000000-0000-0000-0000-000000000000 | Unknown |
| C3F44707-01F3-4EED-8493-168ED5571043 | Discount |
| FD505626-7E57-4B15-B9BF-556F733FDC36 | Tax Exempt |
| FD505626-7E57-4B15-B9BF-556F733FDC36 | TaxExempt |
| AB4671D2-2515-4E69-BE0E-80FE8C912C40 | TimeClock |
| F7952BBD-8A0E-4912-85C9-98DA68213511 | Comp |
| 3629B2CF-F2C7-413A-8CB1-A516C9877847 | Refund |
| A177B9E2-A14A-40DC-BFB7-FC575977586E | Void |
| DsrDataPointType | |
|---|---|
| GrossSales | 0 |
| Adjustments | 1 |
| NetSales | 2 |
| SalesTax | 3 |
| NetPlusTax | 4 |
| NonRevenueGiftCardsIssued | 5 |
| NonRevenueDeposits | 6 |
| NonRevenueDonations | 7 |
| NonRevenueAdjustments | 8 |
| NonRevenueTax | 9 |
| NetPlusTaxPlusNonRevenueSales | 10 |
| GiftCardsCashout | 11 |
| RevenueExpected | 12 |
| Payments | 13 |
| Refunds | 14 |
| RevenueTotal | 15 |
| UnfinishedTransactions | 16 |
| Cash | 17 |
| Tips | 18 |
| CashOwedToHouse | 19 |
| LaborPercentage | 20 |
| LaborDollarsTotal | 21 |
| LaborDollarsRegular | 22 |
| LaborDollarsOvertime | 23 |
| LaborDollarsDoubletime | 24 |
| LaborHoursTotal | 25 |
| LaborHoursRegular | 26 |
| LaborHoursOvertime | 27 |
| LaborHourDoubletime | 28 |
| Paidouts | 29 |
| TaxExempt | 30 |
| TaxOwed | 31 |
| TipShare | 32 |
| CashExpectedDeposit | 33 |
| CreditExpectedDeposit | 34 |
| AlternateExpectedDeposit | 35 |
| GiftCardExpectedDeposit | 36 |
| DepositExpectedDeposit | 37 |
| Gratuities | 38 |
| GratuityTaxOwed | 39 |
| GuestCount | 40 |
| GuestAverageNetSale | 41 |
| ChargedTips | 42 |
| UnclaimedDepositPayments | 43 |
| CashOwedLessTipshare | 44 |
| GrossSalesForTipShareCalc | 45 |
| NetSalesForTipShareCalc | 46 |
| CashDeposits | 47 |
| CashDrops | 48 |
| StartingBanks | 49 |
| OverShort | 50 |
| TipShareContribution | 51 |
| TotalDeposits | 52 |
| CheckCount | 53 |
| CoverCount | 54 |
| NetSalesPerCheck | 55 |
| NetSalesPerCover | 56 |
| NetSalesPerGuest | 57 |
| NoSales | 58 |