Devel - BlueGastro - DB tables
<viewsecurity service />
Obsah
- 1 ACCOUNTING_DOCUMENT
- 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 CLOSED_ACCOUNT_SEND
- 19 DB_ACTUAL_SESSIONS
- 20 DB_SEQUENCE
- 21 EXSYS_LOYALTY_TMR
- 22 EXSYS_LOYALTY_TMR_BILL
- 23 EXSYS_LOYALTY_TMR_B_ITEMS
- 24 FM_BILL
- 25 FM_CLOSING
- 26 FM_INVOICE
- 27 G_AKCIA
- 28 G_AKCIA_LIMIT
- 29 G_AKCIA_TYP_ODBYTU
- 30 G_AKCIA_TYP_ODBYTU_LANG
- 31 G_AKCIA_TYP_UDALOSTI
- 32 G_AKCIA_UDALOST
- 33 G_AKCIA_UDALOST_POLOZKA
- 34 G_BALIK_PLU
- 35 G_BALIK_PLU_KASY
- 36 G_BALIK_PLU_POLOZKY
- 37 G_CENOVY_PROFIL
- 38 G_CENOVY_PROFIL_ZLAVA
- 39 G_CHANGES
- 40 G_CHANGES_ACTUAL_VALUES
- 41 G_CHANGES_FILE
- 42 G_CHOD
- 43 G_CISLO_DOKLADU
- 44 G_CONSTANTS
- 45 G_CONSTANTS_LANG
- 46 G_DEN_V_TYZDNI
- 47 G_DEN_V_TYZDNI_LANG
- 48 G_DOCHADZKA_LOGOVANIE
- 49 G_DOCHADZKA_NASTAVENIA
- 50 G_DOCHADZKA_OBJEKT
- 51 G_DOCHADZKA_UZIVATEL
- 52 G_DOKLAD_NEODPISANY_TOVAR
- 53 G_DOKLAD_POHYBY_JEDLA
- 54 G_DOKLAD_POHYBY_TOVARU
- 55 G_DOKLAD_POHYBY_TOVARU_CCP
- 56 G_DOKLAD_POHYBY_TOVARU_DPH
- 57 G_DOKLAD_STAV
- 58 G_DOKLAD_STAV_LANG
- 59 G_DOKLAD_TOVAR_NA_ODPISANIE
- 60 G_DOKLAD_VYROBA_POLOT
- 61 G_DPT
- 62 G_DRUH_POHYBU
- 63 G_DRUH_POHYBU_TYPY
- 64 G_DRUH_POHYBU_TYPY_LANG
- 65 G_DRUH_TOVAR_JEDLO
- 66 G_EXTERNAL_MESSAGE
- 67 G_EXTERNAL_ORDER
- 68 G_EXTERNAL_ORDER_GOLF
- 69 G_EXTERNAL_ORDER_ITEMS
- 70 G_EXTERNAL_PDA_CLIENT
- 71 G_EXTERNE_SYSTEMY
- 72 G_EXTERNE_SYSTEMY_EKONOMIKA
- 73 G_EXTERNE_SYSTEMY_EXT_GOLF
- 74 G_EXTERNE_SYSTEMY_EXT_PDA
- 75 G_EXTERNE_SYSTEMY_FIDELIO
- 76 G_EXTERNE_SYSTEMY_FIDELIO_IZBY
- 77 G_EXTERNE_SYSTEMY_FIDELIO_ZI
- 78 G_EXTERNE_SYSTEMY_GASTRO
- 79 G_EXTERNE_SYSTEMY_HOTSYS
- 80 G_EXTERNE_SYSTEMY_KAMERA
- 81 G_EXTERNE_SYSTEMY_LOYALITY
- 82 G_EXTERNE_SYSTEMY_ORDERS
- 83 G_EXTERNE_SYSTEMY_SAP
- 84 G_EXTERNE_SYSTEMY_TAP_DEV
- 85 G_EXTERNE_SYSTEMY_TAP_SYS
- 86 G_EXTERNE_SYSTEMY_VTS
- 87 G_EXTERNE_SYSTEMY_VYCAP
- 88 G_EXTERNE_SYSTEMY_WELLNESS_L
- 89 G_EXTERNE_SYSTEMY_WELLNESS_S
- 90 G_EXT_MESSAGE_STATE_CHANGE
- 91 G_EXT_ORDER_STATE_CHANGE
- 92 G_EXT_SYS_KASA
- 93 G_EXT_SYS_LIST
- 94 G_EXT_SYS_LIST_GOODS
- 95 G_EXT_SYS_LIST_SEND
- 96 G_EXT_SYS_ORDERS_AKCIA
- 97 G_EXT_SYS_ORDERS_AKCIA_LANG
- 98 G_EXT_SYS_ORDERS_KASA
- 99 G_EXTSYS_PDA_TRANSACTIONS
- 100 G_EXT_SYS_PLATBA
- 101 G_EXT_SYS_PLU
- 102 G_EXT_SYS_PLU_KASA
- 103 G_EXT_SYS_REST_TABLE
- 104 G_EXT_SYSTEMY_EKON_VER_EXPORT
- 105 G_EXT_SYS_USER
- 106 G_FIRMA
- 107 G_GASTRO_VERSION
- 108 G_GRUPA
- 109 G_HODINY
- 110 G_HOREC
- 111 G_INV
- 112 G_INV_POLOZKA
- 113 G_INV_POL_ZDRUZOVANE
- 114 G_JEDLO
- 115 G_JEDNOTKA_MNOZSTVA
- 116 G_JEDNOTKA_MNOZSTVA_LANG
- 117 G_KALENDAR
- 118 G_KALKULACNA_PRIRAZKA
- 119 G_KAMERA_AKCIE
- 120 G_KAMERA_AKCIE_KASA
- 121 G_KAMERA_AKCIE_LANG
- 122 G_KAMERA_LOG
- 123 G_KARTA_EXT_SLUZBA
- 124 G_KASA
- 125 G_KASA_DPT
- 126 G_KASA_EURO
- 127 G_KASA_EURO_COMMANDS
- 128 G_KASA_EURO_COUNTRY
- 129 G_KASA_EURO_DPH
- 130 G_KASA_EURO_TYP
- 131 G_KASA_EXTERNAL
- 132 G_KASA_FISKALNY_MODUL_POSNET
- 133 G_KASA_GROUP
- 134 G_KASA_GROUP_KASY
- 135 G_KASA_HOREC
- 136 G_KASA_HOREC_DPH
- 137 G_KASA_KLAVESOVA_SKRATKA
- 138 G_KASA_KLAVESOVA_SKRATKA_LANG
- 139 G_KASA_NASTAVENIA_STANICE
- 140 G_KASA_NEVIDITELNOST
- 141 G_KASA_OBJ_STAV
- 142 G_KASA_OBJ_TYP
- 143 G_KASA_PORADIE_KAT
- 144 G_KASA_SADZBA_DPH
- 145 G_KASA_SETTINGS
- 146 G_KASA_SETTINGS_PREDOK
- 147 G_KASA_SETTINGS_VZOR
- 148 G_KASA_SPRAVA_STAV
- 149 G_KASA_SPRAVA_TYP
- 150 G_KASA_STATS_REPORT
- 151 G_KASA_STATS_SETTINGS
- 152 G_KASA_STATS_SETTINGS_KASY
- 153 G_KASA_STREDISKA
- 154 G_KASA_TYP
- 155 G_KASA_TYP_LANG
- 156 G_KASA_UZIVATEL
- 157 G_KASA_UZIVATEL_PREHLAD
- 158 G_KATEGORIA_PLU
- 159 G_KATEGORIA_PLU_VIAZANE
- 160 G_KREDITNE_PLU
- 161 G_LOG_ZMENY
- 162 G_LOG_ZMENY_STLPEC
- 163 G_LOG_ZMENY_STLPEC_LANG
- 164 G_LOKALNE_GASTRO
- 165 G_MASTER_PING_PONG_SETTINGS
- 166 G_MASTER_PING_PONG_STATS
- 167 G_MASTER_PP_SETTINGS_POL
- 168 G_MEGA_COUNTER
- 169 G_MESIAC
- 170 G_MESIAC_LANG
- 171 G_NEODPISANY_TOVAR
- 172 G_OBCHODNY_PARTNER
- 173 G_OBJ_BOD_ITEM_PARENT
- 174 G_OBJ_BOD_ITEM_SIETOVA
- 175 G_OBJ_BOD_ITEM_TERMINAL
- 176 G_OBJ_BOD_TO_ITEMS
- 177 G_OBJEDNAVKOVY_BOD
- 178 G_ODBERATEL_FAKTURA
- 179 GOODS_TRANSFER_KIND_EXT
- 180 GOODS_TRANSFER_ORDER
- 181 GOODS_TRANSFER_ORDER_ITEM
- 182 GOODS_TRANSFER_SEND
- 183 GP_AKCIA_LIMIT
- 184 GP_AKCIA_UDALOST
- 185 GP_AKCIA_UDALOST_POLOZKA
- 186 GP_BALIK_PLU_POLOZKY
- 187 GP_CENOVY_PROFIL_ZLAVA
- 188 G_PERCENTO_ALKOHOLU
- 189 GP_EXTERNE_SYSTEMY_TAP_DEV
- 190 GP_EXTSYS_FIDELIO_ZASL_ITEMS
- 191 GP_EXT_SYS_ORDERS_KASA
- 192 GP_EXT_SYS_PLU
- 193 GP_EXT_SYS_PLU_KASA
- 194 GP_EXT_SYS_REST_TABLE
- 195 GP_EXT_SYS_USER
- 196 GP_GOODS_EAN
- 197 GP_IMPORT_TOVAROV
- 198 G_PLATBY_PLANOVANIE
- 199 G_PLATBY_PLANOVANIE_KASY
- 200 G_PLAT_KARTA_TYP
- 201 G_PLU
- 202 G_PLU_CENY_V_MENACH
- 203 G_PLU_EXT
- 204 G_PLU_KASA
- 205 G_PLU_KASA_ROZPRACOVANE
- 206 G_PLU_KLAVESOVA_SKRATKA
- 207 G_PLU_LG_POCET
- 208 G_PLU_LG_POCET_ZMENA
- 209 G_PLU_SEGMENT
- 210 G_PLU_TARA
- 211 GP_ODVOD
- 212 G_POHYB_JEDLA
- 213 G_POHYB_JEDLA_UDALOST
- 214 G_POHYB_TOVARU
- 215 GP_PLU_CENY_V_MENACH
- 216 GP_PLU_KASA
- 217 GP_POHYB_JEDLA
- 218 GP_POHYB_JEDLA_UDALOST
- 219 GP_POHYB_TOVARU
- 220 GP_PORADIE_KATEGORII
- 221 GP_PROD_TERMINAL_CLIENTS
- 222 G_PRACOVNA_STANICA
- 223 G_PRACOVNA_STANICA_ZARIADENIE
- 224 GP_RECEPT
- 225 G_PREDAJ_GRUPA
- 226 G_PREDAJ_HODINY
- 227 G_PREDAJ_PLU
- 228 G_PREDAJ_PLU_TRN
- 229 G_PREDAJ_TRN
- 230 G_PREDAJ_TRZBY
- 231 G_PREDAJ_UCTUJUCI_DRUHY
- 232 G_PREDAJ_UCTUJUCI_TRN
- 233 G_PREDEFINED_COLORS
- 234 G_PREPOCET_NASTAVENIA
- 235 G_PREVADZKA
- 236 G_PREVOD_DRUHOV_TOVAROV
- 237 G_PRIESTOR
- 238 GP_ROZPIS_SUROVIN
- 239 GP_TJ_CENA_V_MENE
- 240 GP_TOVAR_ZMENA_KCIEN
- 241 GP_UCTOVACI_PROFIL_POLOZKY
- 242 GP_ZAMENA_SUROVIN
- 243 GP_ZMENA_SADZBY_DPH
- 244 G_RECEPT
- 245 G_REST_PRIESTOR
- 246 G_REST_PRIESTOR_NEVIDITELNOST
- 247 G_REST_PRIESTOR_PORADIE
- 248 G_REST_STOL
- 249 G_ROZPRACOVANOST
- 250 G_ROZSIAHLY_EUR_FORMULAR
- 251 G_SADZBA_DPH
- 252 G_SETTINGS
- 253 G_SLUZBA
- 254 G_SLUZBA_EXT_ERS
- 255 G_SPINTOTAL_DAVKA
- 256 G_SPINTOTAL_PLULIST_LOG
- 257 G_SPOSOB_PLATBY
- 258 G_SPOSOB_PLATBY_DPH
- 259 G_SPOSOB_PLATBY_KATEGORIA
- 260 G_SPOSOB_PLATBY_SKUPINA
- 261 G_SPOSOB_PLATBY_SKUP_PRIR
- 262 G_SPOSOB_PLATBY_TYP
- 263 G_SPOSOB_PLATBY_TYP_LANG
- 264 G_SPOSOB_PLATBY_UZIVATEL
- 265 G_STASTNE_HODINY
- 266 G_STAV_TOVARU
- 267 G_STREDISKO
- 268 G_STREDISKO_TYP
- 269 G_STREDISKO_TYP_LANG
- 270 G_STREDISKO_UZIVATEL
- 271 G_STREDISKO_UZIVATEL_POHYB
- 272 G_STREDISKO_UZIVATEL_PREZ_STAV
- 273 G_SUBJEKT
- 274 G_TABLES
- 275 G_TOVAR
- 276 G_TOVAR_JEDLO
- 277 G_TOVAR_JEDLO_CENA
- 278 G_TOVAR_JEDLO_CENA_V_MENE
- 279 G_TOVAR_JEDLO_EAN
- 280 G_TOVAR_NA_ODPISANIE
- 281 G_TOVAR_ODPIS_ALTERNATIVY
- 282 G_TRN
- 283 G_TRN_KATEGORIA
- 284 G_TRN_KATEGORIA_LANG
- 285 G_TYP_POLOZKY_OBJEDNAVKY
- 286 G_TYPY_EKON_EXTERNYCH_SYSTEMOV
- 287 G_UCTOVACI_PROFIL
- 288 G_UCTOVACI_PROFIL_POLOZKY
- 289 G_UCTOVNY_DRUH
- 290 G_USEK
- 291 G_UZAVIERKA
- 292 G_UZAVIERKA_STR_ALK_NEW_STAV
- 293 G_UZAVIERKA_STR_ALKOHOL_NEW
- 294 G_UZAVIERKA_STREDISKO
- 295 G_UZAVIERKA_STREDISKO_ALK_PRIJ
- 296 G_UZAVIERKA_STREDISKO_ALK_STAV
- 297 G_UZAVIERKA_STREDISKO_TOVAR
- 298 G_UZAVIERKA_TYP
- 299 G_UZAVIERKA_TYP_LANG
- 300 G_UZIVATEL_OBCHODNY_PARTNER
- 301 G_VYCAP
- 302 G_VYROBA_POLOT_POLOZKY
- 303 G_VYROBA_POLOT_PREVOD
- 304 G_WEB_SERVICES
- 305 G_WEB_SERVICES_PROTOCOL_TYPE
- 306 G_WELLNESS_LITE_CARD
- 307 G_ZAKAZNICKY_DISPLEJ
- 308 G_ZAKAZNIK
- 309 G_ZAKAZNIK_EXTERNY
- 310 G_ZAKAZNIK_FIDELIO
- 311 G_ZAKAZNIK_HOREC
- 312 G_ZAKAZNIK_HOTSYS
- 313 G_ZAKAZNIK_STALY
- 314 G_ZAKAZNIK_STALY_KATEG_HOSTA
- 315 G_ZAKAZNIK_STALY_KRED_KONTO
- 316 G_ZAKAZNIK_STALY_TP
- 317 G_ZAKAZNIK_STALY_TP_LIST
- 318 G_ZAKAZNIK_STALY_TP_POL
- 319 G_ZAKAZNIK_STALY_TYP_UCTU
- 320 G_ZAKAZNIK_STALY_TYP_UCTU_LANG
- 321 G_ZAMESTNANCI_NASTAVENIA
- 322 G_ZAOKRUHLENIE
- 323 G_ZAOKRUHLENIE_LANG
- 324 G_ZAOKRUHLENIE_TYP
- 325 G_ZAOKRUHLENIE_TYP_LANG
- 326 G_ZARIADENIE
- 327 G_ZARIADENIE_CITACKA_KARIET
- 328 G_ZARIADENIE_KOD_TYP
- 329 G_ZARIADENIE_KOD_TYP_PRAVIDLA
- 330 G_ZARIADENIE_PORT
- 331 G_ZARIADENIE_TYP
- 332 G_ZARIADENIE_TYP_LANG
- 333 G_ZLAVA
- 334 G_ZLAVA_UZIVATEL
- 335 G_ZS_UCT_KONTO_TYP
- 336 G_ZS_UCT_KONTO_TYP_LANG
- 337 HC_ST
- 338 HC_ST_LANG
- 339 HC_TO
- 340 HC_VLAJKA
- 341 HC_VLAJKA_LANG
- 342 HK_FI
- 343 HP_ARCHIV
- 344 HP_FAJKA
- 345 HP_FAJKA_LONG
- 346 HP_LIST
- 347 HP_ZOZNAM
- 348 INFO_MESSAGE_CUSTOMER
- 349 INFO_MESSAGE_CUSTOMER_CALL
- 350 INFO_MESSAGE_CUSTOMER_READ
- 351 K_CISLO_ODVOD
- 352 K_CISLO_UCTU
- 353 K_CISLO_UZAVIERKA
- 354 K_CISLO_UZAVIERKA_NASTAVENIA
- 355 K_DENNY_UCET
- 356 K_DENNY_UCET_ERS_EXT
- 357 K_DENNY_UCET_PLATBA
- 358 K_DENNY_UCET_POL_ERS_EXT
- 359 K_DENNY_UCET_POLOZKA
- 360 K_EXT_SYS_TAP_DEV_SENT
- 361 K_FAKTURA
- 362 K_GRUPA
- 363 K_HODINY
- 364 K_KL_HISTORIA
- 365 K_KL_KURZ
- 366 K_KL_KURZOVY_LISTOK
- 367 K_KL_MENA
- 368 K_KL_SYSTEM
- 369 K_OTVORENY_UCET
- 370 K_OTVORENY_UCET_POL_CHOD
- 371 K_OTVORENY_UCET_POLOZKA
- 372 K_PLANOVANIE_PLATIEB_SUMA
- 373 K_PLU
- 374 K_PLU_KASA
- 375 K_PLU_STAT
- 376 K_POZNAMKA_OBJEDNAVKA
- 377 K_POZNAMKA_OBJEDNAVKA_KAT
- 378 KP_PRACOVNY_UCET
- 379 KP_PRACOVNY_UCET_PLATBA
- 380 KP_PRACOVNY_UCET_POL_CHOD
- 381 KP_PRACOVNY_UCET_POLOZKA
- 382 K_TRN
- 383 K_TRN_ODVOD
- 384 K_TRN_ODVOD_ARCHIVNY
- 385 K_TRN_ODVOD_ARCHIVNY_POLOZKY
- 386 K_UCTUJUCI_TRN
- 387 K_UNPRINTED_BILLS
- 388 K_ZIADANKA_VRATENIE_TOVARU
- 389 K_ZIADANKA_VRATENIE_TOVARU_POL
- 390 L_FUNKCIA
- 391 L_FUNKCIA_TEXT
- 392 L_FUNKCIA_TEXT_LANG
- 393 L_FUNKCIA_VZOR_VIDITELNOSTI
- 394 L_MODUL
- 395 LOG_CH_GUEST_ABIDING
- 396 LOG_FIS_BILL_ATTEMPTS
- 397 LOG_FIS_CLOSING_ATTEMPTS
- 398 LOYALITY_CLOSED_ACCOUNT
- 399 LOYALITY_CLOSED_ACCOUNT_V
- 400 L_ROLA
- 401 L_ROLA_LANG
- 402 L_UZIVATEL
- 403 L_UZIVATEL_FUNKCIA
- 404 L_UZIVATEL_MODUL
- 405 L_UZIVATEL_PREDOK
- 406 L_UZIVATEL_ROLA
- 407 L_VZORY_VIDITELNOSTI
- 408 PAYMENT_GROUP_LIMITS
- 409 PRINT_CHANNEL
- 410 PRINT_CHANNEL_LANG
- 411 PRINT_CHANNEL_ON_WS
- 412 PRINTER
- 413 PRINT_SEQUENCES
- 414 PRINT_TAG
- 415 SAP_MESSAGE
- 416 SBL_CLOSING
- 417 SBL_ESTAB_DEPARTMENT
- 418 SBL_ESTABLISHMENT
- 419 SBL_EVIDENCE
- 420 T_GROUP
- 421 T_ITEM
- 422 T_MESSAGE
- 423 T_ORDER
- 424 T_STATE_CHANGE
- 425 T_ZAKAZNIK_STALY_KREDIT_ZMENA
- 426 VERSION
- 427 VPP_DEVICE
- 428 Z_STAT_ZOSTAVA
- 429 Z_STAT_ZOSTAVA_STLPEC
- 430 Z_STAT_ZOSTAVA_STLPEC_CIS
- 431 Z_STAT_ZOST_STL_TYP
- 432 Z_STAT_ZOST_STL_TYP_EXT
- 433 Z_STAT_ZOST_STL_TYP_EXT_LANG
- 434 Z_STAT_ZOST_STL_TYP_LANG
ACCOUNTING_DOCUMENT
(beta) ukladanie kópií účtov a uzávierok do DB namiesto súborov FDO.
- ACD_ID
- ACD_DOCUMENT - Telo dokumentu.
- ACD_ACCOUNT_ID - ID účtu. (premenovať na bill alebo odstrániť a dať odkaz do účtu)
- > K_DENNY_UCET.DUC_ID_UCET
- ACD_CLOSING_ID - ID uzávierky. (pravdepdobne odstrániť a dať odkaz do uzávierky)
- > G_UZAVIERKA.UZA_ID_UZAVIERKY
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]
CLOSED_ACCOUNT_SEND
Všeobecné záznamy o odoslaných účtoch (väčšinou pre externé systémy).
- CAS_ID - [column description]
- CAS_CLOSED_ACCOUNT_ID - [column description]
- > K_DENNY_UCET.DUC_ID_UCET
- CAS_TIME_INIT - [column description]
- CAS_TIME_SENT - [column description]
- CAS_MESSAGE - [column description]
- CAS_EXT_SYS_ID - [column description]
- > 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 - [column description]
- DB_USER - [column description]
- HOST_NAME - [column description]
- TERMINAL_NAME - [column description]
- INIT_DATE - [column description]
- APPLICATION_CLIENT_NAME - [column description]
- APPLICATION_USER_ID - [column description]
- APPLICATION_USER_LOGIN_DATE - [column description]
- APPLICATION_IDENTIFIER - [column description]
- WORKSTATION_IDENTIFIER - [column description]
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 - [column description]
- SEQ_TABLE_NAME - [column description]
- > G_TABLES.GTA_NAZOV
- SEQ_COLUMN_NAME - [column description]
- SEQ_PK - [column description]
- SEQ_ACTUAL_VALUE - [column description]
EXSYS_LOYALTY_TMR
Externé systémy Loyality TMR.
- LTM_ID - [column description]
- LTM_GIN - [column description]
- > G_LOKALNE_GASTRO.LGA_ID
- LTM_SEND_INTERVAL_START - [column description]
- LTM_SEND_INTERVAL_STOP - [column description]
- LTM_SEND_REPEATS - [column description]
- LTM_SEND_BREAK - [column description]
- LTM_SEND_BILL_TIMEOUT - [column description]
- LTM_CARD_DIGITS - [column description]
- LTM_ABORTED_AT - [column description]
EXSYS_LOYALTY_TMR_BILL
Hlavičky účtov zasielaných do externých systémov Loyality TMR.
- LTB_ACCOUNT_ID - [column description]
- > K_DENNY_UCET.DUC_ID_UCET
- LTB_SEND_ATTEMPTS - [column description]
- LTB_LAST_SEND_ERROR - [column description]
- LTB_SUCCESSFULLY_SENT - [column description]
- LTB_INTO_FAULT_STACK - [column description]
- LTB_IN_FAULT_STACK - [column description]
- LTB_INTO_SEND_STACK - [column description]
- LTB_DISCARDED - [column description]
- LTB_STATE - [column description]
- LTB_CARD_NUMBER - [column description]
EXSYS_LOYALTY_TMR_B_ITEMS
Položky účtov zasielaných do externých systémov Loyality TMR.
- LTBI_ACCOUNT_ID - [column description]
- > EXSYS_LOYALTY_TMR_BILL.LTB_ACCOUNT_ID
- LTBI_ACCOUNT_ITEM_ID - [column description]
- LTBI_CARD_NUMBER - [column description]
FM_BILL
História účtov zasielaných do fiskálnych modulov.
- BFM_ID_BILL - [column description]
- > K_DENNY_UCET.DUC_ID_UCET
- BFM_SEND_REJECTED_DATE - [column description]
- BFM_SENT_DATE - [column description]
- BFM_FM_BILL_ID - [column description]
- BFM_FM_CLOSING_ID - [column description]
- BFM_FM_SERIAL_NUMBER - [column description]
- BFM_DKP - [column description]
FM_CLOSING
História uzávierok zasielaných do fiskálnych modulov.
- FMC_ID - [column description]
- FMC_FM_CLOSING_ID - [column description]
- FMC_FM_SERIAL_NUMBER - [column description]
- FMC_DKP - [column description]
- FMC_SYSTEM_DATE_TIME - [column description]
- FMC_USER - [column description]
FM_INVOICE
História faktúr zasielaných do fiskálnych modulov.
- FIS_ID - [column description]
- FIS_NAME - [column description]
- FIS_SAVE_DATE - [column description]
- FIS_SUM - [column description]
- FIS_CURRENCY_CODE - [column description]
- FIS_USER_ID - [column description]
- > L_UZIVATEL.UZ_ID_UZIVATEL
- FIS_CASHDESK_ID - [column description]
- > G_KASA.CKA_CISLO_KASY
- FIS_PAYMENT_TYPE_ID - [column description]
- > G_SPOSOB_PLATBY.SPL_ID_SPOSOB_PLATBY
- FIS_MESSAGE - [column description]
- FIS_IS_SENT - [column description]
G_AKCIA
Hlavičky akcií cenových limitov a objednávok jedál.
- AKC_ID_AKCIA - [column description]
- AKC_DATUM_OD - [column description]
- AKC_DATUM_DO - [column description]
- AKC_NAZOV - [column description]
- AKC_POCET_OSOB - [column description]
- AKC_ID_ODBERATEL - [column description]
- > G_SUBJEKT.SUB_ID_SUBJEKT
- AKC_STAV - [column description]
- AKC_ID_ZAPISAL - [column description]
- > L_UZIVATEL.UZ_ID_UZIVATEL
- AKC_DATUM_CAS_VYTVORENIA - [column description]
- AKC_MARZA - [column description]
- AKC_TYP - [column description]
- AKC_CISLO_POKLADNA - [column description]
- > 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]
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_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
[table description]
- CHF_ID - [column description]
- CHF_NAME - [column description]
- CHF_FILE_TYPE - [column description]
- CHF_CHANGE_TYPE - [column description]
G_CHOD
[table description]
- CIC_ID - [column description]
- CIC_PORADIE - [column description]
- CIC_NAZOV - [column description]
- CIS_SYSTEMOVY - [column description]
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 jednotlivých užívateľov.
- DOU_ID_DOCHADZKA - [column description]
- DOU_ID_UZIVATEL - [column description]
- DOU_PRICHOD_ODCHOD - [column description]
- DOU_DATUM_CAS - [column description]
- DOU_CASOVA_ZNACKA - [column description]
- DOU_ID_PRVY_PRICHOD - [column description]
- DOU_DATUM_PRVY_PRICHOD - [column description]
- DOU_ID_PARENT - [column description]
- DOU_ID_OBJEKT - [column description]
- > G_DOCHADZKA_OBJEKT.DOO_ID_OBJEKT
- DOU_ZAZNAM_GENEROVANY - [column description]
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
Hlavička dokladu o pohyboch tovaru.
- 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
[table description]
- 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]
- EXS_GIN - [column description]
- > G_LOKALNE_GASTRO.LGA_ID
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_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
G_EXTERNE_SYSTEMY_FIDELIO
[table description]
- ESF_ID - [column description]
- > G_EXTERNE_SYSTEMY.EXS_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
G_EXTERNE_SYSTEMY_KAMERA
[table description]
- ESK_ID - [column description]
- > G_EXTERNE_SYSTEMY.EXS_ID
- ESK_URL - [column description]
- ESK_PLATNOST_LOG_ZAZNAMU - [column description]
G_EXTERNE_SYSTEMY_LOYALITY
[table description]
- ESL_ID - [column description]
- > G_EXTERNE_SYSTEMY.EXS_ID
- ESL_VOUCHERS_MAX - [column description]
- ESL_DISCOUNT_ID_CREDIT - [column description]
- > G_ZLAVA.ZLA_ID_ZLAVA
- ESL_DISCOUNT_ID_POINTS - [column description]
- > G_ZLAVA.ZLA_ID_ZLAVA
- ESL_DISCOUNT_ID_VOUCHER - [column description]
- > G_ZLAVA.ZLA_ID_ZLAVA
- ESL_BILL_SEND_TIME_FROM - [column description]
- ESL_BILL_SEND_TIME_TO - [column description]
- ESL_TIMEOUT - [column description]
- ESL_BILL_PRINT_GUEST_INFO - [column description]
- ESL_GET_FREE_PTV_TIME_FROM - [column description]
- ESL_GET_FREE_PTV_TIME_TO - [column description]
- ESL_GET_FREE_PTV_INTERVAL - [column description]
- ESL_PLU_PRICE_REF_CASHDESK - [column description]
- ESL_NAME_WITH_NOTE - [column description]
- ESL_LAST_LIST_SEND_SUCCESS - [column description]
- ESL_LAST_LIST_SEND_ERROR - [column description]
G_EXTERNE_SYSTEMY_ORDERS
[table description]
- ESO_ID - [column description]
- > G_EXTERNE_SYSTEMY.EXS_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_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_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
G_EXTERNE_SYSTEMY_WELLNESS_S
[table description]
- EWS_ID - [column description]
- > G_EXTERNE_SYSTEMY.EXS_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_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]
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 - [column description]
- CKA_TEXT_KASY - [column description]
- CKA_LOGO - [column description]
- CKA_ZOBRAZIT_KASU - [column description]
- CKA_ID_KASA_SETTINGS - [column description]
- CKA_ID_PRACOVNA_STANICA - [column description]
- > G_PRACOVNA_STANICA.PS_ID_STANICA
- CKA_DKP - [column description]
- CKA_TEXT_PRI_TLACI_OBJEDNAVKY - [column description]
- CKA_PATICKA_UCTENKY - [column description]
- CKA_TYP_FISK - [column description]
- CKA_ID_KASA_TYP - [column description]
- CKA_POVOLENY_PREDAJ_HOREC - [column description]
- CKA_CAS_ZACIATKU_NOVEHO_DNA - [column description]
- CKA_VYRADENA - [column description]
- CKA_ID_LOKAL_GASTRO - [column description]
- > 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]
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 BlueGastro\ServerBlueGastro\src\sk\datalock\blue_gastro\settings\blue_gastro\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 - [column description]
- UPR_NAZOV - [column description]
- UPR_NUMBER - [column description]
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]
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 - [column description]
- 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_HOREC
[table description]
- ZAH_ID_ZAKAZNIK_HOREC - [column description]
- ZAH_DATUM_PRICHODU - [column description]
- ZAH_DATUM_ODCHODU - [column description]
- ZAH_ID_HOTEL - [column description]
- ZAH_CISLO_HOSTA - [column description]
- ZAH_CISLO_IZBY - [column description]
- ZAH_UCET_BLOKOVANY - [column description]
- ZAH_HOST_NEFAJCIAR - [column description]
- ZAH_PARTIAL_CHECKOUT - [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_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]
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
Multilingválna tabuľka.
- 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]
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]
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]
K_DENNY_UCET
[table description]
- DUC_ID_UCET - [column description]
- DUC_CISLO_KASY - [column description]
- > G_KASA.CKA_CISLO_KASY
- DUC_VYHOTOVENY - [column description]
- DUC_VYHOTOVIL - [column description]
- > L_UZIVATEL.UZ_ID_UZIVATEL
- DUC_CISLO_UCTU - [column description]
- DUC_STORNO - [column description]
- DUC_SUMA - [column description]
- DUC_FISKALNY_TYP - [column description]
- DUC_ID_UZAVIERKA - [column description]
- > G_UZAVIERKA.UZA_ID_UZAVIERKY
- DUC_ID_ZAKAZNIK - [column description]
- DUC_NAZOV_DOKLADU - [column description]
- DUC_DATUM - [column description]
- DUC_ID_OTVORENY_UCET - [column description]
- > K_OTVORENY_UCET.OUC_ID_OTVORENY_UCET
- DUC_ID_STORNO_UCET - [column description]
- DUC_POCET_OBSLUZ_HOSTI - [column description]
- DUC_ZUCTOVANY - [column description]
- DUC_ID_ZUCTOVACI_UCET - [column description]
- > K_DENNY_UCET.DUC_ID_UCET
- DUC_ZMENA_PLATBY - [column description]
- DUC_CISLO_OBJ - [column description]
- DUC_WHU_ID_POVODNY_UCET - [column description]
- DUC_WHU_CISLO_DOKLADU - [column description]
- DUC_WHU_NEGATABLE - [column description]
- DUC_ID_KREDITNE_KONTO - [column description]
- DUC_MENA - [column description]
- DUC_DOVOD_STORNA - [column description]
- DUC_SUMA_ZAPLATENE - [column description]
- DUC_ID_PARENT_UCET - [column description]
- > K_DENNY_UCET.DUC_ID_UCET
- DUC_POZNAMKA - [column description]
- DUC_BILL_NO_DAILY_CLOSING - [column description]
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
[table description]
- DUA_ID_UCET - [column description]
- > K_DENNY_UCET.DUC_ID_UCET
- DUA_PORADIE - [column description]
- DUA_ID_SPOSOB_PLATBY - [column description]
- > G_SPOSOB_PLATBY.SPL_ID_SPOSOB_PLATBY
- DUA_MNOZSTVO - [column description]
- DUA_SUMA - [column description]
- DUA_CENA_LISTKA - [column description]
- DUA_CURRENCY_RATE - [column description]
- DUA_ID_PLAT_KARTA_TYP - [column description]
- DUA_SUMA_BDPH - [column description]
- DUA_NEPRIAMA_KOTACIA - [column description]
- DUA_CURRENCY_CODE - [column description]
- DUA_CURRENCY_UNIT - [column description]
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
[table description]
- DUP_ID_UCET - [column description]
- > K_DENNY_UCET.DUC_ID_UCET
- DUP_PORADIE - [column description]
- DUP_ID_PLU - [column description]
- > G_PLU.PLU_ID_PLU
- DUP_TEXT_PLU - [column description]
- DUP_MNOZSTVO - [column description]
- DUP_CENA - [column description]
- DUP_CENA_SUMA - [column description]
- DUP_SADZBA_DPH - [column description]
- DUP_ZLAVNENA_POLOZKA - [column description]
- DUP_CENOVA_HLADINA - [column description]
- DUP_ZLAVA - [column description]
- DUP_CENA_SUMA_ZLAVA - [column description]
- DUP_ID_BALIK_PLU - [column description]
- DUP_CKASY - [column description]
- > G_KASA.CKA_CISLO_KASY
- DUP_ID_UZIVATEL_NATAZIL - [column description]
- > L_UZIVATEL.UZ_ID_UZIVATEL
- DUP_ID_BALIK_PORADIE - [column description]
- DUP_SYSTEMOVA - [column description]
- DUP_EAN - [column description]
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
[table description]
- OUC_ID_OTVORENY_UCET - [column description]
- OUC_CISLO_KASY - [column description]
- OUC_CISLO_OTVORENEHO_UCTU - [column description]
- OUC_OTVORENY_V_CASE - [column description]
- OUC_OTVORIL_ID - [column description]
- OUC_SUMA - [column description]
- OUC_STAV - [column description]
- OUC_ID_STOL - [column description]
- OUC_CISLO - [column description]
- OUC_POZNAMKA - [column description]
- OUC_WELLNESS_LITE_CARD - [column description]
- > G_WELLNESS_LITE_CARD.WLC_ID
- OUC_EXT_SYS_ID - [column description]
- > G_EXTERNE_SYSTEMY.EXS_ID
- OUC_EXT_SYS_CARD_NUMBER - [column description]
- OUC_ID_ZAKAZNIK_VLASTNIK - [column description]
- > G_ZAKAZNIK.ZAK_ID_ZAKAZNIK
- OUC_LOCK - [column description]
K_OTVORENY_UCET_POL_CHOD
[table description]
- OUL_ID_OTVORENY_UCET - [column description]
- OUL_PORADIE - [column description]
- OUL_ID_CHOD - [column description]
- OUL_POZNAMKA - [column description]
- OUL_STAV - [column description]
K_OTVORENY_UCET_POLOZKA
[table description]
- OUP_ID_OTVORENY_UCET - [column description]
- > K_OTVORENY_UCET.OUC_ID_OTVORENY_UCET
- OUP_PORADIE - [column description]
- OUP_ID_PLU - [column description]
- OUP_MNOZSTVO - [column description]
- OUP_CENA - [column description]
- OUP_ZLAVNENA_POLOZKA - [column description]
- OUP_CENA_SUMA - [column description]
- OUP_STORNO - [column description]
- OUP_POZNAMKA_DO_KUCHYNE - [column description]
- OUP_CENOVA_HLADINA - [column description]
- OUP_ID_UZIVATEL_ZAPISAL - [column description]
- OUP_CKASY - [column description]
- OUP_ID_BALIK_PLU - [column description]
- OUP_ID_BALIK_PORADIE - [column description]
- OUP_SYSTEMOVA - [column description]
- OUP_CHOD_PORADIE - [column description]
- OUP_ID_UZIVATEL_STORNOVAL - [column description]
- OUP_NATAZENA - [column description]
- OUP_STORNOVANA - [column description]
- OUP_EAN - [column description]
- 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 - [column description]
- > K_OTVORENY_UCET.OUC_ID_OTVORENY_UCET
- OUP_EXT_SYS_TAP_DEV_SENT_ID - [column description]
- OUP_VAT_ID - [column description]
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]
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]
- FN_MENO - [column description]
- FN_ID_RODIC - [column description]
- FN_VZDY_POVOLENA - [column description]
- FN_PORADIE - [column description]
L_FUNKCIA_TEXT
Názvy funkcií.
- FT_ID_FUNKCIA - [column description]
- 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_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]
LOG_FIS_BILL_ATTEMPTS
[table description]
- FBA_ID - [column description]
- FBA_ID_BILL - [column description]
- FBA_TIME - [column description]
- FBA_ID_CASHDESK - [column description]
- > G_KASA.CKA_CISLO_KASY
- FBA_ID_WORKSTATION - [column description]
- > G_PRACOVNA_STANICA.PS_ID_STANICA
- FBA_ID_USER - [column description]
- > L_UZIVATEL.UZ_ID_UZIVATEL
- FBA_HOST - [column description]
- FBA_PORT - [column description]
- FBA_DEVICE_ID - [column description]
- FBA_STORE_BILL_COPY - [column description]
- FBA_DOCUMENT_PRINTED - [column description]
- FBA_ERROR_CODE - [column description]
- FBA_MESSAGE - [column description]
LOG_FIS_CLOSING_ATTEMPTS
[table description]
- FCA_ID - [column description]
- FCA_TIME - [column description]
- FCA_ID_CASHDESK - [column description]
- > G_KASA.CKA_CISLO_KASY
- FCA_ID_WORKSTATION - [column description]
- > G_PRACOVNA_STANICA.PS_ID_STANICA
- FCA_ID_USER - [column description]
- > L_UZIVATEL.UZ_ID_UZIVATEL
- FCA_HOST - [column description]
- FCA_PORT - [column description]
- FCA_DEVICE_ID - [column description]
- FCA_MESSAGE - [column description]
- FCA_SUCCESSFUL - [column description]
- FCA_CLOSING_FM_ID - [column description]
- > FM_CLOSING.FMC_ID
LOYALITY_CLOSED_ACCOUNT
[table description]
- CAL_CLOSED_ACCOUNT_ID - [column description]
- > K_DENNY_UCET.DUC_ID_UCET
- CAL_CUSTOMER_ID - [column description]
- > G_ZAKAZNIK.ZAK_ID_ZAKAZNIK
- CAL_EXT_SYS_ID - [column description]
- > G_EXTERNE_SYSTEMY_LOYALITY.ESL_ID
- CAL_CREDIT_POINTS_QUANTITY - [column description]
- CAL_CREDIT_POINTS_AMOUNT - [column description]
- CAL_CREDIT_AMOUNT - [column description]
- CAL_CREDIT_OVERDRAWN - [column description]
- CAL_CREDIT_P_THIS_TRANS - [column description]
- CAL_CREDIT_TOTAL - [column description]
- CAL_CREDIT_POINTS_TOTAL - [column description]
- CAL_MOTIVATIONAL_MESSAGE - [column description]
LOYALITY_CLOSED_ACCOUNT_V
[table description]
- ALV_CLOSED_ACCOUNT_ID - [column description]
- > LOYALITY_CLOSED_ACCOUNT.CAL_CLOSED_ACCOUNT_ID
- ALV_ORDER - [column description]
- ALV_CODE - [column description]
- ALV_NAME - [column description]
- ALV_AMOUNT - [column description]
- ALV_NOTE - [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]
- UF_ID_MODUL - [column description]
- UF_ID_UZIVATEL - [column description]
L_UZIVATEL_MODUL
[table description]
- UM_ID_UZIVATEL_PREDOK - [column description]
- UM_ID_MODUL - [column description]
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]
- UR_ID_MODUL - [column description]
- UR_ID_UZIVATEL - [column description]
- UR_TYP_POKLADNE_BIN - [column description]
L_VZORY_VIDITELNOSTI
[table description]
- VV_ID_VZOR - [column description]
- VV_NAZOV - [column description]
PAYMENT_GROUP_LIMITS
[table description]
- PGL_ID - [column description]
- PGL_NAME - [column description]
- PGL_PAYMENT_LIMIT - [column description]
PRINT_CHANNEL
[table description]
- PCH_ID - [column description]
- PCH_NAME - [column description]
- PCH_DESCR - [column description]
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
[table description]
- POW_WS_ID - [column description]
- > G_PRACOVNA_STANICA.PS_ID_STANICA
- POW_PCH_ID - [column description]
- > PRINT_CHANNEL.PCH_ID
- POW_VPP_ID - [column description]
- > VPP_DEVICE.VPP_ID
- POW_PRINTER_ID - [column description]
- > PRINTER.PRI_ID
- POW_CODEPAGE - [column description]
- POW_OPEN_CASHDRAWER - [column description]
- POW_BILL_TEMPLATE - [column description]
PRINTER
[table description]
- PRI_ID - [column description]
- PRI_TYP - [column description]
- PRI_DESCR - [column description]
PRINT_SEQUENCES
[table description]
- PRS_TAG_ID - [column description]
- > PRINT_TAG.PRT_ID
- PRS_PRINTER_ID - [column description]
- > PRINTER.PRI_ID
- PRS_START_SEQ - [column description]
- PRS_STOP_SEQ - [column description]
PRINT_TAG
[table description]
- PRT_ID - [column description]
- PRT_NAME - [column description]
- PRT_SYSTEM_TAG - [column description]
- PRT_DESCR - [column description]
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
[table description]
- 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
[table description]
- 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]
VERSION
[table description]
- DATA_VERSION - [column description]
VPP_DEVICE
[table description]
- VPP_ID - [column description]
- VPP_NAME - [column description]
- VPP_IP_HOST_NAME - [column description]
- VPP_PORT - [column description]
- VPP_DEVICE_ID - [column description]
- VPP_TIMEOUT - [column description]
- VPP_CONVERSION - [column description]
- VPP_DEVICE_NAME - [column description]
- VPP_COMM_PORT - [column description]
- VPP_SN - [column description]
Z_STAT_ZOSTAVA
[table description]
- 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
[table description]
- 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]