Devel - BlueGastro - DB tables
Verzia z 12:23, 6. jún 2017, ktorú vytvoril Juraj.pacolt (diskusia | príspevky) (Nahradenie textu „BlueGastro” textom „Asseco BLUEGASTRO”)
<viewsecurity service />
Obsah
- 1 ALACARTE_COUNTERS
- 2 B_FILE_REPORT_SETTINGS
- 3 B_JAZYK
- 4 B_JAZYK_LANG
- 5 B_OBJEKT
- 6 B_OBJEKT_COMMAND
- 7 B_OBJEKT_LANG
- 8 B_OBJEKT_TYP
- 9 B_OBJEKT_TYP_LANG
- 10 B_TAB_NAR_ZNAKOV
- 11 B_TAB_NAR_ZNAKOV_LANG
- 12 B_TAB_NAR_ZNAKY_POLOZKA
- 13 B_TEMPLATE
- 14 B_TEMPLATE_SKUPINA
- 15 B_TEMPLATE_SKUPINA_LANG
- 16 B_TEMPLATE_TYP
- 17 B_TEMPLATE_TYP_LANG
- 18 CANTINE_ORDER
- 19 CANTINE_ORDER_ITEM
- 20 CANTINE_PLU
- 21 CANTINE_PLU_CATEGORY
- 22 CANTINE_SETTINGS
- 23 CLOSED_ACCOUNT_SEND
- 24 DB_ACTUAL_SESSIONS
- 25 DB_INDEX
- 26 DB_SEQUENCE
- 27 DB_TABLE_COLUMN
- 28 EXTSYS_HOREC
- 29 EXTSYS_HOREC_ACCOM_GUEST
- 30 EXTSYS_LOYALITY
- 31 EXTSYS_LOYALITY_BILL
- 32 EXTSYS_LOYALITY_BILL_ITEM
- 33 EXTSYS_LOYALITY_BILL_VOUCHER
- 34 EXTSYS_SAP_VW
- 35 EXTSYS_SAP_VW_GROUP
- 36 EXTSYS_SAP_VW_PLU_CAT
- 37 EXTSYS_SAP_VW_SYNCHRO_LOG
- 38 FM_BILL
- 39 FM_CLOSING
- 40 FM_INVOICE
- 41 G_AKCIA
- 42 G_AKCIA_LIMIT
- 43 G_AKCIA_TYP_ODBYTU
- 44 G_AKCIA_TYP_ODBYTU_LANG
- 45 G_AKCIA_TYP_UDALOSTI
- 46 G_AKCIA_UDALOST
- 47 G_AKCIA_UDALOST_POLOZKA
- 48 G_BALIK_PLU
- 49 G_BALIK_PLU_KASY
- 50 G_BALIK_PLU_POLOZKY
- 51 G_CENOVY_PROFIL
- 52 G_CENOVY_PROFIL_ZLAVA
- 53 G_CISLO_DOKLADU
- 54 G_CONSTANTS
- 55 G_CONSTANTS_LANG
- 56 G_DEN_V_TYZDNI
- 57 G_DEN_V_TYZDNI_LANG
- 58 G_DOCHADZKA_LOGOVANIE
- 59 G_DOCHADZKA_NASTAVENIA
- 60 G_DOCHADZKA_OBJEKT
- 61 G_DOCHADZKA_UZIVATEL
- 62 G_DOKLAD_NEODPISANY_TOVAR
- 63 G_DOKLAD_POHYBY_JEDLA
- 64 G_DOKLAD_POHYBY_TOVARU
- 65 G_DOKLAD_POHYBY_TOVARU_CCP
- 66 G_DOKLAD_POHYBY_TOVARU_DPH
- 67 G_DOKLAD_STAV
- 68 G_DOKLAD_STAV_LANG
- 69 G_DOKLAD_TOVAR_NA_ODPISANIE
- 70 G_DOKLAD_VYROBA_POLOT
- 71 G_DPT
- 72 G_DRUH_POHYBU
- 73 G_DRUH_POHYBU_TYPY
- 74 G_DRUH_POHYBU_TYPY_LANG
- 75 G_DRUH_TOVAR_JEDLO
- 76 G_EXTERNAL_MESSAGE
- 77 G_EXTERNAL_ORDER
- 78 G_EXTERNAL_ORDER_GOLF
- 79 G_EXTERNAL_ORDER_ITEMS
- 80 G_EXTERNAL_PDA_CLIENT
- 81 G_EXTERNE_SYSTEMY
- 82 G_EXTERNE_SYSTEMY_EKONOMIKA
- 83 G_EXTERNE_SYSTEMY_EXT_GOLF
- 84 G_EXTERNE_SYSTEMY_EXT_PDA
- 85 G_EXTERNE_SYSTEMY_FIDELIO
- 86 G_EXTERNE_SYSTEMY_FIDELIO_IZBY
- 87 G_EXTERNE_SYSTEMY_FIDELIO_ZI
- 88 G_EXTERNE_SYSTEMY_GASTRO
- 89 G_EXTERNE_SYSTEMY_HOTSYS
- 90 G_EXTERNE_SYSTEMY_KAMERA
- 91 G_EXTERNE_SYSTEMY_ORDERS
- 92 G_EXTERNE_SYSTEMY_SAP
- 93 G_EXTERNE_SYSTEMY_TAP_DEV
- 94 G_EXTERNE_SYSTEMY_TAP_SYS
- 95 G_EXTERNE_SYSTEMY_VTS
- 96 G_EXTERNE_SYSTEMY_VYCAP
- 97 G_EXTERNE_SYSTEMY_WELLNESS_L
- 98 G_EXTERNE_SYSTEMY_WELLNESS_S
- 99 G_EXT_MESSAGE_STATE_CHANGE
- 100 G_EXT_ORDER_STATE_CHANGE
- 101 G_EXT_SYS_KASA
- 102 G_EXT_SYS_LIST
- 103 G_EXT_SYS_LIST_GOODS
- 104 G_EXT_SYS_LIST_SEND
- 105 G_EXT_SYS_ORDERS_AKCIA
- 106 G_EXT_SYS_ORDERS_AKCIA_LANG
- 107 G_EXT_SYS_ORDERS_KASA
- 108 G_EXTSYS_PDA_TRANSACTIONS
- 109 G_EXT_SYS_PLATBA
- 110 G_EXT_SYS_PLU
- 111 G_EXT_SYS_PLU_KASA
- 112 G_EXT_SYS_REST_TABLE
- 113 G_EXT_SYSTEMY_EKON_VER_EXPORT
- 114 G_EXT_SYS_USER
- 115 G_FIRMA
- 116 G_GASTRO_VERSION
- 117 G_GRUPA
- 118 G_HODINY
- 119 G_CHANGES
- 120 G_CHANGES_ACTUAL_VALUES
- 121 G_CHANGES_FILE
- 122 G_CHOD
- 123 G_INV
- 124 G_INV_POLOZKA
- 125 G_INV_POL_ZDRUZOVANE
- 126 G_JEDLO
- 127 G_JEDNOTKA_MNOZSTVA
- 128 G_JEDNOTKA_MNOZSTVA_LANG
- 129 G_KALENDAR
- 130 G_KALKULACNA_PRIRAZKA
- 131 G_KAMERA_AKCIE
- 132 G_KAMERA_AKCIE_KASA
- 133 G_KAMERA_AKCIE_LANG
- 134 G_KAMERA_LOG
- 135 G_KARTA_EXT_SLUZBA
- 136 G_KASA
- 137 G_KASA_DPT
- 138 G_KASA_EURO
- 139 G_KASA_EURO_COMMANDS
- 140 G_KASA_EURO_COUNTRY
- 141 G_KASA_EURO_DPH
- 142 G_KASA_EURO_TYP
- 143 G_KASA_EXTERNAL
- 144 G_KASA_FISKALNY_MODUL_POSNET
- 145 G_KASA_GROUP
- 146 G_KASA_GROUP_KASY
- 147 G_KASA_HOREC
- 148 G_KASA_HOREC_DPH
- 149 G_KASA_KLAVESOVA_SKRATKA
- 150 G_KASA_KLAVESOVA_SKRATKA_LANG
- 151 G_KASA_NASTAVENIA_STANICE
- 152 G_KASA_NEVIDITELNOST
- 153 G_KASA_OBJ_STAV
- 154 G_KASA_OBJ_TYP
- 155 G_KASA_PORADIE_KAT
- 156 G_KASA_SADZBA_DPH
- 157 G_KASA_SETTINGS
- 158 G_KASA_SETTINGS_PREDOK
- 159 G_KASA_SETTINGS_VZOR
- 160 G_KASA_SPRAVA_STAV
- 161 G_KASA_SPRAVA_TYP
- 162 G_KASA_STATS_REPORT
- 163 G_KASA_STATS_SETTINGS
- 164 G_KASA_STATS_SETTINGS_KASY
- 165 G_KASA_STREDISKA
- 166 G_KASA_TYP
- 167 G_KASA_TYP_LANG
- 168 G_KASA_UZIVATEL
- 169 G_KASA_UZIVATEL_PREHLAD
- 170 G_KATEGORIA_PLU
- 171 G_KATEGORIA_PLU_VIAZANE
- 172 G_KREDITNE_PLU
- 173 G_LOG_ZMENY
- 174 G_LOG_ZMENY_STLPEC
- 175 G_LOG_ZMENY_STLPEC_LANG
- 176 G_LOKALNE_GASTRO
- 177 G_MASTER_PING_PONG_SETTINGS
- 178 G_MASTER_PING_PONG_STATS
- 179 G_MASTER_PP_SETTINGS_POL
- 180 G_MEGA_COUNTER
- 181 G_MESIAC
- 182 G_MESIAC_LANG
- 183 G_NEODPISANY_TOVAR
- 184 G_OBCHODNY_PARTNER
- 185 G_OBJ_BOD_ITEM_PARENT
- 186 G_OBJ_BOD_ITEM_SIETOVA
- 187 G_OBJ_BOD_ITEM_TERMINAL
- 188 G_OBJ_BOD_TO_ITEMS
- 189 G_OBJEDNAVKOVY_BOD
- 190 G_ODBERATEL_FAKTURA
- 191 GOODS_TRANSFER_KIND_EXT
- 192 GOODS_TRANSFER_ORDER
- 193 GOODS_TRANSFER_ORDER_ITEM
- 194 GOODS_TRANSFER_SEND
- 195 GP_AKCIA_LIMIT
- 196 GP_AKCIA_UDALOST
- 197 GP_AKCIA_UDALOST_POLOZKA
- 198 GP_BALIK_PLU_POLOZKY
- 199 GP_CENOVY_PROFIL_ZLAVA
- 200 G_PERCENTO_ALKOHOLU
- 201 GP_EXTERNE_SYSTEMY_TAP_DEV
- 202 GP_EXTSYS_FIDELIO_ZASL_ITEMS
- 203 GP_EXT_SYS_ORDERS_KASA
- 204 GP_EXT_SYS_PLU
- 205 GP_EXT_SYS_PLU_KASA
- 206 GP_EXT_SYS_REST_TABLE
- 207 GP_EXT_SYS_USER
- 208 GP_GOODS_EAN
- 209 GP_IMPORT_TOVAROV
- 210 G_PLATBY_PLANOVANIE
- 211 G_PLATBY_PLANOVANIE_KASY
- 212 G_PLAT_KARTA_TYP
- 213 G_PLU
- 214 G_PLU_CENY_V_MENACH
- 215 G_PLU_EXT
- 216 G_PLU_KASA
- 217 G_PLU_KASA_ROZPRACOVANE
- 218 G_PLU_KLAVESOVA_SKRATKA
- 219 G_PLU_LG_POCET
- 220 G_PLU_LG_POCET_ZMENA
- 221 G_PLU_SEGMENT
- 222 G_PLU_TARA
- 223 GP_ODVOD
- 224 G_POHYB_JEDLA
- 225 G_POHYB_JEDLA_UDALOST
- 226 G_POHYB_TOVARU
- 227 GP_PLU_CENY_V_MENACH
- 228 GP_PLU_KASA
- 229 GP_POHYB_JEDLA
- 230 GP_POHYB_JEDLA_UDALOST
- 231 GP_POHYB_TOVARU
- 232 GP_PORADIE_KATEGORII
- 233 GP_PROD_TERMINAL_CLIENTS
- 234 G_PRACOVNA_STANICA
- 235 G_PRACOVNA_STANICA_ZARIADENIE
- 236 GP_RECEPT
- 237 G_PREDAJ_GRUPA
- 238 G_PREDAJ_HODINY
- 239 G_PREDAJ_PLU
- 240 G_PREDAJ_PLU_TRN
- 241 G_PREDAJ_TRN
- 242 G_PREDAJ_TRZBY
- 243 G_PREDAJ_UCTUJUCI_DRUHY
- 244 G_PREDAJ_UCTUJUCI_TRN
- 245 G_PREDEFINED_COLORS
- 246 G_PREPOCET_NASTAVENIA
- 247 G_PREVADZKA
- 248 G_PREVOD_DRUHOV_TOVAROV
- 249 G_PRIESTOR
- 250 GP_ROZPIS_SUROVIN
- 251 GP_TJ_CENA_V_MENE
- 252 GP_TOVAR_ZMENA_KCIEN
- 253 GP_UCTOVACI_PROFIL_POLOZKY
- 254 GP_ZAMENA_SUROVIN
- 255 GP_ZMENA_SADZBY_DPH
- 256 G_RECEPT
- 257 G_REST_PRIESTOR
- 258 G_REST_PRIESTOR_NEVIDITELNOST
- 259 G_REST_PRIESTOR_PORADIE
- 260 G_REST_STOL
- 261 G_ROZPRACOVANOST
- 262 G_ROZSIAHLY_EUR_FORMULAR
- 263 G_SADZBA_DPH
- 264 G_SETTINGS
- 265 G_SLUZBA
- 266 G_SLUZBA_EXT_ERS
- 267 G_SPINTOTAL_DAVKA
- 268 G_SPINTOTAL_PLULIST_LOG
- 269 G_SPOSOB_PLATBY
- 270 G_SPOSOB_PLATBY_DPH
- 271 G_SPOSOB_PLATBY_KATEGORIA
- 272 G_SPOSOB_PLATBY_SKUPINA
- 273 G_SPOSOB_PLATBY_SKUP_PRIR
- 274 G_SPOSOB_PLATBY_TYP
- 275 G_SPOSOB_PLATBY_TYP_LANG
- 276 G_SPOSOB_PLATBY_UZIVATEL
- 277 G_STASTNE_HODINY
- 278 G_STAV_TOVARU
- 279 G_STREDISKO
- 280 G_STREDISKO_TYP
- 281 G_STREDISKO_TYP_LANG
- 282 G_STREDISKO_UZIVATEL
- 283 G_STREDISKO_UZIVATEL_POHYB
- 284 G_STREDISKO_UZIVATEL_PREZ_STAV
- 285 G_SUBJEKT
- 286 G_TABLES
- 287 G_TOVAR
- 288 G_TOVAR_JEDLO
- 289 G_TOVAR_JEDLO_CENA
- 290 G_TOVAR_JEDLO_CENA_V_MENE
- 291 G_TOVAR_JEDLO_EAN
- 292 G_TOVAR_NA_ODPISANIE
- 293 G_TOVAR_ODPIS_ALTERNATIVY
- 294 G_TRN
- 295 G_TRN_KATEGORIA
- 296 G_TRN_KATEGORIA_LANG
- 297 G_TYP_POLOZKY_OBJEDNAVKY
- 298 G_TYPY_EKON_EXTERNYCH_SYSTEMOV
- 299 G_UCTOVACI_PROFIL
- 300 G_UCTOVACI_PROFIL_POLOZKY
- 301 G_UCTOVNY_DRUH
- 302 GUEST_CREDIT_ACCOUNT_CHANGE
- 303 G_USEK
- 304 G_UZAVIERKA
- 305 G_UZAVIERKA_STR_ALK_NEW_STAV
- 306 G_UZAVIERKA_STR_ALKOHOL_NEW
- 307 G_UZAVIERKA_STREDISKO
- 308 G_UZAVIERKA_STREDISKO_ALK_PRIJ
- 309 G_UZAVIERKA_STREDISKO_ALK_STAV
- 310 G_UZAVIERKA_STREDISKO_TOVAR
- 311 G_UZAVIERKA_TYP
- 312 G_UZAVIERKA_TYP_LANG
- 313 G_UZIVATEL_OBCHODNY_PARTNER
- 314 G_VYCAP
- 315 G_VYROBA_POLOT_POLOZKY
- 316 G_VYROBA_POLOT_PREVOD
- 317 G_WEB_SERVICES
- 318 G_WEB_SERVICES_PROTOCOL_TYPE
- 319 G_WELLNESS_LITE_CARD
- 320 G_ZAKAZNICKY_DISPLEJ
- 321 G_ZAKAZNIK
- 322 G_ZAKAZNIK_EXTERNY
- 323 G_ZAKAZNIK_FIDELIO
- 324 G_ZAKAZNIK_HOTSYS
- 325 G_ZAKAZNIK_SAP_VW
- 326 G_ZAKAZNIK_STALY
- 327 G_ZAKAZNIK_STALY_KATEG_HOSTA
- 328 G_ZAKAZNIK_STALY_KRED_KONTO
- 329 G_ZAKAZNIK_STALY_TP
- 330 G_ZAKAZNIK_STALY_TP_LIST
- 331 G_ZAKAZNIK_STALY_TP_POL
- 332 G_ZAKAZNIK_STALY_TYP_UCTU
- 333 G_ZAKAZNIK_STALY_TYP_UCTU_LANG
- 334 G_ZAMESTNANCI_NASTAVENIA
- 335 G_ZAOKRUHLENIE
- 336 G_ZAOKRUHLENIE_LANG
- 337 G_ZAOKRUHLENIE_TYP
- 338 G_ZAOKRUHLENIE_TYP_LANG
- 339 G_ZARIADENIE
- 340 G_ZARIADENIE_CITACKA_KARIET
- 341 G_ZARIADENIE_KOD_TYP
- 342 G_ZARIADENIE_KOD_TYP_PRAVIDLA
- 343 G_ZARIADENIE_PORT
- 344 G_ZARIADENIE_TYP
- 345 G_ZARIADENIE_TYP_LANG
- 346 G_ZLAVA
- 347 G_ZLAVA_UZIVATEL
- 348 G_ZS_UCT_KONTO_TYP
- 349 G_ZS_UCT_KONTO_TYP_LANG
- 350 HC_ST
- 351 HC_ST_LANG
- 352 HC_TO
- 353 HC_VLAJKA
- 354 HC_VLAJKA_LANG
- 355 HELP_LINK
- 356 HK_FI
- 357 HP_ARCHIV
- 358 HP_FAJKA
- 359 HP_FAJKA_LONG
- 360 HP_LIST
- 361 HP_ZOZNAM
- 362 INFO_MESSAGE_CUSTOMER
- 363 INFO_MESSAGE_CUSTOMER_CALL
- 364 INFO_MESSAGE_CUSTOMER_READ
- 365 K_CISLO_ODVOD
- 366 K_CISLO_UCTU
- 367 K_CISLO_UZAVIERKA
- 368 K_CISLO_UZAVIERKA_NASTAVENIA
- 369 K_DENNY_UCET
- 370 K_DENNY_UCET_ERS_EXT
- 371 K_DENNY_UCET_PLATBA
- 372 K_DENNY_UCET_POL_ERS_EXT
- 373 K_DENNY_UCET_POLOZKA
- 374 K_EXT_SYS_TAP_DEV_SENT
- 375 K_FAKTURA
- 376 K_GRUPA
- 377 K_HODINY
- 378 K_KL_HISTORIA
- 379 K_KL_KURZ
- 380 K_KL_KURZOVY_LISTOK
- 381 K_KL_MENA
- 382 K_KL_SYSTEM
- 383 K_OTVORENY_UCET
- 384 K_OTVORENY_UCET_POL_CHOD
- 385 K_OTVORENY_UCET_POLOZKA
- 386 K_PLANOVANIE_PLATIEB_SUMA
- 387 K_PLU
- 388 K_PLU_KASA
- 389 K_PLU_STAT
- 390 K_POZNAMKA_OBJEDNAVKA
- 391 K_POZNAMKA_OBJEDNAVKA_KAT
- 392 KP_PRACOVNY_UCET
- 393 KP_PRACOVNY_UCET_PLATBA
- 394 KP_PRACOVNY_UCET_POL_CHOD
- 395 KP_PRACOVNY_UCET_POLOZKA
- 396 K_TRN
- 397 K_TRN_ODVOD
- 398 K_TRN_ODVOD_ARCHIVNY
- 399 K_TRN_ODVOD_ARCHIVNY_POLOZKY
- 400 K_UCTUJUCI_TRN
- 401 K_UNPRINTED_BILLS
- 402 K_ZIADANKA_VRATENIE_TOVARU
- 403 K_ZIADANKA_VRATENIE_TOVARU_POL
- 404 L_FUNKCIA
- 405 L_FUNKCIA_TEXT
- 406 L_FUNKCIA_TEXT_LANG
- 407 L_FUNKCIA_VZOR_VIDITELNOSTI
- 408 L_MODUL
- 409 LOG_FIS_BILL_ATTEMPTS
- 410 LOG_FIS_CLOSING_ATTEMPTS
- 411 LOG_CH_GUEST_ABIDING
- 412 L_ROLA
- 413 L_ROLA_LANG
- 414 L_UZIVATEL
- 415 L_UZIVATEL_FUNKCIA
- 416 L_UZIVATEL_MODUL
- 417 L_UZIVATEL_PREDOK
- 418 L_UZIVATEL_ROLA
- 419 L_VZORY_VIDITELNOSTI
- 420 PAYMENT_GROUP_LIMITS
- 421 PRCPRF_ALT_PRICELEVEL_PLU
- 422 PRCPRF_CHANGE_BY_BILL
- 423 PREINVENTORY
- 424 PREINVENTORY_ITEM
- 425 PREINVENTORY_LOADED_IN
- 426 PRINTER
- 427 PRINT_CHANNEL
- 428 PRINT_CHANNEL_LANG
- 429 PRINT_CHANNEL_ON_WS
- 430 PRINT_SEQUENCES
- 431 PRINT_TAG
- 432 SAP_MESSAGE
- 433 SBL_CLOSING
- 434 SBL_ESTAB_DEPARTMENT
- 435 SBL_ESTABLISHMENT
- 436 SBL_EVIDENCE
- 437 T_GROUP
- 438 T_ITEM
- 439 T_MESSAGE
- 440 T_ORDER
- 441 T_STATE_CHANGE
- 442 T_ZAKAZNIK_STALY_KREDIT_ZMENA
- 443 VERSION
- 444 VPP_DEVICE
- 445 Z_STAT_ZOSTAVA
- 446 Z_STAT_ZOSTAVA_STLPEC
- 447 Z_STAT_ZOSTAVA_STLPEC_CIS
- 448 Z_STAT_ZOST_STL_TYP
- 449 Z_STAT_ZOST_STL_TYP_EXT
- 450 Z_STAT_ZOST_STL_TYP_EXT_LANG
- 451 Z_STAT_ZOST_STL_TYP_LANG
ALACARTE_COUNTERS
[table description]
- ALC_ORDER_ID_CNT - [column description]
- ALC_TRANSACTION_ID_CNT - [column description]
- ALC_INFO_NUMBER_CNT - [column description]
- ALC_INFO_NUMBER_LAST_UPDATE - [column description]
B_FILE_REPORT_SETTINGS
[table description]
- FRS_ID - [column description]
- FRS_REPORT_NAME - [column description]
- FRS_ATTRIBUTE_NAME - [column description]
- FRS_ATTRIBUTE_VALUE - [column description]
B_JAZYK
Systémom podporované jazyky.
- JAZ_KOD_JAZYKA - Kód jazyka.
- JAZ_PORADIE - Poradie.
B_JAZYK_LANG
Multilingválna tabuľka.
- LJAZ_ID - [column description]
- > B_JAZYK.JAZ_KOD_JAZYKA
- LJAZ_NAZOV - [column description]
- LJAZ_LANG - [column description]
- > B_JAZYK.JAZ_KOD_JAZYKA
B_OBJEKT
(refaktor)
- OBJ_TABULKA - [column description]
- OBJ_NAZOV - [column description]
B_OBJEKT_COMMAND
(refaktor)
- OBC_ID_OBJEKT - [column description]
- OBC_MENO - [column description]
- OBC_COMMAND - [column description]
B_OBJEKT_LANG
Multilingválna tabuľka.
- OBJ_ID - [column description]
- > B_OBJEKT.OBJ_TABULKA
- OBJ_NAZOV - [column description]
- OBJ_LANG - [column description]
- > B_JAZYK.JAZ_KOD_JAZYKA
B_OBJEKT_TYP
(refaktor) Typy rôznych objektov použiteľných v BG (využitie napr. zákaznícky displej).
- OBT_ID - [column description]
- OBT_NAZOV - [column description]
- OBT_TEXT - [column description]
B_OBJEKT_TYP_LANG
Multilingválna tabuľka.
- OBT_ID - [column description]
- > B_OBJEKT_TYP.OBT_ID
- OBT_TEXT - [column description]
- OBT_LANG - [column description]
B_TAB_NAR_ZNAKOV
(refaktor) Znakové sady (využitie napr. zákaznícky displej).
- NZT_ID - [column description]
- NZT_NAZOV - [column description]
- NZT_POPIS - [column description]
B_TAB_NAR_ZNAKOV_LANG
Multilingválna tabuľka.
- NZT_ID - [column description]
- > B_TAB_NAR_ZNAKOV.NZT_ID
- NZT_NAZOV - [column description]
- NZT_POPIS - [column description]
- NZT_LANG - [column description]
B_TAB_NAR_ZNAKY_POLOZKA
(refaktor) Jednotlivé znaky znakovej sady.
- NZP_ID_TAB_NAR_ZNAKOV - [column description]
- NZP_JAZYK - [column description]
- NZP_ZNAK_NATIVE - [column description]
- NZP_ZNAK_ASCII - [column description]
B_TEMPLATE
(refaktor) Šablóny (využitie napr. zákaznícky displej).
- TEM_ID_TEMPLATE_SKUPINA - [column description]
- TEM_ID_TEMPLATE_TYP - [column description]
- TEM_TEXT - [column description]
B_TEMPLATE_SKUPINA
(refaktor) Skupiny šablón (využitie napr. zákaznícky displej).
- TES_ID_TEMPLATE_SKUPINA - [column description]
- TES_ID_OBJEKT_TYP - [column description]
- TES_NAZOV - [column description]
B_TEMPLATE_SKUPINA_LANG
Multilingválna tabuľka.
- TES_ID - [column description]
- > B_TEMPLATE_SKUPINA.TES_ID_TEMPLATE_SKUPINA
- TES_NAZOV - [column description]
- TES_LANG - [column description]
B_TEMPLATE_TYP
(refaktor) Typy šablón (využitie napr. zákaznícky displej).
- BTT_ID - [column description]
- BTT_ID_OBJEKT_TYP - [column description]
- BTT_NAZOV - [column description]
- BTT_TEXT - [column description]
B_TEMPLATE_TYP_LANG
Multilingválna tabuľka.
- BTT_ID - [column description]
- > B_TEMPLATE_TYP.BTT_ID
- BTT_TEXT - [column description]
- BTT_LANG - [column description]
CANTINE_ORDER
Tabulka objednavky klienta CANTiNE.
- COR_ID - Jednoznacny identifikator objednavky.
- COR_CREATE_DATETIME - Datum a cas vytvorenia objednavky.
- COR_ORDER_DATE - Datum objednavky, resp. pre aky den je objednavka platna.
- COR_GUEST_ABIDING_ID - Prepojenie objednavky na staleho hosta.
- > G_ZAKAZNIK_STALY.ZAS_ID_ZAKAZNIK_STALY
- COR_ORDER_STATE - Stav objednavky. 1-aktivna, 2-zrusena, 3-vydane(odobrane), 4-stornovana.
- COR_PAYED_DAILY_ACCOUNT_ID - Identifikacne cislo denneho uctu, ktorym bola objednavka zaplatena.
- > K_DENNY_UCET.DUC_ID_UCET
- COR_CHANGE_DATETIME - Datum a cas poslednej zmeny, ktora bola vykonana na objednavke.
CANTINE_ORDER_ITEM
Tabulka polozky objednavky klienta CANTiNE.
- COI_ID - Jedinecny identifikator tabulky.
- COI_CANTINE_ORDER_ID - Prepojenie na objednavku, ktorej patri dana polozka.
- > CANTINE_ORDER.COR_ID
- COI_NAME - Nazov objednanej polozky.
- COI_QUANTITY - Mnozstvo objednanej polozky
- COI_UNIT_PRICE - Jednotkova cena objednanej polozky.
- COI_PLU_ID - Prepojenie na PLU.
- COI_ITEM_STATE - Stav polozky objednavky. 1-aktivna, 2-zrusena, 3-vydana(odobrana), 4-stornovana.
- COI_CREATE_DATETIME - Datum sa cas vytvorenia polozky
- COI_CHANGE_DATETIME - Datum a cas poslednej zmeny.
CANTINE_PLU
Tabulka povolenych PLU pre klienta CANTiNE.
- CAP_ID - Jedinecny identifikator tabulky.
- CAP_PLU_ID - Prepojenie na PLU.
- > G_PLU.PLU_ID_PLU
CANTINE_PLU_CATEGORY
Tabulka povolenych kategorii PLU pre klienta CANTiNE.
- CPC_ID - Jedinecny identifikator tabulky.
- CPC_PLU_CATEGORY_ID - Prepojenie na kategoriu PLU.
- > G_KATEGORIA_PLU.KAP_ID
- CPC_MAX_ORDERED_PLU - Maximalny povoleny pocet PLU na objednanie z danej kategorie.
CANTINE_SETTINGS
Tabulka nastaveni pre klienta CANTiNE.
- CSE_DAYS_AHEAD - Kolko dni dopredu sa moze objednavat
- CSE_DAYS_ORDER_ENB - Kolko dni od dna objednavky sa moze robit zmena.
- CSE_HOURS_ORDER_ENB - Do ktorej hodiny je mozne vykonat zmenu objednavky.
- CSE_ID - Jedinecny identifikator tabulky.
CLOSED_ACCOUNT_SEND
Všeobecné záznamy o odoslaných účtoch do externých systémov.
- CAS_ID - [column description]
- CAS_CLOSED_ACCOUNT_ID - ID zaslaného účtu.
- > K_DENNY_UCET.DUC_ID_UCET
- CAS_TIME_INIT - Čas vytvorenia záznamu.
- CAS_TIME_SENT - Čas zaslania účtu.
- CAS_MESSAGE - Správa o (ne)úspešnosti zaslania.
- CAS_EXT_SYS_ID - ID externého systému.
- > G_EXTERNE_SYSTEMY.EXS_ID
DB_ACTUAL_SESSIONS
Došasné informácie o aktuálne pripojených klientoch na DB. Informácie sú k dispozícii iba v čase, kedy je pripojenie klienta aktívne. Toto slúži hlavne pre logovacie tabuľky fungujúce na systéme triggrov, ktoré si zisťujú kto, kedy a ako zmenil nejaké dáta.
- SESSION_ID - ID pripojenia do DB.
- DB_USER - DB užívateľ.
- HOST_NAME - IP/hostname, odkiaľ sa pripojenie uskutočnilo.
- TERMINAL_NAME - Názov terminálu.
- INIT_DATE - Čas a dátum začiatku pripojenia.
- APPLICATION_CLIENT_NAME - Názov aplikácie, ktorá sa pripája.
- APPLICATION_USER_ID - ID užívateľa z aplikácie.
- APPLICATION_USER_LOGIN_DATE - Čas a dátum, kedy sa užívateľ do aplikácie prihlásil.
- APPLICATION_IDENTIFIER - Univerzálny stĺpec pre identifikátor aplikácie.
- WORKSTATION_IDENTIFIER - Identifikátor (názov) pracovnej stanice.
DB_INDEX
Informácie o indexoch, ktoré sa vytvárajú (ak už neexistujú) pri štarte BG.
- DBI_ID - [column description]
- DBI_TABLE_NAME - Názov tabuľky, na ktorej stĺpci/stĺpcoch bude index.
- > G_TABLES.GTA_NAZOV
- DBI_COLUMN_NAME - Stĺpec indexu
DB_SEQUENCE
Informácie o sekvenciách, ktoré musia na databáze existovať pre správny chod systému - generovanie ID. Náhrada za historický HC_COUNTER.
- ID - [column description]
- SEQ_NAME - Generovaný názov sekvencie.
- SEQ_TABLE_NAME - Názov prislúchajúcej tabuľky.
- > G_TABLES.GTA_NAZOV
- SEQ_COLUMN_NAME - Názov stĺpca, pre ktorý sa sekvencia primárne vytvára.
- SEQ_PK - Príznak, či je sekvencia určená pre primárny kľúč, teda či je stĺpec sám o sebe PK.
- SEQ_ACTUAL_VALUE - Aktuálna hodnota sekvencie - vypĺňa sa len vtedy, pokial chceme sekvenciu reinicializovat s danou hodnotou.
DB_TABLE_COLUMN
[table description]
- TABLE_NAME - [column description]
- COLUMN_NAME - [column description]
- DESCRIPTION - [column description]
EXTSYS_HOREC
[table description]
- HOR_ID_HOREC - [column description]
- > G_EXTERNE_SYSTEMY.EXS_ID
- HOR_IMPORT_TOVARU_DATUM_CAS - [column description]
- HOR_EXPORT_TOVARU_DATUM_CAS - [column description]
- HOR_KOM_ADRESAR - [column description]
- HOR_BG_SYNCHRO_PERIOD - [column description]
- HOR_GIN - [column description]
- > G_LOKALNE_GASTRO.LGA_ID
EXTSYS_HOREC_ACCOM_GUEST
[table description]
- EXTSYS_EXT_ID - [column description]
- GUEST_NUMBER - [column description]
- GUEST_NAME - [column description]
- GUEST_ACTUAL - [column description]
- STATE_CODE - [column description]
- DATE_ARRIVAL - [column description]
- DATE_DEPARTURE - [column description]
- ROOM_NO - [column description]
- ACCOUNT_BLOCKED - [column description]
- PARTIAL_CHECKOUT - [column description]
- CARD_NO - [column description]
- LOYALITY_CARD_NO - [column description]
- BG_PRICE_PROFILE - [column description]
EXTSYS_LOYALITY
Externé systémy Loyality TMR.
- ELO_ID - [column description]
- ELO_GIN - Gastro Install Number.
- > G_LOKALNE_GASTRO.LGA_ID
- ELO_SEND_INTERVAL_START - Od akého momentu sa majú zasielať účty.
- ELO_SEND_INTERVAL_STOP - Do akého momentu sa môžu zasielať účty.
- ELO_SEND_REPEATS - Počet opakovaní zasielania.
- ELO_SEND_BREAK - Pauza medzi opakovaniami.
- ELO_SEND_BILL_TIMEOUT - Timeout pri zasielaní.
- ELO_CARD_DIGITS - Počet znakov čísla karty.
- ELO_ABORTED_AT - Čas a dátum núteného zrušenia zasielania.
- ELO_OFFLINE_ACCOUNTING - [column description]
- ELO_SEND_BILL_IMMEDIATELY - [column description]
- ELO_NAME_WITH_NOTE - [column description]
- ELO_VOUCHERS_MAX - [column description]
- ELO_DISCOUNT_POINTS - [column description]
- ELO_DISCOUNT_POINTS_ID - [column description]
- ELO_DISCOUNT_CREDIT - [column description]
- ELO_DISCOUNT_CREDIT_ID - [column description]
- ELO_DISCOUNT_VOUCHER - [column description]
- ELO_DISCOUNT_VOUCHER_ID - [column description]
- ELO_BILL_PRINT_GUEST_INFO - [column description]
- ELO_PLU_PRICE_REF_CASHDESK - [column description]
- ELO_SHOW_BILL_VALUE_IN_POINTS - [column description]
- ELO_POINT_VALUE - [column description]
- ELO_LAST_LIST_SEND_SUCCESS - [column description]
- ELO_LAST_LIST_SEND_ERROR - [column description]
EXTSYS_LOYALITY_BILL
Hlavičky účtov zasielaných do externých systémov Loyality TMR.
- LTB_ACCOUNT_ID - ID účtu
- > K_DENNY_UCET.DUC_ID_UCET
- LTB_SEND_ATTEMPTS - Počet pokus o odoslanie.
- LTB_LAST_SEND_ERROR - Správa z posledného pokusu o odoslanie.
- LTB_SUCCESSFULLY_SENT - Čas a dátum úspešného odoslania.
- LTB_INTO_FAULT_STACK - Čas a dátum zaradenia účtu do chybovej fronty.
- LTB_IN_FAULT_STACK - Počet, koľkokrát bol účet zaradený v chybovej fronte.
- LTB_INTO_SEND_STACK - Čas a dátum zaradenia účtu do fronty na odoslanie.
- LTB_DISCARDED - Čas a dátum úplného vyradenia z odosielania.
- LTB_STATE - Stav odosielania účtu.
- LTB_CARD_NUMBER - Číslo karty.
- LTB_EXTSYS_ID - [column description]
- LTB_CREDIT_POINTS_QUANTITY - [column description]
- LTB_CREDIT_POINTS_AMOUNT - [column description]
- LTB_CREDIT_AMOUNT - [column description]
- LTB_CREDIT_OVERDRAWN - [column description]
- LTB_CREDIT_P_THIS_TRANS - [column description]
- LTB_CREDIT_TOTAL - [column description]
- LTB_CREDIT_POINTS_TOTAL - [column description]
- LTB_MOTIVATIONAL_MESSAGE - [column description]
EXTSYS_LOYALITY_BILL_ITEM
[table description]
- LTBI_ACCOUNT_ID - [column description]
- > EXTSYS_LOYALITY_BILL.LTB_ACCOUNT_ID
- LTBI_ACCOUNT_ITEM_ID - [column description]
- LTBI_CARD_NUMBER - [column description]
EXTSYS_LOYALITY_BILL_VOUCHER
[table description]
- ALV_CLOSED_ACCOUNT_ID - [column description]
- > EXTSYS_LOYALITY_BILL.LTB_ACCOUNT_ID
- ALV_ORDER - [column description]
- ALV_CODE - [column description]
- ALV_NAME - [column description]
- ALV_AMOUNT - [column description]
- ALV_NOTE - [column description]
EXTSYS_SAP_VW
Externý systém SAP VW.
- XSVW_ID - ID záznamu.
- > G_EXTERNE_SYSTEMY.EXS_ID
- XSVW_IMPORT_TIME - Hodina a minúta importu.
- XSVW_IMPORT_FILE_PATH - Súbor pre import.
- XSVW_EXPORT_TIME - Hodina a minúta exportu.
- XSVW_EXPORT_FILE_PATH - Súbor pre export.
- XSVW_EXPORT_LINE_SEPARATOR - [column description]
EXTSYS_SAP_VW_GROUP
Skupiny hostí pre externý systém SAP VW.
- XSVWG_ID - ID záznamu.
- XSVWG_NUMBER - Číslo skupiny.
- XSVWG_NAME - Názov skupiny.
- XSVWG_EXT_SYS_ID - ID externého systému SAP VW.
- > EXTSYS_SAP_VW.XSVW_ID
- XSVWG_BUSINESS_PARTNER_ID - ID obchodného partnera.
- > G_OBCHODNY_PARTNER.COP_ID_OBCHODNY_PARTNER
- XSVWG_GUEST_CATEGORY_ID - ID kategórie hosťa.
- > G_ZAKAZNIK_STALY_KATEG_HOSTA.ZKH_ID
- XSVWG_CREDIT_CHANGE_OPERATION - Kód operácie s kreditom (nastaviť vs. pripočítať).
- XSVWG_CREDIT_CHANGE_AMOUNT - Výška kreditu pre nastavenie resp. pripočítanie pri importe.
- XSVWG_DELETED - Ak true, zmazaný.
- XSVWG_ENABLED - Ak true, povolený.
EXTSYS_SAP_VW_PLU_CAT
[table description]
- XSVWPG_ID_EXSYS - [column description]
- > EXTSYS_SAP_VW.XSVW_ID
- XSVWPG_ID_CATEGORY - [column description]
- > G_KATEGORIA_PLU.KAP_ID
EXTSYS_SAP_VW_SYNCHRO_LOG
Záznam importu a exportu externého systému SAP VW.
- XSVWL_ID - ID záznamu.
- XSVWL_EXT_SYS_ID - [column description]
- > EXTSYS_SAP_VW.XSVW_ID
- XSVWL_OPERATION - Kód operácie import vs. export.
- XSVWL_DATE_TIME - Dátum a čas operácie.
- XSVWL_RECORDS_SUCCESSFUL - Počet úspešných záznamov.
- XSVWL_RECORDS_FAILED - Počet neúspešných záznamov.
- XSVWL_FAILURES - Clob zápis o chybe.
FM_BILL
História účtov zasielaných do fiskálnych modulov. (Tabulka vo verzii 3 zanika, informacie sa pripajaju priamo k uctu do novej struktury K_OTVORENY_UCET, ktora je popisana)
- BFM_ID_BILL - [column description]
- > K_DENNY_UCET.DUC_ID_UCET
- BFM_SEND_REJECTED_DATE - Dátum a čas posledného odmietnutia zaslania účtu do fiskálneho modulu.
- BFM_SENT_DATE - Dátum a čas úspešného zaslania účtu do fiskálneho modulu.
- BFM_FM_BILL_ID - Číslo účtu z fiskálneho modulu.
- BFM_FM_CLOSING_ID - Číslo uzávierky z fiskálneho modulu.
- BFM_FM_SERIAL_NUMBER - Sériové číslo fiskálneho modulu, na ktorý bol účet odoslaný.
- BFM_DKP - DKP pokladne.
FM_CLOSING
História uzávierok vykonaných na fiskálnych moduloch.
- FMC_ID - [column description]
- FMC_FM_CLOSING_ID - ID uzávierky
- FMC_FM_SERIAL_NUMBER - Sériové číslo FM.
- FMC_DKP - DKP BG pokladne, z ktorej bola uzávierka iniciovaná.
- FMC_SYSTEM_DATE_TIME - Lokálny čas a dátum vykonania uzávierky.
- FMC_USER - ID užívateľa, ktorý uzávierku vykonal.
- FMC_SALE_DATE - [column description]
- FMC_DOCUMENT_FILE_NAME - [column description]
FM_INVOICE
História faktúr zasielaných do fiskálnych modulov.
- FIS_ID - [column description]
- FIS_NAME - Názov.
- FIS_SAVE_DATE - Čas a dátum zápisu faktúry.
- FIS_SUM - Celková suma.
- FIS_CURRENCY_CODE - Kód meny.
- FIS_USER_ID - ID užívateľa.
- > L_UZIVATEL.UZ_ID_UZIVATEL
- FIS_CASHDESK_ID - ID pokladne.
- > G_KASA.CKA_CISLO_KASY
- FIS_PAYMENT_TYPE_ID - ID spôsobu platby.
- > G_SPOSOB_PLATBY.SPL_ID_SPOSOB_PLATBY
- FIS_MESSAGE - Správa z pokusu zasielania.
- FIS_IS_SENT - Príznak úspešného zaslania do FM.
G_AKCIA
Hlavičky akcií cenových limitov a objednávok jedál.
- AKC_ID_AKCIA - [column description]
- AKC_DATUM_OD - Dátum začiatku platnosti akcie.
- AKC_DATUM_DO - Dátum ukončenia platnosti akcie.
- AKC_NAZOV - Názov akcie.
- AKC_POCET_OSOB - Počet osôb, pre koľko je akcia určená.
- AKC_ID_ODBERATEL - ID odberateľa.
- > G_SUBJEKT.SUB_ID_SUBJEKT
- AKC_STAV - Stav akcie.
- AKC_ID_ZAPISAL - ID užívateľa, ktorý akciu vytvoril.
- > L_UZIVATEL.UZ_ID_UZIVATEL
- AKC_DATUM_CAS_VYTVORENIA - Čas a dátum vytvorenia akcie.
- AKC_MARZA - Marža.
- AKC_TYP - Typ akcie.
- AKC_CISLO_POKLADNA - ID pokladne.
- > G_KASA.CKA_CISLO_KASY
G_AKCIA_LIMIT
Limity pre akciu cenové limity.
- AKL_ID_AKCIA - [column description]
- > G_AKCIA.AKC_ID_AKCIA
- AKL_ID_TYP_UDALOSTI - [column description]
- > G_AKCIA_TYP_UDALOSTI.ATU_ID_TYP_UDALOSTI
- AKL_LIMIT - [column description]
G_AKCIA_TYP_ODBYTU
(na refaktor) Typy odbytu (len Stredisko, Pokladňa ... nič iné, zbytočné)
- ATO_TYP_ODBYTU - [column description]
- ATO_NAZOV - [column description]
- ATO_KRATKY_NAZOV - [column description]
G_AKCIA_TYP_ODBYTU_LANG
Multilingválna tabuľka.
- ATO_ID - [column description]
- > G_AKCIA_TYP_ODBYTU.ATO_TYP_ODBYTU
- ATO_NAZOV - [column description]
- ATO_KRATKY_NAZOV - [column description]
- ATO_LANG - [column description]
G_AKCIA_TYP_UDALOSTI
Typy udalostí pre akcie.
- ATU_ID_TYP_UDALOSTI - [column description]
- ATU_NAZOV - [column description]
- ATU_TYP - [column description]
- ATU_CENA - [column description]
- ATU_ID_PLU - [column description]
- ATU_ID_STREDISKO - [column description]
- ATU_CAS_PLATNOSTI_OD - [column description]
- ATU_CAS_PLATNOSTI_DO - [column description]
- ATU_UCTOVNY_DRUH_ID - [column description]
- > G_UCTOVNY_DRUH.UDR_ID
G_AKCIA_UDALOST
Udalosti akcií.
- AKU_ID_UDALOST - [column description]
- AKU_ID_AKCIA - [column description]
- > G_AKCIA.AKC_ID_AKCIA
- AKU_DATUM_CAS_REALIZACIE - [column description]
- AKU_TYP_ODBYTU - [column description]
- AKU_POCET_OSOB - [column description]
- AKU_ID_STREDISKO - [column description]
- > G_STREDISKO.CST_ID_STREDISKO
- AKU_CISLO_POKLADNE - [column description]
- > G_KASA.CKA_CISLO_KASY
- AKU_POZNAMKA - [column description]
- AKU_STAV - [column description]
- AKU_ID_ZAPISAL - [column description]
- > L_UZIVATEL.UZ_ID_UZIVATEL
- AKU_DATUM_CAS_VYTVORENIA - [column description]
- AKU_ID_TYP_UDALOSTI - [column description]
- > G_AKCIA_TYP_UDALOSTI.ATU_ID_TYP_UDALOSTI
- AKU_MARZA - [column description]
- AKU_POCET_REAL - [column description]
- AKU_NA_JEDNU_STRAVNU_JEDNOTKU - [column description]
- AKU_CAS_PLATNOSTI_OD - [column description]
- AKU_CAS_PLATNOSTI_DO - [column description]
G_AKCIA_UDALOST_POLOZKA
Položky udalostí akcií.
- AUP_ID_UDALOST - [column description]
- > G_AKCIA_UDALOST.AKU_ID_UDALOST
- AUP_PORADIE - [column description]
- AUP_ID_TOVAR_JEDLO - [column description]
- > G_TOVAR_JEDLO.CTJ_ID_TOVAR_JEDLO
- AUP_MNOZSTVO - [column description]
- AUP_ID_ODBYT_STRED - [column description]
- > G_STREDISKO.CST_ID_STREDISKO
- AUP_KALK_CENA - [column description]
- AUP_ID_TYP_POLOZKY_OBJEDNAVKY - [column description]
G_BALIK_PLU
Hlavičky balíkov PLU.
- BPL_ID - [column description]
- BPL_ID_KATEGORIA - [column description]
- > G_KATEGORIA_PLU.KAP_ID
- BPL_NAZOV - [column description]
- BPL_CENA - [column description]
- BPL_DEN_V_TYZDNI - [column description]
- BPL_DATUM - [column description]
- BPL_CAS_OD - [column description]
- BPL_CAS_DO - [column description]
- BPL_KOD_PLU - [column description]
- BPL_IMAGE_DISABLED - [column description]
- BPL_IMAGE_DOUBLE_SIZE - [column description]
- BPL_IMAGE_SHOW_TEXT - [column description]
- BPL_IMAGE_ALIGN_HORIZONTAL - [column description]
- BPL_IMAGE_ALIGN_VERTICAL - [column description]
- BPL_TEXT_COLOR - [column description]
- BPL_PORADIE - [column description]
- BPL_IMAGE_FILE - [column description]
G_BALIK_PLU_KASY
Povolenie pre balík PLU na pokladni.
- BPK_ID - [column description]
- > G_BALIK_PLU.BPL_ID
- BPK_CISLO_KASY - [column description]
- > G_KASA.CKA_CISLO_KASY
G_BALIK_PLU_POLOZKY
Jednotlivé PLU, z ktorých sa balíky skladajú.
- BPP_ID - [column description]
- > G_BALIK_PLU.BPL_ID
- BPP_PORADIE - [column description]
- BPP_ID_PLU - [column description]
- BPP_MNOZSTVO - [column description]
G_CENOVY_PROFIL
Hlavičky cenových profilov.
- CPR_ID_CENOVY_PROFIL - [column description]
- CPR_NAZOV - [column description]
- CPR_CENOVA_HLADINA - [column description]
- CPR_ZPOSOB_UPLAT_ZLAVY - [column description]
- CPR_ID_ZLAVA_POLOZKOVA - [column description]
- CPR_ID_ZLAVA_CELKOM - [column description]
- CPR_NUMBER - [column description]
- CPR_ALT_PRLEVEL - Číslo alternatívnej cenovej hladiny.
- CPR_ALT_PRLEVEL_DISCOUNT_APPLY - Ak true, uplatní zľavu z cen. profilu aj na položky v alternatívnej cenovej hladine.
- CPR_ALT_PRLEVEL_ACC_LIMIT - Ak true, aplikuje alternatívnu cenovú hladinu iba do výšky zostatku kreditu na konte.
- CPR_ALT_PRLEVEL_ACC_LIM_W - Ak true, zobrazí upozornenie pri prekročení kreditu.
- CPR_ALT_PRLEVEL_CONFIRM - Ak true, zobrazí otázku pred aplikovaním alt. cenovej hladiny.
- CPR_ALT_PRLEVEL_MARK_PLU - Ak true, farebne zvýrazni na pokladni položky v alternatívnej cenovej hladine.
- CPR_ALT_PRICE_PROFILE_ID - ID alternatívneho cenového profilu.
- > G_CENOVY_PROFIL.CPR_ID_CENOVY_PROFIL
- CPR_ALT_PROF_ACCOUNT_MIN - Podmienka pre zmenu cenového profilu hosťa na alternatívny - zostatok kreditu menší ako.
- CPR_ALT_PROF_PLU_COUNT - Podmienka pre zmenu cenového profilu hosťa na alternatívny - Počet predaných PLU v alternatívnej hladine v účte väčší rovný ako.
- CPR_ALT_PRLEVEL_ENABLED - Ak true, je povolená alternatívna cenová hladina.
G_CENOVY_PROFIL_ZLAVA
Zľavy v cenových profiloch.
- CPR_ID_CENOVY_PROFIL - [column description]
- > G_CENOVY_PROFIL.CPR_ID_CENOVY_PROFIL
- CPR_ID_KATEGORIA_PLU - [column description]
- > G_KATEGORIA_PLU.KAP_ID
- CPR_ZLAVA - [column description]
- CPR_ID - [column description]
- CPR_KASA_GROUP_ID - [column description]
- > G_KASA_GROUP.KGR_ID
G_CISLO_DOKLADU
Stav countrov dokladov podľa druhu pohybu a id strediska.
- CDO_DRUH_POHYBU - [column description]
- CDO_ID_STREDISKO - [column description]
- CDO_CISLO_DOKLADU - [column description]
G_CONSTANTS
(na refaktor) Niektoré konštanty používané v systéme.
- CON_ID - [column description]
- CON_SKUPINA - [column description]
- CON_KOD - [column description]
- CON_SKRATKA - [column description]
- CON_KRATKY_NAZOV - [column description]
- CON_DLHY_NAZOV - [column description]
- CON_POZNAMKA - [column description]
G_CONSTANTS_LANG
Multilingválna tabuľka.
- CON_ID - [column description]
- > G_CONSTANTS.CON_ID
- CON_SKRATKA - [column description]
- CON_KRATKY_NAZOV - [column description]
- CON_DLHY_NAZOV - [column description]
- CON_LANG - [column description]
G_DEN_V_TYZDNI
Vymenované dni v týždni.
- DVT_ID_DEN_V_TYZDNI - [column description]
- DVT_TEXT - [column description]
- DVT_JAVA_DEN_V_TYZDNI - [column description]
G_DEN_V_TYZDNI_LANG
Multilingválna tabuľka.
- DVT_ID - [column description]
- > G_DEN_V_TYZDNI.DVT_ID_DEN_V_TYZDNI
- DVT_TEXT - [column description]
- DVT_LANG - [column description]
G_DOCHADZKA_LOGOVANIE
Logovanie zmien dochádzky.
- DOL_ID - [column description]
- DOL_TIMESTAMP - [column description]
- DOL_ID_UZIVATEL_ZMENIL - [column description]
- > L_UZIVATEL.UZ_ID_UZIVATEL
- DOL_ID_UZIVATEL_DOCHADZKY - [column description]
- > L_UZIVATEL.UZ_ID_UZIVATEL
- DOL_STARA_DOCHADZKA - [column description]
- DOL_NOVA_DOCHADZKA - [column description]
G_DOCHADZKA_NASTAVENIA
Nastavenie dochádzky.
- DON_ID - [column description]
- DON_MIN_CAS_DVOCH_ZMIEN - [column description]
- DON_MAX_PRAC_CAS - [column description]
- DON_PRIEMERNY_PRAC_CAS - [column description]
G_DOCHADZKA_OBJEKT
Použiteľné objekty dochádzky - napr. príchod práca/odchod.
- DOO_ID_OBJEKT - [column description]
- DOO_NAZOV - [column description]
- DOO_POCITAT_DO_PRAC_FONDU - [column description]
- DOO_POVOLENA - [column description]
G_DOCHADZKA_UZIVATEL
Záznamy dochádzky užívateľov.
- DOU_ID_DOCHADZKA - [column description]
- DOU_ID_UZIVATEL - ID zamestnanca.
- DOU_PRICHOD_ODCHOD - Príznak príchodu alebo odchodu.
- DOU_DATUM_CAS - Čas a dátum.
- DOU_CASOVA_ZNACKA - Systémový čas v ms.
- DOU_ID_PRVY_PRICHOD - ID odkazujúce sa na prvý príchod (do práce) za daný cyklus (deň).
- DOU_DATUM_PRVY_PRICHOD - Dátum prvého príchodu.
- DOU_ID_PARENT - ID záznamu, ku ktorému sa tento páruje. (Prvý odchod v dni sa páruje ku prvému príchodu za daný deň)
- DOU_ID_OBJEKT - ID objektu dochádzky.
- > G_DOCHADZKA_OBJEKT.DOO_ID_OBJEKT
- DOU_ZAZNAM_GENEROVANY - Príznak automaticky generovaného záznamu - automatické párovanie napr. pri zabudnutom odkliknutí odchodu.
- DOU_WORKSTATION_ID - [column description]
- > G_PRACOVNA_STANICA.PS_ID_STANICA
- DOU_CASHDESK_ID - [column description]
- > G_KASA.CKA_CISLO_KASY
G_DOKLAD_NEODPISANY_TOVAR
Hlavička dokladu o neodpísaných tovaroch.
- DNT_ID_DOKLAD_NEODPISANY_TOVAR - [column description]
- DNT_ID_UZAVIERKA - [column description]
- > G_UZAVIERKA.UZA_ID_UZAVIERKY
- DNT_ID_POHYB_JEDLA - [column description]
- > G_DOKLAD_POHYBY_JEDLA.DPJ_ID_POHYBY_JEDLA
- DNT_DATUM_CAS - [column description]
- DNT_DRUH_POHYBU - [column description]
- > G_DRUH_POHYBU.CDP_DRUH_POHYBU
- DNT_ID_STREDISKO - [column description]
- > G_STREDISKO.CST_ID_STREDISKO
- DNT_ID_ODKIAL_KAM - [column description]
- > G_SUBJEKT.SUB_ID_SUBJEKT
- DNT_ID_AKCIA_UDALOST - [column description]
- > G_AKCIA_UDALOST.AKU_ID_UDALOST
- DNT_ID_VYROBA_POLOT - [column description]
- > G_DOKLAD_VYROBA_POLOT.DVP_ID_DOKLAD_VYROBA_POLOT
- DNT_STATE - [column description]
G_DOKLAD_POHYBY_JEDLA
Hlavička dokladu o pohyboch jedál.
- DPJ_ID_POHYBY_JEDLA - [column description]
- DPJ_OBJEDNAVKA - [column description]
- DPJ_ID_PRIPRAV_STREDISKA - [column description]
- DPJ_CIS_DOKL_PRIPRAV_STREDISKA - [column description]
- DPJ_ID_ODKIAL_KAM - [column description]
- DPJ_CISLO_DOKL_ODKIAL_KAM - [column description]
- DPJ_DATUM - [column description]
- DPJ_SUMA_NA_PRIPRAV_STREDISKU - [column description]
- DPJ_SUMA_KAM - [column description]
- DPJ_DPH_IN - [column description]
- DPJ_NAZOV - [column description]
- DPJ_POZNAMKA - [column description]
- DPJ_ZAPISAL - [column description]
- DPJ_POZNAMKA_NA_DL - [column description]
- DPJ_DELETED - [column description]
G_DOKLAD_POHYBY_TOVARU
Hlavička dokladu o pohyboch tovaru.
- POD_ID_POHYBY_TOVARU - [column description]
- POD_DRUH_POHYBU - [column description]
- > G_DRUH_POHYBU.CDP_DRUH_POHYBU
- POD_ID_STREDISKO - [column description]
- > G_STREDISKO.CST_ID_STREDISKO
- POD_CISLO_DOKL_STRED - [column description]
- POD_ID_ODKIAL_KAM - [column description]
- > G_SUBJEKT.SUB_ID_SUBJEKT
- POD_CISLO_DOKL_ODKIAL_KAM - [column description]
- POD_DATUM - [column description]
- POD_SUMA_DOKL_STRED - [column description]
- POD_SUMA_DNC - [column description]
- POD_ZOSTAVIL - [column description]
- POD_CISLO_FAKTURY - [column description]
- POD_DPH_IN - [column description]
- POD_ID_POHYB_JEDLA - [column description]
- > G_DOKLAD_POHYBY_JEDLA.DPJ_ID_POHYBY_JEDLA
- POD_ID_UZAVIERKA - [column description]
- > G_UZAVIERKA.UZA_ID_UZAVIERKY
- POD_STAV - [column description]
- POD_ZOSTAVIL_ID - [column description]
- > L_UZIVATEL.UZ_ID_UZIVATEL
- POD_DATUM_CAS_ZOSTAVENIA - [column description]
- POD_ID_UZAVIERKA_STREDISKO - [column description]
- > G_UZAVIERKA_STREDISKO.UZS_ID_UZAVIERKA_STREDISKO
- POD_ZLAVA - [column description]
- POD_POZNAMKA - [column description]
- POD_ID_DOKLAD_PARENT - [column description]
- > G_DOKLAD_POHYBY_TOVARU.POD_ID_POHYBY_TOVARU
- POD_MENA - [column description]
- POD_KURZ - [column description]
- POD_ID_AKCIA_UDALOST - [column description]
- > G_AKCIA_UDALOST.AKU_ID_UDALOST
- POD_ID_DOKLAD_TOVAR_NA_ODPIS - [column description]
- > G_DOKLAD_TOVAR_NA_ODPISANIE.DTO_ID_DOKLAD_TOVAR_NA_ODPIS
- POD_ID_VYROBA_POLOT - [column description]
- > G_DOKLAD_VYROBA_POLOT.DVP_ID_DOKLAD_VYROBA_POLOT
- POD_SUMA_DNC_CM - [column description]
- POD_NEPRIAMA_KOTACIA - [column description]
- POD_JEDNOTKY_MENY - [column description]
G_DOKLAD_POHYBY_TOVARU_CCP
[table description]
- PDC_ID_DOKLAD_POHYBY_TOVARU - [column description]
- PDC_NEPORUSENIE_OBALU - [column description]
- PDC_KVALITA_SPR_OZNACENIA - [column description]
- PDC_EXPIRACIA - [column description]
- PDC_TEPLOTA_MRAZ - [column description]
- PDC_KONTROLA_KVALITY - [column description]
- PDC_PODM_PREPRAVY - [column description]
- PDC_ZOZNAM_ZAK_VYR - [column description]
- PDC_POZNAMKA - [column description]
G_DOKLAD_POHYBY_TOVARU_DPH
[table description]
- PDD_ID_POHYBY_TOVARU - [column description]
- PDD_SADZBA_DPH - [column description]
- PDD_SUMA_B_DPH - [column description]
- PDD_SUMA_DPH - [column description]
- PDD_SUMA_B_DPH_CM - [column description]
- PDD_SUMA_DPH_CM - [column description]
G_DOKLAD_STAV
[table description]
- DOS_STAV - [column description]
- DOS_TEXT - [column description]
G_DOKLAD_STAV_LANG
Multilingválna tabuľka.
- DOS_ID - [column description]
- > G_DOKLAD_STAV.DOS_STAV
- DOS_TEXT - [column description]
- DOS_LANG - [column description]
G_DOKLAD_TOVAR_NA_ODPISANIE
Hlavička dokladu o tovaroch na odpísanie.
- DTO_ID_DOKLAD_TOVAR_NA_ODPIS - [column description]
- DTO_DATUM - [column description]
- DTO_ID_UZAVIERKA_POKLADNE - [column description]
- > G_UZAVIERKA.UZA_ID_UZAVIERKY
- DTO_ID_OBJEDNAVKA_JEDAL - [column description]
- > G_DOKLAD_POHYBY_JEDLA.DPJ_ID_POHYBY_JEDLA
- DTO_ID_AKCIA_UDALOST - [column description]
- > G_AKCIA_UDALOST.AKU_ID_UDALOST
- DTO_ID_DOKLAD_NEODPISANY_TOVAR - [column description]
- > G_DOKLAD_NEODPISANY_TOVAR.DNT_ID_DOKLAD_NEODPISANY_TOVAR
- DTO_ID_VYHOTOVIL - [column description]
- > L_UZIVATEL.UZ_ID_UZIVATEL
- DTO_DATUM_CAS_VYHOTOVENIA - [column description]
- DTO_ID_VYROBA_POLOT - [column description]
- > G_DOKLAD_VYROBA_POLOT.DVP_ID_DOKLAD_VYROBA_POLOT
- DTO_STATE - [column description]
G_DOKLAD_VYROBA_POLOT
[table description]
- DVP_ID_DOKLAD_VYROBA_POLOT - [column description]
- DVP_DATUM - [column description]
- DVP_NAZOV - [column description]
- DVP_CISLO_DOKLAD - [column description]
- DVP_STAV - [column description]
- DVP_ID_VYR_STREDISKO - [column description]
- DVP_SUMA - [column description]
- DVP_ID_ZAPISAL - [column description]
- DVP_MENA - [column description]
G_DPT
[table description]
- DPT_KOD_DPT - [column description]
- DPT_TEXT_DPT - [column description]
- DPT_KOD_GRUPY - [column description]
- DPT_ZAPORNA - [column description]
- DPT_ZLAVY - [column description]
G_DRUH_POHYBU
[table description]
- CDP_DRUH_POHYBU - [column description]
- CDP_NAZOV_POHYBU - [column description]
- CDP_POVOLENE_MAZANIE - [column description]
- CDP_SMER_POHYBU - [column description]
- CDP_REPORT_NAME - [column description]
G_DRUH_POHYBU_TYPY
[table description]
- DRP_ID - [column description]
- DRP_DRUH_ROZSAH_OD - [column description]
- DRP_DRUH_ROZSAH_DO - [column description]
- DRP_DRUH_DEFAULT - [column description]
G_DRUH_POHYBU_TYPY_LANG
Multilingválna tabuľka.
- DRP_ID - [column description]
- > G_DRUH_POHYBU_TYPY.DRP_ID
- DRP_NAZOV - [column description]
- DRP_LANG - [column description]
G_DRUH_TOVAR_JEDLO
[table description]
- DTJ_ID_DRUH_TOVAR_JEDLO - [column description]
- DTJ_CISLO - [column description]
- DTJ_NAZOV - [column description]
- DTJ_TOVAR_JEDLO - [column description]
- DTJ_KOD_DPT - [column description]
- DTJ_JM - [column description]
- DTJ_DOPORUCENY_DO_RECEPTUR - [column description]
- DTJ_PERCENTO_ALKOHOLU - [column description]
- DTJ_ZIADANA_MARZA - [column description]
- DTJ_DOPORUCENE_DO_VYROBY - [column description]
- DTJ_TYP_TOVAR - [column description]
- DTJ_JM2 - [column description]
- DTJ_POVINNY_EAN_PRI_NAKUPE - [column description]
- DTJ_NAKUP_LEN_CELE_MNOZSTVO - [column description]
G_EXTERNAL_MESSAGE
[table description]
- EME_ID - [column description]
- EME_ID_MESSAGE_EXT_SYS - [column description]
- EME_ID_EXTERNAL_SYSTEM - [column description]
- > G_EXTERNE_SYSTEMY.EXS_ID
- EME_ID_MESSAGE_TYPE - [column description]
- > G_KASA_SPRAVA_TYP.KST_ID
- EME_ID_STATE - [column description]
- > G_KASA_SPRAVA_STAV.SSV_ID
- EME_DATE - [column description]
- EME_LAST_CHANGE - [column description]
- EME_CUST_INFO - [column description]
- EME_MSG - [column description]
G_EXTERNAL_ORDER
[table description]
- EOR_ID - [column description]
- EOR_ID_ORDER_EXT_SYS - [column description]
- EOR_ID_ORDER_TYPE - [column description]
- > G_KASA_OBJ_TYP.KOT_ID
- EOR_PAYED - [column description]
- EOR_ID_PAYMENT_TYPE - [column description]
- EOR_ID_EXTERNAL_SYSTEM - [column description]
- > G_EXTERNE_SYSTEMY.EXS_ID
- EOR_ID_STATE - [column description]
- > G_KASA_OBJ_STAV.KOS_ID
- EOR_DATE - [column description]
- EOR_LAST_CHANGE - [column description]
- EOR_CANCELLED - [column description]
- EOR_NOTE - [column description]
- EOR_CUST_INFO - [column description]
- EOR_ID_CLIENT - [column description]
- EOR_ID_USER - [column description]
- > L_UZIVATEL.UZ_ID_UZIVATEL
- EOR_ID_STOL - [column description]
- > G_REST_STOL.RST_ID_STOL
- EOR_ID_CASH_DESK - [column description]
- > G_KASA.CKA_CISLO_KASY
- EOR_ACCOUNT_ID - [column description]
- > K_OTVORENY_UCET.OUC_ID_OTVORENY_UCET
G_EXTERNAL_ORDER_GOLF
[table description]
- EOG_ID - [column description]
- EOG_ID_ZAKAZNIK - [column description]
G_EXTERNAL_ORDER_ITEMS
[table description]
- EOI_ID - [column description]
- > G_EXTERNAL_ORDER.EOR_ID
- EOI_ORDER - [column description]
- EOI_AMOUNT - [column description]
- EOI_PRICE - [column description]
- EOI_ID_PLU - [column description]
- EOI_ID_DISCOUNT - [column description]
- EOI_NOTE - [column description]
- EOI_CHOD - [column description]
- > G_CHOD.CIC_ID
G_EXTERNAL_PDA_CLIENT
[table description]
- EPC_ID - [column description]
G_EXTERNE_SYSTEMY
[table description]
- EXS_ID - [column description]
- EXS_TYP_SYSTEMU - [column description]
- EXS_NAZOV - [column description]
- EXS_WEB_SERVICE - [column description]
- > G_WEB_SERVICES.WES_ID
- EXS_TYP_KOMUNIKACIE - [column description]
- EXS_ID_EXTERNEHO_SYSTEMU - [column description]
- EXS_CODE_PAGE - [column description]
- EXS_COMM_ALLOWED - [column description]
- EXS_DELETED - [column description]
G_EXTERNE_SYSTEMY_EKONOMIKA
[table description]
- ESE_ID - [column description]
- > G_EXTERNE_SYSTEMY.EXS_ID
- ESE_AUTOMATICKE_GENEROVANIE - [column description]
- ESE_TYP_EKON_SYSTEMU - [column description]
- > G_TYPY_EKON_EXTERNYCH_SYSTEMOV.TEE_ID
- ESE_KOM_ADRESAR - [column description]
- ESE_VERZIA - [column description]
- > G_EXT_SYSTEMY_EKON_VER_EXPORT.ESEV_ID
G_EXTERNE_SYSTEMY_EXT_GOLF
[table description]
- EEG_ID - [column description]
- > G_EXTERNE_SYSTEMY.EXS_ID
- EEG_ID_LOKALNE_GASTRO - [column description]
- > G_LOKALNE_GASTRO.LGA_ID
- EEG_CENOVY_PROFIL_ID - [column description]
- > G_CENOVY_PROFIL.CPR_ID_CENOVY_PROFIL
- EEG_CENOVY_PROFIL_SPOSOB - [column description]
- EEG_PRIORITY_CP_ABIDING_GUEST - [column description]
- EEG_PRIORITY_CP_EMPLOYEE - [column description]
G_EXTERNE_SYSTEMY_EXT_PDA
[table description]
- ESP_ID - [column description]
- > G_EXTERNE_SYSTEMY.EXS_ID
- ESP_ID_LOKALNE_GASTRO - [column description]
- > G_LOKALNE_GASTRO.LGA_ID
- ESP_FILTER_CASHDESKS_ALL_DEF - [column description]
- ESP_FILTER_USERS_ALL_DEF - [column description]
G_EXTERNE_SYSTEMY_FIDELIO
[table description]
- ESF_ID - [column description]
- > G_EXTERNE_SYSTEMY.EXS_ID
- ESF_ID_LOKALNE_GASTRO - [column description]
- > G_LOKALNE_GASTRO.LGA_ID
- ESF_HOSTNAME - [column description]
- ESF_PORT - [column description]
G_EXTERNE_SYSTEMY_FIDELIO_IZBY
[table description]
- EFI_ID - [column description]
- > G_EXTERNE_SYSTEMY_FIDELIO.ESF_ID
- EFI_CISLO_IZBY - [column description]
G_EXTERNE_SYSTEMY_FIDELIO_ZI
[table description]
- EFT_ID - [column description]
- > G_EXTERNE_SYSTEMY_FIDELIO.ESF_ID
- EFT_NAZOV - [column description]
- EFT_SALES_OUTLET - [column description]
- EFT_DPH - [column description]
- EFT_CISLO_KASY - [column description]
- > G_KASA.CKA_CISLO_KASY
G_EXTERNE_SYSTEMY_GASTRO
[table description]
- ESG_ID - [column description]
G_EXTERNE_SYSTEMY_HOTSYS
[table description]
- ESH_ID - [column description]
- > G_EXTERNE_SYSTEMY.EXS_ID
- ESH_ID_LOKALNE_GASTRO - [column description]
- > G_LOKALNE_GASTRO.LGA_ID
G_EXTERNE_SYSTEMY_KAMERA
[table description]
- ESK_ID - [column description]
- > G_EXTERNE_SYSTEMY.EXS_ID
- ESK_URL - [column description]
- ESK_ID_LOK_GASTRO - [column description]
- > G_LOKALNE_GASTRO.LGA_ID
- ESK_COLLECT - [column description]
- ESK_PLATNOST_LOG_ZAZNAMU - [column description]
G_EXTERNE_SYSTEMY_ORDERS
[table description]
- ESO_ID - [column description]
- > G_EXTERNE_SYSTEMY.EXS_ID
- ESO_ID_LOKALNE_GASTRO - [column description]
- > G_LOKALNE_GASTRO.LGA_ID
G_EXTERNE_SYSTEMY_SAP
[table description]
- ESS_ID - [column description]
- > G_EXTERNE_SYSTEMY.EXS_ID
- ESS_SEND_TIME_FROM - [column description]
- ESS_SEND_TIME_TO - [column description]
- ESS_SEND_INTERVAL - [column description]
- ESS_TRANSFER_SEND_TIMEOUT_C - [column description]
- ESS_TRANSFER_SEND_TIMEOUT_R - [column description]
- ESS_LIST_SEND_TIMEOUT_C - [column description]
- ESS_LIST_SEND_TIMEOUT_R - [column description]
- ESS_TEST_CONNECTION_TIMEOUT_C - [column description]
- ESS_TEST_CONNECTION_TIMEOUT_R - [column description]
- ESS_QUEUE_DELETE_PERIOD - [column description]
- ESS_MESSAGES_VERSION - [column description]
- ESS_SOURCE_SYSTEM_ID - [column description]
- ESS_TARGET_SYSTEM_ID - [column description]
- ESS_WS_GOODS_ID - [column description]
- > G_WEB_SERVICES.WES_ID
- ESS_WS_GOODS_TRANSFER_ID - [column description]
- > G_WEB_SERVICES.WES_ID
G_EXTERNE_SYSTEMY_TAP_DEV
[table description]
- EVD_ID - [column description]
- > G_EXTERNE_SYSTEMY.EXS_ID
- EVD_TAP_SYS_ID - [column description]
- > G_EXTERNE_SYSTEMY_TAP_SYS.EVS_ID
- EVD_ORDER - [column description]
- EVD_CREDIT_ENABLED - [column description]
- EVD_DEBIT_ENABLED - [column description]
- EVD_READ_INTERVAL - [column description]
- EVD_MOVE_TO_TABLE - [column description]
- EVD_MOVE_TO_TABLE_OPEN - [column description]
- EVD_MOVE_TO_TABLE_FIRST - [column description]
- EVD_DEBIT_CASHDESK_ID - [column description]
- EVD_VPP_ID - [column description]
- > VPP_DEVICE.VPP_ID
G_EXTERNE_SYSTEMY_TAP_SYS
[table description]
- EVS_ID - [column description]
- > G_EXTERNE_SYSTEMY.EXS_ID
- EVS_ID_LOKALNE_GASTRO - [column description]
- > G_LOKALNE_GASTRO.LGA_ID
- EVS_USER_ID_DEFAULT - [column description]
- > L_UZIVATEL.UZ_ID_UZIVATEL
G_EXTERNE_SYSTEMY_VTS
[table description]
- ESV_ID - [column description]
- > G_EXTERNE_SYSTEMY.EXS_ID
- ESV_ID_LOK_GASTRO - [column description]
- > G_LOKALNE_GASTRO.LGA_ID
- ESV_LANGUAGE - [column description]
G_EXTERNE_SYSTEMY_VYCAP
[table description]
- ESY_ID - [column description]
- > G_EXTERNE_SYSTEMY.EXS_ID
- ESY_PORT - [column description]
- ESY_BAUD - [column description]
- ESY_BITY - [column description]
- ESY_STOP_BITY - [column description]
- ESY_PARITA - [column description]
- ESY_MASKA_VETY - [column description]
- ESY_PRAZDNA_VETA - [column description]
- ESY_PRIPOJENE_NA_POKLADNU_ID - [column description]
- ESY_REQUEST_STRING - [column description]
- ESY_CONFIRM_STRING - [column description]
- ESY_READ_INTERVAL - [column description]
- ESY_ORDER - [column description]
G_EXTERNE_SYSTEMY_WELLNESS_L
[table description]
- ESW_ID - [column description]
- > G_EXTERNE_SYSTEMY.EXS_ID
- ESW_ID_LOKALNE_GASTRO - [column description]
- > G_LOKALNE_GASTRO.LGA_ID
G_EXTERNE_SYSTEMY_WELLNESS_S
[table description]
- EWS_ID - [column description]
- > G_EXTERNE_SYSTEMY.EXS_ID
- EWS_ID_LOKALNE_GASTRO - [column description]
- > G_LOKALNE_GASTRO.LGA_ID
G_EXT_MESSAGE_STATE_CHANGE
[table description]
- MSC_ID - [column description]
- > G_EXTERNAL_MESSAGE.EME_ID
- MSC_ORDER - [column description]
- MSC_ID_STATE_FROM - [column description]
- > G_KASA_SPRAVA_STAV.SSV_ID
- MSC_ID_STATE_TO - [column description]
- > G_KASA_SPRAVA_STAV.SSV_ID
- MSC_DATE - [column description]
- MSC_ID_USER - [column description]
- MSC_NOTE - [column description]
G_EXT_ORDER_STATE_CHANGE
[table description]
- EOS_ID - [column description]
- > G_EXTERNAL_ORDER.EOR_ID
- EOS_ORDER - [column description]
- EOS_ID_STATE_FROM - [column description]
- > G_KASA_OBJ_STAV.KOS_ID
- EOS_ID_STATE_TO - [column description]
- > G_KASA_OBJ_STAV.KOS_ID
- EOS_DATE - [column description]
- EOS_ID_USER - [column description]
- EOS_NOTE - [column description]
G_EXT_SYS_KASA
[table description]
- ESK_ID_EXT_SYS - [column description]
- > G_EXTERNE_SYSTEMY.EXS_ID
- ESK_CISLO_KASY - [column description]
- > G_KASA.CKA_CISLO_KASY
G_EXT_SYS_LIST
[table description]
- ESL_ID - [column description]
- ESL_EXT_SYS_ID - [column description]
- > G_EXTERNE_SYSTEMY.EXS_ID
- ESL_CREATED - [column description]
G_EXT_SYS_LIST_GOODS
[table description]
- ELG_EXT_SYS_LIST_ID - [column description]
- > G_EXT_SYS_LIST.ESL_ID
- ELG_GOODS_ID - [column description]
- > G_TOVAR.CTO_ID_TOVAR
G_EXT_SYS_LIST_SEND
[table description]
- ELS_ID - [column description]
- ELS_EXT_SYS_LIST_ID - [column description]
- > G_EXT_SYS_LIST.ESL_ID
- ELS_TIME_INIT - [column description]
- ELS_TIME_SENT - [column description]
- ELS_MESSAGE - [column description]
G_EXT_SYS_ORDERS_AKCIA
[table description]
- SOA_ID - [column description]
- SOA_EXT_SYS_TYP - [column description]
G_EXT_SYS_ORDERS_AKCIA_LANG
Multilingválna tabuľka.
- SOAL_ID - [column description]
- > G_EXT_SYS_ORDERS_AKCIA.SOA_ID
- SOAL_NAME - [column description]
- SOAL_LANG - [column description]
G_EXT_SYS_ORDERS_KASA
[table description]
- SOK_ID - [column description]
- > G_EXTERNE_SYSTEMY.EXS_ID
- SOK_CISLO_KASY - [column description]
- > G_KASA.CKA_CISLO_KASY
- SOK_AKCIA - [column description]
- > G_EXT_SYS_ORDERS_AKCIA.SOA_ID
G_EXTSYS_PDA_TRANSACTIONS
[table description]
- EPT_ID - [column description]
- EPT_TRANSACTION_ID - [column description]
- EPT_CREATION_TIME - [column description]
- EPT_DATA_TYPE - [column description]
- EPT_TIME_RECIEVING - [column description]
- EPT_ORDER_ID - [column description]
- EPT_GASTRO_ACCOUNT_ID - [column description]
- EPT_CHECKSUM - [column description]
- EPT_TRANS_INTERNAL_STATE - [column description]
- EPT_TRANSACTION_STATE - [column description]
- EPT_TRANSACTION_NOTE - [column description]
G_EXT_SYS_PLATBA
[table description]
- EPP_ID_EXTERNY_SYSTEM - [column description]
- > G_EXTERNE_SYSTEMY.EXS_ID
- EPP_ID_SPOSOB_PLATBY - [column description]
- > G_SPOSOB_PLATBY.SPL_ID_SPOSOB_PLATBY
G_EXT_SYS_PLU
[table description]
- ESP_EXT_SYS_ID - [column description]
- > G_EXTERNE_SYSTEMY.EXS_ID
- ESP_PLU_ID - [column description]
- > G_PLU.PLU_ID_PLU
- ESP_EXT_CODE - [column description]
- ESP_ENABLED - [column description]
G_EXT_SYS_PLU_KASA
[table description]
- EPK_EXT_SYS_ID - [column description]
- > G_EXTERNE_SYSTEMY.EXS_ID
- EPK_PLU_ID - [column description]
- > G_PLU.PLU_ID_PLU
- EPK_CASH_DESK_ID - [column description]
- > G_KASA.CKA_CISLO_KASY
G_EXT_SYS_REST_TABLE
[table description]
- ERT_EXT_SYS_ID - [column description]
- > G_EXTERNE_SYSTEMY.EXS_ID
- ERT_TABLE_ID - [column description]
- > G_REST_STOL.RST_ID_STOL
- ERT_EXT_CODE - [column description]
G_EXT_SYSTEMY_EKON_VER_EXPORT
[table description]
- ESEV_ID - [column description]
- ESEV_VERZIA - [column description]
- ESEV_DATE - [column description]
- ESEV_NOTE - [column description]
G_EXT_SYS_USER
[table description]
- ESU_EXT_SYS_ID - [column description]
- > G_EXTERNE_SYSTEMY.EXS_ID
- ESU_USER_ID - [column description]
- > L_UZIVATEL.UZ_ID_UZIVATEL
- ESU_EXT_CODE - [column description]
G_FIRMA
[table description]
- FIR_ID_FIRMY - [column description]
- FIR_OBCHODNY_NAZOV - [column description]
- FIR_PREVADZKA - [column description]
- FIR_ICO - [column description]
- FIR_DIC - [column description]
- FIR_TELEFON - [column description]
- FIR_FAX - [column description]
- FIR_EMAIL - [column description]
- FIR_HOMEPAGE - [column description]
- FIR_ULICA - [column description]
- FIR_MESTO - [column description]
- FIR_UCET_FIRMY - [column description]
- FIR_REGISTER_FIRMY - [column description]
- FIR_CISLO_ZAPISU_DO_REGISTRA - [column description]
- FIR_ICDPH - [column description]
- FIR_INSTALL_NUMBER - [column description]
G_GASTRO_VERSION
[table description]
- GV_ID - [column description]
- GV_VERSION - [column description]
- GV_LAST_CHANGE_DATE - [column description]
G_GRUPA
[table description]
- GRP_KOD_GRUPY - [column description]
- GRP_TEXT_GRUPY - [column description]
G_HODINY
[table description]
- HOD_OD - [column description]
- HOD_DO - [column description]
G_CHANGES
Zmeny vykonané v DB pre účely replikácie.
- GCH_ID - [column description]
- GCH_TIMESTAMP - [column description]
- GCH_TYPE - [column description]
- GCH_TABLE_NAME - [column description]
- GCH_KEY1 - [column description]
- GCH_KEY2 - [column description]
- GCH_KEY3 - [column description]
- GCH_KEY4 - [column description]
- GCH_STR1 - [column description]
- GCH_STR2 - [column description]
- GCH_DATA_VERSION - [column description]
- GCH_TRANSACTION_ID - [column description]
G_CHANGES_ACTUAL_VALUES
Aktuálne hodnoty niektorých záznamov v momente vygenerovania zmeny. Vznikla kvôli FK, ktorým sa medzičasom zmenili hodnoty a potom padala replikácia.
- GCA_CHANGE_ID - ID zmeny.
- > G_CHANGES.GCH_ID
- GCA_COLUMN - Názov stĺpca.
- GCA_VALUE - Hodnota v danom momente.
G_CHANGES_FILE
Záznamy replikácie súborov.
- CHF_ID - [column description]
- CHF_NAME - Názov súboru.
- CHF_FILE_TYPE - Typ súboru.
- CHF_CHANGE_TYPE - Typ zmeny.
G_CHOD
Číselník chodov jedál.
- CIC_ID - [column description]
- CIC_PORADIE - Poradie chodu.
- CIC_NAZOV - Názov chodu.
- CIS_SYSTEMOVY - Defaultný/systémový chod.
G_INV
[table description]
- INV_ID_INV - [column description]
- INV_DATUM_CAS_VYVOLANIA - [column description]
- INV_DATUM_CAS_ZAUCTOVANIA - [column description]
- INV_DATUM_UCTOVNY - [column description]
- INV_ID_STREDISKO - [column description]
- INV_ID_UZIVATEL_VYVOLAL - [column description]
- INV_ID_UZIVATEL_ZAUCTOVAL - [column description]
- INV_STAV - [column description]
- INV_ID_DOKLAD - [column description]
G_INV_POLOZKA
[table description]
- INP_ID_INV_POLOZKA - [column description]
- INP_ID_INV - [column description]
- INP_ID_STAV_TOVARU - [column description]
- > G_STAV_TOVARU.STT_ID_STAV_TOVARU
- INP_ID_TOVAR - [column description]
- INP_MNOZSTVO - [column description]
- INP_NAKUPNA_CENA - [column description]
- INP_MNOZSTVO_FYZICKE - [column description]
- INP_CENA_NA_STREDISKU - [column description]
- INP_FAJKA - [column description]
- INP_PREDAJNA_CENA - [column description]
G_INV_POL_ZDRUZOVANE
[table description]
- IPZ_ID_INV_POLOZKA - [column description]
- IPZ_ID_TOVAR - [column description]
- IPZ_MNOZSTVO - [column description]
- IPZ_HMOTNOST_JM - [column description]
G_JEDLO
[table description]
- CJE_ID_JEDLO - [column description]
- CJE_OBJEM - [column description]
- CJE_POCET_PORCII - [column description]
- CJE_PRIRAZKA - [column description]
- CJE_STRATA - [column description]
- CJE_HMOTNOST_MASA - [column description]
- CJE_DATUM_ZMENY - [column description]
- CJE_ZOSTAVIL - [column description]
- CJE_POPIS - [column description]
- CJE_KALK_CENA_SUROVIN - [column description]
- CJE_DOPORUCENE_DO_VYROBY - [column description]
- CJE_POPIS2 - [column description]
- CJE_IMAGE_FILE - [column description]
G_JEDNOTKA_MNOZSTVA
[table description]
- CJM_KOD - [column description]
- CJM_RECEPTURA - [column description]
- CJM_NAZOV - [column description]
- CJM_TOVAR - [column description]
- CJM_TOVAR2 - [column description]
- CJM_JEDLO - [column description]
G_JEDNOTKA_MNOZSTVA_LANG
Multilingválna tabuľka.
- CJM_ID - [column description]
- > G_JEDNOTKA_MNOZSTVA.CJM_KOD
- CJM_NAZOV - [column description]
- CJM_LANG - [column description]
G_KALENDAR
[table description]
- KAL_ID_KALENDAR - [column description]
- KAL_DATUM - [column description]
- KAL_DEN - [column description]
- KAL_MESIAC - [column description]
- KAL_ROK - [column description]
- KAL_TYZDEN - [column description]
G_KALKULACNA_PRIRAZKA
[table description]
- CKP_CENOVA_HLADINA - [column description]
- CKP_PRIRAZKA - [column description]
- CKP_POPIS - [column description]
- CKP_PRAVIDLO - [column description]
- CKP_ID_TRN - [column description]
G_KAMERA_AKCIE
[table description]
- KAE_ID_KAMERA_AKCIE - [column description]
G_KAMERA_AKCIE_KASA
[table description]
- KAK_ID_KAMERA - [column description]
- > G_EXTERNE_SYSTEMY_KAMERA.ESK_ID
- KAK_ID_KAMERA_AKCIE - [column description]
- > G_KAMERA_AKCIE.KAE_ID_KAMERA_AKCIE
- KAK_CISLO_KASY - [column description]
- > G_KASA.CKA_CISLO_KASY
G_KAMERA_AKCIE_LANG
Multilingválna tabuľka.
- KAEL_ID - [column description]
- > G_KAMERA_AKCIE.KAE_ID_KAMERA_AKCIE
- KAEL_TEXT - [column description]
- KAEL_LANG - [column description]
- > B_JAZYK.JAZ_KOD_JAZYKA
G_KAMERA_LOG
[table description]
- KLO_ID - [column description]
- KLO_ID_KAMERY - [column description]
- KLO_CISLO_KASY - [column description]
- KLO_NAZOV_PRAC_STANICE - [column description]
- KLO_MENO_UZIVATELA - [column description]
- KLO_TIMESTAMP - [column description]
- KLO_ID_AKCIE - [column description]
- > G_KAMERA_AKCIE.KAE_ID_KAMERA_AKCIE
- KLO_MEMO - [column description]
- KLO_ODOSLANA - [column description]
- KLO_CISLO_UCTU - [column description]
G_KARTA_EXT_SLUZBA
[table description]
- KES_ID_KARTA_EXT_SLUZBA - [column description]
- KES_TYP - [column description]
- KES_NUMBER_OF_CHIPS - [column description]
- KES_MULTIPLE_DAY_ENTRY - [column description]
- KES_HIDDEN - [column description]
G_KASA
[table description]
- CKA_CISLO_KASY - ID a zaroven cislo pokladne!
- CKA_TEXT_KASY - nazov pokladne
- CKA_LOGO - [column description]
- CKA_ZOBRAZIT_KASU - [column description]
- CKA_ID_KASA_SETTINGS - ID nastavenia pokladne
- CKA_ID_PRACOVNA_STANICA - ID pracovnej stanice
- > G_PRACOVNA_STANICA.PS_ID_STANICA
- CKA_DKP - ID alebo aj cislo DKP
- CKA_TEXT_PRI_TLACI_OBJEDNAVKY - priznak tlace textu pokladne na objednavkach
- CKA_PATICKA_UCTENKY - textova paticka uctenky
- CKA_TYP_FISK - fiskalny typ pokladne
- CKA_ID_KASA_TYP - [column description]
- CKA_POVOLENY_PREDAJ_HOREC - [column description]
- CKA_CAS_ZACIATKU_NOVEHO_DNA - posunuty "den" pokladne
- CKA_VYRADENA - priznak vyradenia pokladne, ak true, nemala by uz absolutne nikde figurovat, je to iba kvoli historickym datam
- CKA_ID_LOKAL_GASTRO - GIN (Gastro Install Number) alebo tiez id lokalnej prevadzky
- > G_LOKALNE_GASTRO.LGA_ID
- CKA_TEXT_FIRE - [column description]
- CKA_TEXT_SPRAVA - [column description]
G_KASA_DPT
[table description]
- DPK_CISLO_KASY - [column description]
- > G_KASA.CKA_CISLO_KASY
- DPK_KOD_DPT - [column description]
- DPK_ID_STREDISKO - [column description]
- DPK_KP - [column description]
- DPK_DPH - [column description]
- DPK_CENOVA_HLADINA_TOVAROV - [column description]
- DPK_CENOVA_HLADINA_JEDAL - [column description]
G_KASA_EURO
[table description]
- KEU_CISLO_KASY - [column description]
- > G_KASA.CKA_CISLO_KASY
- KEU_CISLO_EURO - [column description]
- KEU_TYP_EURO - [column description]
- KEU_SPEED - [column description]
- KEU_PORT - [column description]
- KEU_FIRMWARE - [column description]
- KEU_SIET - [column description]
- KEU_VPP_ID - [column description]
- > VPP_DEVICE.VPP_ID
G_KASA_EURO_COMMANDS
[table description]
- KEM_CASH_DESK_TYPE - [column description]
- > G_KASA_EURO_TYP.KET_TYP_EURO
- KEM_COMMAND_NUMBER - [column description]
- KEM_COMMAND_DESCRIPTION - [column description]
- KEM_BYTECOUNT - [column description]
G_KASA_EURO_COUNTRY
[table description]
- KEC_ID - [column description]
- KEC_CODE - [column description]
- KEC_NAME - [column description]
G_KASA_EURO_DPH
[table description]
- KED_ID_EURO_CASHDESK - [column description]
- KED_DPH_LEVEL - [column description]
- KED_DPH_VALUE - [column description]
G_KASA_EURO_TYP
[table description]
- KET_TYP_EURO - [column description]
- KET_NAZOV - [column description]
- KET_SIRKA_UCTENKY - [column description]
- KET_POCET_UCTUJUCICH - [column description]
- KET_POCET_PLU - [column description]
- KET_POCET_DPT - [column description]
- KET_TAB_NAR_ZNAKOV - [column description]
- KET_OPER_PLU_BEZ_ZASOB - [column description]
- KET_OPER_PLU_SO_ZASOBAMI - [column description]
- KET_OPER_PREDAJ_PLU - [column description]
- KET_OPER_ZAPIS_DPT - [column description]
- KET_OPER_PRECIT_DPT - [column description]
- KET_OPER_ZAPIS_UCTUJUCI - [column description]
- KET_OPER_PRECIT_UCTUJUCI - [column description]
- KET_ECR - [column description]
- KET_COUNTRY_ID - [column description]
- > G_KASA_EURO_COUNTRY.KEC_ID
- KET_CASHDESK_TYPE - [column description]
G_KASA_EXTERNAL
[table description]
- GKE_CASHDESK_ID - [column description]
- > G_KASA.CKA_CISLO_KASY
- GKE_WORKSTATION_ID - [column description]
- > G_PRACOVNA_STANICA.PS_ID_STANICA
- GKE_WORKSTATION_TYPE - [column description]
G_KASA_FISKALNY_MODUL_POSNET
[table description]
- FMP_CISLO_KASY - [column description]
- > G_KASA.CKA_CISLO_KASY
- FMP_CAS_SYNCHRONIZOVANY - [column description]
G_KASA_GROUP
[table description]
- KGR_ID - [column description]
- KGR_NUMBER - [column description]
- KGR_NAME - [column description]
G_KASA_GROUP_KASY
[table description]
- KGK_GROUP_ID - [column description]
- > G_KASA_GROUP.KGR_ID
- KGK_CASH_DESK_ID - [column description]
- > G_KASA.CKA_CISLO_KASY
G_KASA_HOREC
[table description]
- GKH_CISLO_KASY - [column description]
- GKH_ID_HOREC - [column description]
G_KASA_HOREC_DPH
[table description]
- KHD_CISLO_KASY - [column description]
- KHD_DPH - [column description]
- KHD_KOD_TOVARU - [column description]
- KHD_ID_HOREC - [column description]
G_KASA_KLAVESOVA_SKRATKA
[table description]
- KKS_ID - [column description]
- KKS_KLAVESOVA_SKRATKA - [column description]
- KKS_POVOLENA - [column description]
G_KASA_KLAVESOVA_SKRATKA_LANG
Multilingválna tabuľka.
- LKKS_ID - [column description]
- > G_KASA_KLAVESOVA_SKRATKA.KKS_ID
- LKKS_LANG - [column description]
- LKKS_TEXT - [column description]
G_KASA_NASTAVENIA_STANICE
[table description]
- KNS_IDS - [column description]
- > G_PRACOVNA_STANICA.PS_ID_STANICA
- KNS_CISLO_KASY - [column description]
- KNS_VYBRATA - [column description]
G_KASA_NEVIDITELNOST
[table description]
- KNE_CISLO_KASY - [column description]
- > G_KASA.CKA_CISLO_KASY
- KNE_CISLO_KASY_KTORU_NEVIDI - [column description]
G_KASA_OBJ_STAV
[table description]
- KOS_ID - [column description]
- KOS_CISLO - [column description]
- KOS_NAZOV - [column description]
- KOS_PORADIE - [column description]
- KOS_POVOLENY - [column description]
- KOS_SYSTEMOVY - [column description]
- KOS_TYP - [column description]
- KOS_EXT_SYS_TYP - [column description]
G_KASA_OBJ_TYP
[table description]
- KOT_ID - [column description]
- KOT_CISLO - [column description]
- KOT_NAZOV - [column description]
- KOT_COLOR - [column description]
- KOT_ZMAZANY - [column description]
- KOT_EXT_SYS_TYP - [column description]
G_KASA_PORADIE_KAT
[table description]
- POR_ID_KASA - [column description]
- > G_KASA.CKA_CISLO_KASY
- POR_ID_KAT - [column description]
- POR_PORADIE - [column description]
G_KASA_SADZBA_DPH
[table description]
- KDP_DPH - [column description]
- KDP_SADZBA - [column description]
- KDP_ID_TRN_1 - [column description]
- KDP_ID_TRN_2 - [column description]
- KDP_ID_TRN_3 - [column description]
G_KASA_SETTINGS
[table description]
- KSS_ID_KASA_SETTINGS - [column description]
- KSS_ID_VZOR - [column description]
- KSS_NASTAVENIA_ZO_VZORU - [column description]
G_KASA_SETTINGS_PREDOK
[table description]
- KSP_ID_KASA_SETTING - [column description]
- KSP_POVOLENY_AUTOMATICKY_ZAMOK - [column description]
- KSP_AUTOMATICKY_ZAMOK_PO - [column description]
- KSP_TLAC_UCT_POLOZKY_NA_2_RIAD - [column description]
- KSP_TLAC_DPH_NA_NEFISK_UCTENKE - [column description]
- KSP_TLAC_STORNO_FAREBNE - [column description]
- KSP_TLAC_ZAPORNE_POLOZKY_FAREB - [column description]
- KSP_UCTOV_OU_PRENES_MEDZI_POKL - [column description]
- KSP_UCTOV_OU_PRENES_MEDZI_UCTU - [column description]
- KSP_UCTOV_PRIHLAS_PRED_KAZ_UCT - [column description]
- KSP_UCTOV_PRIHLAS_PRED_PLATBOU - [column description]
- KSP_UCTOV_POVINNE_UCT_NA_STOLY - [column description]
- KSP_PLATBA_PYTAT_SUM_PRI_HOTOV - [column description]
- KSP_PLATBA_PYTAT_SUM_PRI_KARTE - [column description]
- KSP_ZU_TLACIT_KOPIU_ZU - [column description]
- KSP_TLAC_TLACIT_OBJEDNAVKY - [column description]
- KSP_TLAC_TLACIT_MEDZIUCET - [column description]
- KSP_PLATBA_PREDDEF_SPOS_PLATBY - [column description]
- KSP_UZA_POVOL_PRI_OTVOR_UCT - [column description]
- KSP_UZA_DENNA_TLAC_PLU - [column description]
- KSP_UZA_DENNA_TLAC_DPT - [column description]
- KSP_UZA_DENNA_TLAC_GRUPY - [column description]
- KSP_UZA_DENNA_TLAC_TRN - [column description]
- KSP_UZA_DENNA_TLAC_UCTUJUCI - [column description]
- KSP_UZA_DENNA_TLAC_HODINY - [column description]
- KSP_UZA_MESACNA_TLAC_PLU - [column description]
- KSP_UZA_MESACNA_TLAC_DPT - [column description]
- KSP_UZA_MESACNA_TLAC_GRUPY - [column description]
- KSP_UZA_MESACNA_TLAC_TRN - [column description]
- KSP_UZA_MESACNA_TLAC_UCTUJUCI - [column description]
- KSP_UZA_MESACNA_TLAC_HODINY - [column description]
- KSP_TLAC_SUMA_UCTU_VELKYM - [column description]
- KSP_PLATBA_POTVRD_HOTOVOST - [column description]
- KSP_UCTOV_AUTOMAT_NOVY_UCET - [column description]
- KSP_TYP_PRIHLASENIA - [column description]
- KSP_ZAMOK_PO_ZAVRETI_OKIEN - [column description]
- KSP_UCTOV_CITACKA_CIAR_KODOV - [column description]
- KSP_TLAC_ZDRUZ_POLOZ_OD_POCTU - [column description]
- KSP_TRITON_POVOLENY - [column description]
- KSP_ZOBRAZOVAT_INFO_DOP_MENA - [column description]
- KSP_TLAC_ZLAVU_PRI_POLOZK - [column description]
- KSP_TLAC_POZNAMKU - [column description]
- KSP_READCHIP_TIMEOUT - [column description]
- KSP_TYP - [column description]
- KSP_ENCODER_NUMBER - [column description]
- KSP_ZADAVAT_PHOSTI_UCET - [column description]
- KSP_ENCODER_READTIME - [column description]
- KSP_ENCODER_SLEEP - [column description]
- KSP_PREPINAJ_KATEGORIE - [column description]
- KSP_AUTOMATICKE_CIT_DALS_CIPU - [column description]
- KSP_AUTOMATICKY_ODCHOD - [column description]
- KSP_ZMENA_STREDISKA - [column description]
- KSP_TLAC_TRVANIE_UCTU - [column description]
- KSP_UZA_DENNA_TLAC_TRZBY - [column description]
- KSP_UZA_MESACNA_TLAC_TRZBY - [column description]
- KSP_BALIKY_PLU - [column description]
- KSP_SKRATENA_NEFISK_UCT - [column description]
- KSP_ZOBR_UCTUJUCEHO_NA_UCTENKE - [column description]
- KSP_TLACIT_ODDELOVACE - [column description]
- KSP_TLACIT_PODTRHNUTIE_UCTU - [column description]
- KSP_TLACIT_CISLO_STOLA - [column description]
- KSP_AUT_ZATV_ZAPL_UCTU - [column description]
- KSP_OTV_ZAD_NUL_CENY - [column description]
- KSP_ODVODY_POVOLENE - [column description]
- KSP_VRATENIE_TOVARU_POVOLENE - [column description]
- KSP_AUTO_PRIPOJENE - [column description]
- KSP_FIRE - [column description]
- KSP_ROZDELENIE_DO_CHODOV - [column description]
- KSP_UCTOV_ZAMOK_PO_AKCII_POK - [column description]
- KSP_ZAMOK_PO_AKCII_DOCHADZKA - [column description]
- KSP_TLACIT_CELU_OBJEDNAVKU - [column description]
- KSP_VYHLADAT_HOSTA_V_OTV_UCTE - [column description]
- KSP_ZADAVANIE_DOVODU_STORNA - [column description]
- KSP_SKR_REK_PLATIEB - [column description]
- KSP_WL_KONTROLA_VSTUP_NOVY_H - [column description]
- KSP_ES_AUTO_ZATV_CITANIA_KARTY - [column description]
- KSP_OBRAZKY_NA_PLU_TLACIDLACH - [column description]
- KSP_ZORADOVANIE_PLU - [column description]
- KSP_TIP_NA_UCET - [column description]
- KSP_ULOZ_FISK_UCTENKU - [column description]
- KSP_REKAPITULACIA - [column description]
- KSP_KONDENZ_FISKAL - [column description]
- KSP_KONDENZ_UVER - [column description]
- KSP_KONDENZ_NEFISKAL - [column description]
- KSP_OBR_HLAVICKA_FISKAL - [column description]
- KSP_OBR_PATICKA_FISKAL - [column description]
- KSP_OBR_HLAVICKA_UVER - [column description]
- KSP_OBR_PATICKA_UVER - [column description]
- KSP_OBR_HLAVICKA_NEFISKAL - [column description]
- KSP_OBR_PATICKA_NEFISKAL - [column description]
- KSP_ODSUHLAS_TLAC_FISK - [column description]
- KSP_ODSUHLAS_TLAC_NEFISK - [column description]
- KSP_UZA_DENNA_TLAC_TRZBY_UCT - [column description]
- KSP_UZA_MESACNA_TLAC_TRZBY_UCT - [column description]
- KSP_NAZVY_KATEGORII_PLU_SKRAT - [column description]
- KSP_SHOW_PRINT_ERRORS - [column description]
- KSP_PRINT_ICO - [column description]
- KSP_FISCAL_INVOICE_VAT - [column description]
- KSP_FM_CLAIM_COUNTER_VALUES - [column description]
- KSP_FISCAL_MODULE_SN - [column description]
- KSP_FULLTEXT_SEARCH - [column description]
- KSP_FM_DISPLAY_OUTPUT - [column description]
- KSP_CHANGE_VAT - [column description]
- KSP_PREFER_ALT_VAT - [column description]
- KSP_CHANGE_VAT_QUESTION - [column description]
- KSP_BOWA_CLOSING_TYPE - [column description]
- KSP_ALL_PAYMENTS_NEGAT_BILL - [column description]
G_KASA_SETTINGS_VZOR
[table description]
- KSV_ID_KASA_SETTINGS - [column description]
- KSV_NAZOV - [column description]
G_KASA_SPRAVA_STAV
[table description]
- SSV_ID - [column description]
- SSV_CISLO - [column description]
- SSV_NAZOV - [column description]
- SSV_PORADIE - [column description]
- SSV_POVOLENA - [column description]
- SSV_SYSTEMOVA - [column description]
G_KASA_SPRAVA_TYP
[table description]
- KST_ID - [column description]
- KST_CISLO - [column description]
- KST_NAZOV - [column description]
- KST_COLOR - [column description]
- KST_ZMAZANA - [column description]
G_KASA_STATS_REPORT
[table description]
- KSR_ID - [column description]
- KSR_DATE - [column description]
- KSR_CKASY - [column description]
- > G_KASA.CKA_CISLO_KASY
- KSR_ID_KASA_STATS_SETTINGS - [column description]
- > G_KASA_STATS_SETTINGS.KST_ID
- KSR_ID_OBJECT - [column description]
- KSR_TIME - [column description]
G_KASA_STATS_SETTINGS
[table description]
- KST_ID - [column description]
- KST_NAME - [column description]
- KST_ENABLED - [column description]
G_KASA_STATS_SETTINGS_KASY
[table description]
- KSK_ID_KASA_STATS_SETTINGS - [column description]
- > G_KASA_STATS_SETTINGS.KST_ID
- KSK_CKASY - [column description]
- > G_KASA.CKA_CISLO_KASY
G_KASA_STREDISKA
[table description]
- KAS_CISLO_KASY - [column description]
- > G_KASA.CKA_CISLO_KASY
- KAS_ID_STREDISKO - [column description]
G_KASA_TYP
[table description]
- KAT_ID_KASA_TYP - [column description]
- KAT_NAZOV - [column description]
G_KASA_TYP_LANG
Multilingválna tabuľka.
- KAT_ID - [column description]
- > G_KASA_TYP.KAT_ID_KASA_TYP
- KAT_NAZOV - [column description]
- KAT_LANG - [column description]
G_KASA_UZIVATEL
[table description]
- GKU_ID_KASA - [column description]
- > G_KASA.CKA_CISLO_KASY
- GKU_ID_UZIVATEL - [column description]
G_KASA_UZIVATEL_PREHLAD
[table description]
- KUP_ID_KASA - [column description]
- > G_KASA.CKA_CISLO_KASY
- KUP_ID_UZIVATEL - [column description]
- > L_UZIVATEL_PREDOK.UP_ID_UZIVATEL_PREDOK
G_KATEGORIA_PLU
[table description]
- KAP_ID - [column description]
- KAP_NAZOV - [column description]
- KAP_KOD_PLU_OD - [column description]
- KAP_KOD_PLU_DO - [column description]
- KAP_POVOLENY - [column description]
- KAP_PORADIE - [column description]
- KAP_BCKG_COLOR - [column description]
- KAP_CISLO - [column description]
- KAP_ZMAZANA - [column description]
- KAP_NAZOV_SKRAT - [column description]
G_KATEGORIA_PLU_VIAZANE
[table description]
- KPV_ID_HLAVNY - [column description]
- KPV_ID_VIAZANY - [column description]
G_KREDITNE_PLU
[table description]
- KRP_ID_PLU - [column description]
- > G_PLU.PLU_ID_PLU
- KRP_VKLAD - [column description]
- KRP_VYBER - [column description]
G_LOG_ZMENY
[table description]
- LZ_ID_LOG_ZMENY - [column description]
- LZ_DATUM - [column description]
- LZ_TABULKA - [column description]
- LZ_ID_TABULKY - [column description]
- LZ_ID_PREDOK - [column description]
- LZ_ID_UZIVATEL - [column description]
- > L_UZIVATEL.UZ_ID_UZIVATEL
- LZ_DRUH_ZMENY - [column description]
- LZ_ID_LOG_ZMENY_STLPEC - [column description]
- > G_LOG_ZMENY_STLPEC.LZS_ID_LOG_ZMENY_STLPEC
- LZ_OLD_VALUE - [column description]
- LZ_NEW_VALUE - [column description]
G_LOG_ZMENY_STLPEC
[table description]
- LZS_ID_LOG_ZMENY_STLPEC - [column description]
- LZS_NAZOV_STLPEC - [column description]
G_LOG_ZMENY_STLPEC_LANG
Multilingválna tabuľka.
- LZS_ID - [column description]
- > G_LOG_ZMENY_STLPEC.LZS_ID_LOG_ZMENY_STLPEC
- LZS_NAZOV_STLPEC - [column description]
- LZS_LANG - [column description]
G_LOKALNE_GASTRO
[table description]
- LGA_ID - [column description]
- LGA_NAZOV - [column description]
- LGA_PORT - [column description]
- LGA_IP_ADDRESS - [column description]
- LGA_ROZSAH_OD - [column description]
- LGA_ROZSAH_DO - [column description]
- LGA_MASTER - [column description]
- LGA_INTERVAL_ZASIELANIA_REPLIC - [column description]
- LGA_ZMAZANE - [column description]
- LGA_NOTE - [column description]
- LGA_COMPANY - [column description]
- LGA_ICO - [column description]
- LGA_DIC - [column description]
- LGA_ICDPH - [column description]
G_MASTER_PING_PONG_SETTINGS
[table description]
- MPS_ID - [column description]
- MPS_INTERVAL - [column description]
- MPS_PERSIST_AFTER_N_PINGS - [column description]
- MPS_PING_ID - [column description]
- MPS_ENABLED - [column description]
G_MASTER_PING_PONG_STATS
[table description]
- MST_ID - [column description]
- MST_ID_LOKALNE_GASTRO - [column description]
- > G_LOKALNE_GASTRO.LGA_ID
- MST_CREATED_MASTER - [column description]
- MST_SEND_MASTER - [column description]
- MST_RECIEVED_SLAVE - [column description]
- MST_SEND_SLAVE - [column description]
- MST_RECIEVED_MASTER - [column description]
- MST_PING_ID - [column description]
G_MASTER_PP_SETTINGS_POL
[table description]
- MPP_ID - [column description]
- > G_MASTER_PING_PONG_SETTINGS.MPS_ID
- MPP_ID_LOKALNE_GASTRO - [column description]
- > G_LOKALNE_GASTRO.LGA_ID
G_MEGA_COUNTER
[table description]
- GMC_ID - [column description]
- GMC_NAME - [column description]
- GMC_VALUE - [column description]
- GMC_MIN_VALUE - [column description]
- GMC_MAX_VALUE - [column description]
- GMC_OVERFLOW - [column description]
- GMC_UNDERFLOW - [column description]
- GMC_INCREMENT - [column description]
- GMC_TEXT - [column description]
G_MESIAC
[table description]
- MES_ID_MESIAC - [column description]
- MES_NAZ_MESIAC - [column description]
- MES_CIS_MESIAC - [column description]
- MES_CIS_JAVA_MESIAC - [column description]
G_MESIAC_LANG
Multilingválna tabuľka.
- MES_ID - [column description]
- > G_MESIAC.MES_ID_MESIAC
- MES_NAZ_MESIAC - [column description]
- MES_LANG - [column description]
G_NEODPISANY_TOVAR
[table description]
- NEO_ID_NEODPISANY_TOVAR - [column description]
- NEO_ID_DOKLAD_NEODPISANY_TOVAR - [column description]
- NEO_ID_TOVAR - [column description]
- NEO_ID_STREDISKO - [column description]
- NEO_MNOZSTVO - [column description]
G_OBCHODNY_PARTNER
[table description]
- COP_ID_OBCHODNY_PARTNER - [column description]
- > G_SUBJEKT.SUB_ID_SUBJEKT
- COP_TYP - [column description]
- COP_CIS_POVOLENIA_PREDAJA - [column description]
- COP_TYP_OBCHODU - [column description]
- COP_PREVADZKA - [column description]
- COP_DEFAULT_MENA - [column description]
- COP_POUZIVA_DEFAULTNU_MENU - [column description]
G_OBJ_BOD_ITEM_PARENT
[table description]
- BIP_ID - [column description]
- > G_OBJ_BOD_TO_ITEMS.OBI_ID
- BIP_NAME - [column description]
- BIP_ENABLED - [column description]
- BIP_TYP - [column description]
G_OBJ_BOD_ITEM_SIETOVA
[table description]
- BIS_ID - [column description]
- > G_OBJ_BOD_ITEM_PARENT.BIP_ID
- BIS_ZDRUZOVANIE_PLU - [column description]
- BIS_POCET_KOPII - [column description]
- BIS_MNOZSTVO_PRVE - [column description]
- BIS_OTVOR_ZASUVKU - [column description]
- BIS_ID_TLAC_SEKVENCIE - [column description]
- BIS_VPP_ID - [column description]
- > VPP_DEVICE.VPP_ID
- BIS_CODEPAGE - [column description]
- BIS_ORDER - [column description]
G_OBJ_BOD_ITEM_TERMINAL
[table description]
- BIT_ID - [column description]
- > G_OBJ_BOD_ITEM_PARENT.BIP_ID
- BIT_VTS_ID - [column description]
- > G_EXTERNE_SYSTEMY_VTS.ESV_ID
- BIT_VTS_ID_CLIENT - [column description]
- BIT_ORDER - [column description]
G_OBJ_BOD_TO_ITEMS
[table description]
- OBI_ID - [column description]
- OBI_OBJ_BOD_ID - [column description]
- > G_OBJEDNAVKOVY_BOD.OBP_ID
G_OBJEDNAVKOVY_BOD
[table description]
- OBP_ID - [column description]
- OBP_NUMBER - [column description]
- OBP_NAME - [column description]
G_ODBERATEL_FAKTURA
[table description]
- ODF_ID - [column description]
- ODF_ICO - [column description]
- ODF_NAZOV - [column description]
- ODF_DIC - [column description]
- ODF_ADRESA1 - [column description]
- ODF_ADRESA2 - [column description]
- ODF_PSC - [column description]
GOODS_TRANSFER_KIND_EXT
[table description]
- TKE_TRANSFER_KIND_ID - [column description]
- > G_DRUH_POHYBU.CDP_DRUH_POHYBU
- TKE_EXT_SYS_ID - [column description]
- > G_EXTERNE_SYSTEMY.EXS_ID
- TKE_RANGE - [column description]
- TKE_CODE - [column description]
GOODS_TRANSFER_ORDER
[table description]
- GTO_ID - [column description]
- GTO_CREATED_DATE - [column description]
- GTO_TRANSFER_DATE - [column description]
- GTO_NAME - [column description]
- GTO_CURRENCY - [column description]
- GTO_SUPPLIER_ID - [column description]
- > G_OBCHODNY_PARTNER.COP_ID_OBCHODNY_PARTNER
- GTO_TRANSFER_DOCUMENT_ID - [column description]
- > G_DOKLAD_POHYBY_TOVARU.POD_ID_POHYBY_TOVARU
- GTO_EXTERNAL_ID - [column description]
GOODS_TRANSFER_ORDER_ITEM
[table description]
- GTO_ORDER_ID - [column description]
- > GOODS_TRANSFER_ORDER.GTO_ID
- GTO_ORDER_ITEM_ID - [column description]
- GTO_GOODS_ID - [column description]
- > G_TOVAR.CTO_ID_TOVAR
- GTO_QUANTITY - [column description]
- GTO_UNIT_PRICE - [column description]
GOODS_TRANSFER_SEND
[table description]
- GTS_ID - [column description]
- GTS_TRANSFER_DOCUMENT_ID - [column description]
- > G_DOKLAD_POHYBY_TOVARU.POD_ID_POHYBY_TOVARU
- GTS_TRANSFER_DOCUMENT_STATE - [column description]
- GTS_EXT_SYS_ID - [column description]
- > G_EXTERNE_SYSTEMY.EXS_ID
- GTS_TIME_INIT - [column description]
- GTS_TIME_SENT - [column description]
- GTS_TIME_REJECTED - [column description]
- GTS_MESSAGE - [column description]
GP_AKCIA_LIMIT
[table description]
- AKP_ID - [column description]
- AKP_ID_TYP_UDALOSTI - [column description]
- AKP_LIMIT - [column description]
- AKP_CAS_PLATNOSTI_OD - [column description]
- AKP_CAS_PLATNOSTI_DO - [column description]
GP_AKCIA_UDALOST
[table description]
- AKP_ID - [column description]
- AKP_ID_TYP_UDALOSTI - [column description]
- AKP_ID_UDALOST - [column description]
- AKP_DATUM_CAS_REALIZACIE - [column description]
- AKP_TYP_ODBYTU - [column description]
- AKP_POCET_OSOB - [column description]
- AKP_ID_STREDISKO - [column description]
- AKP_CISLO_POKLADNE - [column description]
- AKP_POZNAMKA - [column description]
- AKP_STAV - [column description]
- AKP_ID_ZAPISAL - [column description]
- AKP_DATUM_CAS_VYTVORENIA - [column description]
- AKP_MARZA - [column description]
- AKP_POCET_REAL - [column description]
- AKP_NA_JEDNU_STRAVNU_JEDNOTKU - [column description]
- AKP_CAS_PLATNOSTI_OD - [column description]
- AKP_CAS_PLATNOSTI_DO - [column description]
GP_AKCIA_UDALOST_POLOZKA
[table description]
- APP_ID_UDALOST - [column description]
- APP_PORADIE - [column description]
- APP_ID_TOVAR_JEDLO - [column description]
- APP_MNOZSTVO - [column description]
- APP_ID - [column description]
- APP_ID_ODBYT_STRED - [column description]
- APP_KALK_CENA - [column description]
- APP_ID_TYP_POLOZKY_OBJEDNAVKY - [column description]
GP_BALIK_PLU_POLOZKY
[table description]
- ID - [column description]
- PBP_ID - [column description]
- PBP_PORADIE - [column description]
- PBP_ID_PLU - [column description]
- PBP_MNOZSTVO - [column description]
GP_CENOVY_PROFIL_ZLAVA
[table description]
- CPR_ID - [column description]
- CPR_ID_KATEGORIA_PLU - [column description]
- CPR_KASA_GROUP_ID - [column description]
- CPR_ZLAVA - [column description]
G_PERCENTO_ALKOHOLU
[table description]
- CPA_ID_PERCENTO_ALKOHOLU - [column description]
- CPA_PERCENTO_ALKOHOLU - [column description]
GP_EXTERNE_SYSTEMY_TAP_DEV
[table description]
- EVD_ID_TEMP - [column description]
- EVD_EXT_SYS_ID - [column description]
- EVD_MOVE_TO_TABLE - [column description]
- EVD_MOVE_TO_TABLE_OPEN - [column description]
- EVD_MOVE_TO_TABLE_FIRST - [column description]
GP_EXTSYS_FIDELIO_ZASL_ITEMS
[table description]
- EFZ_ID_TEMP - [column description]
- EFZ_CISLO - [column description]
- EFZ_NAME - [column description]
- EFZ_SALES_OUTLET - [column description]
- EFZ_DPH - [column description]
GP_EXT_SYS_ORDERS_KASA
[table description]
- ID - [column description]
- SOK_CISLO_KASY - [column description]
- SOK_AKCIA - [column description]
GP_EXT_SYS_PLU
[table description]
- ESP_ID_TEMP - [column description]
- ESP_PLU_ID - [column description]
- ESP_EXT_SYS_ID - [column description]
- ESP_EXT_CODE - [column description]
- ESP_ENABLED - [column description]
GP_EXT_SYS_PLU_KASA
[table description]
- EPK_ID_TEMP - [column description]
- EPK_PLU_ID - [column description]
- EPK_EXT_SYS_ID - [column description]
- EPK_CASH_DESK_ID - [column description]
GP_EXT_SYS_REST_TABLE
[table description]
- ERT_ID_TEMP - [column description]
- ERT_TABLE_ID - [column description]
- ERT_EXT_CODE - [column description]
GP_EXT_SYS_USER
[table description]
- ESU_ID_TEMP - [column description]
- ESU_USER_ID - [column description]
- ESU_EXT_CODE - [column description]
GP_GOODS_EAN
[table description]
- GDE_ID - [column description]
- GDE_ID_TEMP - [column description]
- GDE_ID_GOODS - [column description]
- GDE_EAN - [column description]
GP_IMPORT_TOVAROV
[table description]
- ID - [column description]
- ITV_ID_TOVAR - [column description]
- ITV_ID_TOVAR_REF - [column description]
- ITV_TOVAR_JEDLO - [column description]
- ITV_TOVAR_NAZOV - [column description]
- ITV_TOVAR_REF_NAZOV - [column description]
- ITV_IMPORTUJ - [column description]
- ITV_ID_TOVAR_REF_EXT - [column description]
- ITV_ID_TOVAR_REF_ORIGINAL - [column description]
- ITV_DRUH_TOVAR_JEDLO - [column description]
- ITV_DPT_TOVAR_JEDLO - [column description]
- ITV_DRUH_NAZOV - [column description]
- ITV_DPT_NAZOV - [column description]
G_PLATBY_PLANOVANIE
[table description]
- PLP_ID_PLATBY_PLANOVANIE - [column description]
- PLP_ABSOLUTNA_SUMA - [column description]
- PLP_NAZOV - [column description]
- PLP_PERCENTO_ZO_SUMY - [column description]
- PLP_SKUPINA_PLATIEB - [column description]
- PLP_ID_SKUPINA_PLATIEB - [column description]
- > G_SPOSOB_PLATBY_SKUPINA.SPS_ID
- PLP_SUMA_TRZBY_POKLADNE - [column description]
- PLP_ZAKLAD_SUMY - [column description]
- PLP_VYPOCET_TRZIEB_ZA - [column description]
- PLP_SUMA_DO - [column description]
- PLP_DATUM_CAS_OD - [column description]
- PLP_DATUM_CAS_DO - [column description]
- PLP_INICIALIZOVANY - [column description]
- PLP_BILL_AMOUNT_FROM - [column description]
- PLP_BILL_AMOUNT_TO - [column description]
G_PLATBY_PLANOVANIE_KASY
[table description]
- PPK_ID_PLATBY_PLANOVANIE - [column description]
- > G_PLATBY_PLANOVANIE.PLP_ID_PLATBY_PLANOVANIE
- PPK_CISLO_KASY - [column description]
- > G_KASA.CKA_CISLO_KASY
- PPK_AKTIVNE - [column description]
- PPK_SUMA_DO - [column description]
G_PLAT_KARTA_TYP
[table description]
- PKT_ID_PLAT_KARTA_TYP - [column description]
- PKT_KOD - [column description]
- PKT_NAZOV - [column description]
- PKT_POVOLENA - [column description]
G_PLU
Číselník PLU.
- PLU_ID_PLU - [column description]
- PLU_KOD_PLU - [column description]
- PLU_TEXT_PLU - [column description]
- PLU_KOD_DPT - [column description]
- PLU_ID_TOVAR_JEDLO - [column description]
- PLU_ID_PLU1 - [column description]
- PLU_POCET_JEDNOTIEK - [column description]
- PLU_ID_ZLAVA - [column description]
- PLU_ZMAZANE - [column description]
- PLU_TYP - [column description]
- PLU_POZNAMKA - [column description]
- PLU_ID_AKCIA_UDALOST - [column description]
- PLU_ID_KATEGORIA - [column description]
- PLU_ID_KARTA_SLUZBA - [column description]
- PLU_DPH - [column description]
- PLU_ID_UCTOVNY_DRUH - [column description]
- > G_UCTOVNY_DRUH.UDR_ID
- PLU_ID_EXTERNY_SYSTEM - [column description]
- PLU_ID_PLU_EXT_SYSTEM - [column description]
- PLU_SEGMENT_ID - [column description]
- > G_PLU_SEGMENT.PSG_ID
- PLU_ALT_VAT_ID - [column description]
- PLU_LOYALTY_TMR - [column description]
G_PLU_CENY_V_MENACH
[table description]
- PCM_KODME - [column description]
- PCM_ID_PLU - [column description]
- PCM_CISLO_KASY - [column description]
- > G_KASA.CKA_CISLO_KASY
- PCM_CENA - [column description]
- PCM_CENA2 - [column description]
G_PLU_EXT
Rozšírenie čiselníka PLU.
- PLE_ID_PLU - [column description]
- PLE_EAN - [column description]
- PLE_SPECIFIKACIA - [column description]
- PLE_ID_PRODUKT - [column description]
- PLE_ID_SPECIF - [column description]
- PLE_ID_EXTERNY_SYSTEM - [column description]
- > G_EXTERNE_SYSTEMY.EXS_ID
- PLE_ID_PLU_EXTERNY_SYSTEM - [column description]
- PLE_IMAGE_DISABLED - [column description]
- PLE_IMAGE_DOUBLE_SIZE - [column description]
- PLE_IMAGE_SHOW_TEXT - [column description]
- PLE_IMAGE_ALIGN_HORIZONTAL - [column description]
- PLE_IMAGE_ALIGN_VERTICAL - [column description]
- PLE_TEXT_COLOR - [column description]
- PLE_PREVZATY_EAN_Z_TOVARU - [column description]
- PLE_POVINNY_EAN_PRI_PREDAJI - [column description]
- PLE_PREDAJ_LEN_CELE_MNOZSTVO - [column description]
- PLE_IMAGE_FILE - [column description]
G_PLU_KASA
Nastavenie PLU na pokladniach.
- PLK_CISLO_KASY - [column description]
- > G_KASA.CKA_CISLO_KASY
- PLK_ID_PLU - [column description]
- PLK_CENA - [column description]
- PLK_CENA2 - [column description]
- PLK_KP - [column description]
- PLK_IOP - [column description]
- PLK_POVOLENE - [column description]
- PLK_CENOVA_HLADINA - [column description]
- PLK_ID_ODBYTOVE_STREDISKO - [column description]
- PLK_ZMENA - [column description]
- PLK_PORADIE - [column description]
G_PLU_KASA_ROZPRACOVANE
[table description]
- PKR_IDS - [column description]
- PKR_CISLO_KASY - [column description]
- PKR_ID_PLU - [column description]
- PKR_CENA - [column description]
- PKR_CENA2 - [column description]
- PKR_KP - [column description]
- PKR_IOP - [column description]
- PKR_POVOLENE - [column description]
- PKR_CENOVA_HLADINA - [column description]
- PKR_ID_ODBYTOVE_STREDISKO - [column description]
- PKR_ZMENA - [column description]
- PKR_TO_BE_DONE - [column description]
- PKR_ID_TEMP - [column description]
- PKR_PORADIE - [column description]
G_PLU_KLAVESOVA_SKRATKA
[table description]
- PKS_ID_PLU_KLAVESOVA_SKRATKA - [column description]
- PKS_KLAVESOVA_SKRATKA - [column description]
- PKS_ID_PLU - [column description]
- PKS_DATUM_OD - [column description]
- PKS_CISLO_KASY - [column description]
- > G_KASA.CKA_CISLO_KASY
G_PLU_LG_POCET
[table description]
- PLP_ID_PLU - [column description]
- PLP_ID_LOKALNE_GASTRO - [column description]
- > G_LOKALNE_GASTRO.LGA_ID
- PLP_POCET - [column description]
G_PLU_LG_POCET_ZMENA
[table description]
- PLZ_ID - [column description]
- PLZ_ID_PLU - [column description]
- PLZ_ID_LOKALNE_GASTRO - [column description]
- PLZ_ZMENA_INC - [column description]
- PLZ_ZMENA_ABS - [column description]
G_PLU_SEGMENT
[table description]
- PSG_ID - [column description]
- PSG_ORDER - [column description]
- PSG_NAME - [column description]
- PSG_DELETED - [column description]
G_PLU_TARA
[table description]
- PLT_ID - [column description]
- PLT_CODE - [column description]
- PLT_NAME - [column description]
- PLT_WEIGHT_KG - [column description]
GP_ODVOD
[table description]
- ID - [column description]
- ODV_CISLO_KASY - [column description]
- ODV_ID_TRN - [column description]
- ODV_MENA - [column description]
- ODV_MNOZSTVO - [column description]
- ODV_SUMA - [column description]
G_POHYB_JEDLA
[table description]
- POJ_ID_POHYBY_JEDLA - [column description]
- > G_DOKLAD_POHYBY_JEDLA.DPJ_ID_POHYBY_JEDLA
- POJ_PORADIE - [column description]
- POJ_ID_TOVAR_JEDLO - [column description]
- POJ_NAZOV_JEDLA - [column description]
- POJ_MNOZSTVO - [column description]
- POJ_SADZBA_DPH - [column description]
- POJ_CENA_PRIPR_STRED - [column description]
- POJ_CENA_KAM - [column description]
- POJ_ID_STREDISKO - [column description]
- POJ_TYP - [column description]
- POJ_ID_TYP_POLOZKY_OBJEDNAVKY - [column description]
- POJ_ID_UDALOST - [column description]
- > G_POHYB_JEDLA_UDALOST.PJU_ID
- POJ_CENOVA_HLADINA - [column description]
- POJ_CISLO_KASY - [column description]
- POJ_CISLO_TOVAR_JEDLO - [column description]
G_POHYB_JEDLA_UDALOST
[table description]
- PJU_ID - [column description]
- PJU_PORADIE - [column description]
- PJU_ID_POHYBY_JEDLA - [column description]
- > G_DOKLAD_POHYBY_JEDLA.DPJ_ID_POHYBY_JEDLA
- PJU_ID_TYP_UDALOSTI - [column description]
- > G_AKCIA_TYP_UDALOSTI.ATU_ID_TYP_UDALOSTI
- PJU_ID_PRIESTOR - [column description]
- > G_PRIESTOR.PR_ID
- PJU_DATUM - [column description]
- PJU_POCET_OSOB - [column description]
- PJU_CAS_OD - [column description]
- PJU_CAS_DO - [column description]
G_POHYB_TOVARU
[table description]
- POT_ID_POHYBY_TOVARU - [column description]
- > G_DOKLAD_POHYBY_TOVARU.POD_ID_POHYBY_TOVARU
- POT_PORADIE - [column description]
- POT_ID_TOVAR - [column description]
- POT_NAZOV_TOVARU - [column description]
- POT_MNOZSTVO - [column description]
- POT_SADZBA_DPH - [column description]
- POT_CENA_NA_STREDISKU - [column description]
- POT_NAKUPNA_CENA_BDPH - [column description]
- POT_NAKUPNA_CENA_SDPH - [column description]
- POT_MNOZSTVO_PRED - [column description]
- POT_MNOZSTVO_PO - [column description]
- POT_JM - [column description]
- POT_ID_CIELOVE_STREDISKO - [column description]
- POT_PORADIE_PARENT - [column description]
- POT_MNOZSTVO_MJ - [column description]
- POT_INTERNA_SPOTREBA - [column description]
- POT_NAKUPNA_CENA_BDPH_CM - [column description]
- POT_NAKUPNA_CENA_SDPH_CM - [column description]
- POT_TOVAR_MATERIAL - [column description]
- POT_TOVAR_EAN - [column description]
- POT_ZDRUZENY_TOVAR_ID - [column description]
- > G_TOVAR.CTO_ID_TOVAR
- POT_ZDRUZENY_TOVAR_MNOZSTVO - [column description]
GP_PLU_CENY_V_MENACH
[table description]
- GPCM_ID - [column description]
- GPCM_KODME - [column description]
- GPCM_ID_PLU - [column description]
- GPCM_CISLO_KASY - [column description]
- GPCM_CENA_OLD - [column description]
- GPCM_CENA - [column description]
- GPCM_CENA_OLD2 - [column description]
- GPCM_CENA2 - [column description]
GP_PLU_KASA
[table description]
- ID - [column description]
- PPK_CISLO_KASY - [column description]
- PPK_ID_PLU - [column description]
- PPK_CENA - [column description]
- PPK_CENA2 - [column description]
- PPK_KP - [column description]
- PPK_IOP - [column description]
- PPK_ZMENA - [column description]
- PPK_POVOLENE - [column description]
- PPK_CENOVA_HLADINA - [column description]
- PPK_ID_ODBYTOVE_STREDISKO - [column description]
- PPK_IDS - [column description]
- PPK_PORADIE - [column description]
GP_POHYB_JEDLA
[table description]
- POJ_ID_TEMP - [column description]
- POJ_PORADIE - [column description]
- POJ_ID_TOVAR_JEDLO - [column description]
- POJ_NAZOV_JEDLA - [column description]
- POJ_MNOZSTVO - [column description]
- POJ_SADZBA_DPH - [column description]
- POJ_CENA_PRIPR_STRED - [column description]
- POJ_CENA_KAM - [column description]
- POJ_ID_STREDISKO - [column description]
- POJ_TYP - [column description]
- POJ_ID_TYP_POLOZKY_OBJEDNAVKY - [column description]
- POJ_ID_UDALOST - [column description]
- POJ_CENOVA_HLADINA - [column description]
- POJ_CISLO_KASY - [column description]
- POJ_CISLO_TOVAR_JEDLO - [column description]
GP_POHYB_JEDLA_UDALOST
[table description]
- PJU_ID - [column description]
- PJU_ID_TEMP - [column description]
- PJU_PORADIE - [column description]
- PJU_ID_TYP_UDALOSTI - [column description]
- PJU_ID_PRIESTOR - [column description]
- PJU_DATUM - [column description]
- PJU_POCET_OSOB - [column description]
- PJU_CAS_OD - [column description]
- PJU_CAS_DO - [column description]
GP_POHYB_TOVARU
[table description]
- ID - [column description]
- POT_PORADIE - [column description]
- POT_ID_TOVAR - [column description]
- POT_NAZOV_TOVARU - [column description]
- POT_MNOZSTVO - [column description]
- POT_SADZBA_DPH - [column description]
- POT_CENA_NA_STREDISKU - [column description]
- POT_NAKUPNA_CENA - [column description]
- POT_MNOZSTVO_PRED - [column description]
- POT_MNOZSTVO_PO - [column description]
- POT_ID_TOVAR_NA_SKLAD - [column description]
- POT_MNOZSTVO_NA_SKLAD - [column description]
- POT_NAKUPNA_CENA_NA_SKLAD - [column description]
- POT_ID_CIELOVE_STREDISKO - [column description]
- POT_PORADIE_PARENT - [column description]
- POT_INTERNA_SPOTREBA - [column description]
- POT_TOVAR_MATERIAL - [column description]
- POT_TOVAR_EAN - [column description]
- POT_ZDRUZENY_TOVAR_ID - [column description]
- POT_ZDRUZENY_TOVAR_MNOZSTVO - [column description]
GP_PORADIE_KATEGORII
[table description]
- ID - [column description]
- PKA_ID_KASA - [column description]
- PKA_ID_KATEGORIA - [column description]
- PKA_NAZOV_KATEGORIE - [column description]
- PKA_PORADIE - [column description]
- PKA_PRIZNAK_PORADIA - [column description]
GP_PROD_TERMINAL_CLIENTS
[table description]
- ID - [column description]
- PTC_CLIENT_ID - [column description]
- PTC_CLIENT_NUMBER - [column description]
- PTC_CLIENT_NAME - [column description]
- PTC_LANGUAGE - [column description]
G_PRACOVNA_STANICA
[table description]
- PS_ID_STANICA - [column description]
- PS_IDENT - [column description]
- PS_PAMATAT_VELKOSTI_OKIEN - [column description]
- PS_ZAROVNAT_OKNA - [column description]
- PS_OKNA_HORIZONTALNY_POSUN - [column description]
- PS_OKNA_VERTIKALNY_POSUN - [column description]
- PS_AUTOMATICKE_HLADANIE - [column description]
- PS_TYP - [column description]
- PS_HINT_PREPOCET_MENA - [column description]
- PS_HINT_POVOLENY - [column description]
- PS_HINT_KONV_MENA - [column description]
- PS_ZOSTAVY_VYBER_MENY - [column description]
- PS_AUTO_PIHLAS_UZIVATEL_OS - [column description]
- PS_WORKSTATION_PDA_TYPE - [column description]
- PS_DELETED - [column description]
- PS_GIN - [column description]
- > G_LOKALNE_GASTRO.LGA_ID
G_PRACOVNA_STANICA_ZARIADENIE
[table description]
- PZ_ID_STANICA - [column description]
- > G_PRACOVNA_STANICA.PS_ID_STANICA
- PZ_ID_ZARIADENIE - [column description]
- PZ_PORT - [column description]
- PZ_IDENTIFIKATOR - [column description]
- PZ_IP_ADRESA - [column description]
- PZ_IP_PORT - [column description]
- PZ_LOCAL_PORT - [column description]
- PZ_ID_KOD_TYP - [column description]
- PZ_CISLOKARTY_EAN - [column description]
- PZ_PORADIE - [column description]
- PZ_READ_TIMEOUT - [column description]
- PZ_POVOL_MANAGER - [column description]
- PZ_POVOL_CASH - [column description]
GP_RECEPT
[table description]
- ID - [column description]
- CRE_PORADIE - [column description]
- CRE_ID_JEDLO - [column description]
- CRE_ID_SUROVINY - [column description]
- CRE_HRUBE_MNOZSTVO - [column description]
- CRE_CISTE_MNOZSTVO - [column description]
- CRE_POZNAMKA - [column description]
G_PREDAJ_GRUPA
[table description]
- PGR_ID_UZAVIERA - [column description]
- > G_UZAVIERKA.UZA_ID_UZAVIERKY
- PGR_KOD_GRUPY - [column description]
- PGR_TEXT_GRUPY - [column description]
- PGR_MNOZSTVO - [column description]
- PGR_SUMA - [column description]
G_PREDAJ_HODINY
[table description]
- PHO_ID_UZAVIERKY - [column description]
- > G_UZAVIERKA.UZA_ID_UZAVIERKY
- PHO_OD - [column description]
- PHO_DO - [column description]
- PHO_MNOZSTVO - [column description]
- PHO_SUMA - [column description]
G_PREDAJ_PLU
[table description]
- PPL_ID_UZAVIERKA - [column description]
- > G_UZAVIERKA.UZA_ID_UZAVIERKY
- PPL_ID_PLU - [column description]
- PPL_KOD_PLU - [column description]
- PPL_TEXT_PLU - [column description]
- PPL_KOD_DPT - [column description]
- PPL_SADZBA_DPH - [column description]
- PPL_MNOZSTVO - [column description]
- PPL_SUMA - [column description]
- PPL_ID_ODBYTOVE_STREDISKO - [column description]
- PPL_KALK_CENA - [column description]
- PPL_ID_DRUH_TOVAR_JEDLO - [column description]
G_PREDAJ_PLU_TRN
[table description]
- PPT_ID_UZAVIERKY - [column description]
- > G_UZAVIERKA.UZA_ID_UZAVIERKY
- PPT_ID_PLU - [column description]
- PPT_ID_TRN - [column description]
- PPT_MNOZSTVO - [column description]
- PPT_SUMA - [column description]
G_PREDAJ_TRN
[table description]
- PTR_ID_UZAVIERKY - [column description]
- > G_UZAVIERKA.UZA_ID_UZAVIERKY
- PTR_ID_TRN - [column description]
- PTR_TEXT_TRN - [column description]
- PTR_MNOZSTVO - [column description]
- PTR_SUMA - [column description]
- PTR_KATEGORIA - [column description]
G_PREDAJ_TRZBY
[table description]
- PTZ_ID_UZAVIERKY - [column description]
- > G_UZAVIERKA.UZA_ID_UZAVIERKY
- PTZ_ID_TRN - [column description]
- PTZ_PORADIE - [column description]
- PTZ_SUMA - [column description]
- PTZ_POCET_UCET - [column description]
- PTZ_MNOZSTVO - [column description]
- PTZ_KURZ - [column description]
- PTZ_CENA_LISTKA - [column description]
G_PREDAJ_UCTUJUCI_DRUHY
[table description]
- PUD_ID_UZAVIERKA - [column description]
- > G_UZAVIERKA.UZA_ID_UZAVIERKY
- PUD_ID_UCTUJUCI - [column description]
- PUD_ID_DRUH_TOVAR_JEDLO - [column description]
- PUD_MNOZSTVO - [column description]
- PUD_SUMA - [column description]
- PUD_CKASY - [column description]
G_PREDAJ_UCTUJUCI_TRN
[table description]
- PUC_ID_UZAVIERKY - [column description]
- > G_UZAVIERKA.UZA_ID_UZAVIERKY
- PUC_ID_UCTUJUCI - [column description]
- PUC_ID_TRN - [column description]
- PUC_MENO_UCTUJUCEHO - [column description]
- PUC_MNOZSTVO - [column description]
- PUC_SUMA - [column description]
G_PREDEFINED_COLORS
[table description]
- GPC_ID - [column description]
- GPC_IDENT - [column description]
- GPC_COLOR_HEX_RGB - [column description]
G_PREPOCET_NASTAVENIA
[table description]
- PN_ID - [column description]
- PN_ID_KURZOVY_LISTOK - [column description]
- > K_KL_KURZOVY_LISTOK.KLN_ID_KURZOVY_LISTOK
- PN_KOD_MENY - [column description]
- > K_KL_MENA.KLM_KOD_MENY
- PN_ZAOK_DESATINY - [column description]
- PN_ZAOK_TYP - [column description]
- PN_KURZ - [column description]
- PN_ENABLED - [column description]
- PN_TYP_KURZU_PREPOCET - [column description]
- PN_KONVERZNA - [column description]
- PN_ZAOK_50_HAL - [column description]
- PN_NEPRIAMA_KOTACIA - [column description]
G_PREVADZKA
[table description]
- GPR_ID_PREVADZKA - [column description]
- GPR_NAZOV - [column description]
- GPR_POVOLENA - [column description]
G_PREVOD_DRUHOV_TOVAROV
[table description]
- PDT_NAZOV_OLD - [column description]
- PDT_PORADIE_OLD - [column description]
- PDT_ID_NEW - [column description]
G_PRIESTOR
[table description]
- PR_ID - [column description]
- PR_CISLO - [column description]
- PR_NAZOV - [column description]
GP_ROZPIS_SUROVIN
[table description]
- RSU_ID_TEMP - [column description]
- RSU_ID_TOVAR_JEDLO - [column description]
- RSU_ID_SUROVINA - [column description]
- RSU_MNOZSTVO - [column description]
- RSU_ZASOBA - [column description]
- RSU_ID_STREDISKO - [column description]
- RSU_MNOZSTVO_CISTE - [column description]
- RSU_ID_PLU - [column description]
- RSU_SUROVINA_POZNAMKA - [column description]
- RSU_PORADIE - [column description]
- RSU_TYP_POLOZKY - [column description]
- RSU_EXT_PORADIE - [column description]
GP_TJ_CENA_V_MENE
[table description]
- GTCM_IDS - [column description]
- GTCM_ID_TOVAR_JEDLO - [column description]
- GTCM_CENOVA_HLADINA - [column description]
- GTCM_KODME - [column description]
- GTCM_CENA - [column description]
GP_TOVAR_ZMENA_KCIEN
[table description]
- TZK_ID_TOVAR - [column description]
- TZK_CENA - [column description]
- TZK_PRIRAZKA - [column description]
GP_UCTOVACI_PROFIL_POLOZKY
[table description]
- GUP_ID - [column description]
- GUP_CISLO_PROFILU - [column description]
- GUP_KATEGORIA_PLU - [column description]
- GUP_PERCENTO - [column description]
GP_ZAMENA_SUROVIN
[table description]
- ID - [column description]
- PZS_ID_TOVAR_JEDLO_POVODNE - [column description]
- PZS_ID_TOVAR_JEDLO_NOVA - [column description]
- PZS_KOEFICIENT - [column description]
- PZS_NOTE - [column description]
- PZS_NOTE_ALLOW - [column description]
GP_ZMENA_SADZBY_DPH
[table description]
- ZSD_ID_TEMP - [column description]
- ZSD_DPH - [column description]
- ZSD_SADZBA_CASH - [column description]
- ZSD_SADZBA_MANAGER - [column description]
- ZSD_FISCAL_VAT_LEVEL - [column description]
G_RECEPT
[table description]
- CRE_ID_JEDLO - [column description]
- CRE_PORADIE - [column description]
- CRE_ID_SUROVINY - [column description]
- > G_TOVAR_JEDLO.CTJ_ID_TOVAR_JEDLO
- CRE_HRUBE_MNOZSTVO - [column description]
- CRE_CISTE_MNOZSTVO - [column description]
- CRE_POZNAMKA - [column description]
G_REST_PRIESTOR
Zoznam priestorov (miestností).
- RPR_ID_PRIESTOR - [column description]
- RPR_KOD - [column description]
- RPR_POPIS - [column description]
- RPR_POVOLENY - [column description]
- RPR_NAZOV - [column description]
G_REST_PRIESTOR_NEVIDITELNOST
NEviditelnosť priestorov pre pokladne.
- RPN_ID_KASA - [column description]
- > G_KASA.CKA_CISLO_KASY
- RPN_ID_PRIESTOR - [column description]
G_REST_PRIESTOR_PORADIE
Poradie priestorov na jednotlivých pokladniach.
- RPP_ID_KASA - [column description]
- RPP_ID_PRIESTOR - [column description]
- RPP_PORADIE - [column description]
G_REST_STOL
Stoly definované v priestoroch (miestnostiach).
- RST_ID_STOL - [column description]
- RST_CISLO - [column description]
- RST_PRIESTOR_ID - [column description]
- RST_POZICIA_X - [column description]
- RST_POZICIA_Y - [column description]
- RST_SIRKA - [column description]
- RST_VYSKA - [column description]
- RST_TVAR - [column description]
- RST_POVOLENY - [column description]
- RST_DELETED - [column description]
G_ROZPRACOVANOST
[table description]
- SUJ_ID_STREDISKO - [column description]
- SUJ_ID_TOVAR_JEDLO - [column description]
- SUJ_MNOZSTVO - [column description]
G_ROZSIAHLY_EUR_FORMULAR
[table description]
- REF_ID - [column description]
- REF_ZOBR_KONV_MENY_OD - [column description]
- REF_ZOBR_KONV_MENY_DO - [column description]
- REF_DATUM_KONV_POKLADNE - [column description]
- REF_ZAOKR_JEDN_CENY_POL - [column description]
- REF_ZAOKR_CENA_UCT_POL - [column description]
- REF_ZAOKR_VYPOCET_DPH - [column description]
- REF_ZAOKR_NA_50_HAL - [column description]
- REF_TEXT_PLATBY_OLD_DOMACA - [column description]
- REF_PLATBA_OLD_ZAOKR - [column description]
- REF_PLATBA_OLD_TYP_ZAOK - [column description]
- REF_PLATBA_INFO_OLD_ZAOKR - [column description]
- REF_PLATBA_INFO_OLD_TYP_ZAOK - [column description]
- REF_PLATBA_NEW_ZAOKR - [column description]
- REF_PLATBA_NEW_TYP_ZAOK - [column description]
- REF_PLATBA_INFO_NEW_ZAOKR - [column description]
- REF_PLATBA_INFO_NEW_TYP_ZAOK - [column description]
- REF_PLATNOST_OLD_MENA_DO - [column description]
- REF_KONV_POKLADNE_POVOLENA - [column description]
- REF_KONV_SKLAD_POVOLENA - [column description]
- REF_KONV_MENA_Z - [column description]
- REF_KONV_MENA_DO - [column description]
- REF_DATUM_KONV_SKLAD - [column description]
- REF_DEF_CIEN_KONV_MENY_OD - [column description]
- REF_ZAOKR_PRED_CENA_SKLAD - [column description]
- REF_ZAOKR_DPH_SKLAD - [column description]
- REF_DEFAULT_MENA_SKLAD - [column description]
G_SADZBA_DPH
Hladiny DPH.
- DPH_DPH - [column description]
- DPH_SADZBA - [column description]
- DPH_FISCAL_VAT_LEVEL - [column description]
G_SETTINGS
Všeobecné nastavenia BG - generované z XML 'Asseco BLUEGASTRO\ServerAsseco BLUEGASTRO\src\sk\datalock\blue_gastro\settings\blue_gastro\Asseco BLUEGASTROSettingsMapping.xml'
- SET_ID - [column description]
- SET_PATH - [column description]
- SET_NAME - [column description]
- SET_CLASS - [column description]
- SET_VALUE - [column description]
G_SLUZBA
[table description]
- SLU_ID_SLUZBA - [column description]
- SLU_NAKLADY_CENA - [column description]
- SLU_PRIRAZKA - [column description]
- SLU_POPIS - [column description]
G_SLUZBA_EXT_ERS
[table description]
- SEE_ID_SLUZBA - [column description]
- SEE_SERVICE_ID - [column description]
- SEE_ID_SERVICE_TYPE - [column description]
G_SPINTOTAL_DAVKA
[table description]
- GSD_ID_SPINTOTAL_DAVKA - [column description]
- GSD_OD_UCET_ID - [column description]
- GSD_DO_UCET_ID - [column description]
- GSD_OD_ODVOD_ID - [column description]
- GSD_DO_ODVOD_ID - [column description]
- GSD_PREVADZKA_LG_ID - [column description]
- GSD_DATUM_CAS_VYHOT - [column description]
- GSD_POTVRDENA - [column description]
- GSD_DAVKA - [column description]
G_SPINTOTAL_PLULIST_LOG
[table description]
- GSP_ID_SPINTOTAL_PLULIST_LOG - [column description]
- GSP_METODA_WS - [column description]
- GSP_PREVADZKA_LG_ID - [column description]
- GSP_PLULIST_DATUM_PARAM - [column description]
- GSP_DATUM_CAS_SPRAC_OD - [column description]
- GSP_DATUM_CAS_SPRAC_DO - [column description]
- GSP_CTRL_POCET_PRODUKTOV - [column description]
- GSP_CTRL_SUMAR_MNOZSTVA - [column description]
- GSP_POPIS - [column description]
- GSP_DAVKA - [column description]
G_SPOSOB_PLATBY
[table description]
- SPL_ID_SPOSOB_PLATBY - [column description]
- SPL_KOD_PLATBY - [column description]
- SPL_TEXT_PLATBY - [column description]
- SPL_FISKALNY_TYP - [column description]
- SPL_POVOLENA - [column description]
- SPL_CENA_LISTKA - [column description]
- SPL_ID_TRN - [column description]
- SPL_VYDAVAT_Z_CENY_LISTKA - [column description]
- SPL_INTERNA - [column description]
- SPL_KLAVESOVA_SKRATKA - [column description]
- SPL_CENOVA_HLADINA - [column description]
- SPL_TLACIT_POCET_KOPII - [column description]
- SPL_ID_TYP_PLATBY - [column description]
- SPL_MENA - [column description]
- SPL_ZADAVAT_TYP_PLAT_KARTY - [column description]
- SPL_ALTERNATIVNA - [column description]
- SPL_QUICK_PAY - [column description]
- SPL_QUICK_PAY_ALT - [column description]
- SPL_SLEDOVANY_SPOSOB_PLATBY - [column description]
- SPL_MENIT_SUMU_LISTKA - [column description]
- SPL_VYMAZANA - [column description]
- SPL_PORADIE - [column description]
- SPL_FISCAL_PAYMENT_INDEX - [column description]
- SPL_BANK_CARD - [column description]
- SPL_DONT_PRINT - [column description]
- SPL_GROUP_LIMIT - [column description]
- > PAYMENT_GROUP_LIMITS.PGL_ID
G_SPOSOB_PLATBY_DPH
[table description]
- SPD_ID_SPOSOB_PLATBY - [column description]
- SPD_DPH - [column description]
- SPD_DPH_ID_TRN - [column description]
- SPD_BEZ_DPH_ID_TRN - [column description]
G_SPOSOB_PLATBY_KATEGORIA
[table description]
- SPK_ID_PLATBA - [column description]
- > G_SPOSOB_PLATBY.SPL_ID_SPOSOB_PLATBY
- SPK_ID_KATEGORIA - [column description]
- > G_KATEGORIA_PLU.KAP_ID
G_SPOSOB_PLATBY_SKUPINA
[table description]
- SPS_ID - [column description]
- SPS_NAZOV - [column description]
- SPS_PORADIE - [column description]
- SPS_ZMAZANA - [column description]
G_SPOSOB_PLATBY_SKUP_PRIR
[table description]
- PSP_SPOSOB_PLATBY_SKUPINA_ID - [column description]
- > G_SPOSOB_PLATBY_SKUPINA.SPS_ID
- PSP_SPOSOB_PLATBY_ID - [column description]
- > G_SPOSOB_PLATBY.SPL_ID_SPOSOB_PLATBY
G_SPOSOB_PLATBY_TYP
[table description]
- SPT_ID_TYP_PLATBY - [column description]
- SPT_TEXT_TYP_PLATBY - [column description]
G_SPOSOB_PLATBY_TYP_LANG
Multilingválna tabuľka.
- SPT_ID - [column description]
- > G_SPOSOB_PLATBY_TYP.SPT_ID_TYP_PLATBY
- SPT_TEXT_TYP_PLATBY - [column description]
- SPT_LANG - [column description]
G_SPOSOB_PLATBY_UZIVATEL
[table description]
- SPU_ID_PLATBA - [column description]
- SPU_ID_UZIVATEL - [column description]
G_STASTNE_HODINY
[table description]
- STH_ID_STASTNE_HODINY - [column description]
- STH_CISLO_POKLADNE - [column description]
- > G_KASA.CKA_CISLO_KASY
- STH_DEN_V_TYZDNI - [column description]
- STH_CAS_OD - [column description]
- STH_CAS_DO - [column description]
G_STAV_TOVARU
[table description]
- STT_ID_STAV_TOVARU - [column description]
- STT_ID_STREDISKO - [column description]
- STT_ID_TOVAR - [column description]
- STT_MNOZSTVO - [column description]
- STT_NAKUPNA_CENA - [column description]
G_STREDISKO
[table description]
- CST_ID_STREDISKO - [column description]
- > G_SUBJEKT.SUB_ID_SUBJEKT
- CST_STAV_INVENTURY - [column description]
- CST_DATUM_INVENTURY - [column description]
- CST_CENOVA_HLADINA_TOVAROV - [column description]
- CST_CENOVA_HLADINA_JEDAL - [column description]
- CST_PP_DODAVATEL - [column description]
- CST_PP_VYDAJ_ZO_STREDISKA - [column description]
- CST_PP_PRIJEM_NA_STREDISKO - [column description]
- CST_PP_ODBERATEL - [column description]
- CST_PP_VYROBA_JEDAL - [column description]
- CST_PP_ODBYT_JEDAL - [column description]
- CST_PP_KASA - [column description]
- CST_TYP_STREDISKA - [column description]
- CST_POVOLENE_ZDRUZENE_TOVARY - [column description]
- CST_ID_UZAVIERKA_POSLEDNA - [column description]
- CST_ID_HOREC - [column description]
- CST_AUT_GENER_DAVKY_HOREC - [column description]
- CST_ID_USEK - [column description]
- > G_USEK.GUS_ID_USEK
- CST_POCIATOCNY_UCTOVNY_ROK - [column description]
- CST_POCIATOCNY_UCTOVNY_MESIAC - [column description]
- CST_ZMAZANE - [column description]
G_STREDISKO_TYP
[table description]
- GST_ID - [column description]
- GST_NAZOV - [column description]
G_STREDISKO_TYP_LANG
Multilingválna tabuľka.
- GST_ID - [column description]
- > G_STREDISKO_TYP.GST_ID
- GST_NAZOV - [column description]
- GST_LANG - [column description]
G_STREDISKO_UZIVATEL
[table description]
- GSU_ID_STREDISKO - [column description]
- GSU_ID_UZIVATEL - [column description]
G_STREDISKO_UZIVATEL_POHYB
[table description]
- SUP_ID_STREDISKO - [column description]
- SUP_ID_UZIVATEL - [column description]
- SUP_DRUH_POHYBU - [column description]
- > G_DRUH_POHYBU.CDP_DRUH_POHYBU
G_STREDISKO_UZIVATEL_PREZ_STAV
[table description]
- SUS_ID_STREDISKO - [column description]
- > G_STREDISKO.CST_ID_STREDISKO
- SUS_ID_UZIVATEL - [column description]
- > L_UZIVATEL_PREDOK.UP_ID_UZIVATEL_PREDOK
G_SUBJEKT
[table description]
- SUB_ID_SUBJEKT - [column description]
- SUB_ICO - [column description]
- SUB_NAZOV - [column description]
- SUB_DIC - [column description]
- SUB_MENO - [column description]
- SUB_ADRESA1 - [column description]
- SUB_ADRESA2 - [column description]
- SUB_PSC - [column description]
- SUB_TELEFON - [column description]
- SUB_CISLO_UCTU - [column description]
- SUB_NUM_KOD_BANKY - [column description]
- SUB_BANKA - [column description]
- SUB_POZNAMKA - [column description]
- SUB_IBAN - [column description]
- SUB_BICSWIFT - [column description]
- SUB_CISLO - [column description]
G_TABLES
[table description]
- GTA_NAZOV - Názov tabuľky.
- GTA_SYNCHR_NAHOR - Príznak replikovania dát z lokálnych gastier na master.
- GTA_SYNCHR_NADOL - Príznak replikovania z mastra na lokálne gastro.
- GTA_SYNCHR_NADOL_INIT - Príznak zaradenia do exportu - inicializácia lokálneho gastra.
- GTA_LOCAL_NEEDS_ALL_DATA - Príznak replikovania master dát na lokálky. Uplatňuje sa iba v prípade rozsahového countra stĺpca na danej tabuľke.
G_TOVAR
[table description]
- CTO_ID_TOVAR - [column description]
- CTO_JM2 - [column description]
- CTO_MINIMALNA_ZASOBA - [column description]
- CTO_DOPORUCENA_ZASOBA - [column description]
- CTO_ID_ZDRUZENY_TOVAR - [column description]
- CTO_ZDRUZENY_TOVAR - [column description]
- CTO_NAKUPNA_CENA - [column description]
- CTO_PRIRAZKA - [column description]
- CTO_DOPORUCENY_PRE_NAKUPY - [column description]
- CTO_ID_PERCENTO_ALKOHOLU - [column description]
- > G_PERCENTO_ALKOHOLU.CPA_ID_PERCENTO_ALKOHOLU
- CTO_TYP_TOVAR - [column description]
- CTO_MNOZSTVO_SPOT_BAL - [column description]
- CTO_ID_UCTOVNY_DRUH - [column description]
- > G_UCTOVNY_DRUH.UDR_ID
- CTO_POVINNY_EAN_PRI_NAKUPE - [column description]
- CTO_NAKUP_LEN_CELE_MNOZSTVO - [column description]
G_TOVAR_JEDLO
[table description]
- CTJ_ID_TOVAR_JEDLO - [column description]
- CTJ_TOVAR_JEDLO - [column description]
- CTJ_NAZOV - [column description]
- CTJ_KALK_CENA - [column description]
- CTJ_JM - [column description]
- CTJ_HMOTNOST_JM - [column description]
- CTJ_DPH - [column description]
- CTJ_KOD_DPT - [column description]
- > G_DPT.DPT_KOD_DPT
- CTJ_DOPORUCENE_DO_RECEPTUR - [column description]
- CTJ_DRUH_CISLO - [column description]
- CTJ_POZNAMKA - [column description]
- CTJ_ZMAZANE - [column description]
- CTJ_ID_TOVAR_JEDLO_IMPORT - [column description]
- CTJ_CISLO - [column description]
G_TOVAR_JEDLO_CENA
[table description]
- CTC_ID_TOVAR_JEDLO - [column description]
- CTC_CENOVA_HLADINA - [column description]
- CTC_CENA - [column description]
G_TOVAR_JEDLO_CENA_V_MENE
[table description]
- CTCM_ID_TOVAR_JEDLO - [column description]
- CTCM_CENOVA_HLADINA - [column description]
- CTCM_KODME - [column description]
- CTCM_CENA - [column description]
G_TOVAR_JEDLO_EAN
[table description]
- EAN_ID_TOVAR_JEDLO - [column description]
- EAN_KOD - [column description]
- EAN_PORADIE - [column description]
G_TOVAR_NA_ODPISANIE
[table description]
- TNO_ID_TOVAR_NA_ODPISANIE - [column description]
- TNO_ID_DOKLAD_TOVAR_NA_ODPIS - [column description]
- > G_DOKLAD_TOVAR_NA_ODPISANIE.DTO_ID_DOKLAD_TOVAR_NA_ODPIS
- TNO_ID_TOVAR - [column description]
- TNO_ID_STREDISKO - [column description]
- TNO_MNOZSTVO - [column description]
- TNO_ID_TOVAR_PH - [column description]
- TNO_ID_STREDISKO_PH - [column description]
- TNO_MNOZSTVO_PH - [column description]
- TNO_ID_UZIVATEL - [column description]
G_TOVAR_ODPIS_ALTERNATIVY
[table description]
- TOA_ID_TOVAR - [column description]
- TOA_ID_TOVAR_ALTERNATIVA - [column description]
- TOA_PORADIE - [column description]
G_TRN
[table description]
- TRN_ID_TRN - [column description]
- TRN_KOD_TRN - [column description]
- TRN_TEXT_TRN - [column description]
- TRN_KATEGORIA - [column description]
- TRN_PORADIE - [column description]
G_TRN_KATEGORIA
[table description]
- TRK_KATEGORIA - [column description]
- TRK_TEXT - [column description]
- TRK_SLEDOVAT_AJ_PRE_UZIVATELA - [column description]
- TRK_SLEDOVAT_AJ_PRE_PLU - [column description]
G_TRN_KATEGORIA_LANG
Multilingválna tabuľka.
- TRK_ID - [column description]
- > G_TRN_KATEGORIA.TRK_KATEGORIA
- TRK_TEXT - [column description]
- TRK_LANG - [column description]
G_TYP_POLOZKY_OBJEDNAVKY
[table description]
- TPO_ID - [column description]
- TPO_CISLO - [column description]
- TPO_NAZOV - [column description]
- TPO_ZMAZANE - [column description]
G_TYPY_EKON_EXTERNYCH_SYSTEMOV
[table description]
- TEE_ID - [column description]
- TEE_NAZOV - [column description]
G_UCTOVACI_PROFIL
[table description]
- UPR_CISLO_PROFILU - ID záznamu.
- UPR_NAZOV - Názov.
- UPR_NUMBER - Číslo profilu.
- UPR_IGNORE_CREDIT_SUFFICIENCY - Ak true, platba kreditom povolená aj v prípade, že suma kreditu nepokryje cenu položky určenú percentom.
- UPR_AUTO_CREDIT_GAIN_PERC - Pripisovať kredit zo sumy účtu - percento.
- UPR_AUTO_CREDIT_GAIN_VAT - Ak true, kredit počítať z ceny nákupu s DPH, inak bez DPH.
- UPR_CREDIT_APPLY_CONFIRM - Ak true, zobrazí otázku pred čerpaním kreditu.
G_UCTOVACI_PROFIL_POLOZKY
[table description]
- UPP_CISLO_PROFILU - [column description]
- UPP_KATEGORIA_PLU - [column description]
- UPP_PERCENTO - [column description]
G_UCTOVNY_DRUH
[table description]
- UDR_ID - [column description]
- UDR_KOD - [column description]
- UDR_NAZOV - [column description]
- UDR_ID_EXTERNY_SYSTEM - [column description]
- > G_EXTERNE_SYSTEMY.EXS_ID
- UDR_ID_UCT_DRUH_EXT_SYSTEM - [column description]
GUEST_CREDIT_ACCOUNT_CHANGE
História pripisovania kreditu na účet stáleho hosťa.
- GCAC_ID - ID záznamu.
- GCAC_BILL_ID - ID denného účtu.
- > K_DENNY_UCET.DUC_ID_UCET
- GCAC_CREDIT_ACCOUNT_CHANGE - Suma pripísaného kreditu.
G_USEK
[table description]
- GUS_ID_USEK - [column description]
- GUS_ID_PREVADZKA - [column description]
- > G_PREVADZKA.GPR_ID_PREVADZKA
- GUS_NAZOV - [column description]
G_UZAVIERKA
[table description]
- UZA_ID_UZAVIERKY - [column description]
- UZA_CISLO_KASY - [column description]
- UZA_DATUM_CAS - [column description]
- UZA_ID_UZIVATEL_VYROBIL - [column description]
- UZA_MNOZSTVO - [column description]
- UZA_SUMA - [column description]
- UZA_TYP_UZAVIERKY - [column description]
- UZA_STAV_UZAVIERKY - [column description]
- UZA_DATUM - [column description]
- UZA_NAZOV_DOKLADU - [column description]
- UZA_ID_UZAVIERKA_PARENT - id mesačnej uzávierky
- UZA_SUMA_ZAPLATENE - [column description]
- UZA_MNOZSTVO_ZAPLATENE - [column description]
- UZA_CISLO_UZAVIERKY - [column description]
G_UZAVIERKA_STR_ALK_NEW_STAV
[table description]
- USS_ID_UZAVIERKA_STREDISKO - [column description]
- USS_STAV_ZAC - [column description]
- USS_PRIJEM - [column description]
- USS_VYDAJ - [column description]
- USS_STAV_NOVY - [column description]
G_UZAVIERKA_STR_ALKOHOL_NEW
[table description]
- USN_ID_UZAVIERKA_STREDISKO - [column description]
- USN_ID_OBCH_PARTNER - [column description]
- USN_MNOZSTVO_LIEHU - [column description]
- USN_PRIJEM_VYDAJ - [column description]
G_UZAVIERKA_STREDISKO
[table description]
- UZS_ID_UZAVIERKA_STREDISKO - [column description]
- UZS_ID_STREDISKO - [column description]
- UZS_ID_VYHOTOVIL - [column description]
- UZS_DATUM_CAS - [column description]
- UZS_ROK - [column description]
- UZS_MESIAC - [column description]
- UZS_PRIJEM_CENA - [column description]
- UZS_VYDAJ_CENA - [column description]
- UZS_STAV_NOVY_CENA - [column description]
G_UZAVIERKA_STREDISKO_ALK_PRIJ
[table description]
- USA_ID_UZAVIERKA_STREDISKO - [column description]
- USA_ID_TOVAR - [column description]
- USA_ID_ODBERATEL - [column description]
- USA_PERCENTO_ALKOHOLU - [column description]
- USA_NAKUP_MNOZSTVO - [column description]
G_UZAVIERKA_STREDISKO_ALK_STAV
[table description]
- USA_ID_UZAVIERKA_STREDISKO - [column description]
- USA_ID_TOVAR - [column description]
- USA_PERCENTO_ALKOHOLU - [column description]
- USA_STAV_MNOZSTVO - [column description]
G_UZAVIERKA_STREDISKO_TOVAR
[table description]
- UST_ID_UZAVIERKA_STREDISKO - [column description]
- UST_ID_TOVAR - [column description]
- UST_CISLO - [column description]
- UST_NAZOV_TOVARU - [column description]
- UST_PRIJEM_MNOZSTVO - [column description]
- UST_PRIJEM_CENA - [column description]
- UST_VYDAJ_MNOZSTVO - [column description]
- UST_VYDAJ_CENA - [column description]
- UST_STAV_NOVY - [column description]
- UST_STAV_NOVY_CENA - [column description]
- UST_MNOZSTVO_MJ - [column description]
- UST_KOD_DPT - [column description]
G_UZAVIERKA_TYP
[table description]
- UZT_TYP_UZAVIERKY - [column description]
- UZT_TEXT - [column description]
G_UZAVIERKA_TYP_LANG
Multilingválna tabuľka.
- UZT_ID - [column description]
- > G_UZAVIERKA_TYP.UZT_TYP_UZAVIERKY
- UZT_TEXT - [column description]
- UZT_LANG - [column description]
G_UZIVATEL_OBCHODNY_PARTNER
[table description]
- UOP_ID_UZIVATEL - [column description]
- > L_UZIVATEL_PREDOK.UP_ID_UZIVATEL_PREDOK
- UOP_ID_OCHODNY_PARTNER - [column description]
- > G_OBCHODNY_PARTNER.COP_ID_OBCHODNY_PARTNER
G_VYCAP
[table description]
- VYC_ID - [column description]
- VYC_ID_EXT_SYSTEM - [column description]
- > G_EXTERNE_SYSTEMY.EXS_ID
- VYC_POCET - [column description]
- VYC_DATUM_CAS - [column description]
- VYC_DATUM_CAS_UCTOVNY - [column description]
- VYC_KOD_UZAVERU - [column description]
G_VYROBA_POLOT_POLOZKY
[table description]
- VPP_ID_DOKLAD_VYROBA_POLOT - [column description]
- VPP_PORADIE - [column description]
- VPP_ID_JEDLO - [column description]
- VPP_MNOSTVO_JEDLO - [column description]
- VPP_KC_JEDLO - [column description]
- VPP_ID_TOVAR - [column description]
- VPP_MNOSTVO_TOVAR - [column description]
- VPP_NC_TOVAR - [column description]
- VPP_ID_STREDISKO - [column description]
G_VYROBA_POLOT_PREVOD
[table description]
- VPR_ID_JEDLO - [column description]
- VPR_ID_TOVAR - [column description]
G_WEB_SERVICES
[table description]
- WES_ID - [column description]
- WES_NAME - [column description]
- WES_PORT - [column description]
- WES_HOST_NAME - [column description]
- WES_WEB_APP_NAME - [column description]
- WES_USER_NAME - [column description]
- WES_USER_PASS - [column description]
- WES_PROTOCOL_TYPE_ID - [column description]
- > G_WEB_SERVICES_PROTOCOL_TYPE.WPT_ID
G_WEB_SERVICES_PROTOCOL_TYPE
[table description]
- WPT_ID - [column description]
- WPT_NAME - [column description]
G_WELLNESS_LITE_CARD
[table description]
- WLC_ID - [column description]
- WLC_CISLO - [column description]
- WLC_DATUM - [column description]
- WLC_KASA - [column description]
- > G_KASA.CKA_CISLO_KASY
- WLC_UZIVATEL - [column description]
- > L_UZIVATEL.UZ_ID_UZIVATEL
- WLC_REGISTROVANA - [column description]
- WLC_EXT_SYS_ID - [column description]
- > G_EXTERNE_SYSTEMY_WELLNESS_L.ESW_ID
G_ZAKAZNICKY_DISPLEJ
[table description]
- ZAD_ID - [column description]
- ZAD_SIRKA_POCET_ZNAKOV - [column description]
- ZAD_ID_TAB_NAR_ZNAKOV - [column description]
- ZAD_POTREBNY_ENTER - [column description]
- ZAD_ID_TEMPLATE_SKUPINA - [column description]
G_ZAKAZNIK
[table description]
- ZAK_ID_ZAKAZNIK - [column description]
- ZAK_MENO_ZAKAZNIKA - [column description]
- ZAK_ADRESA1 - [column description]
- ZAK_ADRESA2 - [column description]
- ZAK_PSC - [column description]
- ZAK_POVOLENY - [column description]
- ZAK_KOD_STATU - [column description]
- ZAK_CISLO_KARTY - [column description]
G_ZAKAZNIK_EXTERNY
[table description]
- ZAE_ID_ZAKAZNIK_EXTERNY - [column description]
- > G_ZAKAZNIK.ZAK_ID_ZAKAZNIK
- ZAE_CENOVY_PROFIL_ID - [column description]
- > G_CENOVY_PROFIL.CPR_ID_CENOVY_PROFIL
- ZAE_ID_EXT - [column description]
- ZAE_ID_EXT_SYS - [column description]
- > G_EXTERNE_SYSTEMY.EXS_ID
G_ZAKAZNIK_FIDELIO
[table description]
- ZAF_ID_ZAKAZNIK_FIDELIO - [column description]
- > G_ZAKAZNIK.ZAK_ID_ZAKAZNIK
- ZAF_ID_EXT_SYS - [column description]
- > G_EXTERNE_SYSTEMY.EXS_ID
- ZAF_CISLO_IZBY - [column description]
- ZAF_CISLO_REZERVACIE - [column description]
G_ZAKAZNIK_HOTSYS
[table description]
- ZAH_ID_ZAKAZNIK_HOTSYS - [column description]
- ZAH_ID_EXT_SYS - [column description]
- ZAH_BLOKOVANY_UCET - [column description]
- ZAH_CISLO_IZBY - [column description]
- ZAH_DATUM_PRICHODU - [column description]
- ZAH_DATUM_ODCHODU - [column description]
- ZAH_NEFAJCIAR - [column description]
- ZAH_EXTERNE_ID - [column description]
G_ZAKAZNIK_SAP_VW
Zákazník externého systému SAP VW.
- ZSVW_ID - ID záznamu.
- > G_ZAKAZNIK.ZAK_ID_ZAKAZNIK
- ZSVW_SAP_GUEST_GROUP_ID - ID skupiny hostí externého systému SAP VW.
- > EXTSYS_SAP_VW_GROUP.XSVWG_ID
G_ZAKAZNIK_STALY
[table description]
- ZAS_ID_ZAKAZNIK_STALY - [column description]
- > G_ZAKAZNIK.ZAK_ID_ZAKAZNIK
- ZAS_KREDIT - [column description]
- ZAS_UCET_BLOKOVANY - [column description]
- ZAS_POVOLENY_ZOSTATOK - [column description]
- ZAS_POVOLENY_ZOSTATOK_PLATI - [column description]
- ZAS_KONTROLOVAT_OBMEDZ_UCTU - [column description]
- ZAS_ZOSTATOK_NA_UCTE - [column description]
- ZAS_FISKALNA_PLATBA - [column description]
- ZAS_TELEFON - [column description]
- ZAS_FAX - [column description]
- ZAS_POZNAMKA - [column description]
- ZAS_ID_SPOLOCNOST - [column description]
- ZAS_ID_TYP_UCTU - [column description]
- ZAS_ID_CENOVY_PROFIL - [column description]
- ZAS_DOB - [column description]
- ZAS_GENDER - [column description]
- ZAS_EMAIL - [column description]
- ZAS_EAN - [column description]
- ZAS_ZMAZANY - [column description]
- ZAS_CISLO - [column description]
- ZAS_ZAMESTNANEC - [column description]
- ZAS_KRED_KONTO - [column description]
- ZAS_UCTOVACI_PROFIL - [column description]
- ZAS_KATEG_HOSTA - [column description]
- ZAS_PLATNOST_OD - [column description]
- ZAS_PLATNOST_DO - [column description]
- ZAS_PLATNOST_AKTIVNA - [column description]
- ZAS_ID_TLACOVY_PROFIL - [column description]
- > G_ZAKAZNIK_STALY_TP.ZST_ID
- ZAS_ALLOWED_PAYMENT_GROUP - [column description]
- > G_SPOSOB_PLATBY_SKUPINA.SPS_ID
- ZAS_SHOW_INHIBITED_PAYMENTS - [column description]
G_ZAKAZNIK_STALY_KATEG_HOSTA
[table description]
- ZKH_ID - [column description]
- ZKH_NAZOV - [column description]
- ZKH_DEF_TYP_UCTU - [column description]
- ZKH_DEF_CENOVY_PROFIL - [column description]
- ZKH_DEF_UCTOVACI_PROFIL - [column description]
- ZKH_ID_TLACOVY_PROFIL - [column description]
- > G_ZAKAZNIK_STALY_TP.ZST_ID
- ZKH_NUMBER - [column description]
G_ZAKAZNIK_STALY_KRED_KONTO
[table description]
- ZSKK_POPIS_KK - [column description]
- ZSKK_DISP_STAV - [column description]
- ZSKK_DENNY_LIMIT - [column description]
- ZSKK_LIMIT_JEDN_VYBERU - [column description]
- ZSKK_BLOKOVANE_KONTO - [column description]
- ZSKK_AKTUALNY_STAV - [column description]
- ZSKK_ID - [column description]
- ZSKK_ID_UCT_KONTO_TYP - [column description]
- > G_ZS_UCT_KONTO_TYP.UKT_ID
- ZSKK_BLOKOVAT_PO_PREKROCENI - [column description]
- ZSKK_CUMULATIVE_CREDIT - [column description]
G_ZAKAZNIK_STALY_TP
[table description]
- ZST_ID - [column description]
- ZST_NAZOV - [column description]
- ZST_POZNAMKA - [column description]
- ZST_NUMBER - [column description]
G_ZAKAZNIK_STALY_TP_LIST
[table description]
- ZSL_ID - [column description]
- ZSL_ID_CISELNIK - [column description]
G_ZAKAZNIK_STALY_TP_POL
[table description]
- ZSP_ID - [column description]
- ZSP_PORADIE - [column description]
- ZSP_TEXT - [column description]
- ZSP_PORADIE_UZIVATEL - [column description]
- ZSP_TYP_POLOZKY - [column description]
- ZSP_ID_OBDOBIE - [column description]
- ZSP_ID_CISELNIK - [column description]
- ZSP_ID_HODNOTA - [column description]
- ZSP_ID_LIST - [column description]
- ZSP_VZOREC - [column description]
- ZSP_ZOBRAZOVAT - [column description]
- ZSP_UKONCIT_RIADOK - [column description]
G_ZAKAZNIK_STALY_TYP_UCTU
[table description]
- ZSTU_ID_TYP_UCTU - [column description]
- ZSTU_NAZOV - [column description]
G_ZAKAZNIK_STALY_TYP_UCTU_LANG
[table description]
- ZSTU_ID - [column description]
- > G_ZAKAZNIK_STALY_TYP_UCTU.ZSTU_ID_TYP_UCTU
- ZSTU_NAZOV - [column description]
- ZSTU_LANG - [column description]
G_ZAMESTNANCI_NASTAVENIA
[table description]
- ZNA_ID - [column description]
- ZNA_CENA_LISTKA - [column description]
- ZNA_NAKLADOVA_CENA - [column description]
G_ZAOKRUHLENIE
[table description]
- ZAO_ID - [column description]
- ZAO_PORADIE - [column description]
- ZAO_MENO - [column description]
- ZAO_DES_MIEST - [column description]
- ZAO_TYP - [column description]
- ZAO_JEDNOTKA - [column description]
- ZAO_POUZ_CENA_PLU - [column description]
G_ZAOKRUHLENIE_LANG
Multilingválna tabuľka.
- ZAO_ID - [column description]
- > G_ZAOKRUHLENIE.ZAO_ID
- ZAO_MENO - [column description]
- ZAO_LANG - [column description]
G_ZAOKRUHLENIE_TYP
[table description]
- ZAT_ID - [column description]
- ZAT_MENO - [column description]
G_ZAOKRUHLENIE_TYP_LANG
Multilingválna tabuľka.
- ZAT_ID - [column description]
- > G_ZAOKRUHLENIE_TYP.ZAT_ID
- ZAT_MENO - [column description]
- ZAT_LANG - [column description]
G_ZARIADENIE
[table description]
- ZA_ID_ZARIADENIE - [column description]
- ZA_ID_ZARIADENIE_TYP - [column description]
- ZA_NAZOV - [column description]
- ZA_BAUD_RATE - [column description]
- ZA_DATA_BITS - [column description]
- ZA_STOP_BIT - [column description]
- ZA_PARITY - [column description]
- ZA_START - [column description]
- ZA_STOP - [column description]
- ZA_FIXEDTRACK - [column description]
- ZA_PREFIXTRACKLENGTH - [column description]
- ZA_FIXEDTRACKLENGTH - [column description]
- ZA_SUFFIXTRACKLENGTH - [column description]
- ZA_WAIT_BEFORE_READ_MS - [column description]
G_ZARIADENIE_CITACKA_KARIET
[table description]
- GCK_ID_ZARIADENIE - [column description]
- GCK_PORT - [column description]
- GCK_IPADRESA - [column description]
- GCK_REG_MENO - [column description]
- GCK_REG_HESLO - [column description]
G_ZARIADENIE_KOD_TYP
[table description]
- ZKT_ID_ZARIADENIE_KOD_TYP - [column description]
- ZKT_NAZOV - [column description]
- ZKT_POCET_ZNAKOV_KODU - [column description]
G_ZARIADENIE_KOD_TYP_PRAVIDLA
[table description]
- KTP_ID_KOD_TYP - [column description]
- > G_ZARIADENIE_KOD_TYP.ZKT_ID_ZARIADENIE_KOD_TYP
- KTP_PORADIE - [column description]
- KTP_PRAVIDLO - [column description]
G_ZARIADENIE_PORT
[table description]
- ZP_ID_ZARIADENIE_PORT - [column description]
- ZP_NAZOV - [column description]
G_ZARIADENIE_TYP
[table description]
- ZT_ID_ZARIADENIE_TYP - [column description]
- ZT_NAZOV - [column description]
- ZT_POVOLENA_KOMUNIKACIA - [column description]
G_ZARIADENIE_TYP_LANG
Multilingválna tabuľka.
- ZT_ID - [column description]
- > G_ZARIADENIE_TYP.ZT_ID_ZARIADENIE_TYP
- ZT_NAZOV - [column description]
- ZT_LANG - [column description]
G_ZLAVA
[table description]
- ZLA_ID_ZLAVA - [column description]
- ZLA_POVOLENA - [column description]
- ZLA_POLOZKOVA - [column description]
- ZLA_VYPISAT - [column description]
- ZLA_PERCENT - [column description]
- ZLA_ID_TRN - [column description]
- ZLA_MOZNE_MENIT_PERCENTA - [column description]
- ZLA_ZLAVA_S_DPH - [column description]
- ZLA_ZLAVA_PRIRAZKA - [column description]
- ZLA_TLAC_PERC_PRIRAZKU - [column description]
- ZLA_DATUM_CAS_OD - [column description]
- ZLA_DATUM_CAS_DO - [column description]
- ZLA_PLATNOST_POUZIT - [column description]
G_ZLAVA_UZIVATEL
[table description]
- ZLU_ID_ZLAVA - [column description]
- > G_ZLAVA.ZLA_ID_ZLAVA
- ZLU_ID_UZIVATEL - [column description]
- > L_UZIVATEL.UZ_ID_UZIVATEL
G_ZS_UCT_KONTO_TYP
[table description]
- UKT_ID - [column description]
G_ZS_UCT_KONTO_TYP_LANG
Multilingválna tabuľka.
- UKT_ID - [column description]
- > G_ZS_UCT_KONTO_TYP.UKT_ID
- UKT_LANG - [column description]
- UKT_TEXT - [column description]
HC_ST
[table description]
- ST_KODST - [column description]
- ST_NAZOV - [column description]
- ST_VIZUM - [column description]
- ST_TARIF - [column description]
- ST_CIRIA - [column description]
- ST_CENTR - [column description]
- ST_JAZYK - [column description]
- ST_KODME - [column description]
- ST_PORADIE - [column description]
- ST_NEZOBRAZUJ - [column description]
- ST_ID_CENOVY_PROFIL - [column description]
- ST_KOD_MENY - [column description]
- ST_ID_VLAJKA - [column description]
- > HC_VLAJKA.VL_ID
HC_ST_LANG
Multilingválna tabuľka.
- LST_ID - [column description]
- LST_NAZOV - [column description]
- LST_LANG - [column description]
HC_TO
[table description]
- TO_KODTR - [column description]
- TO_NAZOV - [column description]
- TO_DAN_SADZBA - [column description]
- TO_JCENA - [column description]
- TO_ID_HOREC - [column description]
HC_VLAJKA
[table description]
- VL_VLAJKA - [column description]
- VL_ID - [column description]
- VL_NAZOV - [column description]
HC_VLAJKA_LANG
Multilingválna tabuľka.
- LVL_ID - [column description]
- LVL_NAZOV - [column description]
- LVL_LANG - [column description]
HELP_LINK
[table description]
- HLI_ID - [column description]
- HLI_LINK - [column description]
HK_FI
[table description]
- FI_CISPS - [column description]
- > G_KASA.CKA_CISLO_KASY
- FI_DATA - [column description]
HP_ARCHIV
[table description]
- ID - [column description]
- RID - [column description]
- AR_NAZOV - [column description]
- AR_CASZZ - [column description]
- AR_POZNAMKA - [column description]
- AR_VERZIADAT - [column description]
- AR_SUBOROV - [column description]
- AR_CELKOMVELKOST - [column description]
- AR_BACKUPFOLDER - [column description]
HP_FAJKA
[table description]
- ID - [column description]
- SF_CISLO - [column description]
- SF_FAJKA - [column description]
- SF_DATAKOD - [column description]
- SF_POCET - [column description]
HP_FAJKA_LONG
[table description]
- ID - [column description]
- SFL_CISLO - [column description]
- SFL_FAJKA - [column description]
- SFL_DATAKOD - [column description]
- SFL_POCET - [column description]
HP_LIST
[table description]
- LT_ID_TEMP - [column description]
- LT_ID_ITEM - [column description]
HP_ZOZNAM
[table description]
- ID - [column description]
- RID - [column description]
- ZS_NAZOV - [column description]
- ZS_CASZZ - [column description]
- ZS_DETAIL - [column description]
- ZS_ZOBRAZUJ - [column description]
- ZS_USER_ID - [column description]
INFO_MESSAGE_CUSTOMER
[table description]
- IMC_ID - [column description]
- IMC_NAME - [column description]
- IMC_BODY - [column description]
- IMC_TYPE - [column description]
- IMC_REG_FILE - [column description]
- IMC_DOWNLOADED_DATE - [column description]
INFO_MESSAGE_CUSTOMER_CALL
[table description]
- MCC_ID - [column description]
- MCC_DATE - [column description]
- MCC_WORKSTATION_ID - [column description]
- > G_PRACOVNA_STANICA.PS_ID_STANICA
INFO_MESSAGE_CUSTOMER_READ
[table description]
- IMR_MESSAGE_ID - [column description]
- > INFO_MESSAGE_CUSTOMER.IMC_ID
- IMR_USER_ID - [column description]
- > L_UZIVATEL.UZ_ID_UZIVATEL
- IMR_DATE - [column description]
K_CISLO_ODVOD
[table description]
- KCO_CISLO_KASY - [column description]
- > G_KASA.CKA_CISLO_KASY
- KCO_CISLO - [column description]
K_CISLO_UCTU
[table description]
- CUC_CISLO_KASY - [column description]
- > G_KASA.CKA_CISLO_KASY
- CUC_CISLO_UCTU - [column description]
K_CISLO_UZAVIERKA
[table description]
- KCU_CISLO_KASY - [column description]
- > G_KASA.CKA_CISLO_KASY
- KCU_CISLO_UZAVIERKA_D - [column description]
- KCU_CISLO_UZAVIERKA_M - [column description]
- KCU_CISLO_UZAVIERKA_Y - [column description]
K_CISLO_UZAVIERKA_NASTAVENIA
[table description]
- KUN_ID - [column description]
- KUN_CISLUJ_PO_KASACH - [column description]
- KUN_CISLUJ_ZVLAST_DENNE - [column description]
- KUN_VZOR - [column description]
- KUN_CLOSING_NULLS_CLOSING_NR - [column description]
- KUN_CLOSING_NULLS_BILL_NR - [column description]
- KUN_CLOSING_NULLS_LEVY_NR - [column description]
K_DENNY_UCET
Tabuľka účtov.
- DUC_ID_UCET - [column description]
- DUC_CISLO_KASY - ID pokladne.
- > G_KASA.CKA_CISLO_KASY
- DUC_VYHOTOVENY - Dátum a čas uzatvorenia účtu.
- DUC_VYHOTOVIL - Užívateľ, ktorý účet uzavrel.
- > L_UZIVATEL.UZ_ID_UZIVATEL
- DUC_CISLO_UCTU - Číslo účtu.
- DUC_STORNO - Príznak storno účtu.
- DUC_SUMA - Celková suma účtu.
- DUC_FISKALNY_TYP - Fiskálny typ účtu.
- DUC_ID_UZAVIERKA - ID uzávierky.
- > G_UZAVIERKA.UZA_ID_UZAVIERKY
- DUC_ID_ZAKAZNIK - ID zákazníka.
- > G_ZAKAZNIK.ZAK_ID_ZAKAZNIK
- DUC_NAZOV_DOKLADU - Názov súboru, v ktorom je uložená účtenka. (možno bude odstránený, záleží od rozhodnutia uchovávať súbory dokladov priamo v DB)
- DUC_DATUM - Účtovný dátum.
- DUC_ID_OTVORENY_UCET - [column description]
- > K_OTVORENY_UCET.OUC_ID_OTVORENY_UCET
- DUC_ID_STORNO_UCET - ID stornovaného účtu.
- DUC_POCET_OBSLUZ_HOSTI - Počet obslúžených hostí.
- DUC_ZUCTOVANY - [column description]
- DUC_ID_ZUCTOVACI_UCET - Účet zúčtovaný účtom s ID.
- > K_DENNY_UCET.DUC_ID_UCET
- DUC_ZMENA_PLATBY - Príznak zmeny platby na účte.
- DUC_CISLO_OBJ - Číslo objednávky.
- DUC_WHU_ID_POVODNY_UCET - [column description]
- DUC_WHU_CISLO_DOKLADU - [column description]
- DUC_WHU_NEGATABLE - [column description]
- DUC_ID_KREDITNE_KONTO - ID kreditného konta.
- DUC_MENA - Kód meny, ktorou bol účet zaplatený.
- DUC_DOVOD_STORNA - Poznámka pre storno účet.
- DUC_SUMA_ZAPLATENE - Celková zaplatená suma.
- DUC_ID_PARENT_UCET - ID súvisiaceho účtu - účet, z ktorého tento nejakým spôsobom vychádza.
- > K_DENNY_UCET.DUC_ID_UCET
- DUC_POZNAMKA - Poznámka účtu.
- DUC_BILL_NO_DAILY_CLOSING - Číslo účtu v rámci dennej uzávierky.
- DUC_AFTER_CLOSING - ucet po uzavierke
- DUC_CHECKOUT_CHIP - [column description]
- DUC_HOREC_GUEST_EXTSYS_EXT_ID - [column description]
- > EXTSYS_HOREC_ACCOM_GUEST.EXTSYS_EXT_ID
- DUC_HOREC_GUEST_NUMBER - [column description]
- > EXTSYS_HOREC_ACCOM_GUEST.GUEST_NUMBER
K_DENNY_UCET_ERS_EXT
[table description]
- DUE_ID_UCET - [column description]
- > K_DENNY_UCET.DUC_ID_UCET
- DUE_CISLO_KARTY - [column description]
- DUE_ZUCTOVANY - [column description]
K_DENNY_UCET_PLATBA
Tabuľka platieb účtu.
- DUA_ID_UCET - ID účtu.
- > K_DENNY_UCET.DUC_ID_UCET
- DUA_PORADIE - Poradie platby.
- DUA_ID_SPOSOB_PLATBY - ID spôsobu platby.
- > G_SPOSOB_PLATBY.SPL_ID_SPOSOB_PLATBY
- DUA_MNOZSTVO - Množstvo stravných lístkov alebo cudzej meny.
- DUA_SUMA - Suma platby.
- DUA_CENA_LISTKA - Cena stravného lístka.
- DUA_CURRENCY_RATE - Kurz cudzej meny.
- DUA_ID_PLAT_KARTA_TYP - ID typu platobnej karty.
- DUA_SUMA_BDPH - Suma platby bez DPH. (toto je veľká hlúposť)
- DUA_NEPRIAMA_KOTACIA - Nepriama kotácia.
- DUA_CURRENCY_CODE - Kód cudzej meny.
- DUA_CURRENCY_UNIT - Jednotka cudzej meny.
K_DENNY_UCET_POL_ERS_EXT
[table description]
- DEE_ID_UCET - [column description]
- > K_DENNY_UCET.DUC_ID_UCET
- DEE_PORADIE - [column description]
- DEE_ID_SLUZBA - [column description]
- DEE_DATUM_OD - [column description]
- DEE_DATUM_DO - [column description]
K_DENNY_UCET_POLOZKA
Tabuľka položiek účtu.
- DUP_ID_UCET - ID účtu.
- > K_DENNY_UCET.DUC_ID_UCET
- DUP_PORADIE - Poradie položky na účte.
- DUP_ID_PLU - ID PLU.
- > G_PLU.PLU_ID_PLU
- DUP_TEXT_PLU - Názov PLU.
- DUP_MNOZSTVO - Množstvo PLU.
- DUP_CENA - Jednotková cena položky.
- DUP_CENA_SUMA - Suma za položku.
- DUP_SADZBA_DPH - Pevná hodnota DPH pre položku použitá pri uzatvorení účtu.
- DUP_ZLAVNENA_POLOZKA - Ak sa jedná o položku zľavy, uchováva ID položky, na ktorú sa táto zľava uplatňuje.
- DUP_CENOVA_HLADINA - ID cenovej hladiny.
- DUP_ZLAVA - Nominálna hodnota zľavy.
- DUP_CENA_SUMA_ZLAVA - Suma za položku po uplatnení zľavy.
- DUP_ID_BALIK_PLU - ID balíka PLU.
- DUP_CKASY - ID pokladne.
- > G_KASA.CKA_CISLO_KASY
- DUP_ID_UZIVATEL_NATAZIL - ID užívateľa, ktorý položku naťažil.
- > L_UZIVATEL.UZ_ID_UZIVATEL
- DUP_ID_BALIK_PORADIE - Poradie balíka PLU na účte.
- DUP_SYSTEMOVA - Príznak systémovej (automaticky doplnenej) položky.
- DUP_EAN - EAN tovaru/PLU.
- DUP_PRICE_LEVEL_ALTERNATIVE - Ak true, položke bola nastavená alternatívna cenová hladina použitého cenového profilu.
K_EXT_SYS_TAP_DEV_SENT
[table description]
- TDS_ID - [column description]
- TDS_DEVICE_ID - [column description]
- TDS_EXT_SYS_TAP_DEV_ID - [column description]
- > G_EXTERNE_SYSTEMY_TAP_DEV.EVD_ID
- TDS_ROUTE - [column description]
- TDS_CASH_DESK_ID - [column description]
- > G_KASA.CKA_CISLO_KASY
- TDS_USER_ID - [column description]
- TDS_USER_EXT_CODE - [column description]
- TDS_TIME - [column description]
- TDS_PLU_ID - [column description]
- > G_PLU.PLU_ID_PLU
- TDS_PLU_EXT_CODE - [column description]
- TDS_QUANTITY_REQUESTED - [column description]
- TDS_QUANTITY_SUCCESSFUL - [column description]
- TDS_TABLE_ID - [column description]
- > G_REST_STOL.RST_ID_STOL
- TDS_TABLE_EXT_CODE - [column description]
K_FAKTURA
[table description]
- FAK_ID_FAKTURA - [column description]
- FAK_CISLO_FAKTURY - [column description]
- FAK_ID_UCET - [column description]
- > K_DENNY_UCET.DUC_ID_UCET
- FAK_ID_ODBERATEL_FAKTURA - [column description]
- > G_ODBERATEL_FAKTURA.ODF_ID
- FAK_DATUM_SPLATNOSTI - [column description]
- FAK_DATUM_DODANIA - [column description]
- FAK_NAZOV_DOKLADU - [column description]
K_GRUPA
[table description]
- KGR_CISLO_KASY - [column description]
- > G_KASA.CKA_CISLO_KASY
- KGR_KOD_GRUPY - [column description]
- KGR_TEXT_GRUPY - [column description]
- KGR_DENNY_PREDAJ - [column description]
- KGR_DENNA_SUMA - [column description]
- KGR_MESACNY_PREDAJ - [column description]
- KGR_MESACNA_SUMA - [column description]
K_HODINY
[table description]
- KHO_CISLO_KASY - [column description]
- > G_KASA.CKA_CISLO_KASY
- KHO_OD - [column description]
- KHO_DO - [column description]
- KHO_DENNY_PREDAJ - [column description]
- KHO_DENNA_SUMA - [column description]
- KHO_MESACNY_PREDAJ - [column description]
- KHO_MESACNA_SUMA - [column description]
K_KL_HISTORIA
[table description]
- KLH_ID_HISTORIA - [column description]
- KLH_ID_KURZOVY_LISTOK - [column description]
- > K_KL_KURZOVY_LISTOK.KLN_ID_KURZOVY_LISTOK
- KLH_KOD_MENY - [column description]
- > K_KL_MENA.KLM_KOD_MENY
- KLH_CASZZ - [column description]
- KLH_PLATNY_OD - [column description]
- KLH_PLATNY_DO - [column description]
- KLH_INFO_TYP_ZAOKRUHLENIA - [column description]
- KLH_PLATBA_TYP_ZAOKRUHLENIA - [column description]
- KLH_PREPOCTY_TYP_KURZU - [column description]
- KLH_INFO_POCET_DES_MIEST - [column description]
- KLH_PLATBA_POCET_DES_MIEST - [column description]
- KLH_NEPRIAMA_KOTACIA - [column description]
- KLH_JEDNOTKA - [column description]
- KLH_BANKA_NAKUP - [column description]
- KLH_BANKA_STRED - [column description]
- KLH_VALUTY_NAKUP - [column description]
- KLH_INFO_ZAOKRUHLENIE - [column description]
- KLH_PLATBA_ZAOKRUHLENIE - [column description]
- KLH_VALUTY_NAKUP_KOEF - [column description]
K_KL_KURZ
[table description]
- KLK_ID_KURZOVY_LISTOK - [column description]
- > K_KL_KURZOVY_LISTOK.KLN_ID_KURZOVY_LISTOK
- KLK_KOD_MENY - [column description]
- > K_KL_MENA.KLM_KOD_MENY
K_KL_KURZOVY_LISTOK
[table description]
- KLN_ID_KURZOVY_LISTOK - [column description]
- KLN_WEB_AKTUALIZACIA - [column description]
- KLN_WEB_KOD_BANKY - [column description]
- KLN_WEB_AUTOMATICKA_POVOLENA - [column description]
- KLN_WEB_AUTOMATICKA_AKTUALIZ - [column description]
- KLN_HISTORIA - [column description]
- KLN_NAZOV - [column description]
K_KL_MENA
[table description]
- KLM_KOD_MENY - [column description]
- KLM_POVOLENA_PRE_CENOTVORBU - [column description]
- KLM_OZNACENIE_MENY - [column description]
- KLM_PORADIE - [column description]
- KLM_ID_VLAJKA - [column description]
- > HC_VLAJKA.VL_ID
- KLM_NAZOV - [column description]
K_KL_SYSTEM
[table description]
- KLS_ID_SYSTEM - [column description]
- KLS_KOD_DOMACA_MENA - [column description]
- > K_KL_MENA.KLM_KOD_MENY
- KLS_KOD_INA_DOPORUCENA_MENA - [column description]
- > K_KL_MENA.KLM_KOD_MENY
- KLS_KOD_SKLADOVA_MENA - [column description]
- > K_KL_MENA.KLM_KOD_MENY
- KLS_KOD_KALKULACNA_MENA - [column description]
- > K_KL_MENA.KLM_KOD_MENY
- KLS_KOD_MENA_NA_VYDANIA - [column description]
- > K_KL_MENA.KLM_KOD_MENY
- KLS_KONVERZNA_MENA_POVOLENA - [column description]
- KLS_KOD_KONVERZNA_MENA - [column description]
- > K_KL_MENA.KLM_KOD_MENY
- KLS_DEF_ID_KURZOVY_LISTOK - [column description]
- > K_KL_KURZOVY_LISTOK.KLN_ID_KURZOVY_LISTOK
- KLS_SKLAD_PREPOCTY_TYP_KURZU - [column description]
- KLS_MENA_DUAL_ZOBR_PO_KONV - [column description]
- KLS_KONVERZNY_KURZ - [column description]
- KLS_JEDN_DUAL_ZOBR_PO_KONV - [column description]
K_OTVORENY_UCET
Tabuľka účtov.
- OUC_ID_OTVORENY_UCET - [column description]
- OUC_CISLO_KASY - ID pokladne.
- > G_KASA.CKA_CISLO_KASY
- OUC_CISLO_OTVORENEHO_UCTU - Názov účtu.
- OUC_OTVORENY_V_CASE - Dátum a čas otvorenia účtu.
- OUC_OTVORIL_ID - Užívateľ, ktorý účet založil.
- > L_UZIVATEL.UZ_ID_UZIVATEL
- OUC_SUMA - Celková suma účtu.
- OUC_STAV - Aktuálny stav účtu.
- OUC_ID_STOL - ID stola.
- > G_REST_STOL.RST_ID_STOL
- OUC_CISLO - Číslo účtu.
- OUC_POZNAMKA - Poznámka účtu.
- OUC_WELLNESS_LITE_CARD - Číslo Wellness Lite karty.
- > G_WELLNESS_LITE_CARD.WLC_ID
- OUC_EXT_SYS_ID - ID externého systému, ktorému účet patrí.
- > G_EXTERNE_SYSTEMY.EXS_ID
- OUC_EXT_SYS_CARD_NUMBER - Číslo karty pre externý systém.
- OUC_ID_ZAKAZNIK_VLASTNIK - ID zákazníka.
- > G_ZAKAZNIK.ZAK_ID_ZAKAZNIK
- OUC_LOCK - Zámok na účte.
- OUC_EXT_SYS_ORDER_NUMBER - [column description]
K_OTVORENY_UCET_POL_CHOD
Tabuľka chodov na účte.
- OUL_ID_OTVORENY_UCET - ID účtu.
- OUL_PORADIE - Poradie chodu.
- OUL_ID_CHOD - ID chodu.
- OUL_POZNAMKA - Poznámka pre chod.
- OUL_STAV - Stav chodu
K_OTVORENY_UCET_POLOZKA
Tabuľka položiek účtu.
- OUP_ID_OTVORENY_UCET - ID účtu.
- > K_OTVORENY_UCET.OUC_ID_OTVORENY_UCET
- OUP_PORADIE - Poradie položky na účte.
- OUP_ID_PLU - ID PLU.
- OUP_MNOZSTVO - Množstvo PLU.
- OUP_CENA - Jednotková cena položky.
- OUP_ZLAVNENA_POLOZKA - Ak sa jedná o položku zľavy, uchováva ID položky, na ktorú sa táto zľava uplatňuje.
- OUP_CENA_SUMA - Suma za položku.
- OUP_STORNO - [column description]
- OUP_POZNAMKA_DO_KUCHYNE - Poznámka na položke.
- OUP_CENOVA_HLADINA - ID cenovej hladiny.
- OUP_ID_UZIVATEL_ZAPISAL - ID užívateľa, ktorý položku naťažil.
- OUP_CKASY - ID pokladne.
- OUP_ID_BALIK_PLU - ID balíka PLU.
- OUP_ID_BALIK_PORADIE - Poradie balíka PLU na účte.
- OUP_SYSTEMOVA - Príznak systémovej (automaticky doplnenej) položky.
- OUP_CHOD_PORADIE - Poradie chodu.
- OUP_ID_UZIVATEL_STORNOVAL - ID užívateľa, ktorý položku stornoval.
- OUP_NATAZENA - [column description]
- OUP_STORNOVANA - Dátum a čas stornovania položky.
- OUP_EAN - EAN tovaru/PLU.
- OUP_EXTERNAL_ORDER_ID - [column description]
- > G_EXTERNAL_ORDER_ITEMS.EOI_ID
- OUP_EXTERNAL_ORDER_ITEM_ID - [column description]
- > G_EXTERNAL_ORDER_ITEMS.EOI_ORDER
- OUP_ACCOUNT_ID_MOVED_FROM - ID účtu, z ktorého bola položka presunutá.
- > K_OTVORENY_UCET.OUC_ID_OTVORENY_UCET
- OUP_EXT_SYS_TAP_DEV_SENT_ID - [column description]
- OUP_VAT_ID - ID hladiny DPH pre účely existencie účtu pred jeho uzatvorením.
K_PLANOVANIE_PLATIEB_SUMA
[table description]
- PPS_CKASY - [column description]
- PPS_ID_PLATBY_PLANOVANIE - [column description]
- PPS_SUMA - [column description]
K_PLU
[table description]
- KPL_ID_PLU - [column description]
- KPL_KOD_PLU - [column description]
- KPL_TEXT_PLU - [column description]
- KPL_KOD_DPT - [column description]
- KPL_ID_PLU1 - [column description]
- KPL_ID_TOVAR_JEDLO - [column description]
- KPL_ID_ZLAVA - [column description]
- KPL_TYP - [column description]
- KPL_POZNAMKA - [column description]
- KPL_POCET_JEDNOTIEK - [column description]
- KPL_ID_AKCIA_UDALOST - [column description]
- KPL_ID_KARTA_SLUZBA - [column description]
- KPL_DPH - [column description]
- KPL_IMAGE_DISABLED - [column description]
- KPL_IMAGE_DOUBLE_SIZE - [column description]
- KPL_IMAGE_SHOW_TEXT - [column description]
- KPL_IMAGE_ALIGN_HORIZONTAL - [column description]
- KPL_IMAGE_ALIGN_VERTICAL - [column description]
- KPL_TEXT_COLOR - [column description]
- KPL_IMAGE_FILE - [column description]
K_PLU_KASA
[table description]
- KPK_CISLO_KASY - [column description]
- > G_KASA.CKA_CISLO_KASY
- KPK_ID_PLU - [column description]
- KPK_CENA - [column description]
- KPK_CENA2 - [column description]
- KPK_KP - [column description]
- KPK_IOP - [column description]
- KPK_POVOLENE - [column description]
- KPK_ID_KATEGORIA - [column description]
- KPK_PORADIE - [column description]
K_PLU_STAT
[table description]
- KPS_CISLO_KASY - [column description]
- > K_PLU_KASA.KPK_CISLO_KASY
- KPS_ID_PLU - [column description]
- > K_PLU_KASA.KPK_ID_PLU
- KPS_DENNY_PREDAJ - [column description]
- KPS_DENNA_SUMA - [column description]
- KPS_MESACNY_PREDAJ - [column description]
- KPS_MESACNA_SUMA - [column description]
K_POZNAMKA_OBJEDNAVKA
[table description]
- KPO_ID - [column description]
- KPO_TEXT - [column description]
- KPO_TYP - [column description]
K_POZNAMKA_OBJEDNAVKA_KAT
[table description]
- POK_ID - [column description]
- > K_POZNAMKA_OBJEDNAVKA.KPO_ID
- POK_ID_KATEGORIA_PLU - [column description]
- > G_KATEGORIA_PLU.KAP_ID
KP_PRACOVNY_UCET
[table description]
- PUC_ID_PRACOVNY_UCET - [column description]
- PUC_ID_OTVORENY_UCET - [column description]
- PUC_ID_CENOVY_PROFIL - [column description]
KP_PRACOVNY_UCET_PLATBA
[table description]
- PUA_ID_PRACOVNY_UCET - [column description]
- PUA_PORADIE - [column description]
- PUA_ID_SPOSOB_PLATBY - [column description]
- PUA_SUMA - [column description]
- PUA_MNOZSTVO - [column description]
- PUA_CENA_LISTKA - [column description]
- PUA_ID_PLAT_KARTA_TYP - [column description]
- PUA_KURZ - [column description]
KP_PRACOVNY_UCET_POL_CHOD
[table description]
- PUL_ID_PRACOVNY_UCET - [column description]
- PUL_PORADIE - [column description]
- PUL_ID_CHOD - [column description]
- PUL_POZNAMKA - [column description]
- PUL_STAV - [column description]
KP_PRACOVNY_UCET_POLOZKA
[table description]
- PUP_ID_PRACOVNY_UCET - [column description]
- PUP_PORADIE - [column description]
- PUP_ID_PLU - [column description]
- PUP_MNOZSTVO - [column description]
- PUP_CENA - [column description]
- PUP_ZLAVNENA_POLOZKA - [column description]
- PUP_PRENIEST - [column description]
- PUP_CENA_SUMA - [column description]
- PUP_STORNO - [column description]
- PUP_NOVA - [column description]
- PUP_POZNAMKA_DO_KUCHYNE - [column description]
- PUP_CENOVA_HLADINA - [column description]
- PUP_TRITON - [column description]
- PUP_ZLAVA - [column description]
- PUP_ID_UZIVATEL_ZAPISAL - [column description]
- PUP_PRAVE_ZMENENE - [column description]
- PUP_POUZITE - [column description]
- PUP_CKASY - [column description]
- PUP_ID_BALIK_PLU - [column description]
- PUP_ID_BALIK_PORADIE - [column description]
- PUP_SYSTEMOVA - [column description]
- PUP_CHOD_PORADIE - [column description]
- PUP_ID_DENNY_UCET - [column description]
- PUP_ID_UZIVATEL_STORNOVAL - [column description]
- PUP_NATAZENA - [column description]
- PUP_STORNOVANA - [column description]
- PUP_EAN - [column description]
- PUP_EXTERNAL_ORDER_ID - [column description]
- PUP_EXTERNAL_ORDER_ITEM_ID - [column description]
- PUP_ACCOUNT_ID_MOVED_FROM - [column description]
- PUP_EXT_SYS_TAP_DEV_SENT_ID - [column description]
- PUP_VAT_ID - [column description]
- PUP_NAME_EXTRA - [column description]
- PUP_PRICE_LEVEL_ALTERNATIVE - [column description]
K_TRN
Výsledky prepočetu tranzakcií.
- KTR_CISLO_KASY - [column description]
- > G_KASA.CKA_CISLO_KASY
- KTR_ID_TRN - [column description]
- KTR_DENNY_PREDAJ - [column description]
- KTR_DENNA_SUMA - [column description]
- KTR_MESACNY_PREDAJ - [column description]
- KTR_MESACNA_SUMA - [column description]
- KTR_ROCNY_PREDAJ - [column description]
- KTR_ROCNA_SUMA - [column description]
K_TRN_ODVOD
[table description]
- KTO_CISLO_KASY - [column description]
- > G_KASA.CKA_CISLO_KASY
- KTO_ID_TRN - [column description]
- KTO_MENA - [column description]
- KTO_MNOZSTVO - [column description]
- KTO_SUMA - [column description]
K_TRN_ODVOD_ARCHIVNY
[table description]
- TOA_ID_TRN_ODVOD_ARCHIVNY - [column description]
- TOA_CISLO_KASY - [column description]
- TOA_CISLO - [column description]
- TOA_DATUM - [column description]
- TOA_ID_UZIVATEL - [column description]
- TOA_TYPE - [column description]
K_TRN_ODVOD_ARCHIVNY_POLOZKY
[table description]
- TAP_ID_TRN_ODVOD_ARCHIVNY - [column description]
- > K_TRN_ODVOD_ARCHIVNY.TOA_ID_TRN_ODVOD_ARCHIVNY
- TAP_ID_TRN - [column description]
- TAP_MENA - [column description]
- TAP_MNOZSTVO - [column description]
- TAP_SUMA - [column description]
- TAP_STAV - [column description]
K_UCTUJUCI_TRN
[table description]
- KUC_CISLO_KASY - [column description]
- > G_KASA.CKA_CISLO_KASY
- KUC_ID_UCTUJUCI - [column description]
- KUC_ID_TRN - [column description]
- KUC_DENNY_PREDAJ - [column description]
- KUC_DENNA_SUMA - [column description]
- KUC_MESACNY_PREDAJ - [column description]
- KUC_MESACNA_SUMA - [column description]
K_UNPRINTED_BILLS
[table description]
- KUB_CKASY - [column description]
- KUB_PORADIE - [column description]
- KUB_DATA - [column description]
K_ZIADANKA_VRATENIE_TOVARU
[table description]
- ZVT_ID - [column description]
- ZVT_ID_LOKALNE_GASTRO - [column description]
- > G_LOKALNE_GASTRO.LGA_ID
- ZVT_DATUM_ZAPISU - [column description]
- ZVT_ID_SPIN - [column description]
- ZVT_CISLO_SPIN - [column description]
- ZVT_DATUM - [column description]
K_ZIADANKA_VRATENIE_TOVARU_POL
[table description]
- ZVP_ID - [column description]
- > K_ZIADANKA_VRATENIE_TOVARU.ZVT_ID
- ZVP_ID_PLU - [column description]
L_FUNKCIA
Zoznam funkcií menu BGM.
- FN_ID_FUNKCIA - [column description]
- FN_ID_MODUL - [column description]
- > L_MODUL.ML_ID_MODUL
- FN_MENO - [column description]
- FN_ID_RODIC - [column description]
- > L_FUNKCIA.FN_ID_FUNKCIA
- FN_VZDY_POVOLENA - [column description]
- FN_PORADIE - [column description]
L_FUNKCIA_TEXT
Názvy funkcií.
- FT_ID_FUNKCIA - [column description]
- > L_FUNKCIA.FN_ID_FUNKCIA
- FT_TEXT - [column description]
L_FUNKCIA_TEXT_LANG
Multilingválna tabuľka.
- FTL_ID - [column description]
- > L_FUNKCIA_TEXT.FT_ID_FUNKCIA
- FTL_TEXT - [column description]
- FTL_LANG - [column description]
L_FUNKCIA_VZOR_VIDITELNOSTI
Definovane videtelnosti jednotlivých funkcií vo vzoroch.
- FVV_ID_FUNKCIA - [column description]
- > L_FUNKCIA.FN_ID_FUNKCIA
- FVV_ID_VZOR - [column description]
- FVV_VISIBLE - [column description]
L_MODUL
[table description]
- ML_ID_MODUL - [column description]
- ML_MENO - [column description]
LOG_FIS_BILL_ATTEMPTS
Logovanie - pokusy o zaslanie účtu do fiskálneho modulu.
- FBA_ID - [column description]
- FBA_ID_BILL - ID účtu.
- FBA_TIME - Čas a dátum zaslania.
- FBA_ID_CASHDESK - ID pokladne.
- > G_KASA.CKA_CISLO_KASY
- FBA_ID_WORKSTATION - ID pracovnej stanice.
- > G_PRACOVNA_STANICA.PS_ID_STANICA
- FBA_ID_USER - ID užívateľa.
- > L_UZIVATEL.UZ_ID_UZIVATEL
- FBA_HOST - Hostname vpp.
- FBA_PORT - Port vpp.
- FBA_DEVICE_ID - ID zariadenia evidovaného vo vpp.
- FBA_STORE_BILL_COPY - Príznak sťahovania kópie fiskálneho dokladu z fiskálneho modulu.
- FBA_DOCUMENT_PRINTED - Príznak úspešného vytlačenia dokladu.
- FBA_ERROR_CODE - Návratový kód chyby.
- FBA_MESSAGE - Textová správa ako výsledok pokusu o vytlačenie dokladu.
LOG_FIS_CLOSING_ATTEMPTS
Logovanie - pokusy o vykonanie uzávierky na fiskálnom module.
- FCA_ID - [column description]
- FCA_TIME - Čas a dátum pokusu.
- FCA_ID_CASHDESK - ID pokladne, na ktorej bol príkaz vykonaný.
- > G_KASA.CKA_CISLO_KASY
- FCA_ID_WORKSTATION - ID pracovnej stanice, na ktorej bola spustená pokladňa.
- > G_PRACOVNA_STANICA.PS_ID_STANICA
- FCA_ID_USER - ID užívateľa, ktorý zadal príkaz vykonania uzávierky.
- > L_UZIVATEL.UZ_ID_UZIVATEL
- FCA_HOST - Hostname vpp.
- FCA_PORT - Port vpp.
- FCA_DEVICE_ID - ID zariadenia evidovaného vo vpp.
- FCA_MESSAGE - Textová správa ako výsledok pokusu o uzávierku.
- FCA_SUCCESSFUL - Príznak úspešnosti pokusu.
- FCA_CLOSING_FM_ID - ID uzávierky vo fiskálnom module.
- > FM_CLOSING.FMC_ID
LOG_CH_GUEST_ABIDING
[table description]
- CHGA_ID - [column description]
- CHGA_DATE - [column description]
- CHGA_USER_ID - [column description]
- CHGA_WORKSTATION_ID - [column description]
- > G_PRACOVNA_STANICA.PS_ID_STANICA
- CHGA_CASHDESK_ID - [column description]
- CHGA_CHANGE_TYPE - [column description]
- CHGA_GUEST_ID - [column description]
- CHGA_AVAIL_DATE_FROM - [column description]
- CHGA_AVAIL_DATE_TO - [column description]
- CHGA_AVAIL_ACTIVE - [column description]
- CHGA_DELETED - [column description]
L_ROLA
[table description]
- RL_ID_ROLA - [column description]
- RL_ID_MODUL - [column description]
- RL_MENO - [column description]
- RL_POVOLENE_NA_KASACH_BIN - [column description]
- RL_LAVY_STLPEC - [column description]
- RL_PORADIE - [column description]
L_ROLA_LANG
Multilingválna tabuľka.
- RL_ID - [column description]
- > L_ROLA.RL_ID_ROLA
- RL_MENO - [column description]
- RL_LANG - [column description]
L_UZIVATEL
[table description]
- UZ_ID_UZIVATEL - [column description]
- > L_UZIVATEL_PREDOK.UP_ID_UZIVATEL_PREDOK
- UZ_PRIHLASOVACIE_MENO - [column description]
- UZ_PRIHLASOVACIE_HESLO - [column description]
- UZ_EMAIL - [column description]
- UZ_NASTAVENIA_ZO_VZORU - [column description]
- UZ_ID_VZOR - [column description]
- UZ_RYCHLE_HESLO - [column description]
- UZ_SKRME - [column description]
- UZ_KOD_JAZYKA - [column description]
- UZ_ZMAZANY - [column description]
- UZ_CISLO_KARTY - [column description]
- UZ_SERV_PRIST_NOVE_POKL - [column description]
L_UZIVATEL_FUNKCIA
[table description]
- UF_ID_FUNKCIA - [column description]
- > L_FUNKCIA.FN_ID_FUNKCIA
- UF_ID_MODUL - [column description]
- > L_MODUL.ML_ID_MODUL
- UF_ID_UZIVATEL - [column description]
- > L_UZIVATEL_PREDOK.UP_ID_UZIVATEL_PREDOK
L_UZIVATEL_MODUL
[table description]
- UM_ID_UZIVATEL_PREDOK - [column description]
- > L_UZIVATEL_PREDOK.UP_ID_UZIVATEL_PREDOK
- UM_ID_MODUL - [column description]
- > L_MODUL.ML_ID_MODUL
L_UZIVATEL_PREDOK
[table description]
- UP_ID_UZIVATEL_PREDOK - [column description]
- UP_MENO - [column description]
- UP_IS_PATTERN - [column description]
L_UZIVATEL_ROLA
[table description]
- UR_ID_ROLA - [column description]
- > L_ROLA.RL_ID_ROLA
- UR_ID_MODUL - [column description]
- > L_MODUL.ML_ID_MODUL
- UR_ID_UZIVATEL - [column description]
- > L_UZIVATEL_PREDOK.UP_ID_UZIVATEL_PREDOK
- UR_TYP_POKLADNE_BIN - [column description]
L_VZORY_VIDITELNOSTI
Vzory viditeľnosti.
- VV_ID_VZOR - [column description]
- VV_NAZOV - Názov.
PAYMENT_GROUP_LIMITS
Skupinové limity platieb.
- PGL_ID - [column description]
- PGL_NAME - Názov limitu.
- PGL_PAYMENT_LIMIT - Hodnota limitu.
PRCPRF_ALT_PRICELEVEL_PLU
Priradenie počet PLU v alternatívnej cenovej hladine pre cenový profil.
- PRICE_PROFILE_ID - ID cenového profilu.
- > G_CENOVY_PROFIL.CPR_ID_CENOVY_PROFIL
- PLU_CATEGORY_ID - ID kategórie PLU.
- > G_KATEGORIA_PLU.KAP_ID
- PLU_COUNT - Počet PLU spadajúcich do alternatívnej cenovej hladiny.
PRCPRF_CHANGE_BY_BILL
Záznam zmeny cenového profilu stáleho hosťa účtom.
- BILL_ID - ID účtu.
- > K_DENNY_UCET.DUC_ID_UCET
- OLD_PRICE_PROFILE_ID - ID pôvodného cenového profilu hosťa.
- > G_CENOVY_PROFIL.CPR_ID_CENOVY_PROFIL
- NEW_PRICE_PROFILE_ID - ID nového cenového profilu hosťa.
- > G_CENOVY_PROFIL.CPR_ID_CENOVY_PROFIL
PREINVENTORY
[table description]
- PIN_ID - [column description]
- PIN_DATE_TIME_INITIAL - [column description]
- PIN_DATE_TIME_LAST_CHANGE - [column description]
- PIN_DATE_ACCOUNTING - [column description]
- PIN_DEPARTMENT_ID - [column description]
- > G_STREDISKO.CST_ID_STREDISKO
- PIN_USER_ID - [column description]
- > L_UZIVATEL.UZ_ID_UZIVATEL
- PIN_STATE - [column description]
- PIN_PRICE_TYPE_USED - [column description]
PREINVENTORY_ITEM
[table description]
- PII_ID - [column description]
- PII_PREINVENTORY_ID - [column description]
- > PREINVENTORY.PIN_ID
- PII_GOODS_ID - [column description]
- > G_TOVAR_JEDLO.CTJ_ID_TOVAR_JEDLO
- PII_ESTIMATED_QUANTITY - [column description]
- PII_PHYSICAL_QUANTITY - [column description]
- PII_PRICE - [column description]
PREINVENTORY_LOADED_IN
[table description]
- PIL_PREINVENTORY_ID - [column description]
- > PREINVENTORY.PIN_ID
- PIL_INVENTORY_ID - [column description]
- > G_INV.INV_ID_INV
- PIL_QTY_CALCULATION_TYPE - [column description]
PRINTER
Typy tlačiarní.
- PRI_ID - [column description]
- PRI_TYP - Typ, skratka.
- PRI_DESCR - Popis.
PRINT_CHANNEL
Tlačové kanály.
- PCH_ID - [column description]
- PCH_NAME - Názov.
- PCH_DESCR - Popis.
PRINT_CHANNEL_LANG
Multilingválna tabuľka.
- PCH_ID - [column description]
- > PRINT_CHANNEL.PCH_ID
- PCH_NAME - [column description]
- PCH_LANG - [column description]
PRINT_CHANNEL_ON_WS
Nastavenie tlačových kanálov na pracovných staniciach.
- POW_WS_ID - ID pracovnej stanice.
- > G_PRACOVNA_STANICA.PS_ID_STANICA
- POW_PCH_ID - ID tlačového kanálu.
- > PRINT_CHANNEL.PCH_ID
- POW_VPP_ID - ID vpp zariadenia.
- > VPP_DEVICE.VPP_ID
- POW_PRINTER_ID - ID typu tlačiarne.
- > PRINTER.PRI_ID
- POW_CODEPAGE - Kódová stránka.
- POW_OPEN_CASHDRAWER - Príznak otvárania peňažnej zásuvky.
- POW_BILL_TEMPLATE - ID šablóny pokladničného bloku.
- POW_DOC_TYPE - [column description]
PRINT_SEQUENCES
Tlačové sekvencie.
- PRS_TAG_ID - ID tagu.
- > PRINT_TAG.PRT_ID
- PRS_PRINTER_ID - ID typu tlačiarne.
- > PRINTER.PRI_ID
- PRS_START_SEQ - Sekvencia štart tagu.
- PRS_STOP_SEQ - Sekvencia stop tagu.
PRINT_TAG
Definované tlačové tagy.
- PRT_ID - [column description]
- PRT_NAME - Názov.
- PRT_SYSTEM_TAG - Príznak systémového tagu.
- PRT_DESCR - Popis.
SAP_MESSAGE
[table description]
- SMS_ID - [column description]
- SMS_EXT_SYS_ID - [column description]
- SMS_DATE - [column description]
- SMS_TRANSFER_DOCUMENT_ID - [column description]
- > G_DOKLAD_POHYBY_TOVARU.POD_ID_POHYBY_TOVARU
- SMS_XML_MESSAGE - [column description]
- SMS_MESSAGE_TYPE - [column description]
- SMS_MESSAGE_CODE - [column description]
- SMS_DOCUMENT_NUMBER - [column description]
- SMS_STATUS - [column description]
- SMS_STATUS_TYPE - [column description]
- SMS_STATUS_TEXT - [column description]
- SMS_STATUS_NOTIFY_ID - [column description]
- SMS_STATUS_NOTIFY_NUMBER - [column description]
SBL_CLOSING
Uzávierka SBL.
- SBC_ID - [column description]
- SBC_DATE - [column description]
- SBC_DATE_TIME_CREATED - [column description]
- SBC_ID_ESTABLISHMENT - [column description]
- > SBL_ESTABLISHMENT.SBE_ID
- SBC_ID_USER - [column description]
- > L_UZIVATEL.UZ_ID_UZIVATEL
- SBC_DATE_TIME_CANCELED - [column description]
SBL_ESTAB_DEPARTMENT
[table description]
- SED_ID_ESTABLISHMENT - [column description]
- > SBL_ESTABLISHMENT.SBE_ID
- SED_ID_DEPARTMENT - [column description]
- > G_STREDISKO.CST_ID_STREDISKO
- SED_TRANSFER - [column description]
SBL_ESTABLISHMENT
[table description]
- SBE_ID - [column description]
- SBE_NUMBER - [column description]
- SBE_NAME - [column description]
- SBE_ORDER - [column description]
- SBE_ALLOWED - [column description]
SBL_EVIDENCE
Spotrebné balenie liehu - evidencia.
- SEV_ID - [column description]
- SEV_LAST_MODIFY_DATE_TIME - [column description]
- SEV_LAST_MODIFY_USER - [column description]
- SEV_ID_ESTABLISHMENT - [column description]
- > SBL_ESTABLISHMENT.SBE_ID
- SEV_DATE - [column description]
- SEV_ENTRY_CREATION_METHOD - [column description]
- SEV_ENTRY_TYPE - [column description]
- SEV_ID_GOODS_TRANSFER_DOC - [column description]
- > G_DOKLAD_POHYBY_TOVARU.POD_ID_POHYBY_TOVARU
- SEV_ID_BILL - [column description]
- > K_DENNY_UCET.DUC_ID_UCET
- SEV_ID_GOODS - [column description]
- > G_TOVAR.CTO_ID_TOVAR
- SEV_EAN - [column description]
- SEV_QUANTITY - [column description]
- SEV_ID_SUPPLIER - [column description]
- > G_OBCHODNY_PARTNER.COP_ID_OBCHODNY_PARTNER
- SEV_STATE - [column description]
- SEV_ID_CLOSING - [column description]
- SEV_ID_DEPARTMENT - [column description]
- > G_STREDISKO.CST_ID_STREDISKO
- SEV_CHARGE - [column description]
- SEV_NOTE - [column description]
- SEV_WORK_STATION - [column description]
- SEV_ID_ESTABLISHMENT_2 - [column description]
- > SBL_ESTABLISHMENT.SBE_ID
- SEV_ID_DEPARTMENT_2 - [column description]
- > G_STREDISKO.CST_ID_STREDISKO
- SEV_ID_CLOSING_2 - [column description]
- > SBL_CLOSING.SBC_ID
T_GROUP
[table description]
- TGR_ID - [column description]
- TGR_ID_GROUP_PT - [column description]
- TGR_ID_GROUP - [column description]
- TGR_NAME - [column description]
- TGR_ID_ORDER - [column description]
- > T_ORDER.TOR_ID
T_ITEM
[table description]
- TIT_ID - [column description]
- TIT_ID_ITEM_PT - [column description]
- TIT_ID_ITEM - [column description]
- TIT_NAME - [column description]
- TIT_AMOUNT - [column description]
- TIT_ID_GROUP - [column description]
- > T_GROUP.TGR_ID
T_MESSAGE
[table description]
- TME_ID - [column description]
- TME_DATE - [column description]
- TME_ID_TERMINAL_PTC - [column description]
- TME_NAME_TERMINAL_PT - [column description]
- TME_ID_USER_PT - [column description]
- TME_NAME_USER_PT - [column description]
- TME_READED_BY - [column description]
- TME_LOGICAL_ADRESS - [column description]
- TME_MSG - [column description]
- TME_OUTPUT_POINT_TYPE - [column description]
- TME_ID_TERMINAL_PTS - [column description]
- > G_EXTERNE_SYSTEMY.EXS_ID
T_ORDER
[table description]
- TOR_ID - [column description]
- TOR_ID_ORDER_PT - [column description]
- TOR_NUMBER_PT - [column description]
- TOR_ID_ORDER - [column description]
- TOR_NAME - [column description]
- TOR_CKASY - [column description]
T_STATE_CHANGE
[table description]
- STC_ID - [column description]
- > T_MESSAGE.TME_ID
- STC_STATE_FROM - [column description]
- STC_STATE_TO - [column description]
- STC_ID_ORDER - [column description]
- > T_ORDER.TOR_ID
- STC_STATE_CHANGE_TYPE - [column description]
T_ZAKAZNIK_STALY_KREDIT_ZMENA
[table description]
- ZSKZ_ID - [column description]
- ZSKZ_ID_ZAKAZNIK - [column description]
- ZSKZ_NATAZENY_KREDIT - [column description]
- ZSKZ_MENA - [column description]
- ZSKZ_CUMULATE_CREDIT - [column description]
VERSION
Verzie sytému.
- DATA_VERSION - Aktuálna dátová verzia.
VPP_DEVICE
Virtual Printer Port zariadenia.
- VPP_ID - [column description]
- VPP_NAME - Názov.
- VPP_IP_HOST_NAME - IP/hostname.
- VPP_PORT - Port.
- VPP_DEVICE_ID - ID zariadenia registrovaného vo VPP.
- VPP_TIMEOUT - Prednastavený timeout pripojenia.
- VPP_CONVERSION - Konverzia príkazov Bowa Dll, Elcom, Priama, ...
- VPP_DEVICE_NAME - Fyzický názov zariadenia vo VPP.
- VPP_COMM_PORT - Sériový port, na ktorý je vstupno/výstupné (I/O) zariadenie pripojené.
- VPP_SN - Sériové číslo (ak je dostupné) I/O zariadenia.
Z_STAT_ZOSTAVA
Hlavičky užívateľsky definovaných štatisktických zostáv.
- SZO_ID_ZOSTAVA - [column description]
- SZO_NAZOV - [column description]
- SZO_SIRKA - [column description]
- SZO_CISLO - [column description]
- SZO_POZNAMKA - [column description]
- SZO_GENEROVAT_PRI_MES_UZ - [column description]
- SZO_ZOBRAZUJ_POZNAMKU - [column description]
Z_STAT_ZOSTAVA_STLPEC
Stĺpce štatistických zostáv.
- SZS_ID_ZOSTAVA - [column description]
- > Z_STAT_ZOSTAVA.SZO_ID_ZOSTAVA
- SZS_PORADIE - [column description]
- SZS_NAZOV - [column description]
- SZS_ID_STLPEC_TYP_EXT - [column description]
- > Z_STAT_ZOST_STL_TYP_EXT.STE_ID_STLPEC_TYP_EXT
- SZS_SIRKA - [column description]
- SZS_ZOBRAZOVAT - [column description]
- SZS_SUMAR - [column description]
- SZS_DES_MIEST - [column description]
- SZS_VZOREC - [column description]
- SZS_PREDAJNE_CENY - [column description]
- SZS_BEZ_DPH - [column description]
Z_STAT_ZOSTAVA_STLPEC_CIS
[table description]
- SZC_ID_ZOSTAVA - [column description]
- > Z_STAT_ZOSTAVA_STLPEC.SZS_ID_ZOSTAVA
- SZC_PORADIE - [column description]
- > Z_STAT_ZOSTAVA_STLPEC.SZS_PORADIE
- SZC_ID_CISELNIK - [column description]
Z_STAT_ZOST_STL_TYP
[table description]
- SZT_ID_STLPEC_TYP - [column description]
Z_STAT_ZOST_STL_TYP_EXT
[table description]
- STE_ID_STLPEC_TYP_EXT - [column description]
- STE_ID_STLPEC_TYP - [column description]
- > Z_STAT_ZOST_STL_TYP.SZT_ID_STLPEC_TYP
- STE_POVOL_SUMAR - [column description]
- STE_POVOL_PREDAJNE_CENY - [column description]
- STE_POVOL_DPH - [column description]
Z_STAT_ZOST_STL_TYP_EXT_LANG
Multilingválna tabuľka.
- STE_ID - [column description]
- > Z_STAT_ZOST_STL_TYP_EXT.STE_ID_STLPEC_TYP_EXT
- STE_NAZOV - [column description]
- STE_LANG - [column description]
Z_STAT_ZOST_STL_TYP_LANG
Multilingválna tabuľka.
- SZT_ID - [column description]
- > Z_STAT_ZOST_STL_TYP.SZT_ID_STLPEC_TYP
- SZT_NAZOV - [column description]
- SZT_LANG - [column description]
