SQL Cumulative Data Tables

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	For tardiness penalties, link to work time account record, for which bonus is generated 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

Contains information on dish portions

SIFR	Unique identifier
QUANTITY	Quantity
WEIGHT	Weight of per portion dishes
DATETIME	Date/Time of dish rests changes
IAUTHOR	Link to author EMPLOYEES.Sifr
NOTICED	Comments
ABSENT	If flag is enabled, dish is forbidden for sale
ISQNTREST	Is quantity rest
DBSTATUS	If DBStatus = -1, record must be considered deleted. Such records are not uploaded in SQL.
TRANSACT_GUID	GUIDSTRING record time identifier

DISHVOIDS

Information on voids from receipts

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 ORDERVOIDS.SIFR
ICREATOR	Creator EMPLOYEES.Sifr
IAUTHOR	Link to author EMPLOYEES.Sifr
ICREATORROLE	Creator's role ROLES.Sifr
IAUTHORROLE	Author's role ROLES.Sifr
SESSIONUNI	Link to block, field of table OrderSessions.UNI
VOIDSESSIONUNI	Link to block with void, field of table OrderSessions.UNI
COMBOVOIDUNI	Identifier of combo deletion record. When combo is deleted, voids both for combo and its components are created. Is filled for combo component, refers to deleting parent combo dish. Link to DISHVOIDS.UNI
OPENNAME	Opened name of the order void
PIECES	Number of deleted portions
QUANTITY	Quantity of deleted dish
PRLISTSUM	Price * Quantity
DATETIME	Date and time of dish deletion
GLOBALIDENT	Item global identifier
PRINTED	If void is printed or not
SAVEDATETIME	Date and time of saving order
STOREDINFM	The "Void information is recorded in fiscal module" flag
AFTERBILLUNDO	Bill was cancelled before deletion
GUIDSTRING	Unique GUIDString identifier
DBSTATUS	If DBStatus = -1, record must be considered deleted. Such records are not uploaded in SQL
ISUNPRINTEDDISH	The "Deleted dish was not printed". 1 — was not printed, other values — was printed
TRANSACT_GUID	GUIDSTRING record time identifier

DRAWERLOG

Contains information on operations with drawers

MIDSERVER	Cash server identifier, link to CashGroups.Sifr
UNI	Record unique identifier
ICOMMONSHIFT	Common shift number, link to GLOBALSHIFTS.ShiftNum
DRAWERID	Logical drawer identifier, link to DEVICES.Sifr
WAITERID	Identifier of employee performing operation, link to EMPLOYEES.Sifr
OPENTIME	Time of cash drawer opening
CLOSETIME	Time of cash drawer closing
OPER	Operation identifier, link to OPERATIONS.Sifr
KIND	Reason for opening drawer, possible values: 0 — Drawer opened manually 1 — Drawer opened by program
VISIT	Visit identifier, link to VISITS.Sifr
ORDERIDENT	Order identifier, link to ORDERS.IdentInVisit
TRANSACT_GUID	GUIDSTRING record time identifier

EXTERNALIDS

Order extended properties

VISIT	Visit identifier, link to VISITS.Sifr
MIDSERVER	Cash server identifier, link to CashGroups.Sifr
ORDER	Order identifier, link to ORDERS.IdentInVisit
EXTSOURCE	Name of extended properties — GUIDString for properties added to extended properties reference or one specified when adding name for the rest
EXTID	Extended propertise value
DBSTATUS	If DBStatus = -1, record must be considered deleted. Such records are not uploaded in SQL
TRANSACT_GUID	GUIDSTRING record time identifier

EXTRATABLES

Information on additional tables for order

VISIT	Visit identifier, link to VISITS.Sifr
MIDSERVER	Cash server identifier, link to CashGroups.Sifr
ORDER	Order identifier, link to ORDERS.IdentInVisit
TABLE	Table identifier, link to TABLES.Sifr
DBSTATUS	If DBStatus = -1, record must be considered deleted. Such records are not uploaded in SQL
TRANSACT_GUID	GUIDSTRING record time identifier

FINANCEDOCUMENTS

Financial documents, are created either at cash station based on printed documents (then RefNo = 72) or in financial module based on financial documents layouts (RefNo = 205)

MIDSERVER	Cash server identifier, link to CashGroups.Sifr
UNI	Record unique identifier
GUIDSTRING	Unique GUIDString identifier
STATUS	Satus, possible values: 0 — draft 1 — posted 2 — deleted
DOCTYPE	If RefNo = 72, then document type identifier is specified in field, link to DOCUMENTS.Sifr If RefNo = 205, then field contains identifier of financial documents layout, based on which document is created, link to CASHFLOWOPERATIONTYPES.Sifr
BASEDOCLINK	GUIDString of parent document
CREATEDATE	Date and time of document creation
DOCUMENTDATE	Document date
COMMITDATE	Date and time of document posting
AUTHORID	Author's identifier, link to EMPLOYEES.Sifr
DBSTATUS	If DBStatus = -1, record must be considered deleted. Such records are not uploaded in SQL
REFNO	Document type identifier, possible values: 72 — reference of documents for printing 205 — reference of financial documents layouts
RESTAURANT	Restaurant identifier, link to RESTAURANTS.Sifr
ENTITY	Legal entity identifier, link to ENTITIES.Sifr

FINANCETRANSACTDETAILS

Details of financial documents transactions

MIDSERVER	Cash server identifier, link to CASHGROUPS.SIFR
TRANSACTIONUNI	Identifier of transaction, linked with these details, link to FINANCETRANSACTIONS.UNI
UNI	Record identifier
TRANSACTIONGUID	Unique GUIDString identifier
KIND	Details type, possible values: 1 — debit -1 — credit
ACCOUNTID	Account identifier, link to FINANCEACCOUNTS.SIFR
REFNO	Identifier of reference from which object is chosen (in field ObjID)
OBJID	Identifier of object linked with document posting (link to reference, specified in RefNo)
ENTITYID	Legal entity identifier, link to ENTITIES.SIFR
DBSTATUS	If DBStatus = -1, record must be considered deleted. Such records are not uploaded in SQL

FINANCETRANSACTIONEXT

Table contains additional fields for financial documents, which are recorded in database according to key-value principle

TRANSACTIONGUID	GUID- of financial document or GUID- of financial item, FINANCEDOCUMENTS.GuidString or FINANCETRANSACTIONS.GuidString
KEYNAME	Field name, line [200]
EXTVALUE	Field value, line [200]

FINANCETRANSACTIONS

MIDSERVER	INT	Cash server identifier, link to cash server CashGroups.Sifr
UNI	INT	Record identifier
ICOMMONSHIFT	INT	Common shift number, link to GlobalShifts
GUIDSTRING	String(38)	Unique GUIDString identifier
OPERATIONDATE	DateTime	Operation date
TRANSACTIONTYPE	INT	Identifier of financial document layout, link to CashFlowOperationTypeDetails
AUTHORID	INT	Identifier of transaction author, link to Employees
INDOCLINK	String(38)	GUID of document linked with this transaction
CASHFLOWDETAIL	INT	Identifier of cash flow item, link to FinanceCashFlowDetails
AMOUNT	MONEY	Transaction amount
COMMENT	String(255)	Comment
DOCUNI	INT	Identifierof document type, linked with transaction, link to Documents
DBSTATUS	INT	If DBStatus = -1, record must be considered deleted. Such records are not uploaded in SQL
SEQNUM	INT	Sequence number, is needed for right sequence of transactions
STATUS	INT	0 — draft 1 — posted

FISCALREGISTERS

Таблица содержит данные об использованных в течении смены фискальных регистраторах и в накопительную базу не выгружается

DEVICE	Logical printer identifier, DEVICES.Sifr
STATION	Identifier of cash station, to which fiscal register is connected, CASHES.Sifr
EXTFISCID	ID of fiscal register
SHIFTNUM	Cash shift number
PRINTNUM	Number of printed documents
FIRSTDOC	Date and time of first document printing
CLOSEDAT	Date and time of Z-report last printing
NEEDCLOSE	The "Z-report needs to be printed" flag — if when closing common shift, fiscal register was unavailable and Z-report was not printed
UNUSABLE	Flag — if fiscal register was not used since closing common shift
SALEDSUM	Sum of sales at fiscal register in this fiscal shift
INCLOSECH_VISIT	Is filled when receipt is printed. Contains link to visit, whose receipt is sprinted at this moment, VISITS.Sifr
INCLOSECH_ORDERIDENT	Is filled when receipt is printed. Contains link to order, whose receipt is sprinted at this moment, ORDERS.IdentInVisit
INCLOSECH_UNI	Is filled when receipt is printed. Contains link to UNI-receipt, PRINTCHECKS.UNI
INCLOSECH_MIDSERVER	Is filled when receipt is printed. Contains link to cash server, whose receipt is sprinted at this moment, CASHGROUPS.Sifr
INCLOSECH_CLOSESTATION	Is filled when receipt is printed. Contains link to cash station, at whcih receipt printing was launched, CASHES.Sifr
INCLOSECH_MAKETID	Is filled when receipt is printed. Contains link to layout used for receipt printing, MAKETSCHEMEDETAILS.Sifr

GENERATORS (work.udb)

System table, contains information on generators

SIFR	Unique identifier
NAME	Item name in main language
VALUE	Price constant value
RECSTAMP	GUIDSTRING record time identifier

GLOBALSHIFTS

Формируется на кассовом сервере информация о сменах работы ресторана

MIDSERVER	Link to cash server CashGroups.Sifr
SHIFTNUM	Shift internal number
GUIDSTRING	Unique GUIDString identifier
CREATETIME	Shift start time
STARTTIME	Time of first order creation by shift employee
CLOSETIME	Shift closing time
IMANAGER	Shift manager EMPLOYEES.Sifr
SHIFTDATE	Logical data (can be added)
CLOSED	If shift is closed or not (for cash reports)
SENDED	Shows that cash server is aware of table being sent to manager station
IBASICCURRENCY	Link to basic currency CURRENCIES.Sifr
INATIONALCURRENCY	Link to national currency CURRENCIES.Sifr
IRESTAURANT	Link to restaurant RESTAURANTS.Sifr
ORIGINALSHIFTDATE	Shift lasting at closing moment, if logical date was changed
SHIFTLOADDATETIME	Date and time the shift was loaded at
STATUS	Item status
FLAGS	Shift system flags
TRANSACT_GUID	GUIDSTRING record time identifier

GUESTREPLIES

Cumulative table, is formed at cash server, contains information on guests feedback.

MIDSERVER	Link to cash server CashGroups.Sifr
SIFR	Unique identifier
DATETIME	Time
OBJREFNO	Link to table in REFTABLES.Sifr
OBJIDENT	Object identifier (Sifr) in table, to which ObjRefNo refers
GUESTCODE	Link to guest's code from external system
RATING	Rating
COMMENT	Feedback
TRANSACT_GUID	GUIDSTRING record time identifier

HARDWAREINFO

Таблица содержит информацию по оборудованию на кассовом сервере

SERVERID	Cash server identifier, link to CASHGROUPS.Sifr
RECORDID	Record unique number
OBJREFNO	Link to table in REFTABLES.Sifr
OBJIDENT	Object identifier (Sifr) in table to which ObjRefNo refers
CPUCOUNT	Number of CPU
RAMCOUNT	RAM value (in Mb)
OPSYSTEM	Windows version number
CPUSLIST	Line with detailed information on CPU, looks like: 0.6.140.1;0.6.140.1;0.6.140.1;0.6.140.1; where 0 — CPU type 6 — family 140 — model 1 — stepping
HDDSLIST	Line with detailed information about connected HDDs, looks like C:\/228373/4374;D:\/953866/460895, where letter is disk's letter, figure is disk's volume in Mb
TRANSACT_GUID	GUIDSTRING record time identifier

INFO

Additional information on current state of cash server

DELIVERYRESTSTATE	Delivery status in restaurant, possible values: 0 — delivery orders are not currently accepted 1 — restaurant accepts delivery orders
DELIVERYRESTTIME	Planned time for restarting delivery orders acceptance (if DELIVERYRESTSTATE = 0)
HARDSHUTDOWN	The "Computer was restarted without stopping cash server" flag
HTTPNOTFURLS	List of Http Order Notify driver's subscriptions addresses
ENTITYVERSION	Last version of downloaded data for entity.udb

INTFTRANSACTIONS

Information on executed PDS/farcards transactions

VISIT	Visit identifier, link to VISITS.SIFR
MIDSERVER	Cash server identifier, link to CASHGROUPS.SIFR
CHECKUNI	Identifier of record with receipt, to which this transaction relates, link to PRINTCHECKS.UNI
MINTERFACE	Logical interface identifier, link to DEVICES.SIFR
SEQNUM	Transaction sequence number, ensures unicity
CARDCODE	Card number
KIND	Transaction types, possible values: 0 — from upper server, payment/return 1 — from cash station, payment/return 2 — discount 3 — from computer, payment/return 4 — payment cansellation from cash station (receipt deletion) 5 — discount cancellation from cash station (receipt deletion) 7 — bonus 8 — spent cash 9 — card number change 10 — discount level change
EXTSUBACCOUNT	Subaccount number, by default for spent amounts and accounts = 0, for write-offs and bonuses = 1
ORDER	Link to order ORDERS.IdentInVisit
LINEGUID	GUIDString of record with discount for which transaction was added, link to DISHDISCOUNTS.GUIDSTRING
LINEUNI	Identifier of record with discounts, for which transaction is added, link to DISHDISCOUNTS.UNI
LINETAG	Action causing transaction, possible values (line): PAYMENT DISCOUNT
EXTPLACEID	External identifier of transaction execution place, is sent by external system
EXTTRANSACTIONID	Transaction external identifier, is sent by external system
EXTINFO	Additional information for transactions, comment
VALUE	Transaction sum
EXTDATETIME	nnn
ISTATION	Station identifier, link to CASHES.SIFR
TRANSACT_GUID	GUIDSTRING record time identifier

INVOICES

Contains invoice information

MIDSERVER	Cash server identifier, CASHGROUPS.SIFR
UNI	Record identifier inside order
VISIT	Visit identifier, link to VISITS.SIFR
ORDERIDENT	Order identifier, link to ORDERS.IdentInVisit
CHECKUNI	Identifier of record with receipt, link to PRINTCHECKS.UNI
TABLEVER	Record number in entity.udb (for entity.udb synchronization between cash servers)
IAUTHOR	Author's identifier, link to EMPLOYEES.SIFR
ENTITYID	Identifier of counterparty from entity.udb
INVOICENUM	Invoice number
REGNO	Registration number
NAME	Counterparty name
ADDRESS	Legal address
EXTRAINFO	Extra details of organization
COMMENT	Comment in main language
DATETIME	Date and time of invoice creation
PRINTED	The "Invoice is printed" flag
MAKETDATA	Printing slip of invoice
GUIDSTRING	Unique GUIDString identifier
COUNTRY	Country
REGION	Region
CITY	City
STREET	Street
HOUSE	House
BUILDING	Building
ENTRY	Entry
INTERCOM	Entry phone number
FLOOR	Floor number
APARTMENTS	Flat
ADDRDOPINFO	Address additional info
METROSTATION	Metro station
ZIPCODE	ZIP code
DBSTATUS	If DBStatus = -1, record must be considered deleted. Such records are not uploaded in SQL
TRANSACT_GUID	GUIDSTRING record time identifier

KDSDATA

Contains information about KDS — kitchen display system.

Tables referring to it: SESSIONDISHES

KDSSIFR	Record identifier
MIDSERVER	Cash server identifier, link to CASHGROUPS.SIFR
VISITID	Visit identifier, link to VISITS.SIFR
KDSSTATE	Dish KDS-status, possible values: 1 — Sent 2 — Cooking started 3 — Ready 4 — Taken 5 — Order is being collected 6 — Order is collected 7 — To place order to parking 8 — To take order away from parking 9 — Delete
KDSFLAGS	Additional flags for KDS, possible values: 1 — can be deleted
SENTAT	Date and time when order was sent for execution
INITAT	Cooking start date and time
DONEAT	Date and time when kitchen prepared order
TAKEAT	Date and time when kitchen received order
COLLECTAT	Date and time of order collecting start
COLLECTEDAT	Date and time of order collecting end
STARTPARKAT	Date and time of placing order to parking
ENDPARKAT	Date and time of taking order away from parking
COOKTM	Cook time in minutes
MENUCOOKTIME	Nominal time in minutes
MENUCATEGORY	Menu category identifier, link to CLASSIFICATORGROUPS.SIFR
SERVPRINTNUM	Service printing number
SENTMANAGERID	Identifier of employee, who sent order to KDS (saved order), link to EMPLOYEES.SIFR
INITMANAGERID	Identifier of employee, who started cooking, link to EMPLOYEES.SIFR
DONEMANAGERID	Identifier of employee, who marked order as ready, link to EMPLOYEES.SIFR
TAKEMANAGERID	Identifier of employee, who marked order as taken away, link to EMPLOYEES.SIFR
COLLECTMANAGERID	Identifier of employee, who started collecting order, link to EMPLOYEES.SIFR
COLLECTEDMANAGERID	Identifier of employee, who finished collecting order, link to EMPLOYEES.SIFR
STARTPARKMANAGERID	Identifier of employee, who sent order to parking, link to EMPLOYEES.SIFR
ENDPARKMANAGERID	Identifier of employee, who took order away from parking, link to EMPLOYEES.SIFR
KDSSTATIONID	Station identifier, link to CASHES.SIFR
DBSTATUS	If DBStatus = -1, record must be considered deleted. Such records are not uploaded in SQL
TRANSACT_GUID	GUIDSTRING record time ifentifier

MCRPAYMENTS

MCR payments on order (personalized payments)

VISIT	Visit identifier, link to VISITS.SIFR
MIDSERVER	Cash server identifier, link to CASHGROUPS.SIFT
ORDERIDENT	Order identifier, link to ORDERS.IdentInVisit
UNI	Identifier of record inside order
SIFR	Currency identifier, link to CURRENCIES.SIFR
INPUTTYPE	Way of adding payment, possible values: 0 — Manually 1 — Magnetic card 2 — Dallas 3 — Paying order 4 — Card proxy 5 — Barcode 6 — XML
PAYLINETYPE	Currency type, possible values: 0 — Cash 1 — Bank cards 2 — Hotel cards 3 — Payment cards 4 — Exclude from revenue, for false change 5 — Non-cash payment 6 — Coupon for dish 7 — Repurchased dish
OWNER	Owner, is filled for payment cards
CARDNUM	Card number
ACCOUNTIDENT	Account number, linked with card, is filled for payment cards
EXPDATE	Expiration date
AUTHCODE	Authorization code for bank card
TRACK2	Not used
MAXAMOUNT	Maximum sum available for payment
ADDBYINTERFACE	Logical interface identifier, link to DEVICES.SIFR
DEFAULTER	Defaulter type, link to DEFAULTERTYPES.SIFR
EXTTRANSACTIONINFO	Additional information on payment
DBSTATUS	If DBStatus = -1, record must be considered deleted. Such records are not uploaded in SQL

MESSAGEBUTTONS

Information on available buttons for messages to waiter

MESSAGEIDENT	Message identifier, link to MESSAGES.SIFR
UNI	Record identifier
IMAGEINDEX	Identifier of image for button, link to IMAGENODES.SIFR
CAPTION	Button text
BROWSEURL	URL to follow when clicking the button
HTTPCALLURL	URL, to which POST request must be sent when clicking the button
GUIDSTRING	Unique GUIDString identifier
DBSTATUS	If DBStatus = -1, record must be considered deleted. Such records are not uploaded in SQL

MESSAGES

Messages to waiter

IDENT	Identifier of record with message
IEMPLOYEE	Identifier of employee to whom message must be shown, link to EMPLOYEES.SIFR
IAUTHOR	Identifier of employee who added message, link to EMPLOYEES.SIFR
EXPIREDATE	Date and time of message expiration, after which message will be deleted
TEXT	Message text
MESSAGETYPE	Message type, possible values: 0 — no type 1 — to call waiter from table 2 — Monitor 3 — Dish ready message from KDS 4 — Dish ready message from service printing 5 — Error message 6 — Call from pager 7 — Script from cash station 8 — Script from server 9 — XML-interface 10 — Message from license system 11 — Message from rater 12 — Message on system time change 13 — Message from manager station 14 — Message from second screen 15 — Message on soon common shift closing 16 — Request for locking order
PARAMETER	Message parameter
FROMSTATION	Identifier of station from which message was sent, link to CASHES.SIFR
STATION	Identifier of station at which only message must be displayed, link to CASHES.SIFR
ADDEDAT	Date and time of message coming
REPEATCOUNT	Repeat number
EXTID	Message external identifier
VISIT	Visit identifier, link to VISITS.SIFR
ORDERIDENT	Order identifier, link to ORDERS.IdentInVisit
ONDELETEURL	URL for which GET-request must be called when deleting message
DBSTATUS	If DBStatus = -1, record must be considered deleted. Such records are not uploaded in SQL
TRANSACT_GUID	GUIDSTRING record time identifier

NEEDCLOSECHECK

Table contains information on receipts whose printing was started but not finished.

VISIT	Visit identifier, link to VISITS.SIFR
MIDSERVER	Cash server identifier, link to CASHGROUPS.SIFR
UNI	Identifier of record with receipt
ORDERIDENT	Link to order ORDERS.IdentInVisit
DEVICE	Logical printer identifier, link to DEVICES.SIFR
MAKETID	Document view identifier, link to MAKETSCHEMEDETAILS.SIFR
CLOSESTATION	Identifier of cash station, from which receipt printing was started, link to CASHES.SIFR

OPERATIONLOG

Executed operation log

MIDSERVER	Cash server identifier, link to CASHGROUPS.SIFR
SIFR	Record identifier
VISIT	Visit identifier, link to VISITS.Sifr
ORDERIDENT	Order identifier, link to ORDERS.IdentInVisit
ICOMMONSHIFT	Common shift number, link to GLOBALSHIFTS.SHIFTNUM
DATETIME	Date and time of operation execution
STATION	Station identifier, link to CASHES.SIFR
OPERATION	Operation identifier, link to OPERATIONS.SIFR
PARAMETER	Parameter for operation execution
OPERATOR	Identifier of employee who executed operation, link to EMPLOYEES.SIFR
OPERATORROLE	Identifier of role of employee who executed operation, link to EMPLOYEEGROUPS.SIFR
MANAGER	Identifier of employee who confirmed operation execution, link to EMPLOYEES.SIFR
MANAGERROLE	Identifier of role of employee who confirmed operation execution, link to EMPLOYEEGROUPS.SIFR
MENUITEM	Dish identifier, if operation is related to dish, link to MENUITEMS.SIFR
QNT	Dish quantity, if operation is related to dish
MAKETSCHEMEDETAIL	Document view identifier, if operation is related to printing, link to MAKETSCHEMEDETAILS.SIFR
SESSIONUNI	Idenifier of record with session containing object of operation, link to ORDERSESSIONS.SIFR
ORDERSUMBEFORE	Order sum before operation execution
ORDERSUMAFTER	Order sum after operation execution
REASONID	Identifier of void reason related to operation being executed, link to ORDERVOIDS.SIFR
TRANSACT_GUID	GUIDSTRING record time identifier

ORDERS

Cumulative table, is formed at cash server.

Tables referring to it:TARIFFDATA, TAXPARTS, CURRLINES, DISCPARTS, DISHDISCOUNTS, DISHCONSUMATORS, DISHMODIFIERS, DISHVOIDS, SESSIONDISHES, INVOICES, OPERATIONLOG, ORDERSESSIONS, PAYBINDINGS, PAYMENTS, PAYMENTSEXTRA, PRINTCHECKS, SELECTORDETAILS, SERVICECHECKS, EXTRATABLES, EXTERNALIDS, ORDERWAITERS

VISIT	Visit identifier, link to VISITS.SIFR
MIDSERVER	Cash server identifier, link to CashGroups.Sifr
IDENTINVISIT	Identifier of record with order
ICREATOR	Creator's identifier, link to EMPLOYEES.Sifr
IAUTHOR	Author's identifier, link to EMPLOYEES.Sifr
ICREATORROLE	Identifier of creator's role, link to ROLES.Sifr
IAUTHORROLE	Identifier of author's role, link to ROLES.Sifr
ILASTUSER	Identifier of employee, last saving order, link to EMPLOYEES.Sifr
FLAGS	Order flags, bit mask. If number is odd, order is locked
GUESTSCOUNT	Guests number
LASTSERVICE	Date and time of order last serving
NUMONTABLE	Is used when more than one company is placed at one table
OPENTIME	Date and time of order creation
TABLEID	Table identifier, link to TABLES.Sifr
TABLENAME	Table name
ORDERNAME	Order name (table number + NUMONTABLE)
PROMOCODE	Promo-code
COT	Order type identifier, link to CHANGEABLEORDERTYPES.Sifr
UOT	Order category identifier, link to UNCHANGEABLEORDERTYPES.Sifr
DEFAULTER	Defaulter type identifier, link to DEFAULTERTYPES.Sifr
IBASICCURRENCY	Identifier of currency being basic when order was closed, link to CURRENCIES.Sifr
INATIONALCURRENCY	Identifier of currency being national when order was closed, link to CURRENCIES.Sifr
ICOMMONSHIFT	Common shift number, link to GLOBALSHIFTS.SHIFTNUM
MAINWAITER	Identifier of order's main waiter, link to EMPLOYEES.Sifr
BRIGADE	Identifier of brigade to whicj main waiter belongs, link to BRIGADES.Sifr
STARTSERVICE	Date and time of starting adding first dish to order
ENDSERVICE	Date and time of closing order (payment)
DURATION	Order duration (in seconds)
FINISHEDSERVICE	Marker of ready order (1 — ready; 0 — not ready)
PAID	Order is paid (1 — paid; 0 — not paid)
ISBANQUET	Marker of banquet order
BANQUETSTATE	Status of reserve order, is filled only for open orders, possible values: Usual order Active banquet (for which service printing is finished) Today banquet Future banquet
PRICELISTSUM	Sum according to price list including modifiers without discounts
TOPAYSUM	Sum to pay in basic currency
PAIDSUM	Paid sum in basic currency
UNCLOSEDPRICESUM	Non-paid sum according price list
UNCLOSEDPREPAYSUM	Unused prepayment sum
DISCOUNTSUM	Discount sum
TOTALDISHPIECES	Sum of portions of order's all dishes
INVOICEUNI	Identifier of record with invoice, link to INVOICES.UNI
ORIGINALORDERID	Identifier of original order (if order was transferred to another shift), link to ORDERS.IdentInVisit
STATE	Is not used
LASTCHECKUNI	Identifier of record with receipt, link to PRINTCHECKS.UNI
STATIONID	Station identifier, link to CASHES.Sifr
SEQNUMBER	Order sequence number
CRC32	Control sum of order content
GUIDSTRING	Unique GUIDString identifier
FISCORDERSTATE	Order fiscal status, possible values: 0 — No status 1 — Created 2 — Bill 3 — Receipt
KDSState	KDS status of order dishes (a minimum KDS status is chosen), possible values: 1 — Sent 2 — Cooking started 3 — Ready 4 — Taken 5 — Order is being collected 6 — Order is collected 7 — To place order at parking 8 — To take order away from parking 9 — Deleted
DBSTATUS	If DBStatus = -1, record must be considered deleted. Such records are not uploaded in SQL
TRANSACT_GUID	GUIDSTRING record time identifier

ORDERSESSIONS

Cumulative table, is formed at cash server.

Information on block, order may contain several blocks (additional order, different time of serving, etc.)

Tables referring to it: DISHDISCOUNTS, DISHVOIDS, SESSIONDISHES, OPERATIONLOG, PAYMENTS, PRINTCHECKS, PAYMENTS, PRINTCHECKS

VISIT	Visit identifier, link to VISITS.SIFR
MIDSERVER	Cash server identifier, link to CASHGROUPS.SIFR
ORDERIDENT	Order identifier, link to ORDERS.IdentInVisit
UNI	Unique identifier inside order
SORTORDER	Sequence of blocks in order
STATE	Status, possible values: 1 — Open 2 — Locked (not used) 3 — Fixed (bill) 4 — Printed 5 — Partially paid 6 — Closed 7 — Deleted
ICREATOR	Creator's identifier, link to EMPLOYEES.Sifr
IAUTHOR	Author's identifier, link to EMPLOYEES.Sifr
ICREATORROLE	Identifier of creator's role, link to ROLES.Sifr
IAUTHORROLE	Identifier of author's role, link to ROLES.Sifr
ISESSIONTYPE	Way of block creation, possible values: 0 — Block is created automatically 1 — Block is created manually 2 — Block is result of dishes transfer between orders 3 — Block is result of orders transfer when closing common shift 4 — Block is result of union orders 5 — Block is result of XML request call 6 — Block is result of dish return
STARTSERVICE	Date and time of dish, that was first added to block
ENDSERVICE	Date and time of block last saving
IPRICESCALE	Price type identifier, link to PRICETYPES.SIFR
IPERIOD	Period identifier, link to PERIODS.SIFR
ITRADEGROUP	Commodity group identifier, link to TRADEGROUPS.Sifr
ISTATION	Identifier of station at which block was created, link to CASHES.Sifr
EXTRAVISIT	Identifier of original visit from which dishes were transferred, link to VISITS.SIFR
EXTRAORDERIDENT	Identifier of original order from which dishes were transferred, link to ORDERS.IDENTINVISIT
EXTRAUNI	Identifier of original block from which dishes were transferred, link to ORDERSESSIONS.UNI
COMMONVISIT	Identifier of visit in which block was created (first ancestor), link to VISITS.SIFR
COMMONUNI	Identifier of block, based on which current block was created (first ancestor), link to ORDERSESSIONS.UNI
IKURS	Serving sequence identifier, link to KURSES.SIFR
PRINTFLAG	Printing flag while printing, possible values: 0 — No need to print 1 — To print as soon as possible 2 — To print when it is time to print 3 — Error when printing
PRINTAT	Date and time when block must be printed (was printed)
REMINDFLAG	Print remainder flag, see possible values in PRINTFLAG
REMINDAT	Date and time when remainder must be printed (was printed)
READYFLAG	Print flag for readiness time, see possible values in PRINTFLAG
READYAT	Date and time till which dishes must be served (if set)
OPENKURSNAME	Open (user) name for serving order
SESSIONFLAGS	Block flags, bit mask, bits values: Bit 1 — Marker that this session is service line Bit 2 — Empty block Bit 3 — Block for voids Bit 4 — Not to print block (temporarily) Bit 5 — Block with receipts Bit 6 — Block contains dishes Bit 7 — Waiter is informed about oncoming printing time Bit 8 — Waiter is informed about oncoming notification printing time Bit 9 — Course was changed manually Bit 10 — Printed block contains unprinted dishes (they must be printed) Bit 11 — Draft block Bit 12 — New block, added during current editing session Bit 13 — Waiter is notified about dishes being ready
GLOBALIDENT	Element global string identifier
IPRINTSERVICESCHEME	Identifier of service scheme used for first service print, link to SERVICESCHEMES.Sifr
IREMINDSERVICESCHEME	Identifier of service scheme used for notification service print, link to SERVICESCHEMES.Sifr
KDSSTATE	KDS status of block (minimum status of block dishes), possible values: 1 — Sent 2 — Cooking started 3 — Ready 4 — Taken 5 — Order is being collected 6 — Order is collected 7 — To place order to parking 8 — To take order away from parking 9 — Delete
NORMTIME	Nominal cooking time of block dishes (maximum cooking time of dishes), in minutes
UNIQUEID	Unique number of block within cash server, is generated based on generator OrderSessGenID
GUIDSTRING	Unique GUIDString identifier of block
DBSTATUS	If DBStatus = -1, record must be considered deleted. Such records are not uploaded in SQL
ICOSTSCALE	Identifier of cost price type, link to PRICETYPES.SIFR
TRANSACT_GUID	GUIDSTRING record time identifier

ORDERWAITERS

Cumulative table, is formed at cash server
Contains information on waiters, who serve order

VISIT	Link to visit VISITS.Sifr
MIDSERVER	Link to cash server CashGroups.Sifr
ORDER	Link to order ORDERS.IdentInVisit
WAITER	Link to employee EMPLOYEES.Sifr
DBSTATUS	If DBStatus = -1, record must be considered deleted. Such records are not uploaded in SQL
TRANSACT_GUID	GUIDSTRING record time identifier

According to a Lithuanian law, the bar and restaurant cash register software must print the quantity and amounts of unpaid proforma invoices on the control tape when printing the Z report.

Thus, when the common shift is closed, it is necessary to print a report containing the number and sums of all cancelled bills.

The necessary functionality is implemented in 7.05.04.148. When canceling a bill (if the bill was printed), a record about it is saved in the PRINTCHECKS table of receipts.

These records have the following parameters:

DELETED=1
ISBILL=1
IGNOREINREP=1

Included in versions 7.5.5.12 and 7.05.04.148

Now, when a bill is canceled (if the bill was printed), a record about it is saved in the PRINTCHECKS check table.

Such records have the following parameters:

DELETED=1
ISBILL=1
IGNOREINREP=1

PRINTCHECKS

Cumulative table, is formed at cash server, contains information on receipts.

Tables referring to it: CURRLINES, INVOICES, ORDERS, PAYMENTS, SHIFTS

VISIT	integer	Visit identifier	(VISIT, MIDSERVER) → VISITS(SIFR, MIDSERVER)
!	MIDSERVER	integer	Cash server identifier	CASHGROUPS.SIFR
!	UNI	integer	Identifier of record inside orderаказа
	ORDERIDENT	integer	Order identifier	(VISIT, MIDSERVER, ORDERIDENT) → ORDERS(VISIT, MIDSERVER, IDENTINVISIT)
	SESSIONUNI	integer	UNI of session	(VISIT, MIDSERVER, SESSIONUNI) → ORDERSESSIONS(VISIT, MIDSERVER, UNI)
	STATE		Item status
	ICREATOR	integer	Identifier of employee who paid receipt	EMPLOYEES.SIFR
	IAUTHOR	integer	Identifier of employee who confirmed receipt payment	EMPLOYEES.SIFR
	ICREATORROLE	integer	Identifier of creator's role	ROLES.SIFR
	IAUTHORROLE	integer	Identifier of author's role	ROLES.SIFR
	CLOSEDATETIME	datetime	Date and time of receipt printing
	BILLDATETIME	datetime	Date and time of bill printing
	STARTDATETIME	datetime	Date and time of receipt calculation start
	DRAWERDATETIME	datetime	Date and time of cash drawer closing
	ICLOSESTATION	integer	Identifier of station where receipt printing was started	CASHES.SIFR
	FLAGS	integer	Flags of record with receipts, bit mask, bits purpose: 1 — To fix results, not to calculate them based on order content
	ISHIFT	integer	Cash shift number	(MIDSERVER, ISHIFT) → SHIFTS(MIDSERVER, SHIFTNUM)
	IFISCSHIFT	integer	Number of fiscal shift of fiscal register
	IPRINTSTATION	integer	Identifier of station, at which receipt was printed	CASHES.SIFR
	IDRAWER	integer	Cash drawer identifier	DEVICES.SIFR
	IPRINTER	integer	Printer identifier	DEVICES.SIFR
	EXTFISCID	nvarchar(35)	Internal identification number of fiscal register, at which receipt was printed
	PRINTNUMBER	integer	Printed number of receipt
	CHECKNUM	integer	Receipt number
	PARENTCHECKNUM	integer	Parent receipt number (in case of splitting receipt by classifications)
	GUESTCNT	integer	Number of guests in receipt
	SEAT	integer	Seat, for which receipt was printed
	DELETED	smallint	The «Receipt deleted»‎ flag
	UNDOTRANSACTIONS	smallint	The «Transactions by receipt were executed»‎ flag (in case of receipt printing error, transactions are sent to external systems separately, and receipt is also separately printed)
	DELETEDATETIME	integer	Date and time of receipt deletion
	BASICSUM	money	Sum in basic currency
	BINDEDSUM	money	Sum in receipt by dishes
	NATIONALSUM	money	Sum in national currency
	FISCALSUM	money	Fiscal sum
	PRLISTSUM	money	Sum according to price list taking modifiers into account (excluding discounts)
	DISCOUNTSUM	money	Discount sum for receipt
	TOPAYSUM	bigint	Sum to be paid — for paid receipts it is equal to 0, for unpaid receipts it contains sum which should be paid)
	DISHPRICELISTSUM	bigint	Dish price according to price list
	CHARGEPRICELISTSUM	bigint	Markups amount according to price list
	TAXSUM	money	Tax sum in basic currency
	TAXSUMADDED	money	Sum of added tax (sales tax)
	BONUSSUM	money	Bonus sum in basic currency
	GLOBALIDENT	nvarchar(32)	Element global identifier
	PRINTTRY	integer	Number of receipt printing tries
	ISBILL	smallint	The «Is bill» flag‎
	IVOID	integer	Identifier of receipt void	ORDERVOIDS.SIFR
	OPENVOIDNAME	nvarchar(40)	Open (user) name of receipt void
	IDELETEPERSON	integer	Identifier of employee who deleted receipt	EMPLOYEES.SIFR
	IDELETEMANAGER	integer	Identifier of employee who confirmed receipt deletion	EMPLOYEES.SIFR
	BASICRATE	bigint	Basic currency rate
	WASALLCHANGETOTIP	smallint	The «‎Change was given as tips» flag
	BILLERROR	smallint	The «‎Error when printing receipt» flag
	INVOICEUNI	integer	UNI of invoice	(VISIT, MIDSERVER, INVOICEUNI) → INVOICES(VISIT, MIDSERVER, UNI)
	INVOICEPRINTED	smallint	The «‎Invoice is printed» flag
	COPIESPRINTED	integer	Number of receipt printed copies
	IDRAWERSHIFT	integer	Drawer shift number	(MIDSERVER, IDRAWERSHIFT) → REGISTRATIONS(MIDSERVER, IDENT)
	IBUSINESSPERIOD	integer	Business period identifier	BUSINESSPERIODS.SIFR
	IGNOREINREP	smallnt	The «‎Ignore in Report» flag
	ISPREPAYRECEIPT	smallnt	The «This is fiscal prepayment receipt» flag
	ISDEPOSITRECEIPT	smallnt	The «This is fiscal cash deposit receipt» flag
	ISWITHDRAWALRECEIPT	smallnt	The «This is fiscal cash withdrawal receipt» flag
	ISTARERECEIPT	smallnt	The «This is fiscal repurchasing receipt» flag
	SQI	integer	Service quality index
	GUIDSTRING	nvarchar(38)	Unique GUIDString identifier
	PAYFISCALSUM	money	Sum of fiscal payments in national currency
	RECEIPTTAXTYPE	smallint	Number of tax type, system will automatically split receipts by these types
	BILLPRINTED	smallint	The «Bill printed» flag
	DELETEPRINTNUMBER	integer	Number of receipt deletion document
	FISCDOCNUMBER	integer	Fiscal number of receipt printing document
	DELETEFISCDOCNUMBER	integer	Fiscal number of receipt deletion document
	GLOBALFISCALID	nvarchar(255)	Global fiscal number of receipt
	FISCDEV	integer	Identifier of fiscal registrator type	FISCDEVPARAMS.SIFR
	IENTITYDETAILS	integer	Identifier of own legal entity details	ENTITYDETAILS.SIFR
	DELETEERROR	smallint	The «Error when deleting receipt» flag
	TRANSACT_GUID	nvarchar(38)	GUIDSTRING identifier of record time
	DBSTATUS	smallint	If DBStatus = -1, record must be considered deleted. Such records are not uploaded in SQL

PRINTEDDOCUMENTS

Cumulative data: blobs with printed documents slips

RK	Field name	Field type	Description	Link to
	OPERATIONID	integer	Identifier of operation which caused printing	OPERATIONS.SIFR
!	MIDSERVER	integer	Cash server identifier	CASHGROUPS.SIFR
	DEVICE	integer	Identifier of printer on which document was printed	DEVICES.SIFR
	DOCUMENT	integer	Document type identifier	DOCUMENTS.SIFR
	OBJUNI	integer	UNI of record for which printing is executed
!	SIFR	integer	Unique identifier of record
	REFSIFR	integer	Parent printed document, if printing is connected with printing several documents	PRINTEDDOCUMENTS.SIFR
	QUEUEDTIME	datetime	Date and time of queueing document for printing
	PRINTEDTIME	datetime	Date and time of document printing
	MAKETSCHEMEDETAIL	integer	Document view identifier	MAKETSCHEMEDETAILS.SIFR
	AMOUNT	money	Sum in document
	DATA	IMAGE	BLOB with XML with printed document
	ISTATION	integer	Identifier of station at whcih printing was called	CASHES.SIFR
	ISHIFT	integer	Cash shift number	(MIDSERVER, ISHIFT) → SHIFTS(MIDSERVER, SHIFTNUM)
	DBSTATUS	smallint	If DBStatus = -1, record must be considered deleted. Such records are not uploaded in SQL
	TRANSACT_GUID	nvarchar(38)	GUIDSTRING identifier of record time

REGISTRATIONS

Cumulative table, is formed at cash server, contains information on cash drawer registrations.

IDENT	Identifier
MIDSERVER	Link to cash server CashGroups.Sifr
ICASHIER	Link to cashier
IDRAWER	Drawer DEVICES.Sifr
SEQDRAWERNUM	Sequentional number of drawer (sequention by code)
NUMINCASHSHIFT	Day number
CLOSED	Shift is closed or not (for cash reports)
ISTARTCOMMONSHIFT	Link to common shift in beginning of registration GLOBALSHIFTS.Sifr
IENDCOMMONSHIFT	Link to common shift at registration end GLOBALSHIFTS.Sifr
STARTTIME	Time when employee started work with specified cash drawer
CLOSETIME	Time when employee finished work with specified cash drawer
ISTARTMANAGER	Link to manager who started work with cash drawer EMPLOYEES.Sifr
ICLOSEMANAGER	Link to manager who finished work with cash drawer EMPLOYEES.Sifr
ISTARTSTATION	Link to station at which work with cash drawer was started CASHES.Sifr
ICLOSESTATION	Link to station at which work with cash drawer was finished CASHES.Sifr
DBSTATUS	If DBStatus = -1, record must be considered deleted. Such records are not uploaded in SQL
TRANSACT_GUID	GUIDSTRING identifier of record time

REGPERS

List of employees registered during shift. This table is not uploaded to cumulative base.

WAITER	Employee identifier, EMPLOYEES.Sifr
POSITIONS
CONFIRMIDENT	Identifier of employee who confirmed registration, EMPLOYEES.Sifr
DRAWER	Identifier of logical drawer (in case of drawer registration), DEVICES.Sifr
LASTORDER	Identifier of last edited order, int64 (first part — VISITS.Sifr, second part — ORDERS.IdentInVisit)
FLAGS	Flags (bit mask): 1 — Hall plan mode in order choice window 2 — Marker that registration must be cancelled after session end 3 — The «Not to open Personnel Registration Window automatically»‎ flag 4 — Raters mode in order choice window 5 — The «Not to open Clock-in/Clock-out form automatically»‎ flag 6 — The «To turn display when logging in»‎ flag 7 — The «To consider Cash Station parameter enabled»‎ flag
WTRFRMSORTMODE	Order sorting mode in order choice form (operations identifier from Sorting operations group), OPERATIONS.Sifr

RETURNDATA

Is filled when returning goods, contains information on original order from which goods are returned.

VISIT	Current visit identifier, VISITS.Sifr
MIDSERVER	Identifier of current cash server, CASHGROUPS.Sifr
ORDERIDENT	Identifier of current order, ORDERS.IdentInVisit
RETURNVISIT	Identifier of original (returned) visit, VISITS.Sifr
RETURNMIDSERVER	Identifier of cash server, at which original order was sold, CASHGROUPS.Sifr
RETURNORDERIDENT	Identifier of original (returned) order, ORDERS.IdentInVisit
RETURNCHECKUNI	Identifier of original (returned) receipt, PRINTCHECKS.UNI
RETURNSTATIONID	Identifier of station, at which original order was sold, CASHES.Sifr
RETURNCHECKNUM	Number of original (returned) receipt, PRINTCHECKS.CheckNum
RETURNCHECKDATETIME	Date and time of original (returned) receipt sale, PRINTCHECKS.CloseDateTime
RETURNNEXTFISCID	ID of fiscal register, at which original (returned) receipt was sold, PRINTCHECKS.ExtFiscID
RETURNPRINTNUMBER	Print number of original (returned) receipt, PRINTCHECKS.PrintNumber
RETURNUNFISCDOCNUMBER	Number of fiscal document of original (returned) receipt, PRINTCHECKS.FiscDocNumber
RETURNREASONID	Identifier of reason for goods return, ORDERVOIDS.Sifr
RETURNORDERXML	XML with original order content (in GetOrder format)
RETURNGLOBALFISCALID	Global number of original (returned) receipt, PRINTCHECKS.GlobalFiscalId
RETURNGUIDSTRING	GUID of original (returned) receipt, PRINTCHECKS.GuidString
RETURNORDERGUIDSTRING	GUID of original (returned) order, ORDERS.GuidString

Table is used for storing information on last executed backup.

Field name	Description
THISSHIFTCOUNT	Number of last shift, data on which was downloaded
THISBACKUPTIME	Date and time of last shift download
LASTSHIFTCOUNT	Number of last shift, for which backup was executed
LASTBACKUPTIME	Date and time of last backup

SALEOBJECTS

View of sold dishes (there is no such a table, only a view in the base)

RK	Field name	Field type	Description	Link to
!	MIDSERVER	integer	Cash server identifier	CASHGROUPS.SIFR
!	VISIT	integer	Visit identifier	(VISIT, MIDSERVER) → VISITS(SIFR, MIDSERVER)
!	DISHUNI	integer	UNi of record with dish	(VISIT, MIDSERVER, DISHUNI) → SESSIONDISHES(VISIT, MIDSERVER, UNI)
	CHARGEUNI	integer	UNI of record with undistributed markup	(VISIT, MIDSERVER, CHARGEUNI) → DISHDISCOUNTS(VISIT, MIDSERVER, UNI)
	ORDERIDENT	integer	Order identifier	(VISIT, MIDSERVER, ORDERIDENT) → ORDERS(VISIT, MIDSERVER, IDENTINVISIT)
	SESSIONUNI	integer	UNI of session, to which dish/markup is added	(VISIT, MIDSERVER, SESSIONUNI) → ORDERSESSIONS(VISIT, MIDSERVER, UNI)
	OBJKIND	smallint	Record type, possible values: 0 — Dish 1 — Undistributed markup
	CODE	integer	Item code — of dish or undistributed markup
	NAME	nvarchar(100)	Item name in main language
	ALTNAME	nvarchar(100)	Item name in alternative language
	RIGHTLVL	smallint	Identifier of object access right	RIGHTS.SIFR
	TypePath	nvarchar(255)	Name of parent hierarchy (line with groups of dishes including this dish/markup)
	STATUS	smallint	Item status
	SALESTERMS_STARTSALE	datetime	Date and time of item sale start
	SALESTERMS_STOPSALE	datetime	Date and time of item sale end
	ITAXDISHTYPE	integer	Tax group identifier	TAXDISHTYPES.SIFR
	SEAT	integer	Seat
	EXCLUDEFROMEARNINGS	smallint	The «‎Exclude from income»‎ flag
	SOURCESUM	money	Price amount
	PAYSUM	money	Payment sum
	QUANTITY	float	Quantity
	GLOBALIDENT	nvarchar(32)	Item global identifier
	ICREATOR	integer	Creator's identifier	EMPLOYEES.SIFR
	IAUTHOR	integer	Author's identifier	EMPLOYEES.SIFR
	ICREATORROLE	integer	Identifier of creator's role	ROLES.SIFR
	IAUTHORROLE	integer	Identifier of author's role	ROLES.SIFR

SERVPRINTERS

Table is used for getting service check number (seqnum field) and stores last used number with splitting by printers.

Table is not uploaded to cumulative base.

DEVICE	Identifier of logical printer, DEVICES.Sifr
LASTSEQ	Current value of service check number (seqnum)

SESSIONDISHES

Cumulative data: dishes

RK	Field name	Field type	Description	Link to
!	VISIT	integer	Visit identifier	(VISIT, MIDSERVER) → VISITS(SIFR, MIDSERVER)
!	MIDSERVER	integer	Cash server identifier	CASHGROUPS.SIFR
	ORDERIDENT	integer	Order identifier	(VISIT, MIDSERVER, ORDERIDENT) → ORDERS(VISIT, MIDSERVER, IDENTINVISIT)
	SESSIONUNI	integer	UNI of session, to which dish is added	(VISIT, MIDSERVER, SESSIONUNI) → ORDERSESSIONS(VISIT, MIDSERVER, UNI)
	SORTORDER	integer	Record sequence number in session
	UNI	integer	Record identifier inside order
	SIFR	integer	Dish identifier	MENUITEMS.SIFR
	STATE	integer	Dish status
	ICREATOR	integer	Identifier of employee, who added dish	EMPLOYEES.SIFR
	IAUTHOR	integer	Identifier of employeee, who either confirmed dish adding or edited it	EMPLOYEES.SIFR
	ICREATORROLE	integer	Identifier of creator's role	ROLES.SIFR
	IAUTHORROLE	integer	Identifier of author's role	ROLES.SIFR
	ITAXDISHTYPE	integer	Tax group identifier	TAXDISHTYPES.SIFR
	SRCQUANTITY	float	Dish original quantity (not taking following deletions into account)
	WRITEOFFQUANTITY	float	Number of dishes voided on write off reason
	QUANTITY	float	Dish quantity
	PIECES	float	Кол-во порций, используется для расчета кол-ва модификаторов	Number of portions is used for calculating modifiers calculation
	PRLISTSUM	money	Sum according to price list taking modifiers into account (without discounts)
	SRCPRLISTSUM	bigint	Sum according to price list taking modifiers into account, initially specified in receipt (without discounts)
	CLEARSUM	money	Clear Amount (Price * Quantity without modifiers)
	PAYSUM	money	Payment sum in basic currency (taking discounts into account)
	SUMWITHDISCOUNTS	money	Sum according to price list with added distributed discounts
	CLOSEDPAYSUM	bigint	Paid sum, closed by previous receipts
	CONSUMSUM	money	Consummation amount
	CALCCONSUMSUM	money	Base for consummation amount calculation (Sum * Consummation price)
	BONUSBASESUM	money	Base for bonus sum calculation
	PRICE	money	Dish price (cam be cahnged to open price)
	MENUITEMPRICE	money	Dish price according to price list
	SEAT	integer	Seat
	ISPORTION	smallint	The «Portion dish» flag
	ISPURCHASE	smallint	The «Repurchasing of dish» flag Флаг "Блюдо является блюдом выкупа"
	ISCOMBO	smallint	The «Is this a combo dish» flag
	ISCOMBOCOMP	smallint	The «Is this component of a combo dish» flag
	ISUSERPRICE	smallint	The «Dish price is set manually» flag
	DOSINGDEVID	integer	Identifier of dosing device, linked with dish (for doser)	DOSINGDEVICES.SIFR
	PURCHASEPREPAYUNI	integer	UNI of prepayment for repurchasing dish	(VISIT, MIDSERVER, PURCHASEPREPAYUNI) → PAYMENTS(VISIT, MIDSERVER, UNI)
	TARIFFSIFR	integer	Identifier of tariff, linked with dish (for tariffication)	MENUITEMS.SIFR
	GUIDSTRING	nvarchar(38)	Unique GUIDString identifier of record
	SOURCEGUIDSTRING	nvarchar(38)	GUIDString of original dish, is filled in case of return	(SOURCEGUIDSTRING) → SESSIONDISHES(GUIDSTRING)
	ADDBYALGORITHM	integer	Identifier of MCR-algorithm, used for dish adding	MCRALGORITHMS.SIFR
	WEIGHT	float	Dish weight (for portion dishes)
	CHANGECOUNT	smallint	Number of weight changes. Usually, waiter can specify weight only once.
	WEIGHTPRINTED	smallint	The «Weight change notification printed» flag
	GLOBALIDENT	nvarchar(32)	Item global identifier
	KDSIDENT	smallint	Record identifier for KDS	(MIDSERVER, KDSIDENT) → KDSDATA(MIDSERVER, IDENT)
	COMBODISHUNI	integer	UNI of combo dish (is filled for combo dish components)	(VISIT, MIDSERVER, COMBODISHUNI) → SESSIONDISHES(VISIT, MIDSERVER, UNI)
	COMBOMODIUNI	integer	UNI of combo dish modifier (is filled for combo dish components)	(VISIT, MIDSERVER, COMBOMODIUNI) → DISHMODIFIERS(VISIT, MIDSERVER, UNI)
	COMBODISCUNI	integer	UNI of combo discount	(VISIT, MIDSERVER, COMBODISCUNI) → DISHDISCOUNTS(VISIT, MIDSERVER, UNI)
	CHARGEUNI	integer	UNI of markup (for undistributed markup)	(VISIT, MIDSERVER, CHARGEUNI) → DISHDISCOUNTS(VISIT, MIDSERVER, UNI)
	CREATIONDATETIME	datetime	Date and time of adding dish to order
	DBSTATUS	smallint	If DBStatus = -1, record must be considered deleted. Such records are not uploaded in SQL
	TRANSACT_GUID	nvarchar(38)	GUIDSTRING identifier of record time

SHIFTS

Cumulative table containing information on cash shifts.

Tables, referring to it: PAYMENTS, PRINTCHECKS, CASHINOUT

MIDSERVER	Link to cash server CashGroups.Sifr
ISTATION	Link to station CASHES.Sifr
SHIFTNUM	Shift internal number
ICOMMONSHIFT	Link to shift GLOBALSHIFTS.Sifr
STARTSHIFTNUM	Internal number of first unclosed shift
CREATETIME	Creation time
STARTTIME	Shift start time
CLOSETIME	Shift closing time
IMANAGER	Link to manager EMPLOYEES.Sifr
BASICSUM	Sum in basic currency
FISCALSUM	Fiscal sum
NATIONALSUM	Sum in national currency
CLOSED	Marker of closed shift 0 — Not closed 1 — Closed
SENDED	Marker of cash server being aware of table being sent to manager station
PRINTSHIFTNUM	Shift printed number
IPRINTSTATION	Station at which receipt was printed CASHES.Sifr
IPRINTER	Printer PRINTERASSIGNS.Sifr
EXTFISCID	Internal identification number of fiscal register
PRINTED	Shift was printed
ISLASTSHIFT	Marker of last shift
LASTPRINTNUMBER	Last printed number of receipt PRINTCHECKS.CheckNum
ZREPNUM	Z report number, if Z report was printing during shift closure
TRANSACT_GUID	GUIDSTRING identifier of record time

TARIFFDATA

Cumulative data: information on tariffication dishes

RK	Field name	Field type	Description	Link to
!	VISIT	integer	Visit identifier	(VISIT, MIDSERVER) → VISITS(SIFR, MIDSERVER)
!	MIDSERVER	integer	Cash server identifier	CASHGROUPS.SIFR
	ORDERIDENT	integer	Order identifier	(VISIT, MIDSERVER, ORDERIDENT) → ORDERS(VISIT, MIDSERVER, IDENTINVISIT)
!	TARIFFSIFR	integer	Record identifier
	DEVICEID	integer	Rated device identifier	TABLES.SIFR
	TARIFDETAILID	integer	Tariff detail identifier	TARIFFDETAILS.SIFR
	CLOSEMANAGERID	integer	Identifier of employee who stopped tariffication	EMPLOYEES.SIFR
	STARTTIME	datetiime	Date and time of tariffication piece start
	ENDTIME	datetiime	Date and time of tariffication piece startend
	DURATION	float	Tariffication piece duration
	TARIFFSTARTTIME	datetiime	Start date and time of tariffication
	TARIFFENDTIME	datetiime	End date and time of tariffication
	TIMELIMIT	datetiime	Tariffication time limit
	MONEYLIMIT	money	Tariffication money limit
	DEFAULTER	integer	Defaulter type identifier	DEFAULTERTYPES.SIFR
	TARIFFTYPEID	integer	Tariffication type identifier	TARIFFICATIONTYPES.SIFR
	REBOOTING	smallint	The «Cash server was rebooted during tariffication»‎ flag
	EXTNUMBER	nvarchar(30)	Tariffication external number
	DISBALLANCE	bigint	Disbalance sum
	DBSTATUS	smallint	If DBStatus = -1, record must be considered deleted. Such records are not uploaded in SQL
	TRANSACT_GUID	nvarchar(38)	GUIDSTRING identifier of record time

TASKSETTERS

Work table of work.udb: service information on active tariffications

RK	Field name	Field type	Description	Link to
!	IDENT	integer	Rated device identifier	TABLES.SIFR
	VISIT	integer	Visit identifier	(VISIT, MIDSERVER) → VISITS(SIFR, MIDSERVER)
	ORDERIDENT	integer	Order identifier	(VISIT, MIDSERVER, ORDERIDENT) → ORDERS(VISIT, MIDSERVER, IDENTINVISIT)
	DISHUNI	integer	UNI of record with tariffication dish	(VISIT, DISHUNI) → SESSIONDISHES(VISIT, UNI)
	TARIFDETAILID	integer	Tariff detail identifier	TARIFFDETAILS.SIFR
	TARIFFTYPEID	integer	Tariffication type identifier	TARIFFICATIONTYPES.SIFR
	DURATION	int64	Tariffication duration
	SUM	int64	Tariffication sum
	ORDERSUM	int64	Order sum
	EXTNUMBER	nvarchar(30)	Tariffication external number
	TIMELIMIT	int64	Tariffication time limit
	MONEYLIMIT	int64	Tariffication money limit
	FLAGS	smallint	Tariffication flags, bit mask
	STARTTIME	int64	Start date and time of tariffication
	ENDTIME	int64	End date and time of tariffication
	AUTORESUMEAT	int64	Date and time when tariffication must be restarted (when suspending tariffication)
	PREVTARIFFTYPEID	integer	Tariffication type identifier BEFORE suspension	TARIFFICATIONTYPES.SIFR
	PREVTIMELIMIT	int64	Tariffication time limit before suspension
	MESSAGEID	integer	Identifier of record with waiter message on soon tariffication end time	MESSAGES.IDENT
	ITEMTYPE	integer	Type of record with tariffication, possible values: 0 — Rater 1 — Doser
	DBSTATUS	smallint	If DBStatus = -1, record must be considered deleted. Such records are not uploaded in SQL

TAXPARTS

Cumulative data: tax

RK	Field name	Field type	Description	Link to
!	VISIT	integer	Visit identifier	(VISIT, MIDSERVER) → VISITS(SIFR, MIDSERVER)
!	MIDSERVER	integer	Cash server identifier	CASHGROUPS.SIFR
	ORDERIDENT	integer	Order identifier	(VISIT, MIDSERVER, ORDERIDENT) → ORDERS(VISIT, MIDSERVER, IDENTINVISIT)
	BINDINGUNI	integer	UNI of record with sale item, for which tax is calculated	(VISIT, MIDSERVER, BINDINGUNI) → PAYBINDINGS(VISIT, MIDSERVER, UNI)
	UNI	integer	Identifier of record inside order
	SIFR	integer	Tax identifier, link to TAXES.SIFR
	BASEFORTAX	money	Base for tax calculation
	TAXRATE	float	Tax rate
	TAXFLAGS	smallint	Tax flags, bit mask
	SUM	money	Taxed amount
	NATIONALSUM	money	Sum in national currency
	TAXRATEID	integer	Tax rate identifier	TAXRATES.SIFR
	DBSTATUS	smallint	If DBStatus = -1, record must be considered deleted. Such records are not uploaded in SQL
	TRANSACT_GUID	nvarchar(38)	GUIDSTRING identifier of record time

TEMPEMPLOYEES

Work table of work.udb: table with temporary employees, not used

RK	Field name	Field type	Description	Link to
!	SIFR	integer	Employee's identifier	EMPLOYEES.SIFR
	CODE	integer	Employee's code
	CARDCODE	nvarchar(50)	Code of employee's card
	ROLE	integer	Identifier of employee's role	ROLES.SIFR
	NAME	nvarchar(40)	Employee's name
	ALTNAME	nvarchar(40)	Employee's name in alternative language
	ISALTLANG	smallint	The «Alt DB language»‎ flag

UPDATEVERSIONS

This table is used to ensure refernce sync process. It contains current number of collection version.

Each time reference is changed, its version increases by one, and a new version number is recorded in this table.

TABLENAME	Table name, REFTABLES.Name
TABLEVERS	Collection version number (increases after each change to reference)
RECSTAMP	GUIDSTRING identifier of record time

VERSION (work.udb)

This table contains information on work.udb structure version and some other service information.

This table is not uploaded to cumulative base.

Имя поля	Описание
NUMBER	Base structure version for work.udb (looks like 77000022, where first three figures stand for r_keepr 7 version)
CREATED	Creation date and time of work.udb
BACKUPTIME	Date and time of last backup
TRANSACTIONCOUNT	Number of last printed receipt (implicitly indicates number of transactions till last backup), backup is executed after each N receipts
BACKUPCOUNT	Number of executed backups
LIGHTWEIGHTMODE	UDB Database Mode (for check.udb)

VISITGUESTS

Cumulative data: list of visit guests

PK	Field name	Field type	Description	Link to
!	VISIT	integer	Visit identifier	(VISIT, MIDSERVER) → VISITS(SIFR, MIDSERVER)
	MIDSERVER	integer	Cash server identifier	CASHGROUPS.SIFR
	GUEST	integer	Seat number
	MNEMONIC	nvarchar(10)	Text name for seat
	CARDCODE	nvarchar(50)	Card code
	INTFID	integer	Identifier of logical interface linked with card	DEVICES.SIFR
	MAXCREDITSUM	bigint	Maximum sum
	HOLDER	nvarchar(40)	Card holder
	ENTRANCECARDTYPE	integer	Identifier of entrance card type	ENTRANCECARDTYPES.SIFR
	CLIENTID	bigint	Idenfier of client from external system (CRM)
	ADDRESSID	bigint	Identifier of client's address from external system (CRM)
	FISCORDERSTATE	smallint	Fiscal status. 0 — Нет статуса 1 — Created 2 — Bill 3 — Receipt
	DBSTATUS	smallint	If DBStatus = -1, record must be considered deleted. Such records are not uploaded in SQL
	TRANSACT_GUID	nvarchar(38)	GUIDSTRING identifier of record time

Cumulative data: list of visits

RK	Field name	Field type	Description	Link to
!	SIFR	integer	Record identifier
!	MIDSERVER	integer	Cash server identifier	CASHGROUPS.SIFR
	CREATOR	integer	Identifier of employee who created visit	EMPLOYEES.SIFR
	GUESTTYPE	integer	Guest type identifier	GUESTTYPES.SIFR
	STARTGUESTCNT	integer	Number of guests at visit creation moment
	GUESTCNT	integer	Number of guests in visit
	RESERVSOURCE	integer	Reservation source (is filled for reserve visits)
	RESERVID	integer	Reservation identifier (is filled for reserve visits)
	RESERVDURATION	integer	Reservation duration
	RESERVSTATE	integer	Reservation status, possible values: 0 — Common visit 1 — Reservation visit 2 — Reservation is deleted as outdated
	RESERVFLAGS	integer	Reservation flags, bit mask, possible values: 1 — Reservation results were sent
	ENTRCARDMODE	integer	Entrance card type, possible values: 0 — Common visit, without entrance card 1 — Can be seats without card 2 — All guests must have cards
	MAXCREDITSUM	money	Payment maximum sum, available for visit (for entrance card)
	STARTTIME	datetime	Date and time of visit creation
	QUITTIME	datetime	Date and time of visit end
	FINISHED	smallint	Visit activity status, possible values: 0 — Open visit 1 — Closed visit 2 — Visit for reservation (its activity depends on time)
	VISITEXTRAINFOTOSAVE	nvarchar(255)	Saved comment
	SEATSCLOSED	IMAGE	BLOB with list of seats closed in visit
	VISITOTHEREXTRAINFO	nvarchar(255)	Unsaved comment (for cash reports only)
	HOLDER	nvarchar(35)	Holder
	ISTARTCOMMONSHIFT	integer	Number of common shift, during which visit was open	(MIDSERVER, ISTARTCOMMONSHIFT) → GLOBALSHIFTS(MIDSERVER, SHIFTNUM)
	IQUITCOMMONSHIFT	integer	Number of common shift, during which visit was closed	(MIDSERVER, IQUITCOMMONSHIFT) → GLOBALSHIFTS(MIDSERVER, SHIFTNUM)
	GUIDSTRING	nvarchar(38)	Unique GUIDString identifier
	UNICOUNT	integer	Is used for generating UNI for visit items. Stores current value of generator for order items identifiers (UNI) of this visit
	DBSTATUS	smallint	If DBStatus = -1, record must be considered deleted. Such records are not uploaded in SQL
	TRANSACT_GUID	nvarchar(38)	GUIDSTRING identifier of record time

ZREPORTDATA

Cumulative data: printed Z-reports data

RK	Field name	Field type	Description	Link to
!	MIDSERVER	integer	Cash server identifier	CASHGROUPS.SIFR
!	SHIFTNUM	integer	Common shift number	(MIDSERVER, SHIFTNUM) → GLOBALSHIFTS(MIDSERVER, SHIFTNUM)
!	IDENTIFIER	integer	Record identifier
	POS_ID	nvarchar(40)	String identifier of fiscal register/fiscal memory, specified upon registration
	SERIALNUMBER	nvarchar(40)	serial number, is filled by device producer
	INN	nvarchar(20)	TIN (INN), is filled upon fiscalization/re-registration
	ZREPORTNUMBER	integer	Z-report number
	INCASHSUM	money	Deposit sum per shift
	STARTTOTAL	money	Storage counter at shift start, must coincide with that of Z report. Sense may differ for different fiscal registers. Is used in form of KM7, which description does not contain definition of such counter
	ENDTOTAL	money	Storage counter at shift end
	RETURNS	money	Sum of deletions and returns per shift
	ADVANCESUM	money	Sum of advances per shift (Latvia)
	PROCEEDS	money	Sale amount without deletions and advances (if used not in Latvia, than just sale amount)
	PROCEEDSWOTAX	money	Sale amount without taxes
	TAXSUM	money	Tax sum
	CASHSUM	money	Cash revenue sum
	BANKCARDSUM	money	Bank cards revenue sum
	NONCASHSUM	money	Non-cash revenue sum (all revenue minus cash and bank cards)
	SHIFTSTARTDATETIME	datetime	Shift start date and time. If fiscal register does not have this data, cash station will insert date and time of first receipt at this fiscal register after Z report
	ZREPORTDATETIME	datetime	Date and time of fiscal register at moment of data request (before Z report)
	CASHIERID	integer	Identifier of cashier who printed Z report	EMPLOYEES.SIFR
	TAXSUM1	money	Tax sum according to tax rate 1
	TAXSUM2	money	Tax sum according to tax rate 2
	TAXSUM3	money	Tax sum according to tax rate 3
	TAXSUM4	money	Tax sum according to tax rate 4
	TAXSUM5	money	Tax sum according to tax rate 5
	TAXSUM6	money	Tax sum according to tax rate 6
	FISCDEV	integer	Identifier of fiscal register type	FISCDEVPARAMS.SIFR
	DEVICE	integer	Printer identifier	DEVICES.SIFR
	SALERECEIPTCOUNT	integer	Number of receipts by sales
	SALEDELETECOUNT	integer	Number of receipts deletion
	RETURNRECEIPTCOUNT	integer	Number of return receipts
	RETURNDELETECOUNT	integer	Number of return receipts deletions
	TRANSACT_GUID	nvarchar(38)	GUIDSTRING identifier of record time

ZREPORTVALUES

Table with details for Z reports.

RK	Field name	Field type	Description	Link to
!	MIDSERVER	integer	Cash server identifier	CASHGROUPS.SIFR
!	SHIFTNUM	integer	Common shift number	(MIDSERVER, SHIFTNUM) → GLOBALSHIFTS(MIDSERVER, SHIFTNUM)
!	IDENTIFIER	integer	Z report number	(MIDSERVER, SHIFTNUM, IDENTIFIER) → ZREPORTDATA(MIDSERVER, SHIFTNUM, IDENTIFIER)
!	SEQINSHIFT	integer	Sequence number of record within current common shift
	SOURCEID	nvarchar(20)	Property source name
	VALUEKEYID	nvarchar(38)	Property name
	ZREPSVALUE	nvarchar(40)	Property value
	TRANSACT_GUID	nvarchar(38)	GUIDSTRING identifier of record time

Child pages