Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

DataMart.Check


OrderTypeNameOrderTypeExternalCodeTransactionTypeName

TransactionTypeExternalCode
Unknown-1Sale0
DineIn1NoSale1
Takeout2Refund2
Delivery3Paidout3
PreOrder5

OnlineOrder6DataMart.Payment


AuthorizationStatus
TenderTypeTenderTypeNameTenderOptionTenderOptionNameCredtiCardTypePunchType
ClockIn0
ClockOut1


BreakType
ShiftEnd0
PaidBreak1
UnPaidBreak2


PaymentType

Cash

0
CreditCard1
DebitCard2
GiftCard3
DepositApplied4
Alternate5
CompCard6
Unknown255


TransactionType
Purchase0
Authorization1
Void2
Refund3
PreAuthorization4
PaymentAuthorization5


CreditCardTypes
Amex
Visa
MasterCard
Discover
Other


TenderType
TenderTypeNameTenderType
Cash0
Credit Card1
Debit Card2
Gift Card3
Deposit4
Alternate5
Unknown255


TransactionType
TransactionTypeNameTransactionType
Purchase0
Authorization1
Void2
Refund3
PreAuthorization4
PaymentAuthorization5


MenuItemTypes

Sales

0
GiftCardPresetValueSale1
GiftCardOpenValueSale2
GiftCardReload3
GiftCardCashout4
Donation5
Deposit6
MiscItemSale7
DepositRefund8
TicketSale9
Combo10
OpenValueDonation11
PLUBarcodeEntry12


PrepTypes
<Not Set>0
Food Item1
Combo Item2
Piece Detail3
Mixed Item4
Side Item5
Condiment6
Pizza Section7


DataMart.ItemSaleAdjustment
AdjustmentType_ObjectIdAdjustmentTypeName
00000000-0000-0000-0000-000000000000Unknown
C3F44707-01F3-4EED-8493-168ED5571043Discount
FD505626-7E57-4B15-B9BF-556F733FDC36Tax Exempt
FD505626-7E57-4B15-B9BF-556F733FDC36TaxExempt
AB4671D2-2515-4E69-BE0E-80FE8C912C40TimeClock
F7952BBD-8A0E-4912-85C9-98DA68213511Comp
3629B2CF-F2C7-413A-8CB1-A516C9877847Refund
A177B9E2-A14A-40DC-BFB7-FC575977586EVoid

...