View Source

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

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

AWARDSPENALTIESDATA

Cumulative table of awards and penalties.

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

CASHINOUT

Contains information about cash deposit/collection.

Is formed at the cash server.

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

CASHINOUTDETAILS

Details of deposit/collect cash operations

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

CASHSUMS

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

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

CHECKLISTDATA

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

CHECKLISTDATADETAILS

Check lists details

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

CLOCKRECS

Is formed at the cash server for work hours control

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

CURRLINES

Contains information about payments with regard to currencies

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

DELIVERYDATA

Table with delivery data

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

DEFFEREDSYNC

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

This table is not used anymore.

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

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

DISCPARTS

Contains information on discounts

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

DISHCONSUMATORS

Contains information on dishes sold by consumator.

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

DISHDISCOUNTS

Contains information about discounts/markups, added to order

Tables referring to it: CURRLINES, DISCPARTS

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

DISHMODIFIERS

Contains information on sold modifiers.

Tables referring to it: SESSIONDISHES

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

DISHRESTS

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	Фискальная сумма
	PRLISTSUM	money	Сумма по прайс листу с учётом модификаторов (но без скидок)
	DISCOUNTSUM	money	Сумма скидки, приходящаяся на чек
	TOPAYSUM	bigint	Сумма к оплате (для оплаченных чеков равна 0, для неоплаченных содержит сумму, которую нужно доплатить для оплаты чека)
	DISHPRICELISTSUM	bigint	Стоимость блюд по прейскуранту
	CHARGEPRICELISTSUM	bigint	Стоимость наценок по прейскуранту
	TAXSUM	money	Сумма налога в базовой валюте
	TAXSUMADDED	money	Сумма добавленного налога (налог с продаж)
	BONUSSUM	money	Сумма бонуса в базовой валюте
	GLOBALIDENT	nvarchar(32)	Глобальный идентификатор элемента
	PRINTTRY	integer	Число попыток печати чека
	ISBILL	smallint	Флаг "Это пречек"
	IVOID	integer	Идентификатор причины удаления чека	ORDERVOIDS.SIFR
	OPENVOIDNAME	nvarchar(40)	Открытое (пользовательское) имя причины удаления чека
	IDELETEPERSON	integer	Идентификатор работника, который выполнил удаление чека	EMPLOYEES.SIFR
	IDELETEMANAGER	integer	Идентификатор работника, который подтвердил удаление чека	EMPLOYEES.SIFR
	BASICRATE	bigint	Курс базовой валюты
	WASALLCHANGETOTIP	smallint	Флаг "Сдача была выдана в виде чаевых"
	BILLERROR	smallint	Флаг "Ошибка при печати пречека"
	INVOICEUNI	integer	UNI счет-фактуры	(VISIT, MIDSERVER, INVOICEUNI) → INVOICES(VISIT, MIDSERVER, UNI)
	INVOICEPRINTED	smallint	Флаг "Печать счет-фактуры выполнена"
	COPIESPRINTED	integer	Число распечатанных копий чека
	IDRAWERSHIFT	integer	Номер смены ящика	(MIDSERVER, IDRAWERSHIFT) → REGISTRATIONS(MIDSERVER, IDENT)
	IBUSINESSPERIOD	integer	Идентификатор бизнес-периода	BUSINESSPERIODS.SIFR
	IGNOREINREP	smallnt	Флаг "Игнорировать в отчетах"
	ISPREPAYRECEIPT	smallnt	Флаг "Это чек фискальной предоплаты"
	ISDEPOSITRECEIPT	smallnt	Флаг "Это чек фискального внесения денег"
	ISWITHDRAWALRECEIPT	smallnt	Флаг "Это чек фискального изъятия денег"
	ISTARERECEIPT	smallnt	Флаг "Это чек фискального выкупа"
	SQI	integer	Оценка качества обслуживания
	GUIDSTRING	nvarchar(38)	Уникальный GUIDString идентификатор
	PAYFISCALSUM	money	Сумма фискальных платежей в национальной валюте
	RECEIPTTAXTYPE	smallint	Номер типа налогообложения, система автоматически разобьёт чеки по этим типам
	BILLPRINTED	smallint	Флаг "Был распечатан пречек"
	DELETEPRINTNUMBER	integer	Номер документа удаления чека
	FISCDOCNUMBER	integer	Фискальный номер документа печати чека
	DELETEFISCDOCNUMBER	integer	Фискальный номер документа удаления чека
	GLOBALFISCALID	nvarchar(255)	Глобальный фискальный номер чека
	FISCDEV	integer	Идентификатор типа фискального регистратора	FISCDEVPARAMS.SIFR
	IENTITYDETAILS	integer	Идентификатор реквизита собственного юридического лица	ENTITYDETAILS.SIFR
	DELETEERROR	smallint	Флаг "При удалении чека возникла ошибка"
	TRANSACT_GUID	nvarchar(38)	GUIDSTRING идентификатор времени записи
	DBSTATUS	smallint	Если DBStatus = -1, то запись нужно считать удаленной. В SQL такие записи не выгружаются.