[toc]
1. General information
1.1. To build your own reports directly from SQL data you have to use this guide.
2. Tables
2.1. Log tables
2.1.1. LOGBOOK
2.1.2. LOGVERSION
2.1.3. BLOBPARTS
2.1.4. INTEGERPARTS
2.1.5. STRINGPARTS
2.1.6. COMPPARTS
2.1.7. PARENTPARTS
2.1.8. COMMENTPARTS
2.2. Cubes and reports tables
2.2.1. OLAPCUBEEXTENDEDFIELDS
2.2.2. OLAPCUBEFIELDS
2.2.3. OLAPCUBEFIELDSDETAILS
2.2.4. OLAPCUBES
2.2.5. OLAPCUBESCHEMES
2.2.6. OLAPREPORTGROUPS
2.2.7. OLAPREPORTRIGHTS
2.2.8. OLAPREPORTS
2.2.9. CASHREPORTDETAILS
2.3. References tables
2.3.A. Employees data
2.3.1. EMPLOYEES
2.3.2. EMPLOYEEGROUPDETAILS
2.3.3. EMPLOYEEGROUPS
2.3.4. EMPLOYEEROLES
2.3.5. ROLES
2.3.B. Stations data
2.3.6. CASHES
2.3.7. CASHGROUPS
2.3.8. CASHCONFIG
2.3.9. CASHPARAMS
2.3.C. Restaurant organisation
2.3.10. RESTAURANTCONCEPTS
2.3.11. RESTAURANTREGIONS
2.3.12. RESTAURANTS
2.3.13. BRIGADES
2.3.14. BUSINESSPERIODS
2.3.15. BONUSTYPES
2.3.16. HALLPLANITEMS
2.3.17. HALLPLANS
2.3.D. Taxes information
2.3.18. TAXDISHRULES
2.3.19. TAXDISHTYPES
2.3.20. TAXES
2.3.21. TAXPAYRULES
2.3.22. TAXPAYTYPES
2.3.23. TAXRATEFIELDS
2.3.24. TAXRATES
2.3.E. Rights
2.3.25. RIGHTGROUPS
2.3.26. RIGHTS
2.3.110. PRIVILEGEDETAILS
2.3.111. PRIVILEGEGROUPS
2.3.112. PRIVILEGES
2.3.F. Devices
2.3.27. DEVICELICENSES
2.3.28. DEVICEDATALOOKUPITEMS
2.3.29. DEVICEDETAILS
2.3.30. DEVICES
2.3.31. DOSINGDEVICEASSIGNS
2.3.32. DOSINGDEVICES
2.3.33. DRAWERLOG
2.3.34. INPDEVTYPES
2.3.35. MCRALGORITHMS
2.3.36. INTERFACEDLL
2.3.37. STOREHOUSECONFIGS
2.3.129. KBDLAYOUTKEYS
2.3.130. KBDLAYOUTS
2.3.131. KBDTYPES
2.3.G. Money
2.3.38. CURRENCIES
2.3.39. CURRENCIESBANS
2.3.40. CURRENCYFACEVALUES
2.3.41. CURRENCYTYPES
2.3.42. RATECLASSES
2.3.89. DEPOSITCOLLECTREASONS
2.3.90. DISCOUNTCOMPOSITIONS
2.3.91. DISCOUNTDETAILS
2.3.92. DISCOUNTS
2.3.93. DISCOUNTTYPES
2.3.H. Prices
2.3.43. PRICECONSTANTS
2.3.44. PRICECONSTANTTYPES
2.3.45. PRICEFORMULAS
2.3.46. PRICES
2.3.47. PRICETYPES
2.3.L. Printing
2.3.94. DOCUMENTMAKETSCHEMELINKS
2.3.95. DOCUMENTS
2.3.96. MAKETS
2.3.97. MAKETSCHEMEDETAILS
2.3.98. MAKETSCHEMES
2.3.99. FISCDEVPARAMS
2.3.100. FISCTYPEPROPS
2.3.108. PRINTERASSIGNS
2.3.109. PRINTERPURPOSES
2.3.124. SERVICECHECKS
2.3.125. SERVICESCHEMES
2.3.126. SERVINGPOSITIONS
2.3.M. Menu
2.3.58. CATEGLIST
2.3.59. DISHGROUPS
2.3.60. KURSES
2.3.61. MENUITEMS
2.3.62. MODIFIERS
2.3.63. MODIGROUPS
2.3.64. MODISCHEMEDETAILS
2.3.65. MODISCHEMES
2.3.O. Orders
2.3.66. CHANGEABLEORDERTYPES
2.3.67. COTUSAGES
2.3.68. UNCHANGEABLEORDERTYPES
2.3.69. ORDERVOIDS
2.3.P. Operations
2.3.132. OPERATIONCLASSES
2.3.133. OPERATIONDETAILS
2.3.134. OPERATIONS
2.3.135. OPERATIONSUSERDATA
2.3.S. GUI
2.3.76. COLORMAPPINGS
2.3.77. COLORSCHEMEDETAILS
2.3.78. COLORSCHEMES
2.3.79. DISPLAYRESOLUTIONS
2.3.80. FORMDETAILS
2.3.81. FORMS
2.3.82. FORMSCHEMECHILDS
2.3.83. FORMSCHEMEDETAILS
2.3.84. FORMSCHEMES
2.3.85. FUNCTIONKEYGROUPS
2.3.86. FUNCTIONKEYS
2.3.87. IMAGENODES
2.3.88. IMAGELIST
2.3.113. SELECTORDETAILS
2.3.114. SELECTORGROUPS
2.3.115. SELECTORHIERARHIES
2.3.116. SELECTORS
2.3.117. SELECTORTYPES
2.3.118. SELECTORTYPEVSTRADEOBJ
2.3.T. Trade groups
2.3.70. TRADEGROUPDETAILS
2.3.71. TRADEGROUPS
2.3.X. Other
2.3.48. CONSUMATORS
2.3.49. CONSUMTYPES
2.3.50. TABLEATTRIBUTES
2.3.51. TABLEATTRIBUTESASSIGNS
2.3.52. TABLEGROUPS
2.3.53. TABLES
2.3.54. TARIFFDATA
2.3.55. TARIFFDETAILS
2.3.56. TARIFFICATIONTYPES
2.3.57. DEFAULTERTYPES
2.3.72. ENTRANCECARDTYPES
2.3.73. CLASSIFICATORGROUPS
2.3.74. DISHRESTS
2.3.75. RECOMMENDEDMENUITEMS
2.3.101. GENERATEDPROPDATAS
2.3.102. GENERATEDPROPINFOS
2.3.103. GENERATEDPROPTYPES
2.3.104. FILTERS
2.3.105. PDSCARDS
2.3.106. PERIODDETAILS
2.3.107. PERIODS
2.3.119. REPORTINGSERVERS
2.3.120. REPORTSERVERGROUPS
2.3.121. ROLEREPSSERVS
2.3.122. SCRIPTS
2.3.123. SCRIPTTYPES
2.3.127. GUESTSTYPELABELS
2.3.128. GUESTTYPES
2.3.136. PARAMETEREXCEPTIONS
2.3.137. PARAMETERHIERARHIES
2.3.138. PARAMETERS
In cube structure their data is not in bold font.
2.4. Accumulative data tables
Taxes
2.4.1. TAXPARTS
Worktime
2.4.2. CLOCKRECS
Stations
2.4.3. CASHINOUT
2.4.4. CASHSERVDATASTATUSES
Discounts
2.4.6. DISCPARTS
2.4.7. DISHDISCOUNTS
Dishes
2.4.8. DISHCONSUMATORS
2.4.9. DISHMODIFIERS
2.4.10. DISHVOIDS
2.4.11. SESSIONDISHES
Shifts
2.4.12. GLOBALSHIFTS
2.4.13. GLOBALSHIFTSTATS
2.4.14. SHIFTS
Receipts
2.4.27. PRINTCHECKS
Guests
2.4.15. GUESTREPLIES
Invoices
2.4.16. INVOICES
Operations
2.4.17. OPERATIONLOG
Orders
2.4.18. EXTERNALIDS
2.4.19. EXTRATABLES
2.4.20. KDSDATA
2.4.21. ORDERS
2.4.22. ORDERSESSIONS
2.4.23. ORDERWAITERS
Payments
2.4.24. PAYBINDINGS
2.4.25. PAYMENTS
2.4.26. PAYMENTSEXTRA
2.4.5. CURRLINES
Cash drawer
2.4.28. REGISTRATIONS
Visits
2.4.29. VISITGUESTS
2.4.30. VISITS
In cube structure their data is in bold font. This data comes from cash servers.
2.5. Internal system tables
2.5.1. ALIASES
2.5.2. ALIASLANGUAGES
2.5.3. BANDEDPROPSRIGHTS
2.5.4. BANDRIGHTS
2.5.5. EXTBASECONFIGS
2.5.6. EXTBASEUPGRADES
2.5.7. CHECKTABLES
2.5.8. CHECKTABLEFIELDS
2.5.9. DBDESCRIPTION
2.5.10. DBInformation
2.5.11. GENERATORS
2.5.12. ITEMSSALED
2.5.13. PROPRIGHTS
2.5.14. REFLINKS
2.5.15. REFRESOURCES
2.5.16. TRK7CHANGETYPES
2.5.17. TRK7ENUMSVALUES
2.5.18. WARNGROUPS
3. Columns
3.1. In different tables the same data usually have different names.
3.1.1. Visit ident in [VISITS] table column name is [SIFR], in [ORDERS] table is [VISIT], etc. Nevertheless, this is one and the same visit idents calculated as [VISIT]=([currentdate]-[2000-01-01])days*(2^16)+[currentdatevisitnumber]
4. Views
4.1. All recalculated cubes have their views in SQL DB.
4.2. Views are named as "VRK7CUBEVIEWxxxxx", where "xxxxx"= cube ident from RK7 references.