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:
|
| 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 |
| 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:
|
| 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 идентификатор времени записи |