View Source

Tracking accessibility of cash stations, cash servers or report servers from the current cash server.

RECORDID	A record unique identifier
SERVERID	An identifier of the object, whose activity is checked. Depending on ObjRefNo, it refers to: If ObjRefNo = 94, it is a cash server identifier, the link leads to CASHGROUPS.Sifr If ObjRefNo = 71, it is a cash station identifier, the link leads to CASHES.Sifr If ObjRefNo = 152, it is a report server identifier, the link leads to REPORTINGSERVERS.Sifr
OBJREFNO	A link to the table in REFTABLES.Sifr. Possible values: 94 - CASHGROUPS, 71 - CASHES, 152 - REPORTINGSERVERS
OBJIDENT	An object identifier (Sifr) in the table, to which ObjRefNo refers
LASTSEEN	Date and time of record updates
ONLINE	The Device is active flag
TRANSACT_GUID	GUIDSTRING identifier of record time

AWARDSPENALTIESDATA

Cumulative table of awards and penalties.

VISIT	Link to visit VISITS.Sifr
MIDSERVER	Link to cash server CashGroups.Sifr
ORDERIDENT	Link to order ORDERS.IdentInVisit
CHECKUNI	Link to receipt PRINTCHECKS.UNI
UNI	Unique identifier inside order
STATE	Status starting with 0: TDrawItemState = (disNone, disOpened, disLocked, disFixed, disPrinted, disPartClosed, disClosed, disDeleted)
DATETIME	Date/time of adding award/penalty
OPERATOR	Employee executing operation EMPLOYEES.Sifr
MANAGER	Manager confirming execution of operation EMPLOYEES.Sifr
TYPEID	Identifier of award/penalty type, link to AWARDSPENALTIESTYPES.Sifr
AMOUNT	Amount (sum)
CALCULATED	The Award sum is calculated automatically flag
ICOMMONSHIFT	Link to common shift GLOBALSHIFTS.Sifr
COMMENT	Comment in main language
CLOCKRECID	Для штрафов за опоздание, ссылка на запись учета рабочего времени, для которой сгенерирована премия CLOCKRECS.UNI
FACTORVALUE	A factor value for an award calculation
APMINLIMIT	Indicator minimal limit of award/penalty
DBSTATUS	If DBStatus = -1, record must be considered deleted. Such records are not uploaded in SQL.
TRANSACT_GUID	GUIDSTRING identifier of record time

CASHINOUT

Contains information about cash deposit/collection.

Is formed at the cash server.

MIDSERVER	Link to cash server CashGroups.Sifr
UNI	Unique identifier inside order
ISDEPOSIT	Deposition or Collection of money
ISTATION	Station at which cash was deposited/collected CASHES.Sifr
ICOMMONSHIFT	Link to common shift GLOBALSHIFTS.Sifr
ISHIFT	Cash shift number SHIFTS.ShiftNum
IDRAWERSHIFT	Cashier Registration Identifier
SIFR	Unique identifier
ORIGINALSUM	Sum of deposited/collected money
NATIONALSUM	Sum in national currency
REALORIGINALSUM	Real sum — cash sum specified when closing cash shift
ICASHIER	Cashier taking part in cash deposit/collection EMPLOYEES.Sifr
IPRINTER	Printer PRINTERASSIGNS.Sifr
KIND	Type of deposit — cash, prepayment, tips, etc. 0 — Cash deposit/collection 1 — Deposit for prepayment (collecting when deleting) 2 — Deposit for tips 3 — Cash collection when closing shift 4 — Virtual collection when closing common shift 5 — Virtual deposit when opening common shift 6 — Card balance replenishment
IDRAWER	Drawer DEVICES.Sifr
EXTFISCID	Internal identification number of fiscal register
PRINTNUMBER	Printer number
IFISCSHIFT	Fiscal shift number
DATETIME	Date and time of cash deposit/collection
INTFID	Identifier of interface executing payment transaction
CARDCODE	Card number
ACCOUNTIDENT	Account identifier AccountIdent,MInterface –> Table PDSCards, field(s) AccountIdent,MInterface;
IREASON	Reason for deposit/collection DEPOSITCOLLECTREASONS.Sifr
OPENREASONNAME	Open name of reason for cash deposit/collection
IAUTHOR	Link to author EMPLOYEES.Sifr
PAYGUIDSTRING	PAYGUIDSTRING of payment for which this deposit was done, link to PAYMENTS.GuidString
DBSTATUS	If DBStatus = -1, record must be considered deleted. Such records are not uploaded in SQL.
TRANSACT_GUID	GUIDSTRING identifier of record time

CASHINOUTDETAILS

Details of deposit/collect cash operations

MIDSERVER	Cash server identifier, link to CashGroups.Sifr
CASHINOUTUNI	Identifier of deposit/collection to which these details relate, link to CASHINOUT.UNI
FACEVALUEID	Identifier of banknote value, link to CURRENCYFACEVALUES.Sifr
BANKNOTECOUNT	Number of banknotes of this type, is filled if FACEVALUEID is specified
ORIGINALSUM	Sum
DBSTATUS	If DBStatus = -1, record must be considered deleted. Such records are not uploaded in SQL.
TRANSACT_GUID	GUIDSTRING identifier of record time

CASHSUMS

This table is located only in work.udb and is not uploaded to the shift file and cumulative database. The table stores information on which amount of cash and in what currency a cash drawer must contain.

STATION	Link to station, CASHES.Sifr
CURRENCY	Link to currency, CURRENCIES.Sifr
DRAWER	Link to cash drawer, DEVICES.Sifr
PRINTER	Link to logical printer, DEVICES.Sifr
SUM	Sum in currency Currency
NATIONALSUM	Sum in national currency

CHECKLISTDATA

GUIDSTRING	GUIDString unique identifier
MIDSERVER	Cash server identifier, link to CashGroups.Sifr
ICOMMONSHIFT	Common shift number, link to GLOBALSHIFTS.ShiftNum
SIFR	Identifier of check list item, link to CHECKLISTITEMS.Sifr
UNI	Record unique identifier
DBSTATUS	If DBStatus = -1, record must be considered deleted. Such records are not uploaded in SQL.
FINISHED	Marker of check list item being executed
NUMBER	How many times this check list was executed during the current shift
FILLINGQULITY	Grade of check list item execution (if the grade must be specified for the item)

CHECKLISTDATADETAILS

Check lists details

GUIDSTRING	GUIDString unique identifier
MIDSERVER	Cash server identifier, link to CashGroups.Sifr
CHECKLISTUNI	Identifier of filled check list to which these details relate, link to CHECKLISTDATA.UNI
STATIONID	Identifier of station at which check list was filled in, link to CASHES.Sifr
SIFR	Identifier of check list item, link to CHECKLISTITEMS.Sifr
UNI	Record unique identifier
DBSTATUS	If DBStatus = -1, record must be considered deleted. Such records are not uploaded in SQL.
EMPID	Identifier of employee executing this record, link to EMPLOYEES.Sifr
VALUE	Grade put when filling in check list for this item (0 — not filled, or 1 for items without grades, or any grade specified for items)
DATETIME	Time/date of filling in this item of check list

CLOCKRECS

Is formed at the cash server for work hours control

MIDSERVER	Link to the cash server CashGroups.Sifr
IDENT	Record identifier in table
EMPID	Identifier in table EMPLOYEES.Sifr
ROLEID	Identifier in table ROLES.Sifr
CARDCODE	Card number
STARTTIME	Time of arrival to work
ENDTIME	Time of departure
SHIFTSTARTTIME	Employee's shift start time
SHIFTDURATION	Employee's shift duration
MAXSHIFTDURATION	Maximum allowed shift duration
ISTARTCOMMONSHIFT	Link to common shift when employee came to work GLOBALSHIFTS.Sifr
IENDCOMMONSHIFT	Link to common shift when employee left work GLOBALSHIFTS.Sifr
ISTARTSTATION	Link to station at which employee's arrival was registered CASHES.Sifr
IENDSTATION	Link to station at which employee's departure was registered CASHES.Sifr
ISTARTMANAGER	Link to manager confirming employee's arrival EMPLOYEES.Sifr
IENDMANAGER	Link to manager confirming employee's departure EMPLOYEES.Sifr
DURATION	Duration = End time - Start time (in hours)
RIGHTDURATION	Net duration = Min(end time, shift end) - Max(start time, shift start) (in hours)\intersection of actual time with nominal time
NOENDINGLABEL	If employee doesn't check in when max.time is reached
AUTOENTRANCE	{unnecessary field}
DELAY	Being late for work in milliseconds
LATENESS	Marker of employee being late
MANUALLYCHANGED	Clock-in/Clock-out was changed
STATUS	Item status
DBSTATUS	If DBStatus = -1, record must be considered deleted. Such records are not uploaded in SQL.
TRANSACT_GUID	GUIDSTRING record time identifier

CURRLINES

Contains information about payments with regard to currencies

VISIT	Link to visit VISITS.Sifr
MIDSERVER	Link to cash server CashGroups.Sifr
ORDERIDENT	Link to order ORDERS.IdentInVisit
CHECKUNI	Link to receipt PRINTCHECKS.UNI
UNI	Unique identifier inside order
SIFR	Unique identifier CURRENCIES.Sifr
BINDEDSUM	Amount of linked sum
ORIGINALSUM	Original sum
BASICSUM	Sum in basic currency
NATIONALSUM	Sum in national currency
DISBALLANCE	Disbalance sum
TAXPAYTYPESIFR	Applied tax priviledge TAXPAYTYPES.Sifr
SOURCEORDERIDENT	ORDERS.IdentInVisit
IHIGHLEVELTYPE	Currency type for payment currency CURRENCYTYPES.Sifr
DBKURS	Exchange rate for currency
GLOBALIDENT	Currency global identifier
DISCLINEUNI	Discount for payment DISHDISCOUNTS.UNI
PAYUNIFOROWNERINFO	Payments.UNI, where ORDERIDENT = 0
OWNERINFO	Additional payment information
FISCREGUNFISCTYPE	Type method for fiscal registers
DBSTATUS	If DBStatus = -1, record must be considered deleted. Such records are not uploaded in SQL.
TRANSACT_GUID	GUIDSTRING record time identifier

DELIVERYDATA

Table with delivery data

VISIT	Link to visit VISITS.Sifr
MIDSERVER	Link to cash server CashGroups.Sifr
ORDERIDENT	Link to order ORDERS.IdentInVisit
RESTAURANTID	Link to restaurant RESTAURANTS.Sifr
DELIVERYSTARTTIME	Delivery start time
TRAVELTIME	Travel time
DELIVERYTIME	Expected delivery time
DELIVERYREADYTIME	Delivery ready time
ZONEID	Delivery zone identifier
ZONENAME	Delivery zone name
DELIVERYSTATE	Delivery status
ORDERPREFIX	Order prefix
FORWARDERSENDTIME	Courier's departure time
FORWARDERRETURNTIME	Courier's return time
REALDELIVERYTIME	Delivery real time
DELIVERYLASTPROCESSTIME	Last processing time
DELIVERYTAKEOUT	Takeout order
DELIVERYMINCOOKTIME	Minimal order cooking time
GUIDSTRING	GUIDString unique identifier
DBSTATUS	If DBStatus = -1, record must be considered deleted. Such records are not uploaded in SQL.
TRANSACT_GUID	GUIDSTRING record time identifier

DEFFEREDSYNC

The table is only located in work.udb and is not uploaded to cumulative database.

This table is not used anymore.

It contains data about delayed sync of references, which must be updated only after shift is closed.

REFID	Reference identifier, REFTABLES.Sifr
COLLECTIONNAME	Reference system name, REFTABLES.Name
DEFFDATAVERSION	Data version number, to which reference must update after common shift is closed
DEFFLASTCHANGE	Date/Time of last change (not synchronized) of this reference
LASTACTUALIZATION	Date/Time of last delayed sync of this reference

DISCPARTS

Contains information on discounts

VISIT	Link to visit VISITS.Sifr
MIDSERVER	Link to cash server CashGroups.Sifr
ORDERIDENT	Link to order ORDERS.IdentInVisit
BINDINGUNI	Link to sales item, table PAYBINDINGS.UNI
UNI	Unique identifier inside order
SIFR	Unique identifier
DISCLINEUNI	Discount for payment DISHDISCOUNTS.UNI
DISCOUNTQNT	Quantity to which discount is assigned
NONZERODISC	Non-zero discount
NONZEROBONUS	Non-zero bonus
SUM	Discount sum
BONUSSUM	Bonus sum
CALCSUM	Calculated discount amount before redistribution
DBSTATUS	If DBStatus = -1, record must be considered deleted. Such records are not uploaded in SQL.
TRANSACT_GUID	GUIDSTRING record time identifier

DISHCONSUMATORS

Contains information on dishes sold by consumator.

VISIT	Link to visit VISITS.Sifr
MIDSERVER	Link to cash server CashGroups.Sifr
ORDERIDENT	Link to order ORDERS.IdentInVisit
DISHUNI	Link to dish, table SESSIONDISHES.UNI
SORTORDER	Classification number when printing
UNI	Unique identifier inside order
SIFR	Unique identifier EMPLOYEES.Sifr
ICREATOR	Creator EMPLOYEES.Sifr
IAUTHOR	Link to author EMPLOYEES.Sifr
ICREATORROLE	Creator's role ROLES.Sifr
IAUTHORROLE	Author's role ROLES.Sifr
CONSUMSUM	Cash amount received by consumator
PRLISTSUM	Part of sum according to price list for one consumator (common value for only consumator)
PAYSUM	Part of sum paid to one consumator (common value for only consumator)
BASICSUM	Part of total sum of consumation (%)
QUANTITY	Part of consumated quantity (common value for only consumator)
CPERCENT	Percent of consumation
GLOBALIDENT	Item global identifier
GUIDSTRING	Unique GUIDString identifier
DBSTATUS	If DBStatus = -1, record must be considered deleted. Such records are not uploaded in SQL.
TRANSACT_GUID	GUIDSTRING record time identifier

DISHDISCOUNTS

Contains information about discounts/markups, added to order

Tables referring to it: CURRLINES, DISCPARTS

VISIT	Visit identifier, link to VISITS.Sifr
MIDSERVER	Cash server identifier, link to CashGroups.Sifr
ORDERIDENT	Order identifier, link to ORDERS.IdentInVisit
OWNERUNI	Parent record identifier. For discounts for dish — link to SESSIONDISHES.UNI, For discounts for seat and order — link to ORDERSESSIONS.UNI
SORTORDER	Sequence number of discount/markup in order, is needed for right order of applying discounts
UNI	Unique identifierinside order
SESSIONUNI	Sessiom identifier, link to OrderSessions.UNI
SIFR	Discount/markup identifier, link to DISCOUNTS.SIFR
STATE	Item status Starting with 0: TDrawItemState = (disNone, disOpened, disLocked, disFixed, disPrinted, disPartClosed, disClosed, disDeleted);
ICREATOR	Identifier of employee adding discount/markup, link to EMPLOYEES.Sifr
IAUTHOR	Identifier of employee confirming adding discount/markup or editing it, link to EMPLOYEES.Sifr
ICREATORROLE	Identifier of creator's role, link to ROLES.Sifr
IAUTHORROLE	Identifier of author's role, link to ROLES.Sifr
ISCHARGE	The "Undistributed markup" flag
EXCLUDEFROMEARNINGS	The "Exclude from income" flag
LOCALIZATION	Localization of discount/markup,possible values: 1 — order discount 2 — seat discount 3 — dish discount 4 — discount for seat in visit 5 — visit discount
CHARGESOURCE	Assignation method of the discounts/markups (automatically, manually, on card and etc.)
VALUECHANGED	The "Discount/markup value was changed manually" flag
PDSTRANSACTION	The "PDS transaction is executed" flag, is set for PDS discounts
COUNTTYPE	Discount/markup type
SRCAMOUNT	Discount/markup value
CALCAMOUNT	Discount/markup sum
MAXAMOUNT	Maximum amount of discount/markup
DELETEDSUM	Sum deleted when deleting receipt or transferred when closing common shift
PAYSUM	Paid amount in basic currency
CLOSEDPAYSUM	Paid amount, may be less than total amount if only part of receipts was paid when calculating order by seats
SEAT	Seta, to which discount was assigned
UNFISCALOPERATION	The "Non-fiscal operation" flag
ITAXDISHTYPE	Tax group identifier, is filled for undistributed markups, link to TAXDISHTYPES.Sifr
CARDCODE	Card number, is filled for PDS discounts
ACCOUNTIDENT	Number of account linked to card, is filled for PDS discounts
GLOBALIDENT	Discount/markup global identifier
BONUSTYPE	Bonus type identifier, is filled for PDS discounts, link to BONUSTYPES.Sifr
MINTERFACE	Logical interface identifier, is filled for PDS discounts, link to DEVICES.Sifr
BONUSAMOUNT	Bonus amount
DEFAULTER	Defaulter type identifier, is filled for PDS discounts, link to DEFAULTERTYPES.Sifr
HOLDER	Holder of card, for which discount was given, is filled for PDS discounts
CREATETIME	Date/Time of discount creation
GUIDSTRING	Unique GUIDString identifier
PERSONID	Identifier of employee applying coupon, thus discount was added, link to EMPLOYEES.Sifr
COUPONCOUNT	Coupon quantity
DBSTATUS	If DBStatus = -1, record must be considered deleted. Such records are not uploaded in SQL.
TRANSACT_GUID	GUIDSTRING record time identifier

DISHMODIFIERS

Contains information on sold modifiers.

Tables referring to it: SESSIONDISHES

VISIT	Link to visit VISITS.Sifr
MIDSERVER	Link to cash server CashGroups.Sifr
ORDERIDENT	Link to order ORDERS.IdentInVisit
DISHUNI	Link to dish, table SESSIONDISHES.UNI
SORTORDER	Dish position in modifiers list. If dish has 2 modifiers, than SortOrder = 0 for the first one and SortOrder = 1 for the second. This field is used to display modifiers in order in which they were added
UNI	Unique identifier inside order
SIFR	Unique modifier MODIFIERS.Sifr
ICREATOR	Creator EMPLOYEES.Sifr
IAUTHOR	Link to author EMPLOYEES.Sifr
ICREATORROLE	Creator's role ROLES.Sifr
IAUTHORROLE	Author's role ROLES.Sifr
OPENNAME	Modifier open name
PRICE	Modifier price when creating order in current price type
SRCPRICE	Original dish amount (before applying voids)
PRLISTSUM	Modifier amount sum
SRCPRLISTSUM	Initial modifier amount sum
PIECES	Number of servings, is used for calculating modifiers quantity
SRCMODICNT	Initial number of dish servings (before applying voids)
MODICNT	Number of modifiers for dish
GLOBALIDENT	Item global modifier
COMBODISHUNI	Link to combo dish, which include dish SESSIONDISHES.UNI
GUIDSTRING	Unique GUIDString identifier
FREEMODICNT	Number of free modifiers
DBSTATUS	If DBStatus = -1, record must be considered deleted. Such records are not uploaded in SQL.
TRANSACT_GUID	GUIDSTRING record time identifier

DISHRESTS

Содержит информацию о порциях блюд

SIFR	Уникальный идентификатор
QUANTITY	Количество
WEIGHT	Вес порционных блюд
DATETIME	ДатаВремя изменения остатка
IAUTHOR	Ссылка на автора EMPLOYEES.Sifr
NOTICED	Замечания
ABSENT	Если флаг включен, то блюдо находится в списке запрещенных к продаже блюд
ISQNTREST	Is quantity rest
DBSTATUS	Если DBStatus = -1, то запись нужно считать удаленной. В SQL такие записи не выгружаются.
TRANSACT_GUID	GUIDSTRING идентификатор времени записи