Page History

...

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

Contains information about KDS — kitchen display system

.

Tables referring to it: SESSIONDISHES

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

KDSSIFR

Идентификатор записи

Record identifier

MIDSERVER

Идентификатор кассового сервера, ссылка на CASHGROUPS

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

- Идет сборка заказа

6 - Заказ собран

7 - Поставить заказ на парковку

8 - Снять заказ с парковки

9 - Удалено

— 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 - Исключить из доходов, для фиктивных сдач 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 — Признак того что данная сессия является сервис-линией Bit 2 — Пустой пакет Bit 3 — Пакет для отказов (воидов) Bit 4 — Не печатать пакет (временно) Bit 5 — Пакет с чеками Bit 6 — В пакете есть блюда Bit 7 — Официант был уведомлен о приближении времени печати Bit 8 — Официант был уведомлен о приближении времени печати напоминания Bit 9 — Порядок подачи изменен вручную Bit 10 — В распечатанном пакете есть нераспечатанные блюда (их нужно напечатать) Bit 11 — Пакет - черновик Bit 12 — Новый пакет, добавлен в текущем сеансе редактирования Bit 13 — Официант был уведомлен об окончании готовки блюд
GLOBALIDENT	Глобальный строковый идентификатор элемента
IPRINTSERVICESCHEME	Идентификатор сервис-схемы, которая использовалась для первой сервис-печати, ссылка на SERVICESCHEMES.Sifr
IREMINDSERVICESCHEME	Идентификатор сервис-схемы, которая использовалась для сервис-печати напоминания, ссылка на SERVICESCHEMES.Sifr
KDSSTATE	КДС-статус пакета (минимальный статус по блюдам пакета), возможные значения: 1 - Отправлено 2 - Начата готовка 3 - Приготовлено 4 - Забрано 5 - Идет сборка заказа 6 - Заказ собран 7 - Поставить заказ на парковку 8 - Снять заказ с парковки 9 - Удалено
NORMTIME	Номинальное время приготовления по блюдам пакета (максимально время готовки у блюд), в минутах
UNIQUEID	Уникальный номер пакета в рамках кассового сервера, генерируется на основе генератора OrderSessGenID
GUIDSTRING	Уникальный GUIDString идентификатор пакета

KDSFLAGS

Доп. флаги для КДС, возможные значения:

1 - можно удалять

SENTATДата и время когда послали заказ на выполнениеINITATДата и время начала готовкиDONEATДата и время когда кухней сделан заказTAKEATДата и время когда кухня приняла заказCOLLECTATДата и время начала сборки заказаCOLLECTEDATДата и время окончания сборки заказаSTARTPARKATДата и время постановки заказа на парковкуENDPARKATДата и время снятия заказа с парковкиCOOKTMФактическое время приготовления в минутахMENUCOOKTIMEНоминальное время приготовления в минутахMENUCATEGORYИдентификатор категории меню, ссылка на CLASSIFICATORGROUPS.SIFRSERVPRINTNUMНомер сервис-печатиSENTMANAGERIDИдентификатор работника, который отправил заказ на КДС (сохранил заказ), ссылка на EMPLOYEES.SIFRINITMANAGERIDИдентификатор работника, который начал готовку, ссылка на EMPLOYEES.SIFRDONEMANAGERIDИдентификатор работника, который отметил заказ приготовленным, ссылка на EMPLOYEES.SIFRTAKEMANAGERIDИдентификатор работника, который отметил заказ забранным, ссылка на EMPLOYEES.SIFRCOLLECTMANAGERIDИдентификатор работника, который начал сборку заказа, ссылка на EMPLOYEES.SIFRCOLLECTEDMANAGERIDИдентификатор работника, который завершил сборку заказа, ссылка на EMPLOYEES.SIFRSTARTPARKMANAGERIDИдентификатор работника, который отправил заказ на парковку, ссылка на EMPLOYEES.SIFRENDPARKMANAGERIDИдентификатор работника, который снял заказ с парковки, ссылка на EMPLOYEES.SIFRKDSSTATIONIDИдентификатор станции, ссылка на CASHES.SIFRDBSTATUSЕсли DBStatus = -1, то запись нужно считать удаленной. В SQL такие записи не выгружаются.TRANSACT_GUIDGUIDSTRING идентификатор времени записи

MCRPAYMENTS

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

VISITИдентификатор визита, ссылка на VISITS.SIFRMIDSERVERИдентификатор кассового сервера, ссылка на CASHGROUPS.SIFTORDERIDENTИдентификатор заказа, ссылка на ORDERS.IdentInVisitUNIИдентификатор записи внутри заказаSIFRИдентификатор валюты, ссылка на CURRENCIES.SIFRINPUTTYPE

Способ добавления платежа, возможные значения:

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.SIFRDEFAULTERИдентификатор типа неплательщиков, ссылка на DEFAULTERTYPES.SIFREXTTRANSACTIONINFOДоп.инфо по платежу


DBSTATUS	Если DBStatus = -1, то запись нужно считать удаленной. В SQL такие записи не выгружаются.
ICOSTSCALE	Идентификатор типа себестоимости, ссылка на PRICETYPES.SIFR
TRANSACT_GUID	GUIDSTRING идентификатор времени записи

Child pages

Page History

Versions Compared

Old Version 3

New Version 4

Key

AWARDSPENALTIESDATA

CASHINOUT

CASHINOUTDETAILS

CASHSUMS

CHECKLISTDATA

CHECKLISTDATADETAILS

CLOCKRECS

CURRLINES

DELIVERYDATA

DEFFEREDSYNC

DISCPARTS

DISHCONSUMATORS

DISHDISCOUNTS

DISHMODIFIERS

DISHRESTS

DISHVOIDS

DRAWERLOG

EXTERNALIDS

EXTRATABLES

FINANCEDOCUMENTS

FINANCETRANSACTDETAILS

FINANCETRANSACTIONEXT

FINANCETRANSACTIONS

FISCALREGISTERS

GENERATORS (work.udb)

GLOBALSHIFTS

GUESTREPLIES

HARDWAREINFO

INFO

INTFTRANSACTIONS

INVOICES

KDSDATA

MCRPAYMENTS

MESSAGEBUTTONS

MESSAGES

NEEDCLOSECHECK

OPERATIONLOG

ORDERS

ORDERSESSIONS

MCRPAYMENTS