Type Definitions
DataMart.Cashouts | CashoutType |
---|---|
User | 0 |
EntireHouse | 1 |
Drawer | 2 |
DataMart.Paidouts | PaidoutType |
---|---|
Paidout | 0 |
Paidin | 1 |
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 |
PunchType | |
---|---|
ClockIn | 0 |
ClockOut | 1 |
BreakType | |
---|---|
ShiftEnd | 0 |
PaidBreak | 1 |
UnPaidBreak | 2 |
PaymentType | |
---|---|
Cash | 0 |
CreditCard | 1 |
DebitCard | 2 |
GiftCard | 3 |
DepositApplied | 4 |
Alternate | 5 |
CompCard | 6 |
Unknown | 255 |
TransactionType | |
---|---|
Purchase | 0 |
Authorization | 1 |
Void | 2 |
Refund | 3 |
PreAuthorization | 4 |
PaymentAuthorization | 5 |
CreditCardTypes |
---|
Amex |
Visa |
MasterCard |
Discover |
Other |
TenderType | |
---|---|
TenderTypeName | TenderType |
Cash | 0 |
Credit Card | 1 |
Debit Card | 2 |
Gift Card | 3 |
Deposit | 4 |
Alternate | 5 |
Unknown | 255 |
TransactionType | |
---|---|
TransactionTypeName | TransactionType |
Purchase | 0 |
Authorization | 1 |
Void | 2 |
Refund | 3 |
PreAuthorization | 4 |
PaymentAuthorization | 5 |
MenuItemTypes | |
---|---|
Sales | 0 |
GiftCardPresetValueSale | 1 |
GiftCardOpenValueSale | 2 |
GiftCardReload | 3 |
GiftCardCashout | 4 |
Donation | 5 |
Deposit | 6 |
MiscItemSale | 7 |
DepositRefund | 8 |
TicketSale | 9 |
Combo | 10 |
OpenValueDonation | 11 |
PLUBarcodeEntry | 12 |
PrepTypes | |
---|---|
<Not Set> | 0 |
Food Item | 1 |
Combo Item | 2 |
Piece Detail | 3 |
Mixed Item | 4 |
Side Item | 5 |
Condiment | 6 |
Pizza Section | 7 |
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 |