Type Definitions



DataMart.Cashouts

CashoutType

DataMart.Cashouts

CashoutType

User

0

EntireHouse

1

Drawer

2



DataMart.Paidouts

PaidoutType

DataMart.Paidouts

PaidoutType

Paidout

0

Paidin

1



DataMart.Check







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



PunchType



ClockIn

0

ClockOut

1



BreakType



BreakType



ShiftEnd

0

PaidBreak

1

UnPaidBreak

2



PaymentType



PaymentType



Cash

0

CreditCard

1

DebitCard

2

GiftCard

3

DepositApplied

4

Alternate

5

CompCard

6

Unknown

255



TransactionType



TransactionType



Purchase

0

Authorization

1

Void

2

Refund

3

PreAuthorization

4

PaymentAuthorization

5



CreditCardTypes

CreditCardTypes

Amex

Visa

MasterCard

Discover

Other



TenderType



TenderType



TenderTypeName

TenderType

Cash

0

Credit Card

1

Debit Card

2

Gift Card

3

Deposit

4

Alternate

5

Unknown

255



TransactionType



TransactionType



TransactionTypeName

TransactionType

Purchase

0

Authorization

1

Void

2

Refund

3

PreAuthorization

4

PaymentAuthorization

5



MenuItemTypes



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



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



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



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