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	Для штрафов за опоздание, ссылка на запись учета рабочего времени, для которой сгенерирована премия 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

Содержит информацию о данных KDS - Kitchen display system

Таблицы, которые на нее ссылаются: SESSIONDISHES

KDSSIFR	Идентификатор записи
MIDSERVER	Идентификатор кассового сервера, ссылка на CASHGROUPS.SIFR
VISITID	Идентификатор визита, ссылка на VISITS.SIFR
KDSSTATE	КДС-Статус блюда, возможные значения: 1 - Отправлено 2 - Начата готовка 3 - Приготовлено 4 - Забрано 5 - Идет сборка заказа 6 - Заказ собран 7 - Поставить заказ на парковку 8 - Снять заказ с парковки 9 - Удалено
KDSFLAGS	Доп. флаги для КДС, возможные значения: 1 - можно удалять
SENTAT	Дата и время когда послали заказ на выполнение
INITAT	Дата и время начала готовки
DONEAT	Дата и время когда кухней сделан заказ
TAKEAT	Дата и время когда кухня приняла заказ
COLLECTAT	Дата и время начала сборки заказа
COLLECTEDAT	Дата и время окончания сборки заказа
STARTPARKAT	Дата и время постановки заказа на парковку
ENDPARKAT	Дата и время снятия заказа с парковки
COOKTM	Фактическое время приготовления в минутах
MENUCOOKTIME	Номинальное время приготовления в минутах
MENUCATEGORY	Идентификатор категории меню, ссылка на CLASSIFICATORGROUPS.SIFR
SERVPRINTNUM	Номер сервис-печати
SENTMANAGERID	Идентификатор работника, который отправил заказ на КДС (сохранил заказ), ссылка на EMPLOYEES.SIFR
INITMANAGERID	Идентификатор работника, который начал готовку, ссылка на EMPLOYEES.SIFR
DONEMANAGERID	Идентификатор работника, который отметил заказ приготовленным, ссылка на EMPLOYEES.SIFR
TAKEMANAGERID	Идентификатор работника, который отметил заказ забранным, ссылка на EMPLOYEES.SIFR
COLLECTMANAGERID	Идентификатор работника, который начал сборку заказа, ссылка на EMPLOYEES.SIFR
COLLECTEDMANAGERID	Идентификатор работника, который завершил сборку заказа, ссылка на EMPLOYEES.SIFR
STARTPARKMANAGERID	Идентификатор работника, который отправил заказ на парковку, ссылка на EMPLOYEES.SIFR
ENDPARKMANAGERID	Идентификатор работника, который снял заказ с парковки, ссылка на EMPLOYEES.SIFR
KDSSTATIONID	Идентификатор станции, ссылка на CASHES.SIFR
DBSTATUS	Если DBStatus = -1, то запись нужно считать удаленной. В SQL такие записи не выгружаются.
TRANSACT_GUID	GUIDSTRING идентификатор времени записи

MCRPAYMENTS

MCR-платежи по заказу (предварительно персонализированные платежи)

VISIT	Идентификатор визита, ссылка на VISITS.SIFR
MIDSERVER	Идентификатор кассового сервера, ссылка на CASHGROUPS.SIFT
ORDERIDENT	Идентификатор заказа, ссылка на ORDERS.IdentInVisit
UNI	Идентификатор записи внутри заказа
SIFR	Идентификатор валюты, ссылка на CURRENCIES.SIFR
INPUTTYPE	Способ добавления платежа, возможные значения: 0 - Вручную 1 - Магнитная карта 2 - Даллас 3 - Расчет заказа 4 - Прокси карты 5 - Штрих-код 6 - XML
PAYLINETYPE	Тип валюты, возможные значения: 0 - Наличные 1 - Банковские карты 2 - Карты отеля 3 - Платежные карты 4 - Исключить из доходов, для фиктивных сдач 5 - Безнал 6 - Купон на блюдо 7 - Блюдо выкупа
OWNER	Владелец, заполняется для платежных карт
CARDNUM	Номер карты
ACCOUNTIDENT	Номер счета, связанный с картой, заполняется для платежных карт
EXPDATE	Дата окончания
AUTHCODE	Код авторизации для банковской карты
TRACK2	Не используется
MAXAMOUNT	Максимальная сумма, доступная для оплаты
ADDBYINTERFACE	Идентификатор логического интерфейса, ссылка на DEVICES.SIFR
DEFAULTER	Идентификатор типа неплательщиков, ссылка на DEFAULTERTYPES.SIFR
EXTTRANSACTIONINFO	Доп.инфо по платежу
DBSTATUS	Если DBStatus = -1, то запись нужно считать удаленной. В SQL такие записи не выгружаются.

Child pages