Devel - Horec - DB tables

Z Hotelové systémy - Wiki
Verzia z 23:14, 12. marec 2013, ktorú vytvoril DeletedMJ (diskusia | príspevky)
Skočit na navigaci Skočit na vyhledávání

<viewsecurity service />

Obsah

B_JAZYK

[table description]

  • JAZ_KOD_JAZYKA - [column description]
  • JAZ_PORADIE - [column description]

B_JAZYK_LANG

[table description]

  • LJAZ_ID - [column description]
> B_JAZYK.JAZ_KOD_JAZYKA
  • LJAZ_NAZOV - [column description]
  • LJAZ_LANG - [column description]
> B_JAZYK.JAZ_KOD_JAZYKA

B_OBJEKT

[table description]

  • OBJ_TABULKA - [column description]
  • OBJ_NAZOV - [column description]

B_OBJEKT_LANG

[table description]

  • LOBJ_ID - [column description]
> B_OBJEKT.OBJ_TABULKA
  • LOBJ_NAZOV - [column description]
  • LOBJ_LANG - [column description]
> B_JAZYK.JAZ_KOD_JAZYKA

B_POVINNE_PARAMETRE

[table description]

  • PP_TABULKA - [column description]
> B_OBJEKT.OBJ_TABULKA
  • PP_STLPEC - [column description]
  • PP_MINIMALNA_DLZKA - [column description]
  • PP_TEXT_ID - [column description]
> H_CP_TEXTS.TXTS_ID
  • PP_SYSTEM - [column description]
  • PP_TYPE - [column description]
  • PP_ORDER - [column description]

B_REPORT

[table description]

  • RPT_ID_REPORT - [column description]
  • RPT_ID_REPORT_CUSTOM - [column description]
> B_REPORT_CUSTOM.RPTC_ID_REPORT_CUSTOM
  • RPT_REPORT_NAME - [column description]
  • RPT_FILE_NAME - [column description]

B_REPORT_CUSTOM

[table description]

  • RPTC_ID_REPORT_CUSTOM - [column description]
  • RPTC_STYLE_NAME - [column description]
  • RPTC_LEFT_REPORT - [column description]
  • RPTC_TOP_REPORT - [column description]
  • RPTC_USE_PICT1 - [column description]
  • RPTC_LEFT_PICT1 - [column description]
  • RPTC_TOP_PICT1 - [column description]
  • RPTC_WIDTH_PICT1 - [column description]
  • RPTC_HEIGHT_PICT1 - [column description]
  • RPTC_ALFA_PICT1 - [column description]
  • RPTC_USE_PICT2 - [column description]
  • RPTC_LEFT_PICT2 - [column description]
  • RPTC_TOP_PICT2 - [column description]
  • RPTC_WIDTH_PICT2 - [column description]
  • RPTC_HEIGHT_PICT2 - [column description]
  • RPTC_ALFA_PICT2 - [column description]
  • RPTC_USE_STYLE - [column description]

B_REPORT_CUSTOM_LANG

[table description]

  • LRPTC_ID - [column description]
> B_REPORT_CUSTOM.RPTC_ID_REPORT_CUSTOM
  • LRPTC_STYLE_NAME - [column description]
  • LRPTC_LANG - [column description]
> B_JAZYK.JAZ_KOD_JAZYKA

B_REPORT_LANG

[table description]

  • LRPT_ID - [column description]
> B_REPORT.RPT_ID_REPORT
  • LRPT_REPORT_NAME - [column description]
  • LRPT_LANG - [column description]
> B_JAZYK.JAZ_KOD_JAZYKA

B_REPORT_SETTINGS

[table description]

  • RPTS_ID_REPORT_SETTINGS - [column description]
  • RPTS_PICTURE1 - [column description]
  • RPTS_PICTURE2 - [column description]

B_RTF_REPORT_DATA_TYP

[table description]

  • RDT_ID - [column description]
  • RDT_NAZOV - [column description]
  • RDT_POCET_DES_MIEST - [column description]

B_RTF_REPORT_DEFAULT_SABLONY

[table description]

  • RDS_ID - [column description]
  • RDS_SABLONA_ID - [column description]
> B_RTF_REPORT_SABLONY.RS_SABLONA_ID
  • RDS_CISPS - [column description]
> HC_PS.PS_CISPS

B_RTF_REPORT_SABLONY

[table description]

  • RS_SABLONA_ID - [column description]
  • RS_TYP_ID - [column description]
> B_RTF_REPORT_TYP.RT_TYP_ID
  • RS_ID_UZIVATEL - [column description]
  • RS_DATUM - [column description]
  • RS_SABLONA - [column description]
  • RS_JAZYK_ID - [column description]
> H_CP_LANGUAGE.CPL_ID_LANGUAGE
  • RS_ALT_JAZYK_ID - [column description]
> H_CP_LANGUAGE.CPL_ID_LANGUAGE
  • RS_SABLONA_NAZOV - [column description]
  • RS_POVOLENE_MAZANIE - [column description]

B_RTF_REPORT_SKUP_ZNACIEK

[table description]

  • RSZ_SKUPINA_ID - [column description]
  • RSZ_NAZOV - [column description]

B_RTF_REPORT_SKUP_ZNACIEK_LANG

[table description]

  • LRSZ_ID - [column description]
> B_RTF_REPORT_SKUP_ZNACIEK.RSZ_SKUPINA_ID
  • LRSZ_LANG - [column description]
> B_JAZYK.JAZ_KOD_JAZYKA
  • LRSZ_NAZOV - [column description]

B_RTF_REPORT_TYP

[table description]

  • RT_TYP_ID - [column description]
  • RT_NAZOV - [column description]
  • RT_ULOZIT_PRI_TLACI_EXPORTE - [column description]

B_RTF_REPORT_TYP_LANG

[table description]

  • LRT_ID - [column description]
> B_RTF_REPORT_TYP.RT_TYP_ID
  • LRT_LANG - [column description]
> B_JAZYK.JAZ_KOD_JAZYKA
  • LRT_NAZOV - [column description]

B_RTF_REPORT_TYP_ZNACKY

[table description]

  • RTZ_TYP_ZNACKY_ID - [column description]
  • RTZ_NAZOV - [column description]

B_RTF_REPORT_ZNACKY

[table description]

  • RZ_ZNACKA_ID - [column description]
  • RZ_TYP_ID - [column description]
> B_RTF_REPORT_TYP.RT_TYP_ID
  • RZ_SKUPINA_ID - [column description]
> B_RTF_REPORT_SKUP_ZNACIEK.RSZ_SKUPINA_ID
  • RZ_TYP_ZNACKY_ID - [column description]
> B_RTF_REPORT_TYP_ZNACKY.RTZ_TYP_ZNACKY_ID
  • RZ_DATA_TYP - [column description]
> B_RTF_REPORT_DATA_TYP.RDT_ID
  • RZ_ZNACKA - [column description]
  • RZ_RIADIACE_ZNAKY - [column description]
  • RZ_NAZOV - [column description]

B_RTF_REPORT_ZNACKY_LANG

[table description]

  • LRZ_ID - [column description]
> B_RTF_REPORT_ZNACKY.RZ_ZNACKA_ID
  • LRZ_LANG - [column description]
> B_JAZYK.JAZ_KOD_JAZYKA
  • LRZ_NAZOV - [column description]

DB_ACTUAL_SESSIONS

[table description]

  • 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_ARCHIVE_STORAGE

[table description]

  • DBAS_ID - [column description]
  • DBAS_DIRECTORY - [column description]
  • DBAS_ARCHIVE_ID - [column description]
  • DBAS_COMPRESSION - [column description]
  • DBAS_IS_BACKUP - [column description]

DB_CLOB

[table description]

  • DC_ID - [column description]
  • DC_TEXT - [column description]

DB_SEQUENCE

[table description]

  • SEQ_ID - [column description]
  • SEQ_NAME - [column description]
  • SEQ_TABLE_NAME - [column description]
  • SEQ_COLUMN_NAME - [column description]
  • SEQ_PK - [column description]

DWH_REVENUE_ORDERED

[table description]

  • DWHRO_ID - [column description]
  • DWHRO_BATCH_ID - [column description]
  • DWHRO_CREATED_DATE - [column description]
  • DWHRO_ACCOMMODATED_GUEST_ID - [column description]
> HK_DO.DO_CISHO
  • DWHRO_AMOUNT - [column description]
  • DWHRO_BOOKING_GUEST_ID - [column description]
> HK_OBJEDNAVKA_HOST.OBH_CIS_HOST_OBJ
  • DWHRO_EXTERNAL_GUEST_ROOM_ID - [column description]
  • DWHRO_FROM_PRICE_PROFILE - [column description]
  • DWHRO_HOTEL_DATE - [column description]
  • DWHRO_HOTEL_DATE_EXPORT - [column description]
  • DWHRO_HOTEL_DATE_LAST_CHANGE - [column description]
  • DWHRO_ITEM_LAST_CHANGE - [column description]
  • DWHRO_PRICE_PER_UNIT_VAT - [column description]
  • DWHRO_PRICE_WITH_VAT - [column description]
  • DWHRO_SERVICE_ID - [column description]
> H_CP_TOVAR.CTO_ID_TOVAR
  • DWHRO_SERVICE_PACKAGE_ID - [column description]
> H_CP_BALIKY_SLUZIEB.CBS_ID_TOVAR
  • DWHRO_VAT_RATE_PERCENT - [column description]

EXTERNE_ODKAZY

[table description]

  • EOD_ID - [column description]
  • EOD_URL - [column description]
  • EOD_WEB_REPORTS_URL - [column description]
  • EOD_USERNAME - [column description]
  • EOD_PASSWORD - [column description]
  • EOD_INTERNY_PREHLIADAC - [column description]
  • EOD_TEXT_ID - [column description]

EXTERNE_ODKAZY_OPRAVNENIA

[table description]

  • EOO_EXTERNE_ODKAZY_ID - [column description]
> EXTERNE_ODKAZY.EOD_ID
  • EOO_POUZIVATELSKY_VZOR_ID - [column description]
> L_UZIVATEL_PREDOK.UP_ID_UZIVATEL_PREDOK

FLXR_GUEST

Hlavička Flexi Rate ceny pre hosťa pobytu alebo objednávku.

  • FLXRG_ID - ID, na ktorý sa odkazuje HK_DO resp. HK_OBJEDNAVKA_HOST.
  • FLXRG_ORIGIN_FR_GUEST_ID - ID prvého záznamu dávky. Pokiaľ sa nejaká cena menila, zapíše sa vždy nový záznam. Cez tento stĺpec je tak možné dohľadať históriu záznamov.
  • FLXRG_CREATED_DATE_TIME - Dátum a čas uloženia záznamu.
  • FLXRG_USER_ID - ID používateľa, ktorý danú cenu uložil.
> L_UZIVATEL.UZ_ID_UZIVATEL

FLXR_GUEST_DATE

Cena Flexi Rate za izbu pre konkrétny pobytový deň.

  • FLXRGD_ID - ID záznamu.
  • FLXRGD_FR_GUEST_ID - ID nadradeného záznamu - ceny FlexiRate FLXR_GUEST.
> FLXR_GUEST.FLXRG_ID
  • FLXRGD_HOTEL_DATE - Pobytový deň, pre ktorý sa cena uplatní.
  • FLXRGD_ROOM_PRICE - Cena za celú izbu pre daný pobytový deň - len pevné lôžka. Príplatky za prístelky sú v HK_FLEXI_RATE_GUEST_BED.

FLXR_GUEST_DATE_BED

Cena Flexi Rate pre jednotlivé typy lôžok.

  • FLXRGDB_FR_GUEST_DATE_ID - ID nadradeného záznamu - ceny FlexiRate pre konkrétny pobytový deň - FLXR_GUEST_DATE.
> FLXR_GUEST_DATE.FLXRGD_ID
  • FLXRGDB_BED_TYPE_ID - ID typu lôžka.
> HC_BED_TYPE.HBT_ID
  • FLXRGDB_BED_PRICE - Cena za dané lôžko pre daný pobytový deň (v hlavičke).

FLXR_PRICE_TEMPLATE

Predlohy cien pre typy izieb a typy lôžok.

  • FLXRPT_BED_TYPE_ID - ID typu lôžka > HC_BED_TYPE.HBT_ID
> HC_BED_TYPE.HBT_ID
  • FLXRPT_ROOM_TYPE_ID - ID typu izby > HC_CE.CE_CISTY
> HC_CE.CE_CISTY
  • FLXRPT_PRICE - cena(predloha) za typ izby a typ lôžka

HC_AUTH_LEVEL_BOOKING

[table description]

  • ALB_ID - [column description]
  • ALB_NAME - [column description]
  • ALB_LEVEL - [column description]
  • ALB_ENABLED - [column description]
  • ALB_DELETED - [column description]

HC_BED_TYPE

[table description]

  • HBT_ID - [column description]
  • HBT_CODE - [column description]
  • HBT_ID_TEXT - [column description]
> H_CP_TEXTS.TXTS_ID
  • HBT_SYSTEM_BED_TYPE - [column description]
  • HBT_COUNT - [column description]
  • HBT_ORDER_ID - [column description]
  • HBT_ALLOWED_USER_CHANGE - [column description]
  • HBT_IMMEDIATELY_CHECKINABLE - [column description]
  • HBT_CONTROLLED_COUNT - [column description]
  • HBT_INCL_IN_STAT_OCCUPIED - [column description]
  • HBT_INCL_IN_STAT_ALL - [column description]

HC_BM

[table description]

  • BM_DATNA - [column description]
  • BM_DATOD - [column description]
  • BM_ATRIB - [column description]
  • BM_ROOM_ID - [column description]
> HC_IZ.IZ_ID_IZBA
  • BM_JOINED_ROOM_ID - [column description]
> HC_JOINED_ROOM.JR_ID
  • BM_ID - [column description]

HC_CE

[table description]

  • CE_CISTY - [column description]
  • CE_TYPIZ - [column description]
  • CE_POCPO - [column description]
  • CE_POCPR - [column description]
  • CE_PDUTE - [column description]
  • CE_PDPRA - [column description]
  • CE_POCET - [column description]
  • CE_ID_TOVAR - [column description]
> H_CP_TOVAR.CTO_ID_TOVAR
  • CE_SOLO_TYPE - [column description]

HC_CESTOVNY_DOKLAD

[table description]

  • CD_KOD - [column description]
  • CD_PORADIE - [column description]
  • CD_ID - [column description]
  • CD_TEXT_ID - [column description]
> H_CP_TEXTS.TXTS_ID

HC_CLIENT_FONT

[table description]

  • CF_ID - [column description]
  • CF_FILE_NAME - [column description]
  • CF_FAMILY_NAME - [column description]

HC_CLIENT_UPDATING_FILE

[table description]

  • CUF_ID - [column description]
  • CUF_PATH_CLIENT - [column description]
  • CUF_PATH_SERVER - [column description]
  • CUF_LOAD_ONLY_ONCE - [column description]
  • CUF_IS_DIRECTORY - [column description]

HC_CODE_READER

[table description]

  • COR_ID - [column description]
  • COR_CISPS - [column description]
> HC_PS.PS_CISPS
  • COR_HOST - [column description]
  • COR_REMOTE_PORT - [column description]
  • COR_LOCAL_PORT - [column description]
  • COR_TIMEOUT - [column description]
  • COR_INFORMATION_TYPE - [column description]

HC_COMPANY

[table description]

  • HCC_ID - [column description]
  • HCC_ICO - [column description]
  • HCC_NAME - [column description]
  • HCC_IC_DPH - [column description]
  • HCC_DIC - [column description]
  • HCC_STREET - [column description]
  • HCC_CITY - [column description]
  • HCC_ZIP - [column description]
  • HCC_STATE - [column description]
  • HCC_BANK - [column description]
  • HCC_IBAN - [column description]
  • HCC_BANK_ACCOUNT_NR - [column description]
  • HCC_BANK_CODE - [column description]
  • HCC_TEL - [column description]
  • HCC_EMAIL - [column description]
  • HCC_VAT_PAYER - [column description]
  • HCC_NOTE_BILL - [column description]
  • HCC_NOTE - [column description]
  • HCC_ENABLED - [column description]
  • HCC_RELATION_ID - [column description]
> HC_MARKETING_RELATION.HMR_ID

HC_COMPANY_CATEGORY

[table description]

  • CCT_COMPANY_ID - [column description]
> HC_COMPANY.HCC_ID
  • CCT_CATEGORY_ID - [column description]
> HC_MARKETING_CATEGORY.HMC_ID

HC_COMPANY_PARAMETER

[table description]

  • CCP_COMPANY_ID - [column description]
> HC_COMPANY.HCC_ID
  • CCP_PARAMETER_ID - [column description]
> HC_MARKETING_PARAMETER.HMP_ID

HC_COUNTER

[table description]

  • CO_NAME - [column description]
  • CO_TABLE_NAME - [column description]
  • CO_COLUMN_NAME - [column description]
  • CO_VALUE - [column description]
  • CO_MIN_VALUE - [column description]
  • CO_MAX_VALUE - [column description]

HC_DISCOUNT_PROFILE

[table description]

  • HDP_ID - [column description]
  • HDP_CODE - [column description]
  • HDP_NAME - [column description]
  • HDP_SERVICE_CATEGORY_TYPE_ID - [column description]
> H_CP_KATEGORIA_TOVARU_TYP.CKK_ID_KATEGORIA_TOVARU_TYP
  • HDP_ENABLED - [column description]

HC_DISCOUNT_PROFILE_CATEGORIES

[table description]

  • HDPC_ID - [column description]
  • HDPC_DISCOUNT_PROFILE_ID - [column description]
> HC_DISCOUNT_PROFILE.HDP_ID
  • HDPC_SERVICE_CATEGORY_ID - [column description]
> H_CP_KATEGORIA_TOVARU.CKT_ID_KATEGORIA_TOVARU
  • HDPC_VALUE - [column description]

HC_DOCUMENT_NUMBERING_RULES

[table description]

  • CDNR_ID - [column description]
  • CDNR_REPEAT_INTERVAL - [column description]
  • CDNR_STARTING_NUMBER - [column description]
  • CDNR_PREFIXSUFFIX - [column description]
  • CDNR_IS_PREFIX - [column description]

HC_DOCUMENT_TYPE

[table description]

  • DCT_ID - [column description]
  • DCT_ID_TEXT - [column description]
> H_CP_TEXTS.TXTS_ID
  • DCT_CODE - [column description]
  • DCT_CODE_ON_DOCUMENT - [column description]
  • DCT_SYSTEM - [column description]

HC_ECONOMICS_VERSION

[table description]

  • HEV_ID - [column description]
  • HEV_ID_VERSION - [column description]
  • HEV_ACTUAL - [column description]

HC_EXTERNAL_NUMBER_TYPE

[table description]

  • ENT_ID - [column description]
  • ENT_NAME - [column description]
  • ENT_DESCRIPTION - [column description]
  • ENT_ENABLED - [column description]

HC_EXT_SYS_IO_FILE

[table description]

  • ESIOF_ID - [column description]
  • ESIOF_DIRECTORY - [column description]
  • ESIOF_FILE_NAME - [column description]
  • ESIOF_TIME_OUT - [column description]
  • ESIOF_REPEAT_COUNT - [column description]
  • ESIOF_RETURN_SYS_REC - [column description]
  • ESIOF_TERMINATING_CHARS - [column description]
  • ESIOF_LOG - [column description]
  • ESIOF_ASYNCHRONOUS - [column description]
  • ESIOF_DELETE - [column description]
  • ESIOF_IS_OUT - [column description]

HC_EXT_SYS_KASA

[table description]

  • ESK_ID - [column description]
  • ESK_NAZOV_EXT - [column description]
  • ESK_ID_EXT - [column description]
  • ESK_ID_EXT_SYS - [column description]
> H_CP_EXT_SYSTEM.CES_ID_EXT_SYSTEM
  • ESK_NAZOV_INT_ID_TEXT - [column description]
> H_CP_TEXTS.TXTS_ID

HC_EXT_SYS_KASA_KATEGORIA

[table description]

  • EKK_ID_EXT_SYS_KASA - [column description]
> HC_EXT_SYS_KASA.ESK_ID
  • EKK_ID_KATEGORIA_SLUZBY - [column description]
> H_CP_KATEGORIA_TOVARU.CKT_ID_KATEGORIA_TOVARU

HC_GRAF_OBJEKT

[table description]

  • GRO_X1 - [column description]
  • GRO_Y1 - [column description]
  • GRO_X2 - [column description]
  • GRO_Y2 - [column description]
  • GRO_UHOL - [column description]
  • GRO_POLYGON - [column description]
  • GRO_KOD_POSCH - [column description]
  • GRO_ID_IZBA - [column description]
> HC_IZ.IZ_ID_IZBA

HC_GUEST_AGE_INTERVAL

[table description]

  • GAI_ID - [column description]
  • GAI_CODE - [column description]
  • GAI_ID_TEXT - [column description]
> H_CP_TEXTS.TXTS_ID
  • GAI_ORDER - [column description]
  • GAI_ENABLED - [column description]
  • GAI_DELETED - [column description]
  • GAI_AGE_FROM - [column description]
  • GAI_AGE_TO - [column description]

HC_GUEST_PROFILE

[table description]

  • HGP_ID - [column description]
  • HGP_CODE - [column description]
  • HGP_NAME - [column description]
  • HGP_DISCOUNT_PROFILE_ID - [column description]
> HC_DISCOUNT_PROFILE.HDP_ID
  • HGP_ENABLED - [column description]

HC_GUEST_PROFILE_P_PROFILES

[table description]

  • HGPC_ID - [column description]
  • HGPC_GUEST_PROFILE_ID - [column description]
> HC_GUEST_PROFILE.HGP_ID
  • HGPC_PRICE_PROFILE_ID - [column description]
> H_CP_CENOVY_PROFIL.CEP_ID_PROFIL

HC_GUEST_TITLE

[table description]

  • HGT_ID - [column description]
  • HGT_CODE - [column description]
  • HGT_TEXT_ID - [column description]
> H_CP_TEXTS.TXTS_ID
  • HGT_ORDER_ID - [column description]
  • HGT_ENABLED - [column description]

HC_HOREC_LANGUAGE

[table description]

  • HLNG_ID_LANGUAGE - [column description]
  • HLNG_HOREC_CODE - [column description]
  • HLNG_SYSTEM - [column description]
  • HLNG_ID_TEXT - [column description]
> H_CP_TEXTS.TXTS_ID

HC_IZ

[table description]

  • IZ_CISIZ - [column description]
  • IZ_NAZOV - [column description]
  • IZ_TELEF - [column description]
  • IZ_POSCH - [column description]
  • IZ_POCPO - [column description]
  • IZ_POCPR - [column description]
  • IZ_ERPOZ - [column description]
  • IZ_ERAKT - [column description]
  • IZ_ERDEF - [column description]
  • IZ_EHPOZ - [column description]
  • IZ_EHAKT - [column description]
  • IZ_ERDOC - [column description]
  • IZ_EHDOC - [column description]
  • IZ_CASNA - [column description]
  • IZ_CASTR - [column description]
  • IZ_ESAKT - [column description]
  • IZ_DATAK - [column description]
  • IZ_STAKT - [column description]
  • IZ_POOPO - [column description]
  • IZ_POOPR - [column description]
  • IZ_STPLA - [column description]
  • IZ_STDEF - [column description]
  • IZ_STRAP - [column description]
  • IZ_VYTAZ - [column description]
  • IZ_RAJON - [column description]
  • IZ_BITMA - [column description]
  • IZ_IZBA_MIMO_PREVADZKY - [column description]
  • IZ_POZNAMKA - [column description]
  • IZ_ID_IZBA - [column description]
  • IZ_CISTY - [column description]
> HC_CE.CE_CISTY
  • IZ_STAV_PTV - [column description]
  • IZ_ID_UBYTOVACI_BLOK - [column description]
> HC_UBYTOVACI_BLOK.HUB_ID
  • IZ_PERM_BLOCKED_TELEPHONES - [column description]
  • IZ_BLOCKED_TELEPHONES - [column description]
  • IZ_TEXT_STATUS - [column description]
  • IZ_ORDER_ID - [column description]

HC_IZ_HISTORIA

[table description]

  • IZH_ID - [column description]
  • IZH_ID_IZBA - [column description]
> HC_IZ.IZ_ID_IZBA
  • IZH_CISIZ - [column description]
  • IZH_CISTY - [column description]
  • IZH_TYPIZ - [column description]
  • IZH_NAZOV - [column description]
  • IZH_DATUM_PLATNOSTI_OD - [column description]
  • IZH_DATUM_PLATNOSTI_DO - [column description]
  • IZH_POBYTOVY_DEN - [column description]
  • IZH_TELEF - [column description]
  • IZH_POSCH - [column description]
  • IZH_POCPO - [column description]
  • IZH_POCPR - [column description]
  • IZH_ERPOZ - [column description]
  • IZH_ERAKT - [column description]
  • IZH_ERDEF - [column description]
  • IZH_EHPOZ - [column description]
  • IZH_EHAKT - [column description]
  • IZH_ERDOC - [column description]
  • IZH_EHDOC - [column description]
  • IZH_CASNA - [column description]
  • IZH_CASTR - [column description]
  • IZH_ESAKT - [column description]
  • IZH_STPLA - [column description]
  • IZH_STDEF - [column description]
  • IZH_STRAP - [column description]
  • IZH_RAJON - [column description]
  • IZH_IZBA_MIMO_PREVADZKY - [column description]
  • IZH_POZNAMKA - [column description]
  • IZH_ID_UBYTOVACI_BLOK - [column description]
  • IZH_PERM_BLOCKED_TELEPHONES - [column description]
  • IZH_TEXT_STATUS - [column description]

HC_JOINED_ROOM

[table description]

  • JR_ID - [column description]
  • JR_JOINED_ROOM_TYPE_ID - [column description]
> HC_JOINED_ROOM_TYPE.JRT_ID
  • JR_NAME - [column description]
  • JR_ROOM_NUMBER - [column description]
  • JR_ORDER_ID - [column description]
  • JR_NOTE - [column description]
  • JR_ENABLED - [column description]
  • JR_AVERAGE_OCCUPANCY - [column description]

HC_JOINED_ROOM_ROOMS

[table description]

  • JRR_ID - [column description]
  • JRR_JOINED_ROOM_ID - [column description]
> HC_JOINED_ROOM.JR_ID
  • JRR_ROOM_ID - [column description]
> HC_IZ.IZ_ID_IZBA
  • JRR_ORDER_ID - [column description]

HC_JOINED_ROOM_TYPE

[table description]

  • JRT_ID - [column description]
  • JRT_CODE - [column description]
  • JRT_SERVICE_ID - [column description]
> H_CP_TOVAR.CTO_ID_TOVAR

HC_JOINED_ROOM_TYPE_BED_TYPES

[table description]

  • JRTBT_ID - [column description]
  • JRTBT_JOINED_ROOM_TYPE_ID - [column description]
> HC_JOINED_ROOM_TYPE.JRT_ID
  • JRTBT_BED_TYPE_ID - [column description]
> HC_BED_TYPE.HBT_ID
  • JRTBT_ORDER - [column description]

HC_JOINED_ROOM_TYPE_R_TYPES

[table description]

  • JRTRT_ID - [column description]
  • JRTRT_JOINED_ROOM_TYPE_ID - [column description]
> HC_JOINED_ROOM_TYPE.JRT_ID
  • JRTRT_ROOM_TYPE_ID - [column description]
> HC_CE.CE_CISTY
  • JRTRT_COUNT - [column description]

HC_KA

[table description]

  • KA_DATUM - [column description]

HC_KA_JOINED_ROOM_TYPE

[table description]

  • KJRT_DATE - [column description]
  • KJRT_JOINED_ROOM_TYPE_ID - [column description]
> HC_JOINED_ROOM_TYPE.JRT_ID
  • KJRT_JROOM_COUNT_TOTAL - [column description]
  • KJRT_JROOM_COUNT_ENABLED_R - [column description]
  • KJRT_JROOM_COUNT_OCCUPIED - [column description]
  • KJRT_JROOM_COUNT_OCCUP_NOROOM - [column description]

HC_KA_STATISTICS

[table description]

  • KAS_DATUM - [column description]
  • KAS_CENHL - [column description]
  • KAS_VYTHO - [column description]
  • KAS_SUMTR - [column description]
  • KAS_POCDO - [column description]
  • KAS_POCCU - [column description]
  • KAS_POCUJ - [column description]
  • KAS_POCUS - [column description]
  • KAS_POCSK - [column description]
  • KAS_POCEX - [column description]
  • KAS_PRIDO - [column description]
  • KAS_PRICU - [column description]
  • KAS_ODIDO - [column description]
  • KAS_ODICU - [column description]
  • KAS_PPODO - [column description]
  • KAS_PPOCU - [column description]
  • KAS_ZRUHO - [column description]
  • KAS_POCIZ - [column description]
  • KAS_POCPO - [column description]
  • KAS_POCPR - [column description]
  • KAS_OBSIZ - [column description]
  • KAS_OBSPO - [column description]
  • KAS_OBSPR - [column description]
  • KAS_POC_IZIEB_V_PREVADZKE - [column description]
  • KAS_POC_POSTELI_V_PREVADZKE - [column description]
  • KAS_POC_PRISTELOK_V_PREVADZKE - [column description]

HC_KA_TYP_IZBY

[table description]

  • KATI_DATUM - [column description]
  • KATI_CISTY - [column description]
  • KATI_POCET_IZIEB_CELKOM - [column description]
  • KATI_POCET_IZIEB_V_PREVADZKE - [column description]
  • KATI_OBSADENE_BITMAPA - [column description]
  • KATI_OBSADENE_NA_TYP_IZBY - [column description]

HC_KH

[table description]

  • KH_KOD - [column description]
  • KH_NAZOV - [column description]
  • KH_ID_CENOVY_PROFIL - [column description]
> H_CP_CENOVY_PROFIL.CEP_ID_PROFIL
  • KH_KOD_MENY - [column description]
> K_KL_MENA.KLM_KOD_MENY
  • KH_ID_KATEGORIA - [column description]

HC_KK_OBJEKT

[table description]

  • KKO_ID - [column description]
  • KKO_ID_TYP_SYSTEMU - [column description]
  • KKO_CISLO - [column description]
  • KKO_KOD - [column description]
  • KKO_NAZOV - [column description]

HC_KK_PS_OBJEKT_PREDNASTAVENY

[table description]

  • KPO_CISPS - [column description]
  • KPO_ID_KK_OBJEKT - [column description]

HC_KK_PS_SETTINGS

[table description]

  • KPS_CISPS - [column description]
  • KPS_CAKANIE_NA_KARTU - [column description]
  • KPS_CISLO_ENKODERA - [column description]
  • KPS_PONUKAT_ZAPIS_PRI_PRICHODE - [column description]
  • KPS_POVOLENE_KARTY - [column description]
  • KPS_CAS_PO_ZAPISE_KARTY - [column description]
  • KPS_CIS_IDENT - [column description]

HC_KK_PS_SETTINGS_SYSTEM

[table description]

  • KPP_CISPS - [column description]
  • KPP_ID_TYP_SYSTEMU - [column description]
  • KPP_BEZKONTAKTNE_KARTY - [column description]
  • KPP_COM_PORT - [column description]

HC_KK_SETTINGS

[table description]

  • KSE_ID - [column description]
  • KSE_CAS_EXPIRACIE - [column description]
  • KSE_ID_TYP_SYSTEMU - [column description]
  • KSE_ALLOW_ASSOC_ROOMS - [column description]

HC_KK_SETTINGS_SYSTEM

[table description]

  • KSS_ID - [column description]
  • KSS_PORT - [column description]
  • KSS_IPADRESA - [column description]
  • KSS_ID_TYP_SYSTEMU - [column description]
  • KSS_REG_MENO - [column description]
  • KSS_REG_HESLO - [column description]
  • KSS_KARTA_TYP - [column description]
  • KSS_JEDN_KARTA_TYP - [column description]
  • KSS_USER_GROUP - [column description]
  • KSS_CUSTOMER_NUM - [column description]

HC_KK_TYP_SYSTEMU

[table description]

  • KTS_ID - [column description]
  • KTS_NAZOV - [column description]

HC_MARKETING_CATEGORY

[table description]

  • HMC_ID - [column description]
  • HMC_CODE - [column description]
  • HMC_TEXT_ID - [column description]
> H_CP_TEXTS.TXTS_ID
  • HMC_CATEGORY_TYPE_ID - [column description]
> HC_MARKETING_CATEGORY_TYPE.MCT_ID
  • HMC_ORDER_ID - [column description]
  • HMC_ENABLED - [column description]
  • HMC_STAY - [column description]
  • HMC_GUEST - [column description]
  • HMC_COMPANY - [column description]
  • HMC_NOTE - [column description]

HC_MARKETING_CATEGORY_TYPE

[table description]

  • MCT_ID - [column description]
  • MCT_CODE - [column description]
  • MCT_TEXT_ID - [column description]
> H_CP_TEXTS.TXTS_ID
  • MCT_ORDER_ID - [column description]
  • MCT_ENABLED - [column description]
  • MCT_STAY - [column description]
  • MCT_GUEST - [column description]
  • MCT_COMPANY - [column description]
  • MCT_TYPE - [column description]
  • MCT_SYSTEM - [column description]
  • MCT_REQ_BOOKING_SOLO - [column description]
  • MCT_REQ_BOOKING_GROUP - [column description]
  • MCT_REQ_STAY_SOLO - [column description]
  • MCT_REQ_STAY_GROUP - [column description]

HC_MARKETING_PARAMETER

[table description]

  • HMP_ID - [column description]
  • HMP_CODE - [column description]
  • HMP_TEXT_ID - [column description]
> H_CP_TEXTS.TXTS_ID
  • HMP_ORDER_ID - [column description]
  • HMP_ENABLED - [column description]
  • HMP_STAY - [column description]
  • HMP_GUEST - [column description]
  • HMP_COMPANY - [column description]
  • HMP_ROOM_OVERVIEW_MAP - [column description]
  • HMP_TYPE - [column description]
  • HMP_SYSTEM - [column description]
  • HMP_SHOW_IN_REPORT - [column description]

HC_MARKETING_RELATION

[table description]

  • HMR_ID - [column description]
  • HMR_CODE - [column description]
  • HMR_TEXT_ID - [column description]
> H_CP_TEXTS.TXTS_ID
  • HMR_ORDER_ID - [column description]
  • HMR_ENABLED - [column description]

HC_PA

[table description]

  • PA_NAZPP - [column description]
  • PA_CASPA - [column description]
  • PA_CASPB - [column description]
  • PA_CASTP - [column description]
  • PA_CASTO - [column description]
  • PA_DRCAS - [column description]
  • PA_NRCAS - [column description]
  • PA_CENHL - [column description]
  • PA_DEFPP - [column description]
  • PA_ID_TOVAR_A - [column description]
> H_CP_TOVAR.CTO_ID_TOVAR
  • PA_ID_TOVAR_B - [column description]
> H_CP_TOVAR.CTO_ID_TOVAR
  • PA_ID_TOVAR_C - [column description]
> H_CP_TOVAR.CTO_ID_TOVAR
  • PA_ID_TOVAR_D - [column description]
> H_CP_TOVAR.CTO_ID_TOVAR
  • PA_ID - [column description]

HC_PAYMENT_CHEQUE_TYPE

[table description]

  • PCT_ID - [column description]
  • PCT_CODE - [column description]
  • PCT_NAME - [column description]
  • PCT_ENABLED - [column description]
  • PCT_DELETED - [column description]
  • PCT_ORDER_ID - [column description]

HC_PAYMENT_FISCAL

[table description]

  • PF_ID - [column description]
  • PF_CISPS - [column description]
> HC_PS.PS_CISPS
  • PF_ID_PAYMENT - [column description]
> H_CP_DRUH_PLATBY.CDP_ID_DRUH_PLATBY
  • PF_ID_PAYMENT_FISCAL - [column description]

HC_PAYMENT_TYPE_USER

[table description]

  • PTU_PAYMENT_TYPE_ID - [column description]
> H_CP_DRUH_PLATBY.CDP_ID_DRUH_PLATBY
  • PTU_USER_ID - [column description]
> L_UZIVATEL_PREDOK.UP_ID_UZIVATEL_PREDOK

H_CP_BALIKY_SLUZIEB

[table description]

  • CBS_PORADIE - [column description]
  • CBS_ID_TOVAR - [column description]
  • CBS_BALIK_TYP - [column description]
  • CBS_POCET_DNI - [column description]
  • CBS_POVOLENE_PRE_DOLORES - [column description]

H_CP_BALIKY_SLUZIEB_SLUZBY

[table description]

  • BST_ID - [column description]
  • BST_PARENT - [column description]
> H_CP_BALIKY_SLUZIEB.CBS_ID_TOVAR
  • BST_ID_TOVAR - [column description]
> H_CP_TOVAR.CTO_ID_TOVAR
  • BST_ID_CENOVA_STRUKTURA - [column description]
> HK_PRICES.PRCS_ID
  • BST_TRVALA - [column description]
  • BST_PLATENA - [column description]
  • BST_POCET - [column description]
  • BST_RELZA - [column description]
  • BST_RELKO - [column description]
  • BST_CASPO - [column description]
  • BST_NUTUP - [column description]
  • BST_SLDEN - [column description]
  • BST_INTERNA - [column description]
  • BST_PO_POLNOCI - [column description]

H_CP_CENOVA_HLADINA

[table description]

  • CEH_ID_HLADINA - [column description]
  • CEH_PORADIE - [column description]
  • CEH_NAZOV - [column description]

H_CP_CENOVA_HLADINA_PROFIL

[table description]

  • CHP_ID_HLADINA - [column description]
  • CHP_ID_PROFIL - [column description]
  • CHP_ID_TYP_IZBY - [column description]
  • CHP_VYTAZENOST - [column description]
  • CHP_ID_CENOVA_STRUKTURA - [column description]
> HK_PRICES.PRCS_ID
  • CHP_POVOLENA - [column description]

H_CP_CENOVA_POLITIKA_PROFIL

[table description]

  • CPP_ID_POLITIKA - [column description]
  • CPP_ID_PROFIL - [column description]
  • CPP_ID_POLITIKA_TYP - [column description]
  • CPP_HODNOTA - [column description]
  • CPP_POVOLENA - [column description]
  • CPP_ROUNDING_TYPE - [column description]
  • CPP_ROUNDING - [column description]
  • CPP_ROUNDING_APPLY - [column description]
  • CPP_ORDER - [column description]

H_CP_CENOVA_POLITIKA_TYP

[table description]

  • CPT_ID_POLITIKA_TYP - [column description]
  • CPT_SKUPINA - [column description]
  • CPT_NAZOV - [column description]

H_CP_CENOVA_POLITIKA_TYP_LANG

[table description]

  • LCPT_ID - [column description]
> H_CP_CENOVA_POLITIKA_TYP.CPT_ID_POLITIKA_TYP
  • LCPT_LANG - [column description]
  • LCPT_NAZOV - [column description]

H_CP_CENOVA_STRUKTURA_OBJED

[table description]

  • CCSO_ID - [column description]
  • CCSO_KOD_MENY - [column description]
  • CCSO_OBJEM_V_DANEJ_MENE - [column description]

H_CP_CENOVY_PROFIL

[table description]

  • CEP_ID_PROFIL - [column description]
  • CEP_PREDOK - [column description]
  • CEP_TYP - [column description]
  • CEP_PORADIE - [column description]
  • CEP_NAZOV - [column description]
  • CEP_POZNAMKA - [column description]
  • CEP_IND_PROFIL_PREFIX - [column description]
  • CEP_IND_PROFIL_POVOLENY - [column description]

H_CP_DRUH_PLATBY

[table description]

  • CDP_ID_DRUH_PLATBY - [column description]
  • CDP_ID_TEXT - [column description]
> H_CP_TEXTS.TXTS_ID
  • CDP_INVOICE - [column description]
  • CDP_BILL - [column description]
  • CDP_INCOME - [column description]
  • CDP_LEVY - [column description]
  • CDP_PORADIE - [column description]
  • CDP_KODPLATBY - [column description]
  • CDP_ID_DRUH_PLATBY_PREVOD - [column description]
> H_CP_DRUH_PLATBY.CDP_ID_DRUH_PLATBY
  • CDP_SYSTEM - [column description]
  • CDP_FISCAL - [column description]
  • CDP_TYPE - [column description]
  • CDP_ENABLED - [column description]
  • CDP_DELETED - [column description]
  • CDP_CREDIT_CARD_DATA_VIS - [column description]
  • CDP_CREDIT_CARD_EXP_CHECK - [column description]
  • CDP_CHEQUE_DATE_VIS - [column description]
  • CDP_CHEQUE_DATE_REQ - [column description]
  • CDP_CHEQUE_POST_OFFICE_VIS - [column description]
  • CDP_CHEQUE_POST_OFFICE_REQ - [column description]
  • CDP_CHEQUE_TYPE_VIS - [column description]
  • CDP_CHEQUE_TYPE_REQ - [column description]
  • CDP_CHEQUE_NR_VIS - [column description]
  • CDP_CHEQUE_NR_REQ - [column description]
  • CDP_MAX_FISCAL_AMOUNT - [column description]

H_CP_EXT_SYS_KATEGORIA

[table description]

  • CEK_ID_EXT_SYSTEM - [column description]
> H_CP_EXT_SYSTEM.CES_ID_EXT_SYSTEM
  • CEK_ID_KATEGORIA_SLUZBY - [column description]
> H_CP_KATEGORIA_TOVARU.CKT_ID_KATEGORIA_TOVARU

H_CP_EXT_SYS_SETTINGS

[table description]

  • CESS_ID_EXT_SYSTEM - [column description]
> H_CP_EXT_SYSTEM.CES_ID_EXT_SYSTEM
  • CESS_POVOLENA_KOMUNIKACIA - [column description]
  • CESS_POVOL_KOMUN_SKLAD - [column description]
  • CESS_ID_UZIVATEL_ZAPIS - [column description]
> L_UZIVATEL.UZ_ID_UZIVATEL
  • CESS_WEB_SERVICES - [column description]
  • CESS_WS_HOST - [column description]
  • CESS_WS_PORT - [column description]
  • CESS_DEF_KOD_MENY - [column description]
  • CESS_VERSION - [column description]
  • CESS_WS_APP_NAME - [column description]

H_CP_EXT_SYSTEM

[table description]

  • CES_ID_EXT_SYSTEM - [column description]
  • CES_ID_EXT_SYSTEM_TYP - [column description]
> H_CP_EXT_SYSTEM_TYP.CEY_ID_EXT_SYSTEM_TYP
  • CES_EXTERNE_ID - [column description]
  • CES_NAME - [column description]

H_CP_EXT_SYSTEM_IMPEXP

[table description]

  • CEI_ID_EXT_SYSTEM - [column description]
> H_CP_EXT_SYSTEM.CES_ID_EXT_SYSTEM
  • CEI_ID_TYP_OBJEKTU - [column description]
> H_CP_EXT_SYSTEM_TYP_OBJEKTU.CET_ID_TYP_OBJEKTU
  • CEI_ID_OBJEKT - [column description]
  • CEI_ID_IDENTIFIKACNY_STRING - [column description]
  • CEI_IE_FLAG - [column description]

H_CP_EXT_SYSTEM_TYP

[table description]

  • CEY_ID_EXT_SYSTEM_TYP - [column description]
  • CEY_ID_TEXT - [column description]
> H_CP_TEXTS.TXTS_ID
  • CEY_SYSTEM - [column description]

H_CP_EXT_SYSTEM_TYP_OBJEKTU

[table description]

  • CET_ID_TYP_OBJEKTU - [column description]

H_CP_HLADINA_DPH

[table description]

  • CHD_ID_HLADINA_DPH - [column description]
  • CHD_KOD - [column description]
  • CHD_SADZBA - [column description]
  • CHD_SYSTEM - [column description]
  • CHD_PARENT_ID - [column description]
  • CHD_ID_TEXT - [column description]
> H_CP_TEXTS.TXTS_ID
  • CHD_ACTUAL - [column description]
  • CHD_VAT_FISCAL_MODULE - [column description]

HC_PK

[table description]

  • PK_KODPK - [column description]
  • PK_NAZOV - [column description]
  • PK_LIMIT - [column description]
  • PK_POPPK - [column description]
  • PK_TELEF - [column description]
  • PK_ID - [column description]

H_CP_KALENDAR

[table description]

  • CKA_ID_KALENDAR - [column description]
  • CKA_ID_KALENDAR_TYP - [column description]
  • CKA_PORADIE - [column description]
  • CKA_FUNKCIA - [column description]
  • CKA_NAZOV - [column description]

H_CP_KALENDAR_HLADINA_ZLAVA

[table description]

  • CKH_ID_HLADINA_ZLAVA - [column description]
  • CKH_ID_KALENDAR - [column description]
  • CKH_HODNOTA - [column description]
  • CKH_TYP - [column description]

H_CP_KALENDAR_MREZA_TYP_LANG

[table description]

  • LCKM_ID - [column description]
> H_CP_KALENDAR_MRIEZKA_TYP.CKM_ID_MRIEZKA
  • LCKM_LANG - [column description]
  • LCKM_NAZOV - [column description]

H_CP_KALENDAR_MRIEZKA_TYP

[table description]

  • CKM_ID_MRIEZKA - [column description]
  • CKM_STLPEC_TYP - [column description]
  • CKM_TRIEDA - [column description]
  • CKM_NAZOV - [column description]

H_CP_KALENDAR_PRIEBEH

[table description]

  • CKP_ID_PRIEBEH - [column description]
  • CKP_X - [column description]
  • CKP_ID_KALENDAR - [column description]
  • CKP_ID_HLADINA_ZLAVA - [column description]

H_CP_KALENDAR_TYP

[table description]

  • CKAT_ID_KALENDAR_TYP - [column description]
  • CKAT_ID_MRIEZKA_H - [column description]
  • CKAT_TRIEDA_V - [column description]
  • CKAT_PORADIE - [column description]

H_CP_KATEGORIA_TOVARU

[table description]

  • CKT_ID_KATEGORIA_TOVARU - [column description]
  • CKT_ID_TEXT - [column description]
> H_CP_TEXTS.TXTS_ID
  • CKT_ID_KATEGORIA_TOVARU_TYP - [column description]
> H_CP_KATEGORIA_TOVARU_TYP.CKK_ID_KATEGORIA_TOVARU_TYP
  • CKT_PORADIE - [column description]
  • CKT_KOD - [column description]
  • CKT_SYSTEM - [column description]
  • CKT_TYP_INTERNAL - [column description]

H_CP_KATEGORIA_TOVARU_TYP

[table description]

  • CKK_ID_KATEGORIA_TOVARU_TYP - [column description]
  • CKK_ID_TEXT - [column description]
> H_CP_TEXTS.TXTS_ID
  • CKK_SYSTEM - [column description]

H_CP_LANGUAGE

[table description]

  • CPL_ID_LANGUAGE - [column description]
  • CPL_KOD - [column description]
  • CPL_ID_TEXT - [column description]
> H_CP_TEXTS.TXTS_ID
  • CPL_SYSTEM - [column description]

HC_PLANY_POSCHODI

[table description]

  • PLP_KOD_POSCH - [column description]
  • PLP_NAZOV_POSCH - [column description]
  • PLP_PLAN_POSCH - [column description]

HC_POKLADNA

[table description]

  • POK_ID - [column description]
  • POK_ID_TEXT - [column description]
> H_CP_TEXTS.TXTS_ID
  • POK_CISPS - [column description]
> HC_PS.PS_CISPS
  • POK_ID_UBYTOVACI_BLOK - [column description]
> HC_UBYTOVACI_BLOK.HUB_ID
  • POK_ID_USEK - [column description]
> HC_USEK.HUS_ID
  • POK_SYSTEM - [column description]

HC_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]

HC_PS

[table description]

  • PS_CISPS - [column description]
  • PS_NAZPS - [column description]
  • PS_IDENT - [column description]
  • PS_TYPFI - [column description]
  • PS_DKPFI - [column description]
  • PS_CASDU - [column description]
  • PS_CASMU - [column description]
  • PS_ZAKAZANEUCTY - [column description]
  • PS_ZAKAZANEFAKTURY - [column description]
  • PS_MAXRIADUCTU - [column description]
  • PS_POVOLENEUCTENKY - [column description]
  • PS_SIRKAUCTENKY - [column description]
  • PS_NULYNAUCTE - [column description]
  • PS_ZDRUZOVANIECIEN - [column description]
  • PS_MINIMALIZOVANYUCET - [column description]
  • PS_SOLOPOLOZKYNAUCTE - [column description]
  • PS_POPISNAUCTENKACH - [column description]
  • PS_ADRESADOPOPISU - [column description]
  • PS_OTVORZASUVKU - [column description]
  • PS_OZDOBNYBLANKET - [column description]
  • PS_JVSTIMEOUT - [column description]
  • PS_TELEFONY_FILTER - [column description]
  • PS_EXTERNE_SLUZBY_FILTER - [column description]
  • PS_FAREBNAPALETA - [column description]
  • PS_PAMATAT_VELKOSTI_OKIEN - [column description]
  • PS_ZAROVNAVAT_OKNA - [column description]
  • PS_OKNA_HORIZONTALNY_POSUN - [column description]
  • PS_OKNA_VERTIKALNY_POSUN - [column description]
  • PS_AUTOMATICKE_HLADANIE - [column description]
  • PS_SOLOEXTERNEUCTY - [column description]
  • PS_POCET_AKCIA - [column description]
  • PS_ZOBRAZ_KLIENT_HINT - [column description]
  • PS_NEZOBRAZOVAT_POBYTOVY_DEN - [column description]
  • PS_ZAUCTOVANIE_NA_UCTE - [column description]
  • PS_POMOCNY_POPIS_UCTU - [column description]
  • PS_C_BYVALA_OBJEDNANA_IZBA - [column description]
  • PS_C_PLNE_OBSADENA_IZBA - [column description]
  • PS_C_CIASTOCNE_OBSADENA_IZBA - [column description]
  • PS_C_OBJEDNAVKA_POTVRDENA_FIX - [column description]
  • PS_C_OBJEDNAVKA_POTVRDENA - [column description]
  • PS_C_OBJEDNAVKA_NEPOTVRDENA - [column description]
  • PS_C_KONTRAKT - [column description]
  • PS_C_NOVY_ELEMENT - [column description]
  • PS_C_PREBUKOVANY - [column description]
  • PS_C_ZDRUZENY_ELEMENT - [column description]
  • PS_ROZUCTOVANIE_ZALOHY - [column description]
  • PS_C_PRAZDNA_IZBA - [column description]
  • PS_BUDENIE_HOSTI - [column description]
  • PS_C_BITMAP_NEDELA - [column description]
  • PS_C_BITMAP_NEDELA_ZOBRAZENA - [column description]
  • PS_C_BITMAP_NEDELA_BLEND - [column description]
  • PS_HINT_POVOLENY - [column description]
  • PS_ZOBRAZ_SUMU_INEJ_MENY - [column description]
  • PS_HINT_PREPOCET_MENA - [column description]
  • PS_HINT_KONV_MENA - [column description]
  • PS_ZOSTAVY_VYBER_MENY - [column description]
  • PS_ZDRUZ_PODLA_KATEGORIZACIE - [column description]
  • PS_MENA_UCTU - [column description]
  • PS_NASTAV_DUAL_ZOBR_ENABLED - [column description]
  • PS_SUMA_UCTENKA_BOLD - [column description]
  • PS_AUTO_PRIHLAS_UZIVATEL_OS - [column description]
  • PS_READ_DOC_FISCAL_MODULE - [column description]
  • PS_ZDRUZOVANIE_EXT_POKL - [column description]
  • PS_F_VAT_RECAPITULATION - [column description]
  • PS_F_COMPR_PRINT_FISCAL - [column description]
  • PS_F_COMPR_PRINT_NONFISCAL - [column description]
  • PS_F_GRAPH_HEADER_FISCAL - [column description]
  • PS_F_GRAPH_FOOTER_FISCAL - [column description]
  • PS_F_GRAPH_HEADER_NONFISCAL - [column description]
  • PS_F_GRAPH_FOOTER_NONFISCAL - [column description]
  • PS_ZDRUZOVANIE_CP_S_BAL - [column description]
  • PS_ZDRUZOVANIE_CP - [column description]
  • PS_ZDRUZOVANIE_BALIKY - [column description]
  • PS_SPRAVA_CAS - [column description]
  • PS_SYNCHRO_CAS - [column description]
  • PS_F_VAT_CLAIM_SETT - [column description]
  • PS_ZDRUZOVANIE_CP_S_BAL_IZBA - [column description]
  • PS_ZDRUZOVANIE_CP_IZBA - [column description]
  • PS_ZDRUZOVANIE_BALIKY_IZBA - [column description]
  • PS_C_OBJ_NEPOTVRDENA_FIX - [column description]
  • PS_TEXT_FONT - [column description]
  • PS_OSTRA_FA_S_DODACIM_LISTOM - [column description]
  • PS_EMAIL_CLIENT_TYPE - [column description]
  • PS_BITMAP_VIEW_NONSYSTEM_BEDS - [column description]
  • PS_F_BOWA_CLOSING_REP_NR - [column description]

HC_PT

[table description]

  • PT_CISPS - [column description]
  • PT_ANOPREVIEW - [column description]
  • PT_ANOSETUPPRINTER - [column description]
  • PT_ANOGRAFICKA - [column description]
  • PT_TYPVYSTUPU - [column description]
  • PT_VYBERZOSTAVYPRETLAC - [column description]
  • PT_NAZOVTLACIARNE - [column description]
  • PT_POCETKOPII - [column description]
  • PT_OKRAJTOP - [column description]
  • PT_OKRAJLEFT - [column description]
  • PT_OKRAJBOTTOM - [column description]
  • PT_OKRAJRIGHT - [column description]
  • PT_DISABLEANOPREVIEW - [column description]
  • PT_FORMATSTRANY - [column description]
  • PT_VYSKAPAPIERA - [column description]
  • PT_SIRKAPAPIERA - [column description]
  • PT_EMAIL - [column description]
  • PT_UKONCOVACIEZNAKY - [column description]
  • PT_VYSTUPNYSUBOR - [column description]
  • PT_ZMENATEXTU - [column description]
  • PT_DEFAULTTK - [column description]
  • PT_STRANAOD - [column description]
  • PT_STRANADO - [column description]
  • PT_PORT_TLACIARNE - [column description]
  • PT_SLIP - [column description]
  • PT_SPEC_TAG_RIADOK - [column description]
  • PT_TK_ID - [column description]
> HC_TK.TK_ID
  • PT_TL_ID - [column description]
> HC_TL.TL_ID
  • PT_SIET_HOST - [column description]
  • PT_SIET_PORT - [column description]
  • PT_SIET_KONVERZIA - [column description]
  • PT_SIET_ID_TLAC - [column description]
  • PT_SIET_TIMEOUT - [column description]

H_CP_TEXT

[table description]

  • TXT_ID_TEXT - [column description]
> H_CP_TEXTS.TXTS_ID
  • TXT_ID_LANGUAGE - [column description]
> H_CP_LANGUAGE.CPL_ID_LANGUAGE
  • TXT_TEXT - [column description]
  • TXT_ID - [column description]

H_CP_TEXTS

[table description]

  • TXTS_ID - [column description]

H_CP_TOVAR

[table description]

  • CTO_ID_TOVAR - [column description]
  • CTO_ID_TEXT - [column description]
> H_CP_TEXTS.TXTS_ID
  • CTO_ID_CENOVA_STRUKTURA - [column description]
> HK_PRICES.PRCS_ID
  • CTO_ID_DPH - [column description]
> H_CP_HLADINA_DPH.CHD_ID_HLADINA_DPH
  • CTO_ID_AKTUALNOST - [column description]
  • CTO_KODTR - [column description]
  • CTO_TYP_SLUZBY - [column description]
  • CTO_MENIT_CENA - [column description]
  • CTO_ZAKLADNY_TYP - [column description]
  • CTO_PULTOVY_PREDAJ - [column description]
  • CTO_EXT_ZAZNAM - [column description]
  • CTO_ID_TOVAR_SKLAD - [column description]
> H_CP_TOVAR_SKLAD.CTS_ID_TOVAR_SKLAD
  • CTO_SYSTEM - [column description]
  • CTO_PO_POLNOCI - [column description]

H_CP_TOVAR_KATEGORIA

[table description]

  • CTK_ID_TOVAR - [column description]
> H_CP_TOVAR.CTO_ID_TOVAR
  • CTK_ID_KATEGORIA_TOVARU - [column description]
> H_CP_KATEGORIA_TOVARU.CKT_ID_KATEGORIA_TOVARU

H_CP_TOVAR_SKLAD

[table description]

  • CTS_ID_TOVAR_SKLAD - [column description]
  • CTS_MNOZSTVO - [column description]
  • CTS_NAKUPNA_CENA - [column description]
  • CTS_MIN_MNOZSTVO - [column description]
  • CTS_ID_TEXT - [column description]
> H_CP_TEXTS.TXTS_ID
  • CTS_PREDAJNA_CENA - [column description]
  • CTS_SYSTEM - [column description]
  • CTS_ID_AKTUALNOST - [column description]
  • CTS_KOD - [column description]

H_CP_TOVAR_ZLAVA

[table description]

  • CTZ_ID_TOVAR - [column description]
> H_CP_TOVAR.CTO_ID_TOVAR
  • CTZ_DPH - [column description]
  • CTZ_ZLAVA_HODNOTA - [column description]
  • CTZ_ZLAVA_PERCENTO - [column description]
  • CTZ_ID_NA_KATEGORIU - [column description]
> H_CP_KATEGORIA_TOVARU.CKT_ID_KATEGORIA_TOVARU
  • CTZ_ID_NA_TOVAR - [column description]
> H_CP_TOVAR.CTO_ID_TOVAR
  • CTZ_SYSTEM - [column description]

HC_PTV_HOUSEKEEPING

[table description]

  • HSKP_CODE - [column description]
  • HSKP_NAME - [column description]
  • HSKP_CLEAN_ROOM - [column description]
  • HSKP_NOCLEAN_ROOM - [column description]
  • HSKP_TECHNICAL_FAULT - [column description]

HC_PTV_LANGUAGE

[table description]

  • PLNG_ID - [column description]
  • PLNG_PTV_CODE - [column description]

HC_PTV_PERMISSION

[table description]

  • PRMS_PTV_CODE - [column description]
  • PRMS_NAME - [column description]
  • PRMS_ID - [column description]

HC_PTV_POST_AMOUNT

[table description]

  • PAMO_ID - [column description]
  • PAMO_REVENUE_CODE - [column description]
> HC_PTV_POST_REVENUE_CODE.PPRC_REVENUE_CODE
  • PAMO_NAME - [column description]
  • PAMO_PAYTV_CODE - [column description]
  • PAMO_ID_TOVAR - [column description]
> H_CP_TOVAR.CTO_ID_TOVAR

HC_PTV_POST_REVENUE_CODE

[table description]

  • PPRC_REVENUE_CODE - [column description]
  • PPRC_NAME - [column description]

H_CP_TYP_PRODUKTU

[table description]

  • HTP_ID - [column description]
  • HTP_ID_TEXT - [column description]
> H_CP_TEXTS.TXTS_ID
  • HTP_KOD - [column description]
  • HTP_SYSTEM - [column description]

H_CP_TYP_SLUZBY

[table description]

  • HTS_ID - [column description]
  • HTS_ID_TEXT - [column description]
> H_CP_TEXTS.TXTS_ID
  • HTS_SYSTEM - [column description]

H_CP_UCTOVANIE_PROFIL

[table description]

  • CPU_KEY - [column description]
  • CPU_ID_PROFIL - [column description]
  • CPU_VALUE - [column description]

H_CP_UZIVATELSKY_TEXT

[table description]

  • CUT_ID_UZIVATELSKY_TEXT - [column description]
  • CUT_ID_TEXT - [column description]
> H_CP_TEXTS.TXTS_ID
  • CUT_SYSTEM - [column description]

HC_PV

[table description]

  • PV_KODPA - [column description]
  • PV_NAZPA - [column description]
  • PV_POCDN - [column description]
  • PV_CISNL - [column description]
  • PV_CASSK - [column description]
  • PV_TECHN - [column description]

H_CP_ZLAVA

[table description]

  • CZL_ID_ZLAVA - [column description]
  • CZL_ID_TYP - [column description]
  • CZL_PERCENTA - [column description]
  • CZL_PORADIE - [column description]
  • CZL_NAZOV - [column description]
  • CZL_ID_PRICES - [column description]
> HK_PRICES.PRCS_ID

H_CP_ZLAVA_TYP

[table description]

  • CZT_ID_TYP - [column description]
  • CZT_NAZOV - [column description]

H_CP_ZLAVA_TYP_LANG

[table description]

  • LCZT_ID - [column description]
> H_CP_ZLAVA_TYP.CZT_ID_TYP
  • LCZT_LANG - [column description]
  • LCZT_NAZOV - [column description]

HC_ROOM_TYPE_BED_TYPES

[table description]

  • RTBT_ID - [column description]
  • RTBT_ROOM_TYPE_ID - [column description]
> HC_CE.CE_CISTY
  • RTBT_BED_TYPE_ID - [column description]
> HC_BED_TYPE.HBT_ID
  • RTBT_COUNT - [column description]
  • RTBT_ORDER_ID - [column description]

HC_SE

[table description]

  • SE_CASZME - [column description]
  • SE_CPRAZM - [column description]
  • SE_POPRAZ - [column description]
  • SE_POPNER - [column description]
  • SE_POPRAT - [column description]
  • SE_ZDRUDN - [column description]
  • SE_UZADEN - [column description]
  • SE_UZANOC - [column description]
  • SE_UZAMES - [column description]
  • SE_UZAROK - [column description]
  • SE_BMDATS - [column description]
  • SE_BMDATN - [column description]
  • SE_CASARCHIVACIA - [column description]
  • SE_PRACARCHIVACIA - [column description]
  • SE_CASVERIFIKACIA - [column description]
  • SE_PRACVERIFIKACIA - [column description]
  • SE_CASUODVODOVA - [column description]
  • SE_PRACUODVODOVA - [column description]
  • SE_CASUPRIEBEZNA - [column description]
  • SE_PRACUPRIEBEZNA - [column description]
  • SE_CASUDENNA - [column description]
  • SE_PRACUDENNA - [column description]
  • SE_CASUDENNAZOSTAVY - [column description]
  • SE_PRACUDENNAZOSTAVY - [column description]
  • SE_CASUMESACNA - [column description]
  • SE_PRACUMESACNA - [column description]
  • SE_CASUROCNA - [column description]
  • SE_PRACUROCNA - [column description]
  • SE_MENFIR - [column description]
  • SE_ADRFIR - [column description]
  • SE_MESFIR - [column description]
  • SE_TELFIR - [column description]
  • SE_FAXFIR - [column description]
  • SE_ICOFIR - [column description]
  • SE_DICFIR - [column description]
  • SE_UCEFIR - [column description]
  • SE_SPLAFA - [column description]
  • SE_HODNAS - [column description]
  • SE_ZOSTAVYPOCETRIADKOV - [column description]
  • SE_IFTELEFONY - [column description]
  • SE_IFTELEFONYFILTER - [column description]
  • SE_TELEFONYPRIRAZKA - [column description]
  • SE_IFKLUCOVEKARTY - [column description]
  • SE_IFEXTERNESLUZBY - [column description]
  • SE_REFRESHTELEFONYCAS - [column description]
  • SE_UCHOVADATA - [column description]
  • SE_UCHOVAZOSTAVYPU - [column description]
  • SE_UCHOVAZOSTAVYDU - [column description]
  • SE_UCHOVAZOSTAVYMU - [column description]
  • SE_UCHOVAZOSTAVYRU - [column description]
  • SE_UCHOVAFISKALDOKLAD - [column description]
  • SE_IFUPRATATIZBY - [column description]
  • SE_UCHOVAODBERATELOV - [column description]
  • SE_VALUTYPERCENT - [column description]
  • SE_VALUTYMINPOP - [column description]
  • SE_UCHOVAZOSTAVYOU - [column description]
  • SE_IFNEZIADHOOBJED - [column description]
  • SE_IFNEZIADHOPRICHOD - [column description]
  • SE_IFENERGETREGULACIA - [column description]
  • SE_UCHOVAZOSTAVYRA - [column description]
  • SE_IFAUTCISLOVANIEOBJ - [column description]
  • SE_IFPOVOLENYPRIS - [column description]
  • SE_DOPFIR - [column description]
  • SE_REGFIR - [column description]
  • SE_RCZFIR - [column description]
  • SE_NEZAPISOVATNULOVEUBYTOVANIE - [column description]
  • SE_MAX_CAS_ZRUS_PRICHOD - [column description]
  • SE_BMPLNEOBSADENA - [column description]
  • SE_DESATINYTELEFONYCENA - [column description]
  • SE_DESATINYNAKUPNACENA - [column description]
  • SE_DESATINYPRIJEMSKLADCENA - [column description]
  • SE_DESATINYVYPOCETDPH - [column description]
  • SE_IFNULADPHUCET - [column description]
  • SE_IFNULADPHUCTENKA - [column description]
  • SE_IFNULADPHFAKTURA - [column description]
  • SE_EMAILFIR - [column description]
  • SE_WEBFIR - [column description]
  • SE_SMTPFIR - [column description]
  • SE_CASUPRIPRAVA - [column description]
  • SE_PRACUPRIPRAVA - [column description]
  • SE_CASURAPORTKA - [column description]
  • SE_PRACURAPORTKA - [column description]
  • SE_MIESTNYPOPLATOK - [column description]
  • SE_LIMITPOSLEDNAOBJEDNAVKA - [column description]
  • SE_ZOBRAZUCETMAIL - [column description]
  • SE_IFPRESUNNAZMRAZENYUCET - [column description]
  • SE_REFRESHSTAVPOKLADNE - [column description]
  • SE_FAKTURAKONSTANTNYSYMBOL - [column description]
  • SE_FAKTURA_DATUM_ZDAN_PLNENIA - [column description]
  • SE_MASK_EVID_OBJEDNAVKY - [column description]
  • SE_NEPOCITAJ_MP_ZALOHA - [column description]
  • SE_DESATINYVYPOCETCENA - [column description]
  • SE_DESATINYVYPOCETUBYTCENA - [column description]
  • SE_IFZMENAREN - [column description]
  • SE_RASTERUBYTOVANIE - [column description]
  • SE_RASTERSTRAVOVANIE - [column description]
  • SE_IBANFIR - [column description]
  • SE_MAX_FISKAL_SUMA - [column description]
  • SE_BICSWIFT - [column description]
  • SE_DESATINYJEDNOTKOVACENAUCET - [column description]
  • SE_IFNEZIADVIPPRICHOD - [column description]
  • SE_IFNEZIADVIPOBJED - [column description]
  • SE_DICFIROLD - [column description]
  • SE_ANODICUCTENKY - [column description]
  • SE_ANODICFAKTURY - [column description]
  • SE_HODINA_PREDCAS_PRICHOD - [column description]
  • SE_POLOZKA_DOBROPIS_NA_SKLAD - [column description]
  • SE_IFUZAV_VERIF_REFERENCII - [column description]
  • SE_DEFAULT_OBJED_NA_TYP_IZBY - [column description]
  • SE_PONUKAT_IZ_MIMO_PREVADZKY - [column description]
  • SE_AUTOMATICKE_CISLOVANIE - [column description]
  • SE_ZOBRAZOVAT_IKONY_NA_MAPACH - [column description]
  • SE_VYPIS_EXTERNYCH_DO_HLAS - [column description]
  • SE_POCET_CISLO_ZAKAZKY - [column description]
  • SE_POVOL_NAVIAZANIE_RTP - [column description]
  • SE_PREKRYTIE_IKON - [column description]
  • SE_PTV_POVOLENE - [column description]
  • SE_PTV_LITE - [column description]
  • SE_PTV_COM_PORT - [column description]
  • SE_PTV_DEF_PERMISSION - [column description]
  • SE_PTV_DIACRITICAL - [column description]
  • SE_NASTAV_LOZKA_OBJEDNAVKY - [column description]
  • SE_ID_TOVAR_ZALOHA_PRIJATA - [column description]
> H_CP_TOVAR.CTO_ID_TOVAR
  • SE_ID_TOVAR_ZALOHA_REALIZOVANA - [column description]
> H_CP_TOVAR.CTO_ID_TOVAR
  • SE_ID_TOVAR_ZALOHA_Z_UCTU - [column description]
> H_CP_TOVAR.CTO_ID_TOVAR
  • SE_INSTALL_NUMBER - [column description]
  • SE_POPRDO - [column description]
> H_CP_TOVAR.CTO_ID_TOVAR
  • SE_POPRCU - [column description]
> H_CP_TOVAR.CTO_ID_TOVAR
  • SE_KODHO50HAL - [column description]
> H_CP_TOVAR.CTO_ID_TOVAR
  • SE_ID_TOVAR_TELEFONY - [column description]
> H_CP_TOVAR.CTO_ID_TOVAR
  • SE_SKLAD_DO_MINUSU - [column description]
  • SE_DEF_KOD_MENY_IEXTSYS - [column description]
  • SE_ARCHIVACIA_PRED_UZ - [column description]
  • SE_ARCHIVACIA_PO_UZ - [column description]
  • SE_PAY_TV_UZIVATEL - [column description]
  • SE_PLATBA_ZAOKR_TYP - [column description]
  • SE_PLATBA_ZAOKR_TYP_VYPOCET - [column description]
  • SE_UCTENKA_DVA_RIADKY - [column description]
  • SE_UCTENKA_JCENA_BEZ_DPH - [column description]
  • SE_ID_HOREC_LANGUAGE - [column description]
> HC_HOREC_LANGUAGE.HLNG_ID_LANGUAGE
  • SE_ZAOKRUH_KOEF_DPH - [column description]
  • SE_UCHOVAZOSTAVYUU - [column description]
  • SE_LANGUAGE - [column description]

HC_SEEXT

[table description]

  • SX_ID - [column description]
  • SX_HEADER - [column description]
  • SX_FOOTER - [column description]
  • SX_PLUS_DNI_NOVEJ_OBJEDNAVKE - [column description]
  • SX_COPY_UDAJE_HOSTA - [column description]
  • SX_COPY_SLUZBY_HOSTA - [column description]
  • SX_FAKTURA_FISK_DOKLAD - [column description]
  • SX_ID_TEXT_OSLOVENIE - [column description]
> H_CP_TEXTS.TXTS_ID
  • SX_ZOBRAZ_HOSTA - [column description]
  • SX_ZOBRAZ_POBYTOVE_DNI - [column description]
  • SX_ZOBRAZ_CISLO_IZBY - [column description]
  • SX_CAS_EXPIRACIE_EXT_HOST - [column description]
  • SX_POVOLENE_EXT_HOST - [column description]
  • SX_DEF_ID_STAT_IEXTSYS - [column description]
> HC_ST.ST_ID_STAT
  • SX_ID_DEFAULT_FLAG - [column description]
  • SX_PHONE_BASEPRICE_MULTIP - [column description]
  • SX_UNBLOCK_TELEPHONE_CHKIN - [column description]
  • SX_BLOCK_TELEPHONE_CHKOUT - [column description]
  • SX_DAN_DODACI_LIST - [column description]
  • SX_INDIVIDUALNA_CENA - [column description]
  • SX_INDIVIDUALNA_CENA_POVOL - [column description]
  • SX_LICENCE_WS_URL - [column description]
  • SX_FAKTURA_FISK_PLATBA - [column description]
  • SX_ID_HOT_POSKYTNUTA - [column description]
> H_CP_TOVAR.CTO_ID_TOVAR
  • SX_ID_HOT_POSKYTNUTA_REALIZ - [column description]
> H_CP_TOVAR.CTO_ID_TOVAR
  • SX_ID_HOT_POSKYTNUTA_ZUCT - [column description]
> H_CP_TOVAR.CTO_ID_TOVAR
  • SX_MESACNE_UBYT_BLOK - [column description]
  • SX_PARTIAL_CHECKOUT_MAX_DAYS - [column description]
  • SX_ZALOHA_CISELNY_RAD - [column description]
  • SX_ZMENA_DATUMOV_FAKTURA - [column description]
  • SX_ZMENA_DATUM_SPLAT_FAKTURA - [column description]
  • SX_BOOKING_NUMBER_PREFIX - [column description]
  • SX_BOOKING_NUM_PREFIX_LENGTH - [column description]
  • SX_MAPA_OSTATNY_POPIS - [column description]
  • SX_MAPA_NAZOV_SKUPINY - [column description]
  • SX_MAPA_MENO_VEDUCEHO - [column description]
  • SX_ZF_SERVICE_ID - [column description]
> H_CP_TOVAR.CTO_ID_TOVAR
  • SX_ZF_DEFAULT_AMOUNT - [column description]
  • SX_ZF_DEFAULT_PERC - [column description]
  • SX_ZF_AMOUNT_ROUND - [column description]
  • SX_TEXT_SUGGEST_CHAR_COUNT - [column description]
  • SX_TEXT_SUGGEST_DIA - [column description]
  • SX_FORMERGS_PRICE_PROFILE_NO - [column description]
  • SX_AUTH_LEVEL_BOOKING - [column description]
  • SX_DWH_REVENUE_ORDERED_RECALC - [column description]
  • SX_DWH_REVENUE_ORDERED_TIME - [column description]
  • SX_DWH_REVENUE_ORDERED_ARCHIVE - [column description]
  • SX_INVOICES_DIR - [column description]
  • SX_LOG_SEND_EMAIL - [column description]
  • SX_FISKAL_DOC_DIR - [column description]
  • SX_CALENDAR_RANGE - [column description]
  • SX_LICENSE_OVER_NOTIFY_DAYS - [column description]
  • SX_CRIT_TRA_LOGOUT_TIME - [column description]
  • SX_WARN_REPEAT_ACT_SYS_STATE - [column description]
  • SX_CLIENT_TIME_SYNCHRO_MINUTES - [column description]
  • SX_CLIENT_LED_DB_TRA - [column description]
  • SX_CLIENT_LED_TRA_TRA - [column description]
  • SX_CLIENT_BUTTON_FLASH_DELAY - [column description]
  • SX_EXT_SYS_IO_FILES_LOG - [column description]
  • SX_EXT_SYS_EKONOMIKA_DIR - [column description]
  • SX_DAILY_CLOSING_NORMAL_TIME - [column description]
  • SX_DAILY_CLOSING_MINIMAL_TIME - [column description]
  • SX_CLOSINGS_DOC_DIR - [column description]
  • SX_ARCHIVE_DIR_TEMP - [column description]
  • SX_ARCHIVE_TYPE - [column description]
  • SX_LOCALE_DECIMAL_SEP - [column description]
  • SX_LOCALE_THOUSANDS_SEP - [column description]
  • SX_LOCALE_DATE_SEP - [column description]
  • SX_LOCALE_TIME_SEP - [column description]
  • SX_LOCALE_DATE_FORMAT - [column description]

HC_SE_KONVERZIA

[table description]

  • KON_ID - [column description]
  • KON_ZOBR_KONV_MENY_OD - [column description]
  • KON_ZOBR_KONV_MENY_DO - [column description]
  • KON_DATUM_KONVERZIE - [column description]
  • KON_ZAOKR_NA_50_HAL - [column description]
  • KON_PLATNOST_OLD_MENA_DO - [column description]
  • KON_ZAOK_CENA_VSEOB - [column description]
  • KON_ZAOK_VYPOCET_DPH - [column description]
  • KON_ZAOK_CENA_TELEF - [column description]
  • KON_ZAOK_JCEN_BEZ_DPH - [column description]
  • KON_ZAOK_NAK_CENA - [column description]
  • KON_ZAOK_UBYT_CENA_LOZ - [column description]
  • KON_ZAOK_PRIJEM_SKLAD - [column description]
  • KON_REAL_DAT_KONV - [column description]
  • KON_HLASKA_CENY - [column description]
  • KON_OBDOBIE_KONVERZIE - [column description]
  • KON_PLATBA_OLD_ZAOKR - [column description]
  • KON_PLATBA_OLD_TYP_ZAOK - [column description]
  • KON_PLATBA_INFO_OLD_ZAOKR - [column description]
  • KON_PLATBA_INFO_OLD_TYP_ZAOK - [column description]
  • KON_PLATBA_NEW_ZAOKR - [column description]
  • KON_PLATBA_NEW_TYP_ZAOK - [column description]
  • KON_PLATBA_INFO_NEW_ZAOKR - [column description]
  • KON_PLATBA_INFO_NEW_TYP_ZAOK - [column description]
  • KON_REAL_DAT_PLAT_OLD_M - [column description]
  • KON_KROK_SIMULACIA - [column description]
  • KON_ARCHIV_SIMULACIA - [column description]
  • KON_POV_DOM_MENA - [column description]
  • KON_SIMULACIA_CISPS - [column description]
  • KON_INFO_OLD_SCALE - [column description]
  • KON_INFO_NEW_SCALE - [column description]
  • KON_PLATBA_OLD_SCALE - [column description]
  • KON_PLATBA_NEW_SCALE - [column description]

HC_ST

[table description]

  • ST_KODST - [column description]
  • ST_NAZOV - [column description]
  • ST_VIZUM - [column description]
  • ST_TARIF - [column description]
  • ST_ID_STAT_STATISTIKA - [column description]
> HC_STAT_STATISTIKA.SS_ID
  • ST_KODME - [column description]
  • ST_PORADIE - [column description]
  • ST_NEZOBRAZUJ - [column description]
  • ST_ID_CENOVY_PROFIL - [column description]
  • ST_KOD_MENY_UCTU - [column description]
  • ST_ID_STAT - [column description]
  • ST_ID_VLAJKA - [column description]
> HC_VLAJKA.VL_ID
  • ST_ID_HOREC_LANGUAGE - [column description]
> HC_HOREC_LANGUAGE.HLNG_ID_LANGUAGE

HC_STAT_STATISTIKA

[table description]

  • SS_ID - [column description]
  • SS_NAZOV - [column description]
  • SS_KOD - [column description]
  • SS_PORADIE - [column description]

HC_STAT_STATISTIKA_LANG

[table description]

  • LSS_ID - [column description]
> HC_STAT_STATISTIKA.SS_ID
  • LSS_NAZOV - [column description]
  • LSS_LANG - [column description]
> B_JAZYK.JAZ_KOD_JAZYKA

HC_ST_LANG

[table description]

  • LST_LANG - [column description]
  • LST_ID - [column description]
> HC_ST.ST_ID_STAT
  • LST_NAZOV - [column description]

HC_TF

[table description]

  • TF_TELEF - [column description]
  • TF_INDZC - [column description]
  • TF_ID_TOVAR - [column description]
> H_CP_TOVAR.CTO_ID_TOVAR
  • TF_ID_IZBA - [column description]
> HC_IZ.IZ_ID_IZBA
  • TF_NAZOV - [column description]
  • TF_BASE_PRICE_MULTIPLIER - [column description]
  • TF_ID - [column description]

HC_TK

[table description]

  • TK_KODTK - [column description]
  • TK_ANOPREVIEW - [column description]
  • TK_ANOSETUPPRINTER - [column description]
  • TK_ANOGRAFICKA - [column description]
  • TK_TYPVYSTUPU - [column description]
  • TK_VYBERZOSTAVYPRETLAC - [column description]
  • TK_NAZOVTLACIARNE - [column description]
  • TK_POCETKOPII - [column description]
  • TK_OKRAJTOP - [column description]
  • TK_OKRAJLEFT - [column description]
  • TK_OKRAJBOTTOM - [column description]
  • TK_OKRAJRIGHT - [column description]
  • TK_DISABLEANOPREVIEW - [column description]
  • TK_FORMATSTRANY - [column description]
  • TK_VYSKAPAPIERA - [column description]
  • TK_SIRKAPAPIERA - [column description]
  • TK_EMAIL - [column description]
  • TK_UKONCOVACIEZNAKY - [column description]
  • TK_VYSTUPNYSUBOR - [column description]
  • TK_ZMENATEXTU - [column description]
  • TK_DEFAULTTK - [column description]
  • TK_STRANAOD - [column description]
  • TK_STRANADO - [column description]
  • TK_PORT_TLACIARNE - [column description]
  • TK_ID - [column description]
  • TK_TL_ID - [column description]
> HC_TL.TL_ID
  • TK_SIET_HOST - [column description]
  • TK_SIET_PORT - [column description]
  • TK_SIET_KONVERZIA - [column description]
  • TK_SIET_ID_TLAC - [column description]
  • TK_SIET_TIMEOUT - [column description]

HC_TK_LANG

[table description]

  • LTK_NAZOV - [column description]
  • LTK_LANG - [column description]
> B_JAZYK.JAZ_KOD_JAZYKA
  • LTK_ID - [column description]
> HC_TK.TK_ID

HC_TL

[table description]

  • TL_TYPTL - [column description]
  • TL_POPIS - [column description]
  • TL_ID - [column description]

HC_TL_SEKV

[table description]

  • TS_ID_TAG - [column description]
  • TS_START_SEKV - [column description]
  • TS_STOP_SEKV - [column description]
  • TS_TL_ID - [column description]
> HC_TL.TL_ID

HC_TL_TAG

[table description]

  • TT_ID_TAG - [column description]
  • TT_NAZOV - [column description]
  • TT_SYSTEMOVY - [column description]
  • TT_POPIS - [column description]

HC_TP

[table description]

  • TP_CISLO_TECH_PRIESTORU - [column description]
  • TP_NAZOV - [column description]
  • TP_TELEFON - [column description]
  • TP_POSCHODIE - [column description]
  • TP_RAJON - [column description]
  • TP_STAKT - [column description]
  • TP_STDEF - [column description]
  • TP_VYTAZ - [column description]
  • TP_POCET_POZICII - [column description]
  • TP_COLOR - [column description]
  • TP_VISIBLE_ALL - [column description]
  • TP_ID_TOVAR - [column description]
> H_CP_TOVAR.CTO_ID_TOVAR
  • TP_TPT_ID - [column description]
> HC_TP_TYP.TPT_ID

HC_TP_CASOVY_TYP

[table description]

  • TPC_CASOVY_TYP - [column description]
  • TPC_NAZOV_TYPU - [column description]
  • TPC_POCET_MINUT - [column description]
  • TPC_PORADIE - [column description]

HC_TP_CASOVY_TYP_LANG

[table description]

  • LTPC_ID - [column description]
  • LTPC_NAZOV_TYPU - [column description]
  • LTPC_LANG - [column description]

HC_TP_OPRAVNENIA

[table description]

  • TPR_CISLO_TECH_PRIESTORU - [column description]
  • TPR_CISPR - [column description]

HC_TP_POZICIA

[table description]

  • TPP_CISLO_TECH_PRIESTORU - [column description]
  • TPP_POZICIA - [column description]
  • TPP_NAZOV - [column description]
  • TPP_ZDIELANA_SKUPINA - [column description]
  • TPP_ID_TOVAR - [column description]
> H_CP_TOVAR.CTO_ID_TOVAR

HC_TPT_OTVOR_HODINY

[table description]

  • TPH_CASOD - [column description]
  • TPH_CASDO - [column description]
  • TPH_ID - [column description]
  • TPH_TPT_ID - [column description]
> HC_TP_TYP.TPT_ID

HC_TP_TYP

[table description]

  • TPT_NAZOV_TYPU - [column description]
  • TPT_CASOVY_TYP - [column description]
  • TPT_PORADIE - [column description]
  • TPT_ID - [column description]

HC_TYP_PRODUKTU

[table description]

  • TPD_KOD_PRODUKTU - [column description]
  • TPD_NAZOV_TYPU_PRODUKTU - [column description]
  • TPD_PORADIE - [column description]

HC_TYP_PRODUKTU_LANG

[table description]

  • LTPD_ID - [column description]
  • LTPD_NAZOV_TYPU_PRODUKTU - [column description]
  • LTPD_LANG - [column description]

HC_UBYTOVACI_BLOK

[table description]

  • HUB_ID - [column description]
  • HUB_ID_TEXT - [column description]
> H_CP_TEXTS.TXTS_ID
  • HUB_SYSTEM - [column description]

HC_USEK

[table description]

  • HUS_ID - [column description]
  • HUS_ID_TEXT - [column description]
> H_CP_TEXTS.TXTS_ID
  • HUS_SYSTEM - [column description]

HC_VLAJKA

[table description]

  • VL_VLAJKA - [column description]
  • VL_ID - [column description]
  • VL_NAZOV - [column description]

HC_VLAJKA_LANG

[table description]

  • LVL_ID - [column description]
  • LVL_NAZOV - [column description]
  • LVL_LANG - [column description]

HC_VLASTNOSTI_HOSTA

[table description]

  • VH_KOD - [column description]
  • VH_NAZOV - [column description]
  • VH_PRIORITA - [column description]
  • VH_CAS_ZAPNUTIA - [column description]
  • VH_CAS_VYPNUTIA - [column description]
  • VH_CAS_PRED - [column description]
  • VH_CAS_ZA - [column description]
  • VH_IMAGE - [column description]
  • VH_ZOBRAZOVAT_IKONU - [column description]

HC_VLASTNOSTI_HOSTA_LANG

[table description]

  • LVH_ID - [column description]
  • LVH_NAZOV - [column description]
  • LVH_LANG - [column description]

HC_ZALOHA_SETTINGS

[table description]

  • CZS_ID - [column description]
  • CZS_ID_TEXT - [column description]
> H_CP_TEXTS.TXTS_ID
  • CZS_DPH - [column description]
  • CZS_MENIT_CENA - [column description]
  • CZS_ZALOHA_HODNOTA - [column description]
  • CZS_ZALOHA_PERCENTO - [column description]
  • CZS_ID_NA_KATEGORIU - [column description]
> H_CP_KATEGORIA_TOVARU.CKT_ID_KATEGORIA_TOVARU
  • CZS_ID_NA_SLUZBU - [column description]
> H_CP_TOVAR.CTO_ID_TOVAR
  • CZS_SYSTEM - [column description]
  • CZS_PERCENTUALNA - [column description]
  • CZS_STAV - [column description]
  • CZS_NEPOCITAT_MP_ZALOHA - [column description]

HC_ZO

[table description]

  • ZO_KODZO - [column description]
  • ZO_NAZZO - [column description]
  • ZO_NEZAV - [column description]
  • ZO_VSTUP - [column description]
  • ZO_EXPAR - [column description]
  • ZO_TXTP1 - [column description]
  • ZO_TXTP2 - [column description]
  • ZO_REPORT_ID - [column description]

HC_ZO_LANG

[table description]

  • LZO_ID - [column description]
> HC_ZO.ZO_KODZO
  • LZO_NAZZO - [column description]
  • LZO_LANG - [column description]
> B_JAZYK.JAZ_KOD_JAZYKA

HC_ZO_VYBER

[table description]

  • ZOV_KODZO - [column description]
  • ZOV_POCET - [column description]

HK_BILL_CANCELLED

[table description]

  • BC_ID - [column description]
  • BC_ID_BILL - [column description]
> HK_PO.PO_CISPZ
  • BC_ID_BILL_CANCELLED - [column description]
> HK_PO.PO_CISPZ
  • BC_DOC_TYPE - [column description]

HK_BILL_FISCAL_MODULE

[table description]

  • BFM_ID - [column description]
  • BFM_ID_BILL - [column description]
> HK_PO.PO_CISPZ
  • 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]

HK_BOOKINGS_BED_TYPES

[table description]

  • BBT_ID - [column description]
  • BBT_BOOKING_ID - [column description]
> HK_OBJEDNAVKA.OB_CISOB
  • BBT_BED_TYPE_ID - [column description]
> HC_BED_TYPE.HBT_ID
  • BBT_COUNT - [column description]

HK_BUDENIE_TELEFONOM

[table description]

  • BT_CISHO - [column description]
> HK_DO.DO_CISHO
  • BT_CAS_BUDENIA - [column description]
  • BT_OPAKOVANE_BUDENIA - [column description]

HK_CLOSING

[table description]

  • HKC_ID - [column description]
  • HKC_USER_ID - [column description]
> L_UZIVATEL.UZ_ID_UZIVATEL
  • HKC_INIT_TIME - [column description]
  • HKC_FINISH_TIME - [column description]
  • HKC_HOTEL_DATE - [column description]

HK_CLOSING_FISCAL_MODULE

[table description]

  • CFM_ID - [column description]
  • CFM_FM_CLOSING_ID - [column description]
  • CFM_FM_SERIAL_NUMBER - [column description]
  • CFM_DKP - [column description]

HK_DN

[table description]

  • DN_CISDN - [column description]
  • DN_CPRAC - [column description]
  • DN_CASZZ - [column description]
  • DN_STAHO - [column description]
  • DN_IZBA - [column description]
  • DN_DATNA - [column description]
  • DN_DATOD - [column description]
  • DN_TITHO - [column description]
  • DN_MENHO - [column description]
  • DN_PRZHO - [column description]
  • DN_MESTO - [column description]
  • DN_ULICA - [column description]
  • DN_DATNR - [column description]
  • DN_TYPDO - [column description]
  • DN_CISDO - [column description]
  • DN_SPECI - [column description]
  • DN_POZNA - [column description]
  • DN_VIPHOST - [column description]
  • DN_ID_HOREC_LANGUAGE - [column description]
> HC_HOREC_LANGUAGE.HLNG_ID_LANGUAGE
  • DN_ID_STAT - [column description]
> HC_ST.ST_ID_STAT

HK_DO

[table description]

  • DO_CISHO - [column description]
  • DO_CISSK - [column description]
  • DO_PLATBY - [column description]
  • DO_NAVSTEV - [column description]
  • DO_DATNA - [column description]
  • DO_IZDEN - [column description]
  • DO_MPDEN - [column description]
  • DO_DATOD - [column description]
  • DO_DATNR - [column description]
  • DO_CENHO - [column description]
  • DO_TOTAL - [column description]
  • DO_DEBET - [column description]
  • DO_TABLE_NR - [column description]
  • DO_PLAOK - [column description]
  • DO_CPRAC - [column description]
  • DO_CASZZ - [column description]
  • DO_STAHO - [column description]
  • DO_SPOPL - [column description]
  • DO_KODCK - [column description]
  • DO_EXT_HOST - [column description]
  • DO_DOMCU - [column description]
  • DO_TARIF - [column description]
  • DO_TITHO - [column description]
  • DO_MENHO - [column description]
  • DO_PRZHO - [column description]
  • DO_MESTO - [column description]
  • DO_PSCME - [column description]
  • DO_ULICA - [column description]
  • DO_TELHO - [column description]
  • DO_SPZVO - [column description]
  • DO_FAXHO - [column description]
  • DO_STAY_PURPOSE - [column description]
  • DO_TYPDO - [column description]
  • DO_CISDO - [column description]
  • DO_POZNA - [column description]
  • DO_ARAHO - [column description]
  • DO_POPUC - [column description]
  • DO_SPECI - [column description]
  • DO_POPOS - [column description]
  • DO_EMAIL - [column description]
  • DO_CHECKOUT_REAL_DATE - [column description]
  • DO_CASPR - [column description]
  • DO_KARTAZAMOK - [column description]
  • DO_KARTAKLUB - [column description]
  • DO_VIZUM - [column description]
  • DO_ZABLOKOVANY_UCET - [column description]
  • DO_EVIDOB - [column description]
  • DO_CIS_HOST_OBJ - [column description]
  • DO_ID_CENOVY_PROFIL - [column description]
  • DO_KOD_MENY - [column description]
  • DO_LEVELID - [column description]
  • DO_ID_IZBA - [column description]
> HC_IZ.IZ_ID_IZBA
  • DO_PRMS_ID - [column description]
> HC_PTV_PERMISSION.PRMS_ID
  • DO_ID_HOREC_LANGUAGE - [column description]
> HC_HOREC_LANGUAGE.HLNG_ID_LANGUAGE
  • DO_ID_KATEGORIA_HOSTA - [column description]
> HC_KH.KH_ID_KATEGORIA
  • DO_ID_STAT - [column description]
> HC_ST.ST_ID_STAT
  • DO_ID_LOCAL_TAX - [column description]
> H_CP_TOVAR.CTO_ID_TOVAR
  • DO_PARTIAL_CHECKOUT - [column description]
  • DO_EXTERNAL_NUMBER - [column description]
  • DO_EXTERNAL_NUMBER_TYPE - [column description]
> HC_EXTERNAL_NUMBER_TYPE.ENT_ID
  • DO_BOOKING_NUMBER - [column description]
  • DO_BOOKING_NUMBER_INHERITED - [column description]
  • DO_GUEST_AGE_INTERVAL_ID - [column description]
> HC_GUEST_AGE_INTERVAL.GAI_ID
  • DO_BED_TYPE_ID - [column description]
> HC_BED_TYPE.HBT_ID
  • DO_GUEST_ID - [column description]
> HK_DY.DY_ID
  • DO_POCET_PRENOCOVANI - [column description]
  • DO_GUEST_TITLE_ID - [column description]
> HC_GUEST_TITLE.HGT_ID
  • DO_CHANGE_HOTEL_DATE - [column description]
  • DO_PLACE_OF_BIRTH - [column description]
  • DO_JOINED_ROOM_ID - [column description]
> HC_JOINED_ROOM.JR_ID
  • DO_DISCOUNT_PROFILE_ID - [column description]
> HC_DISCOUNT_PROFILE.HDP_ID
  • DO_FLEXI_RATE_GUEST_ID - [column description]
> FLXR_GUEST.FLXRG_ID
  • DO_ACCOMMODATION_PRICE_TYPE - [column description]

HK_DOCUMENT_NUMBERING

[table description]

  • KDN_ID - [column description]
  • KDN_ID_DOCUMENT_TYPE - [column description]
> HC_DOCUMENT_TYPE.DCT_ID
  • KDN_ID_DOC_NUMBERING_COUNTER - [column description]
> HK_DOCUMENT_NUMBERING_COUNTER.KDNC_ID
  • KDN_ACTUAL - [column description]
  • KDN_NAME - [column description]

HK_DOCUMENT_NUMBERING_COUNTER

[table description]

  • KDNC_ID - [column description]
  • KDNC_ID_DOC_NUMBERING_RULE - [column description]
> HC_DOCUMENT_NUMBERING_RULES.CDNR_ID
  • KDNC_NEXT_CHANGE_DATE - [column description]
  • KDNC_VALUE - [column description]
  • KDNC_LAST_CHANGE_DATE - [column description]
  • KDNC_CHANGE_DATE - [column description]
  • KDNC_LAST_USER_CHANGE - [column description]
  • KDNC_USER_ID - [column description]
> L_UZIVATEL.UZ_ID_UZIVATEL

HK_DO_MARKETING_CATEGORY

[table description]

  • DOC_STAY_ID - [column description]
> HK_DO.DO_CISHO
  • DOC_CATEGORY_ID - [column description]
> HC_MARKETING_CATEGORY.HMC_ID
  • DOC_CATEGORY_TYPE_ID - [column description]
> HC_MARKETING_CATEGORY_TYPE.MCT_ID

HK_DO_MARKETING_COMPANY

[table description]

  • DOR_STAY_ID - [column description]
> HK_DO.DO_CISHO
  • DOR_COMPANY_ID - [column description]
> HC_COMPANY.HCC_ID
  • DOR_RELATION_ID - [column description]
> HC_MARKETING_RELATION.HMR_ID

HK_DO_MARKETING_PARAMETER

[table description]

  • STP_STAY_ID - [column description]
> HK_DO.DO_CISHO
  • STP_PARAMETER_ID - [column description]
> HC_MARKETING_PARAMETER.HMP_ID

HK_DY

[table description]

  • DY_DATNR - [column description]
  • DY_CENHO - [column description]
  • DY_TABLE_NR - [column description]
  • DY_CPRAC - [column description]
  • DY_CASZZ - [column description]
  • DY_SPOPL - [column description]
  • DY_EXT_HOST - [column description]
  • DY_DOMCU - [column description]
  • DY_TARIF - [column description]
  • DY_TITHO - [column description]
  • DY_MENHO - [column description]
  • DY_PRZHO - [column description]
  • DY_MESTO - [column description]
  • DY_PSCME - [column description]
  • DY_ULICA - [column description]
  • DY_TELHO - [column description]
  • DY_SPZVO - [column description]
  • DY_FAXHO - [column description]
  • DY_STAY_PURPOSE - [column description]
  • DY_POZNA - [column description]
  • DY_ARAHO - [column description]
  • DY_POPUC - [column description]
  • DY_SPECI - [column description]
  • DY_POPOS - [column description]
  • DY_EMAIL - [column description]
  • DY_KARTAZAMOK - [column description]
  • DY_KARTAKLUB - [column description]
  • DY_VIZUM - [column description]
  • DY_ZABLOKOVANY_UCET - [column description]
  • DY_ID_CENOVY_PROFIL - [column description]
  • DY_KOD_MENY - [column description]
  • DY_LEVELID - [column description]
  • DY_ID_IZBA - [column description]
> HC_IZ.IZ_ID_IZBA
  • DY_PRMS_ID - [column description]
> HC_PTV_PERMISSION.PRMS_ID
  • DY_ID_HOREC_LANGUAGE - [column description]
> HC_HOREC_LANGUAGE.HLNG_ID_LANGUAGE
  • DY_ID_KATEGORIA_HOSTA - [column description]
> HC_KH.KH_ID_KATEGORIA
  • DY_ID_STAT - [column description]
> HC_ST.ST_ID_STAT
  • DY_ID_LOCAL_TAX - [column description]
> H_CP_TOVAR.CTO_ID_TOVAR
  • DY_ID - [column description]
  • DY_GUEST_AGE_INTERVAL_ID - [column description]
> HC_GUEST_AGE_INTERVAL.GAI_ID
  • DY_GUEST_TITLE_ID - [column description]
> HC_GUEST_TITLE.HGT_ID
  • DY_GUEST_PROFILE_ID - [column description]
> HC_GUEST_PROFILE.HGP_ID
  • DY_DISCOUNT_PROFILE_ID - [column description]
> HC_DISCOUNT_PROFILE.HDP_ID
  • DY_ACCOMMODATION_PRICE_TYPE - [column description]

HK_DY_CREDIT_CARDS

[table description]

  • HDCC_ID - [column description]
  • HDCC_CREDIT_CARD_TYPE_ID - [column description]
> HC_PK.PK_ID
  • HDCC_GUEST_ID - [column description]
> HK_DY.DY_ID
  • HDCC_EXPIRE_MONTH - [column description]
  • HDCC_EXPIRE_YEAR - [column description]
  • HDCC_NUMBER - [column description]

HK_DY_DOCUMENTS

[table description]

  • HGD_ID - [column description]
  • HGD_DOCUMENT_TYPE_ID - [column description]
> HC_CESTOVNY_DOKLAD.CD_ID
  • HGD_GUEST_ID - [column description]
> HK_DY.DY_ID
  • HGD_VALUE - [column description]

HK_DY_MARKETING_CATEGORY

[table description]

  • DYC_GUEST_ID - [column description]
> HK_DY.DY_ID
  • DYC_CATEGORY_ID - [column description]
> HC_MARKETING_CATEGORY.HMC_ID
  • DYC_CATEGORY_TYPE_ID - [column description]
> HC_MARKETING_CATEGORY_TYPE.MCT_ID

HK_DY_MARKETING_COMPANY

[table description]

  • DYR_GUEST_ID - [column description]
> HK_DY.DY_ID
  • DYR_COMPANY_ID - [column description]
> HC_COMPANY.HCC_ID
  • DYR_RELATION_ID - [column description]
> HC_MARKETING_RELATION.HMR_ID

HK_DY_MARKETING_PARAMETER

[table description]

  • DYP_GUEST_ID - [column description]
> HK_DY.DY_ID
  • DYP_PARAMETER_ID - [column description]
> HC_MARKETING_PARAMETER.HMP_ID

HK_ELEMENT_MAP_SEARCH_FILTER

[table description]

  • EMSF_ID - [column description]
  • EMSF_CISPS - [column description]
> HC_PS.PS_CISPS
  • EMSF_USER_ID - [column description]
> L_UZIVATEL.UZ_ID_UZIVATEL
  • EMSF_SURNAME - [column description]
  • EMSF_FIRST_NAME - [column description]
  • EMSF_DATE_FROM - [column description]
  • EMSF_DATE_TO - [column description]
  • EMSF_ROOM_NUMBER - [column description]
  • EMSF_ACCOM_BLOCK_ID - [column description]
  • EMSF_GROUP_ATTR - [column description]
  • EMSF_RESERVATION_DATE - [column description]
  • EMSF_EXTERNAL_NUMBER - [column description]
  • EMSF_EXTERNAL_NUMBER_TYPE - [column description]
  • EMSF_BOOKING_NUMBER - [column description]
  • EMSF_EVIDENCE_NUMBER - [column description]
  • EMSF_PREFIX_SEARCH - [column description]
  • EMSF_IGNORE_CASE - [column description]
  • EMSF_IGNORE_DIACRITICS - [column description]
  • EMSF_BOOKINGS_INCLUDED - [column description]
  • EMSF_ACCOM_GUESTS_INCLUDED - [column description]
  • EMSF_FORMER_GUESTS_INCLUDED - [column description]
  • EMSF_EXTENDED_FILTER - [column description]
  • EMSF_COUNTRY_ID - [column description]
> HC_ST.ST_ID_STAT
  • EMSF_GUEST_CATEGORY_ID - [column description]
> HC_KH.KH_ID_KATEGORIA

HK_EXTERNY_SKLAD

[table description]

  • ES_ID - [column description]
  • ES_KOD - [column description]
  • ES_CASZZ - [column description]
  • ES_ID_EXT_SKLAD - [column description]
  • ES_NAZOV_TOVARU - [column description]
  • ES_POCET - [column description]
  • ES_JEDNOTKOVA_CENA - [column description]
  • ES_SADZBA_DPH - [column description]
  • ES_ID_EXT_SYS - [column description]
  • ES_EXT_ID_UCTOVNY_DRUH - [column description]

HK_FA

[table description]

  • FA_CASZZ - [column description]
  • FA_CENAF - [column description]
  • FA_DATOF - [column description]
  • FA_DATSF - [column description]
  • FA_NAZOD - [column description]
  • FA_ULIOD - [column description]
  • FA_MESOD - [column description]
  • FA_ICOOD - [column description]
  • FA_DICOD - [column description]
  • FA_UCEOD - [column description]
  • FA_BANKA - [column description]
  • FA_DATUH - [column description]
  • FA_IBANOD - [column description]
  • FA_DATZDANPLN - [column description]
  • FA_ZAPLATENE_PREVODOM - [column description]
  • FA_CISLO_ZAKAZKY - [column description]
  • FA_CISPZ - [column description]
> HK_PO.PO_CISPZ
  • FA_ID_ODBERATEL - [column description]
> HK_OD.OD_CISOD
  • FA_COMPANY_ID - [column description]
> HC_COMPANY.HCC_ID
  • FA_GUEST_ID - [column description]
> HK_DY.DY_ID
  • FA_BOOKING_GUEST_ID - [column description]
> HK_OBJEDNAVKA_HOST.OBH_CIS_HOST_OBJ

HK_FI

[table description]

  • FI_CISPS - [column description]
  • FI_DATA - [column description]

HK_FISCAL_INVOICE

[table description]

  • HFI_ID - [column description]
  • HFI_NAME - [column description]
  • HFI_SAVE_DATE - [column description]
  • HFI_HOTEL_DATE - [column description]
  • HFI_SUM - [column description]
  • HFI_CURRENCY_CODE - [column description]
  • HFI_BILL_ID - [column description]
> HK_PO.PO_CISPZ
  • HFI_USER_ID - [column description]
> L_UZIVATEL.UZ_ID_UZIVATEL
  • HFI_MESSAGE - [column description]
  • HFI_IS_SENT - [column description]
  • HFI_PAYMENT_ID - [column description]
> H_CP_DRUH_PLATBY.CDP_ID_DRUH_PLATBY

HK_GUARANTEE_DEPOSIT

[table description]

  • GDP_ID - [column description]
  • GDP_BILL_NR - [column description]
  • GDP_DATE - [column description]
  • GDP_HOTEL_DATE - [column description]
  • GDP_GUEST_ID - [column description]
> HK_DO.DO_CISHO
  • GDP_AMOUNT - [column description]
  • GDP_CURRENCY_CODE - [column description]
  • GDP_OPPOSITE_ID - [column description]
  • GDP_USER_ID - [column description]

HK_IN

[table description]

  • IN_CISIN - [column description]
  • IN_POPIS - [column description]
  • IN_NAZOV - [column description]
  • IN_SUBNA - [column description]

HK_OBJEDNAVKA

[table description]

  • OB_CISOB - [column description]
  • OB_CISSK - [column description]
> HK_SO.SO_CISSK
  • OB_CIS_HOST_OBJ_VLASTNIK - [column description]
  • OB_EVIDO - [column description]
  • OB_DATNA - [column description]
  • OB_DATOD - [column description]
  • OB_DATPO - [column description]
  • OB_CASPR - [column description]
  • OB_HODIN - [column description]
  • OB_POCNO - [column description]
  • OB_FIXIZ - [column description]
  • OB_STAVO - [column description]
  • OB_POZNA - [column description]
  • OB_CHANGED_USER_ID - [column description]
  • OB_CHANGED_DATE - [column description]
  • OB_VARSYMBOL - [column description]
  • OB_ID_IZBA - [column description]
> HC_IZ.IZ_ID_IZBA
  • OB_NASTUPENE_ID_IZBA - [column description]
> HC_IZ.IZ_ID_IZBA
  • OB_BOOKING_NUMBER - [column description]
  • OB_BOOKING_NUMBER_INHERITED - [column description]
  • OB_CHANGE_HOTEL_DATE - [column description]
  • OB_AUTH_LEVEL_BOOKING_ID - [column description]
> HC_AUTH_LEVEL_BOOKING.ALB_ID
  • OB_JOINED_ROOM_ID - [column description]
> HC_JOINED_ROOM.JR_ID
  • OB_JOINED_ROOM_TYPE_ID - [column description]
> HC_JOINED_ROOM_TYPE.JRT_ID
  • OB_CHECKEDIN_JOINEDR_ID - [column description]
> HC_JOINED_ROOM.JR_ID
  • OB_ROOM_TYPE_ID - [column description]
> HC_CE.CE_CISTY
  • OB_FLEXI_RATE_GUEST_ID - [column description]
> FLXR_GUEST.FLXRG_ID

HK_OBJEDNAVKA_HOST

[table description]

  • OBH_CISOB - [column description]
  • OBH_CIS_HOST_OBJ - [column description]
  • OBH_CENHO - [column description]
  • OBH_SUMOB - [column description]
  • OBH_ZALOB - [column description]
  • OBH_SPOOB - [column description]
  • OBH_SPOPL - [column description]
  • OBH_PRIST - [column description]
  • OBH_TITHO - [column description]
  • OBH_MENHO - [column description]
  • OBH_PRZHO - [column description]
  • OBH_MESTO - [column description]
  • OBH_PSCME - [column description]
  • OBH_ULICA - [column description]
  • OBH_TELHO - [column description]
  • OBH_SPZVO - [column description]
  • OBH_ARAHO - [column description]
  • OBH_SPECI - [column description]
  • OBH_CUCOB - [column description]
  • OBH_EMAIL - [column description]
  • OBH_DATNR - [column description]
  • OBH_TYPDO - [column description]
  • OBH_CISDO - [column description]
  • OBH_KARTAZAMOK - [column description]
  • OBH_KARTAKLUB - [column description]
  • OBH_STAV_HOST_OBJ - [column description]
  • OBH_CHANGED_USER_ID - [column description]
> L_UZIVATEL.UZ_ID_UZIVATEL
  • OBH_CREATED_DATE - [column description]
  • OBH_POZNA - [column description]
  • OBH_ID_CENOVY_PROFIL - [column description]
  • OBH_KOD_MENY - [column description]
  • OBH_NASTUPENE_ID_IZBA - [column description]
> HC_IZ.IZ_ID_IZBA
  • OBH_PRMS_ID - [column description]
> HC_PTV_PERMISSION.PRMS_ID
  • OBH_ID_HOREC_LANGUAGE - [column description]
> HC_HOREC_LANGUAGE.HLNG_ID_LANGUAGE
  • OBH_ID_KATEGORIA_HOSTA - [column description]
> HC_KH.KH_ID_KATEGORIA
  • OBH_ID_STAT - [column description]
> HC_ST.ST_ID_STAT
  • OBH_ID_LOCAL_TAX - [column description]
> H_CP_TOVAR.CTO_ID_TOVAR
  • OBH_EXTERNAL_NUMBER - [column description]
  • OBH_EXTERNAL_NUMBER_TYPE - [column description]
> HC_EXTERNAL_NUMBER_TYPE.ENT_ID
  • OBH_GUEST_AGE_INTERVAL_ID - [column description]
> HC_GUEST_AGE_INTERVAL.GAI_ID
  • OBH_BED_TYPE_ID - [column description]
> HC_BED_TYPE.HBT_ID
  • OBH_GUEST_ID - [column description]
> HK_DY.DY_ID
  • OBH_GUEST_TITLE_ID - [column description]
> HC_GUEST_TITLE.HGT_ID
  • OBH_CREATED_HOTEL_DATE - [column description]
  • OBH_CREATED_USER_ID - [column description]
> L_UZIVATEL.UZ_ID_UZIVATEL
  • OBH_PLACE_OF_BIRTH - [column description]
  • OBH_CREDIT_CARD_TYPE_ID - [column description]
> HC_PK.PK_ID
  • OBH_CREDIT_CARD_NUMBER - [column description]
  • OBH_CREDIT_CARD_EXP_MONTH - [column description]
  • OBH_CREDIT_CARD_EXP_YEAR - [column description]
  • OBH_DISCOUNT_PROFILE_ID - [column description]
> HC_DISCOUNT_PROFILE.HDP_ID
  • OBH_CHANGE_HOTEL_DATE - [column description]
  • OBH_CHANGED_DATE - [column description]
  • OBH_ROOM_ID - [column description]
> HC_IZ.IZ_ID_IZBA
  • OBH_DESCRIPTION_ID - [column description]
> DB_CLOB.DC_ID
  • OBH_DESCRIPTION_BILL_ID - [column description]
> DB_CLOB.DC_ID
  • OBH_ACCOMMODATION_PRICE_TYPE - [column description]

HK_OBJ_HOST_CATEGORY

[table description]

  • BGC_BOOKING_GUEST_ID - [column description]
> HK_OBJEDNAVKA_HOST.OBH_CIS_HOST_OBJ
  • BGC_CATEGORY_ID - [column description]
> HC_MARKETING_CATEGORY.HMC_ID
  • BGC_CATEGORY_TYPE_ID - [column description]
> HC_MARKETING_CATEGORY_TYPE.MCT_ID

HK_OBJ_HOST_COMPANY

[table description]

  • OHC_ORDER_GUEST_ID - [column description]
> HK_OBJEDNAVKA_HOST.OBH_CIS_HOST_OBJ
  • OHC_COMPANY_ID - [column description]
> HC_COMPANY.HCC_ID
  • OHC_RELATION_ID - [column description]
> HC_MARKETING_RELATION.HMR_ID

HK_OBJ_HOST_PARAMETER

[table description]

  • BGP_BOOKING_GUEST_ID - [column description]
> HK_OBJEDNAVKA_HOST.OBH_CIS_HOST_OBJ
  • BGP_PARAMETER_ID - [column description]
> HC_MARKETING_PARAMETER.HMP_ID

HK_OD

[table description]

  • OD_CISOD - [column description]
  • OD_DATUM - [column description]
  • OD_CENAF - [column description]
  • OD_POCET - [column description]
  • OD_NAZOD - [column description]
  • OD_ULIOD - [column description]
  • OD_MESOD - [column description]
  • OD_ICOOD - [column description]
  • OD_DICOD - [column description]
  • OD_UCEOD - [column description]
  • OD_BANKA - [column description]
  • OD_TELEF - [column description]
  • OD_EMAIL - [column description]
  • OD_IBANOD - [column description]

HK_OS

[table description]

  • OS_CISOS - [column description]
  • OS_CPRAC - [column description]
  • OS_CASZZ - [column description]
  • OS_CISHO - [column description]
  • OS_CISSK - [column description]
  • OS_PLATENA - [column description]
  • OS_DATZA - [column description]
  • OS_DATKO - [column description]
  • OS_POCET - [column description]
  • OS_CASPO - [column description]
  • OS_NUTUP - [column description]
  • OS_SLDEN - [column description]
  • OS_NOTE - [column description]
  • OS_TRVALA - [column description]
  • OS_CIS_HOST_OBJ - [column description]
  • OS_ID_TOVAR - [column description]
> H_CP_TOVAR.CTO_ID_TOVAR
  • OS_Z_CEN_PROFILU - [column description]
  • OS_ID_CISOS - [column description]
  • OS_CCSO_ID - [column description]
  • OS_INTERNA - [column description]
  • OS_PO_POLNOCI - [column description]
  • OS_BALIK_TYP - [column description]
  • OS_REL_ZACIATOK - [column description]
  • OS_REL_KONIEC - [column description]

HK_PL

[table description]

  • PL_CASZZ - [column description]
  • PL_CPRAC - [column description]
  • PL_ZADEN - [column description]
  • PL_CISLI - [column description]
  • PL_KODPA - [column description]
  • PL_NAZPA - [column description]
  • PL_NAZPP - [column description]
  • PL_DATPA - [column description]
  • PL_CASPA - [column description]
  • PL_DATOL - [column description]
  • PL_CASOL - [column description]
  • PL_SUMPA - [column description]
  • PL_CISUC - [column description]
  • PL_STAPL - [column description]
  • PL_VYBER - [column description]
  • PL_ID - [column description]

HK_PO

[table description]

  • PO_CISPZ - [column description]
  • PO_CPRAC - [column description]
  • PO_CASZZ - [column description]
  • PO_CISUC - [column description]
  • PO_ZADEN - [column description]
  • PO_CISHO - [column description]
  • PO_CISSK - [column description]
  • PO_POZNA - [column description]
  • PO_CISPS - [column description]
  • PO_CISFI - [column description]
  • PO_NAZFD - [column description]
  • PO_CIS_HOST_OBJ - [column description]
  • PO_TYP_UCTU - [column description]
  • PO_KOD_DOMACEJ_MENY - [column description]
  • PO_OBJEM_V_DOMACEJ_MENE - [column description]
  • PO_STAV - [column description]
  • PO_KOD_DOMACA_MENA_UCET - [column description]
  • PO_CHANGE_HOTEL_DATE - [column description]
  • PO_EXTERNAL - [column description]

HK_POBYT_HOSTA

[table description]

  • PH_CISHO - [column description]
> HK_DO.DO_CISHO
  • PH_EXT_HOST - [column description]
  • PH_DATNA - [column description]
  • PH_DATOD - [column description]
  • PH_POSLEDNY_POBYT - [column description]
  • PH_ID_IZBA - [column description]
> HC_IZ.IZ_ID_IZBA
  • PH_JOINED_ROOM_ID - [column description]
> HC_JOINED_ROOM.JR_ID

HK_PO_DPH

[table description]

  • POD_CISPZ - [column description]
> HK_PO.PO_CISPZ
  • POD_ID_DPH - [column description]
> H_CP_HLADINA_DPH.CHD_ID_HLADINA_DPH
  • POD_KOD_MENY - [column description]
> K_KL_MENA.KLM_KOD_MENY
  • POD_ZAKLAD - [column description]
  • POD_CIASTKA - [column description]

HK_PO_DPH_FISCAL

[table description]

  • PODF_CISPZ - [column description]
> HK_PO.PO_CISPZ
  • PODF_ID_DPH - [column description]
> H_CP_HLADINA_DPH.CHD_ID_HLADINA_DPH
  • PODF_KOD_MENY - [column description]
> K_KL_MENA.KLM_KOD_MENY
  • PODF_ZAKLAD - [column description]
  • PODF_CIASTKA - [column description]

HK_POKLADNA

[table description]

  • POK_UZADEN - [column description]
  • POK_ID_DRUH_PLATBY - [column description]
  • POK_KOD_MENY - [column description]
  • POK_OBJEM_V_DANEJ_MENE_PRENOS - [column description]

HK_POKLADNA_MIN_STAV

[table description]

  • POM_KOD_MENY - [column description]
> K_KL_MENA.KLM_KOD_MENY
  • POM_OBJEM_V_DANEJ_MENE - [column description]

HK_PO_PLATBA

[table description]

  • POP_PORADIE - [column description]
  • POP_MENA_VYBRANA_KOD - [column description]
  • POP_MENA_VYBRANA_JEDNOTKA - [column description]
  • POP_MENA_VYBRANA_KURZ - [column description]
  • POP_MENA_VYBRANA_SUMA - [column description]
  • POP_MENA_DOMACA_KOD - [column description]
  • POP_MENA_DOMACA_SUMA - [column description]
  • POP_MENA_DOMACA_VRATENE - [column description]
  • POP_CISPZ - [column description]
> HK_PO.PO_CISPZ
  • POP_ID_DRUH_PLATBY - [column description]

HK_PO_PLATBA_EXTERNA

[table description]

  • EP_PORADIE_HK_PO_PLATBA - [column description]
  • EP_KODPK - [column description]
  • EP_CISPK - [column description]
  • EP_POPPK - [column description]
  • EP_DATUH - [column description]
  • EP_POSTA - [column description]
  • EP_CISPZ - [column description]
> HK_PO.PO_CISPZ
  • EP_ID_PLATOBNA_KARTA - [column description]
> HC_PK.PK_ID
  • EP_PLAT_KARTA_MESIAC - [column description]
  • EP_PLAT_KARTA_ROK - [column description]
  • EP_CHEQUE_TYPE_ID - [column description]
> HC_PAYMENT_CHEQUE_TYPE.PCT_ID
  • EP_CHEQUE_NUMBER - [column description]

HK_PO_VALUTY

[table description]

  • POV_CISPZ - [column description]
  • POV_MENA_KONVERZNA_KOD - [column description]
  • POV_MENA_KONVERZNA_JEDNOTKA - [column description]
  • POV_MENA_KONVERZNA_KURZ - [column description]
  • POV_MENA_KONVERZNA_SUMA_INFO - [column description]
  • POV_MENA_VYBRANA_KOD - [column description]
  • POV_MENA_VYBRANA_JEDNOTKA - [column description]
  • POV_MENA_VYBRANA_KURZ - [column description]
  • POV_MENA_VYBRANA_SUMA_INFO - [column description]
  • POV_MENA_VYBRANA_SUMA_PLATBA - [column description]
  • POV_MENA_VYBRANA_SUMA_ROZDIEL - [column description]
  • POV_MENA_DOMACA_KOD - [column description]

HK_PRESUNY_TRZIEB

[table description]

  • KPT_ID_PRESUN - [column description]
  • KPT_CISTR - [column description]
  • KPT_POCET - [column description]
  • KPT_NOVECISTR - [column description]
  • KPT_CASZZ - [column description]
  • KPT_POBYTOVY_DEN - [column description]
  • KPT_CISPS - [column description]
  • KPT_CISPR - [column description]
  • KPT_CISHO - [column description]
  • KPT_NOVECISHO - [column description]
  • KPT_CISSK - [column description]
  • KPT_NOVECISSK - [column description]
  • KPT_CIS_HOST_OBJ - [column description]
  • KPT_NOVECIS_HOST_OBJ - [column description]

HK_PRICE

[table description]

  • PRC_ID_PRICES - [column description]
> HK_PRICES.PRCS_ID
  • PRC_KOD_MENY - [column description]
  • PRC_OBJEM_V_DANEJ_MENE - [column description]
  • PRC_ID - [column description]

HK_PRICES

[table description]

  • PRCS_ID - [column description]

HK_RE

[table description]

  • RE_CISRE - [column description]
  • RE_CASZZ - [column description]
  • RE_EXT_HOST - [column description]
  • RE_CISHO - [column description]
  • RE_MENHO - [column description]
  • RE_KODRT - [column description]
  • RE_CASRT - [column description]
  • RE_DLZRT - [column description]
  • RE_CISPU - [column description]
  • RE_CENAT - [column description]
  • RE_POCET - [column description]
  • RE_DANPH - [column description]
  • RE_CISTR - [column description]
  • RE_CISPZ - [column description]
> HK_PO.PO_CISPZ
  • RE_ID_TOVAR - [column description]
> H_CP_TOVAR.CTO_ID_TOVAR
  • RE_ID_IZBA - [column description]
> HC_IZ.IZ_ID_IZBA
  • RE_JOINED_ROOM_ID - [column description]
> HC_JOINED_ROOM.JR_ID

HK_REZERVACIA

[table description]

  • REZ_ID_REZERVACIA - [column description]
  • REZ_CISSK - [column description]
  • REZ_DATUM_CAS_PREDBEZ_REZ - [column description]
  • REZ_DATUM_CAS_POTVRD_REZ - [column description]
  • REZ_DATUM_OD - [column description]
  • REZ_DATUM_DO - [column description]
  • REZ_STAV_REZERVACIE - [column description]
  • REZ_ID_REZERVACIA_SYSTEM - [column description]
> HK_REZERVACIA_SYSTEM.RSY_ID_REZERVACIA_SYSTEM
  • REZ_VARSYMBOL - [column description]
  • REZ_ZAPLATENE - [column description]

HK_REZERVACIA_HOST

[table description]

  • RHO_ID_HOST - [column description]
  • RHO_ID_REZERVACIA - [column description]
> HK_REZERVACIA.REZ_ID_REZERVACIA
  • RHO_PRIEZVISKO - [column description]
  • RHO_MENO - [column description]
  • RHO_TITUL - [column description]
  • RHO_TYP_HOSTA - [column description]
  • RHO_POZNAMKA - [column description]

HK_REZERVACIA_IZBY

[table description]

  • RUI_ID_REZERVACIA_IZBY - [column description]
  • RUI_ID_REZERVACIA - [column description]
> HK_REZERVACIA.REZ_ID_REZERVACIA
  • RUI_TYP_IZBY - [column description]
  • RUI_POCET_POSTELI - [column description]
  • RUI_POCET_PRISTELOK - [column description]
  • RUI_CISOB - [column description]
> HK_OBJEDNAVKA.OB_CISOB

HK_REZERVACIA_KLIENT

[table description]

  • RKL_ID_KLIENT - [column description]
  • RKL_ID_REZERVACIA - [column description]
> HK_REZERVACIA.REZ_ID_REZERVACIA
  • RKL_PRIEZVISKO - [column description]
  • RKL_MENO - [column description]
  • RKL_TITUL - [column description]
  • RKL_ADRESA1 - [column description]
  • RKL_ADRESA2 - [column description]
  • RKL_ADRESA3 - [column description]
  • RKL_PSC - [column description]
  • RKL_TEL_CISLO_DO_PRACE - [column description]
  • RKL_TEL_CISLO_DOMOV - [column description]
  • RKL_TEL_CISLO_FAXU - [column description]
  • RKL_EMAIL - [column description]

HK_REZERVACIA_PLATBA_KARTOU

[table description]

  • RPK_ID_PLATBA_KARTOU - [column description]
  • RPK_ID_REZERVACIA - [column description]
> HK_REZERVACIA.REZ_ID_REZERVACIA
  • RPK_TYP_KARTY - [column description]
  • RPK_CISLO_KARTY - [column description]
  • RPK_PLAT_KARTY_OD - [column description]
  • RPK_PLAT_KARTY_DO - [column description]
  • RPK_CISLO_VYDANIA - [column description]
  • RPK_SUMA_NA_KARTE - [column description]
  • RPK_DRZITEL_KARTY_MENO - [column description]
  • RPK_DRZITEL_KARTY_ADRESA1 - [column description]
  • RPK_DRZITEL_KARTY_ADRESA2 - [column description]
  • RPK_DRZITEL_KARTY_ADRESA3 - [column description]
  • RPK_DRZITEL_KARTY_PSC - [column description]

HK_REZERVACIA_SYSTEM

[table description]

  • RSY_ID_REZERVACIA_SYSTEM - [column description]
  • RSY_NAZ_REZERV_SYSTEM - [column description]

HK_REZERVACIA_TYPY_IZIEB

[table description]

  • RTI_ID_TYPY_IZIEB - [column description]
  • RTI_TYPIZ - [column description]
  • RTI_EXT_REZV_TYPIZ - [column description]

HK_SK

[table description]

  • SK_CISSK - [column description]
  • SK_CPRAC - [column description]
  • SK_CASZZ - [column description]
  • SK_EVIDC - [column description]
  • SK_NAZOV - [column description]
  • SK_TITVE - [column description]
  • SK_MENVE - [column description]
  • SK_PRZVE - [column description]
  • SK_MESTV - [column description]
  • SK_PSCMV - [column description]
  • SK_ULICV - [column description]
  • SK_TELVE - [column description]
  • SK_FAXVE - [column description]
  • SK_ARASK - [column description]
  • SK_KODCK - [column description]
  • SK_POCCL - [column description]
  • SK_CASPR - [column description]
  • SK_DATNA - [column description]
  • SK_HODIN - [column description]
  • SK_DATOD - [column description]
  • SK_STASK - [column description]
  • SK_SPOPL - [column description]
  • SK_POZNA - [column description]
  • SK_EMAIL - [column description]
  • SK_CISSO - [column description]
  • SK_EVIDOB - [column description]
  • SK_ID_CENOVY_PROFIL - [column description]
  • SK_KOD_MENY - [column description]
  • SK_POPOS - [column description]
  • SK_ID_STAT - [column description]
> HC_ST.ST_ID_STAT
  • SK_ID_LOCAL_TAX - [column description]
> H_CP_TOVAR.CTO_ID_TOVAR
  • SK_CHANGE_HOTEL_DATE - [column description]

HK_SKLADOVY_UCET

[table description]

  • SU_ID - [column description]
  • SU_CISLO_UCTU - [column description]
  • SU_CAS_VYTVORENIA - [column description]
  • SU_CISLO_PRACOVNIKA - [column description]
> L_UZIVATEL.UZ_ID_UZIVATEL
  • SU_POBYTOVY_DEN - [column description]
  • SU_KOD_MENY - [column description]

HK_SKLADOVY_UCET_EXTERNE

[table description]

  • SUE_SU_ID - [column description]
> HK_SKLADOVY_UCET.SU_ID
  • SUE_ID_EXT_SYSTEM - [column description]
  • SUE_ID_EXT_UCET - [column description]
  • SUE_EXT_CISLO_UCTU - [column description]
  • SUE_EXT_CASZZ - [column description]

HK_SKLADOVY_UCET_POLOZKA

[table description]

  • SUP_ID - [column description]
  • SUP_SU_ID - [column description]
> HK_SKLADOVY_UCET.SU_ID
  • SUP_ID_TOVAR_SKLAD - [column description]
> H_CP_TOVAR_SKLAD.CTS_ID_TOVAR_SKLAD
  • SUP_PRIJEM - [column description]
  • SUP_MNOZSTVO - [column description]
  • SUP_NAKUPNA_SUMA - [column description]
  • SUP_PREDAJNA_SUMA - [column description]

HK_SO

[table description]

  • SO_CISSK - [column description]
  • SO_CPRAC - [column description]
  • SO_CASZZ - [column description]
  • SO_EVIDC - [column description]
  • SO_NAZOV - [column description]
  • SO_TITVE - [column description]
  • SO_MENVE - [column description]
  • SO_PRZVE - [column description]
  • SO_MESTV - [column description]
  • SO_PSCMV - [column description]
  • SO_ULICV - [column description]
  • SO_TELVE - [column description]
  • SO_FAXVE - [column description]
  • SO_ARASK - [column description]
  • SO_KODCK - [column description]
  • SO_POCCL - [column description]
  • SO_CASPR - [column description]
  • SO_DATPO - [column description]
  • SO_DATNA - [column description]
  • SO_HODIN - [column description]
  • SO_DATOD - [column description]
  • SO_SPOOB - [column description]
  • SO_STASK - [column description]
  • SO_SPOPL - [column description]
  • SO_POZNA - [column description]
  • SO_PRISC - [column description]
  • SO_SUMSO - [column description]
  • SO_ZALSO - [column description]
  • SO_CUCSO - [column description]
  • SO_KROKRUSENIA - [column description]
  • SO_EMAIL - [column description]
  • SO_OCHRANNADOBA - [column description]
  • SO_ID_CENOVY_PROFIL - [column description]
  • SO_KOD_MENY - [column description]
  • SO_POPOS - [column description]
  • SO_ID_STAT - [column description]
> HC_ST.ST_ID_STAT
  • SO_BOOKING_NUMBER - [column description]
  • SO_CHANGE_HOTEL_DATE - [column description]
  • SO_AUTH_LEVEL_BOOKING_ID - [column description]
> HC_AUTH_LEVEL_BOOKING.ALB_ID

HK_SPRAVA

[table description]

  • SP_ID - [column description]
  • SP_CISHO - [column description]
  • SP_OBSAH - [column description]
  • SP_CAS_ZAPISU - [column description]
  • SP_PRECITANA - [column description]
  • SP_PREDMET - [column description]
  • SP_ODOSIELATEL - [column description]
  • SP_CAS_ZMENY - [column description]
  • SP_PAYTV - [column description]
  • SP_CIS_HOST_OBJ - [column description]

HK_STAT_STATISTIKA

[table description]

  • SSS_ID_STAT_STATISTIKA - [column description]
> HC_STAT_STATISTIKA.SS_ID
  • SSS_DATUM - [column description]
  • SSS_PRISLI_HOSTIA - [column description]
  • SSS_ODISLI_HOSTIA - [column description]
  • SSS_HOSTIA - [column description]
  • SSS_NOCI - [column description]

HK_TE

[table description]

  • TE_CISTE - [column description]
  • TE_CISTR - [column description]
  • TE_TELEF - [column description]
  • TE_CISHO - [column description]
  • TE_CASHV - [column description]
  • TE_POCIM - [column description]
  • TE_CENAT - [column description]
  • TE_DANPH - [column description]
  • TE_CASZZ - [column description]
  • TE_MENHO - [column description]
  • TE_KODHV - [column description]
  • TE_DLZHV - [column description]
  • TE_VOLCI - [column description]
  • TE_CISPZ - [column description]
> HK_PO.PO_CISPZ
  • TE_ID_TOVAR - [column description]
> H_CP_TOVAR.CTO_ID_TOVAR
  • TE_ID_IZBA - [column description]
> HC_IZ.IZ_ID_IZBA
  • TE_JOINED_ROOM_ID - [column description]
> HC_JOINED_ROOM.JR_ID

HK_TP_OBJEDNAVKA

[table description]

  • TPO_CISLO_OBJEDNAVKY - [column description]
  • TPO_CISLO_TECH_PRIESTORU - [column description]
  • TPO_POZICIA - [column description]
  • TPO_EVIDO - [column description]
  • TPO_CISSK - [column description]
  • TPO_CASOD - [column description]
  • TPO_CASDO - [column description]
  • TPO_STAVO - [column description]
  • TPO_MENHO - [column description]
  • TPO_POCET - [column description]
  • TPO_POZNAMKA - [column description]
  • TPO_NASOBOK_INTERVALU - [column description]
  • TPO_CENA_CELKOM - [column description]
  • TPO_CISHO - [column description]
  • TPO_CPRAC - [column description]
  • TPO_CASZZ - [column description]
  • TPO_FIXOVANA - [column description]
  • TPO_LOGS - [column description]
  • TPO_COLOR - [column description]
  • TPO_MASTER_REZERVACIA - [column description]
  • TPO_JCENA - [column description]
  • TPO_CISTR - [column description]
  • TPO_NEUCTOVAT - [column description]
  • TPO_ZDIELANA - [column description]
  • TPO_STAV_NASTUPU - [column description]
  • TPO_ZA_INTERVAL - [column description]
  • TPO_DOHODNUTA_CENA - [column description]
  • TPO_CIS_HOST_OBJ - [column description]
  • TPO_ID_TOVAR - [column description]
> H_CP_TOVAR.CTO_ID_TOVAR

HK_TR

[table description]

  • TR_CISTR - [column description]
  • TR_CISHO - [column description]
> HK_DO.DO_CISHO
  • TR_CIS_HOST_OBJ - [column description]
> HK_OBJEDNAVKA_HOST.OBH_CIS_HOST_OBJ
  • TR_CISSK - [column description]
  • TR_ID_IZBA - [column description]
> HC_IZ.IZ_ID_IZBA
  • TR_EXT_HOST - [column description]
  • TR_ZADEN - [column description]
  • TR_POCET - [column description]
  • TR_ID_TOVAR - [column description]
> H_CP_TOVAR.CTO_ID_TOVAR
  • TR_KOD_MENY - [column description]
> K_KL_MENA.KLM_KOD_MENY
  • TR_OBJEM_V_DANEJ_MENE - [column description]
  • TR_ID_DPH - [column description]
> H_CP_HLADINA_DPH.CHD_ID_HLADINA_DPH
  • TR_CPRAC - [column description]
> L_UZIVATEL.UZ_ID_UZIVATEL
  • TR_CASZZ - [column description]
  • TR_SPOPL - [column description]
  • TR_CISPZ - [column description]
> HK_PO.PO_CISPZ
  • TR_CISUV - [column description]
  • TR_ZAUCTOVANE - [column description]
  • TR_ODKAZ - [column description]
  • TR_CISOT - [column description]
> HK_TP_OBJEDNAVKA.TPO_CISLO_OBJEDNAVKY
  • TR_CISPZ_ZFAKTURA - [column description]
> HK_PO.PO_CISPZ
  • TR_CISHO_ORIGINAL - [column description]
> HK_DO.DO_CISHO
  • TR_CIS_HOST_OBJ_ORIG - [column description]
> HK_OBJEDNAVKA_HOST.OBH_CIS_HOST_OBJ
  • TR_ID_TOVAR_BALIK - [column description]
> H_CP_TOVAR.CTO_ID_TOVAR
  • TR_ID_CENOVY_PROFIL - [column description]
> H_CP_CENOVY_PROFIL.CEP_ID_PROFIL
  • TR_CHANGE_HOTEL_DATE - [column description]
  • TR_ORDERED - [column description]
  • TR_JOINED_ROOM_ID - [column description]
> HC_JOINED_ROOM.JR_ID

HK_TR_EXTERNE

[table description]

  • TRE_CISTR - [column description]
> HK_TR.TR_CISTR
  • TRE_ID_EXT_SYS - [column description]
  • TRE_UCET_IDENT - [column description]
  • TRE_IMPORT - [column description]
  • TRE_CISLO_POKLADNE - [column description]
  • TRE_CISLO_UCTU - [column description]

HK_TR_ROZPOCITANE

[table description]

  • TRR_CISTR - [column description]
> HK_TR.TR_CISTR
  • TRR_ID_DRUH_PLATBY - [column description]
> H_CP_DRUH_PLATBY.CDP_ID_DRUH_PLATBY
  • TRR_KOD_MENY - [column description]
> K_KL_MENA.KLM_KOD_MENY
  • TRR_OBJEM_V_DANEJ_MENE - [column description]

HK_UNPRINTED_BILLS

[table description]

  • HUB_CISPS - [column description]
  • HUB_PORADIE - [column description]
  • HUB_DATA - [column description]

HK_ZALOHOVA_FAKTURA

[table description]

  • ZF_CISPZ - [column description]
> HK_PO.PO_CISPZ
  • ZF_CASZZ - [column description]
  • ZF_CENAF - [column description]
  • ZF_DATOF - [column description]
  • ZF_DATSF - [column description]
  • ZF_NAZOD - [column description]
  • ZF_ULIOD - [column description]
  • ZF_MESOD - [column description]
  • ZF_ICOOD - [column description]
  • ZF_DICOD - [column description]
  • ZF_UCEOD - [column description]
  • ZF_BANKA - [column description]
  • ZF_DATUH - [column description]
  • ZF_IBANOD - [column description]
  • ZF_DATZDANPLN - [column description]
  • ZF_CISLO_ZAKAZKY - [column description]
  • ZF_VYMAZANE - [column description]

HL_PREDAJ_GASTRO

[table description]

  • PG_CISPG - [column description]
  • PG_KOD_PREDAJA - [column description]
  • PG_CASZZ - [column description]
  • PG_ZADEN - [column description]
  • PG_CISTR - [column description]
  • PG_POCET - [column description]
  • PG_JCENA - [column description]
  • PG_DANPH - [column description]
  • PG_EXKOD - [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_CP_CENOVA_HLADINA_PROFIL

[table description]

  • TID - [column description]
  • PCHP_ID_HLADINA - [column description]
  • PCHP_ID_PROFIL - [column description]
  • PCHP_ID_TYP_IZBY - [column description]
  • PCHP_VYTAZENOST - [column description]
  • PCHP_KOD_MENY - [column description]
  • PCHP_OBJEM_V_DANEJ_MENE - [column description]
  • PCHP_POVOLENA - [column description]
  • PCHP_ZDEDENA - [column description]

HP_CP_CENOVA_POLITIKA_PROFIL

[table description]

  • TID - [column description]
  • PCPP_ID_POLITIKA - [column description]
  • PCPP_ID_PROFIL - [column description]
  • PCPP_ID_POLITIKA_TYP - [column description]
  • PCPP_HODNOTA - [column description]
  • PCPP_POVOLENA - [column description]
  • PCPP_KOD_MENY - [column description]
  • PCPP_OBJEM_V_DANEJ_MENE - [column description]
  • PCPP_ROUNDING_TYPE - [column description]
  • PCPP_ROUNDING - [column description]
  • PCPP_ROUNDING_APPLY - [column description]
  • PCPP_ORDER - [column description]

HP_CP_KALENDAR_HLADINA_ZLAVA

[table description]

  • TID - [column description]
  • PCKH_ID_HLADINA_ZLAVA - [column description]
  • PCKH_ID_KALENDAR - [column description]
  • PCKH_HODNOTA - [column description]
  • PCKH_KOD_MENY - [column description]
  • PCKH_OBJEM_V_DANEJ_MENE - [column description]
  • PCKH_TYP - [column description]

HP_CP_UCTOVANIE_PROFIL

[table description]

  • TID - [column description]
  • PCPU_KEY - [column description]
  • PCPU_ID_PROFIL - [column description]
  • PCPU_VALUE - [column description]

HP_DO

[table description]

  • DOP_ID - [column description]
  • DOP_CISHO - [column description]
  • DOP_CISSK - [column description]
  • DOP_PLATBY - [column description]
  • DOP_NAVSTEV - [column description]
  • DOP_DATNA - [column description]
  • DOP_IZDEN - [column description]
  • DOP_MPDEN - [column description]
  • DOP_DATOD - [column description]
  • DOP_DATNR - [column description]
  • DOP_CENHO - [column description]
  • DOP_TOTAL - [column description]
  • DOP_DEBET - [column description]
  • DOP_TABLE_NR - [column description]
  • DOP_PLAOK - [column description]
  • DOP_CPRAC - [column description]
  • DOP_CASZZ - [column description]
  • DOP_STAHO - [column description]
  • DOP_SPOPL - [column description]
  • DOP_KODCK - [column description]
  • DOP_EXT_HOST - [column description]
  • DOP_DOMCU - [column description]
  • DOP_TARIF - [column description]
  • DOP_TITHO - [column description]
  • DOP_MENHO - [column description]
  • DOP_PRZHO - [column description]
  • DOP_MESTO - [column description]
  • DOP_PSCME - [column description]
  • DOP_ULICA - [column description]
  • DOP_TELHO - [column description]
  • DOP_SPZVO - [column description]
  • DOP_FAXHO - [column description]
  • DOP_STAY_PURPOSE - [column description]
  • DOP_TYPDO - [column description]
  • DOP_CISDO - [column description]
  • DOP_POZNA - [column description]
  • DOP_ARAHO - [column description]
  • DOP_POPUC - [column description]
  • DOP_SPECI - [column description]
  • DOP_POPOS - [column description]
  • DOP_EMAIL - [column description]
  • DOP_CHECKOUT_REAL_DATE - [column description]
  • DOP_CASPR - [column description]
  • DOP_KARTAZAMOK - [column description]
  • DOP_KARTAKLUB - [column description]
  • DOP_VIZUM - [column description]
  • DOP_EVIDOB - [column description]
  • DOP_PRIDAT_DOP_BYVALYCH_HOSTI - [column description]
  • DOP_ZABLOKOVANY_UCET - [column description]
  • DOP_CIS_HOST_OBJ - [column description]
  • DOP_ID_IZBA - [column description]
  • DOP_PRMS_ID - [column description]
  • DOP_ID_HOREC_LANGUAGE - [column description]
  • DOP_ID_KATEGORIA_HOSTA - [column description]
  • DOP_ID_STAT - [column description]
  • DOP_ID_LOCAL_TAX - [column description]
  • DOP_BED_TYPE_ID - [column description]
  • DOP_JOINED_ROOM_ID - [column description]
  • DOP_ACCOMMODATION_PRICE_TYPE - [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_HOSTIA

[table description]

  • HOP_ID - [column description]
  • HOP_PORADIE - [column description]
  • HOP_CISHO - [column description]
  • HOP_CISSK - [column description]
  • HOP_EXT_HOST - [column description]
  • HOP_DATOD - [column description]
  • HOP_MENHO - [column description]
  • HOP_OZNAC - [column description]
  • HOP_STAHO - [column description]
  • HOP_CENAT - [column description]
  • HOP_CIS_HOST_OBJ - [column description]
  • HOP_ID_IZBA - [column description]
  • HOP_ID_STAT - [column description]
  • HOP_PARTIAL_CHECKOUT - [column description]
  • HOP_BED_TYPE_ID - [column description]
  • HOP_JOINED_ROOM_ID - [column description]

HP_LIST

[table description]

  • LT_ID_TEMP - [column description]
  • LT_ID_ITEM - [column description]

HP_OS

[table description]

  • OSP_ID - [column description]
  • OSP_RID - [column description]
  • OSP_CISOS - [column description]
  • OSP_CPRAC - [column description]
  • OSP_CASZZ - [column description]
  • OSP_CISHO - [column description]
  • OSP_CISSK - [column description]
  • OSP_PLATENA - [column description]
  • OSP_DATZA - [column description]
  • OSP_DATKO - [column description]
  • OSP_POCET - [column description]
  • OSP_CASPO - [column description]
  • OSP_NUTUP - [column description]
  • OSP_SLDEN - [column description]
  • OSP_NOTE - [column description]
  • OSP_TRVALA - [column description]
  • OSP_CIS_HOST_OBJ - [column description]
  • OSP_ID_TOVAR - [column description]
  • OSP_Z_CEN_PROFILU - [column description]
  • OSP_ID_CISOS - [column description]
  • OSP_PARENT_RID - [column description]
  • OSP_CCSO_ID - [column description]
  • OSP_MODIFIED_STATE - [column description]
  • OSP_INTERNA - [column description]
  • OSP_PO_POLNOCI - [column description]
  • OSP_BALIK_TYP - [column description]
  • OSP_REL_ZACIATOK - [column description]
  • OSP_REL_KONIEC - [column description]

HP_PLATBA

[table description]

  • ID - [column description]
  • PB_PORADIE - [column description]
  • PB_SPOPL - [column description]
  • PB_CELKOM - [column description]
  • RID - [column description]

HP_PRACOVNE_IZBY

[table description]

  • PI_ID - [column description]
  • PI_VYTAZENIE - [column description]
  • PI_LOZOK - [column description]
  • PI_MAX_LOZOK - [column description]
  • PI_RID - [column description]
  • PI_CIS_HOST_OBJ - [column description]
  • PI_ID_IZBA - [column description]
  • PI_JOINED_ROOM_ID - [column description]
  • PI_JOINED_ROOM_TYPE_ID - [column description]
  • PI_ROOM_TYPE_ID - [column description]

HP_RAPORTKA

[table description]

  • RAP_RAJON - [column description]
  • RAP_IZBA - [column description]
  • RAP_PRISTELKA - [column description]
  • RAP_PRICHADZA - [column description]
  • RAP_OSTAVA - [column description]
  • RAP_ODCHADZA - [column description]
  • RAP_UTERAKY - [column description]
  • RAP_BIELIZEN - [column description]
  • RAP_CAS - [column description]
  • RAP_RAPZ - [column description]
  • RAP_RAPNA - [column description]

HP_STAV_IZBY

[table description]

  • SI_ID - [column description]
  • SI_STAKT - [column description]
  • SI_STDEF - [column description]
  • SI_STAV - [column description]
  • SI_ID_IZBA - [column description]

HP_UCET

[table description]

  • ID - [column description]
  • UC_NAZOV - [column description]
  • UC_TOVAR - [column description]
  • UC_SPOPL - [column description]
  • UC_CISTR - [column description]
  • UC_CISHO - [column description]
  • UC_CISSK - [column description]
  • UC_ZADEN - [column description]
  • UC_CISOS - [column description]
  • UC_ODKAZ - [column description]
  • UC_OZNAC - [column description]
  • UC_PORADIE - [column description]
  • UC_ZOBRAZUJ - [column description]
  • UC_ODLOZENE - [column description]
  • UC_STORNO - [column description]
  • UC_CISTE - [column description]
  • UC_CISRE - [column description]
  • UC_CISOT - [column description]
  • UC_SPECIAL - [column description]
  • UC_CIS_HOST_OBJ - [column description]
  • UC_POCET - [column description]
  • UC_ID_TOVAR - [column description]
  • UC_KOD_MENY - [column description]
  • UC_OBJEM_V_DANEJ_MENE - [column description]
  • UC_ID_DPH - [column description]
  • UC_ID_IZBA - [column description]
  • UC_NCENA - [column description]
  • UC_KURZ - [column description]
  • UC_ID_UZIVATELSKY_TEXT - [column description]
  • UC_EXT_HOST - [column description]
  • UC_ID_TOVAR_BALIK - [column description]
  • UC_ID_CENOVY_PROFIL - [column description]
  • UC_ODPISANE_ZO_SKLADU - [column description]
  • UC_ORDERED - [column description]
  • UC_JOINED_ROOM_ID - [column description]

HP_UCET_PLATBA

[table description]

  • UCP_ID_HP_UCET - [column description]
  • UCP_PORADIE - [column description]
  • UCP_MENA_VYBRANA_KOD - [column description]
  • UCP_MENA_VYBRANA_JEDNOTKA - [column description]
  • UCP_MENA_VYBRANA_KURZ - [column description]
  • UCP_MENA_VYBRANA_SUMA - [column description]
  • UCP_MENA_DOMACA_KOD - [column description]
  • UCP_MENA_DOMACA_SUMA - [column description]
  • UCP_MENA_DOMACA_VRATENE - [column description]
  • UCP_ID_DRUH_PLATBY - [column description]

HP_UCET_PLATBA_EXTERNA

[table description]

  • EPP_ID_HP_UCET - [column description]
  • EPP_PORADIE_HP_UCET_PLATBA - [column description]
  • EPP_KODPK - [column description]
  • EPP_CISPK - [column description]
  • EPP_POPPK - [column description]
  • EPP_DATUH - [column description]
  • EPP_POSTA - [column description]
  • EPP_ID_PLATOBNA_KARTA - [column description]
  • EPP_PLAT_KARTA_MESIAC - [column description]
  • EPP_PLAT_KARTA_ROK - [column description]
  • EPP_CHEQUE_TYPE_ID - [column description]
  • EPP_CHEQUE_NUMBER - [column description]

HP_UCKO

[table description]

  • UK_ID - [column description]
  • UK_RID - [column description]
  • UK_NAZOV - [column description]
  • UK_DATOX - [column description]
  • UK_DATDX - [column description]
  • UK_CIAST - [column description]
  • UK_NETTO - [column description]
  • UK_CISTR - [column description]
  • UK_OZNAC - [column description]
  • UK_TYPZAZNAMU - [column description]
  • UK_NCENA - [column description]
  • UK_KURZ - [column description]
  • UK_ID_DRUH_PLATBY - [column description]
  • UK_POCET - [column description]
  • UK_ID_TOVAR - [column description]
  • UK_KOD_MENY - [column description]
  • UK_OBJEM_V_DANEJ_MENE - [column description]
  • UK_ID_DPH - [column description]
  • UK_JCENA_V_DANEJ_MENE - [column description]
  • UK_ID_IZBA - [column description]
  • UK_ID_KATEGORIA_TOVARU - [column description]
  • UK_ID_TEXT - [column description]
  • UK_EXT_HOST - [column description]
  • UK_ID_POKLADNA - [column description]
  • UK_ID_TOVAR_BALIK - [column description]
  • UK_ID_CENOVY_PROFIL - [column description]
  • UK_ID_HOST - [column description]
  • UK_ZDRUZOVAT - [column description]
  • UK_JOINED_ROOM_ID - [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]

HS_PREDAJ

[table description]

  • PD_CISPS - [column description]
  • PD_POCET - [column description]
  • PD_UCETIDTEMP - [column description]
  • PD_UCETPORADIE - [column description]
  • PD_ID_TOVAR - [column description]
> H_CP_TOVAR.CTO_ID_TOVAR

HT_TEXT_REPORTS

[table description]

  • ZT_ID - [column description]
  • ZT_KODZO - [column description]
  • ZT_CISPS - [column description]
  • ZT_CASZZ - [column description]
  • ZT_DRUZO - [column description]
  • ZT_ID_CAST - [column description]
  • ZT_DATA - [column description]
  • ZT_ID_THREAD - [column description]
  • ZT_POC_RIADKOV_NA_STR - [column description]

HT_ZT

[table description]

  • ZT_KODZO - [column description]
  • ZT_CISPS - [column description]
  • ZT_DRUZO - [column description]
  • ZT_CSTRA - [column description]
  • ZT_CRIAD - [column description]
  • ZT_TEXTY - [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]

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_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]

L_FUNKCIA

[table description]

  • FN_ID_FUNKCIA - [column description]
  • FN_ID_MODUL - [column description]
> L_MODUL.ML_ID_MODUL
  • FN_MENO - [column description]
  • FN_ID_RODIC - [column description]
  • FN_VZDY_POVOLENA - [column description]
  • FN_PORADIE - [column description]
  • FN_VISIBLE - [column description]

L_FUNKCIA_TEXT

[table description]

  • FT_ID_FUNKCIA - [column description]
> L_FUNKCIA.FN_ID_FUNKCIA
  • FT_JAZYK - [column description]
  • FT_TEXT - [column description]

L_HELP_LINK

[table description]

  • HL_ID - [column description]
  • HL_KEY - [column description]
  • HL_LINK - [column description]

L_MODUL

[table description]

  • ML_ID_MODUL - [column description]
  • ML_MENO - [column description]

LOG_FIS_BILL_ATTEMPTS

[table description]

  • FBA_ID - [column description]
  • FBA_ID_BILL - [column description]
> HK_PO.PO_CISPZ
  • FBA_TIME - [column description]
  • FBA_ID_WORKSTATION - [column description]
  • 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_WORKSTATION - [column description]
  • 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]
> HK_CLOSING_FISCAL_MODULE.CFM_ID

LOG_SERVICES_PACKAGE_RECALC

[table description]

  • LPR_ID - [column description]
  • LPR_DATE_TIME - [column description]
  • LPR_HOTEL_DATE - [column description]
  • LPR_SERVICES_PACKAGE_ID - [column description]
  • LPR_HOTEL_DATE_FROM - [column description]
  • LPR_HOTEL_DATE_TO - [column description]
  • LPR_USER_ID - [column description]
> L_UZIVATEL.UZ_ID_UZIVATEL

LOYALTY_TMR_BILL

[table description]

  • LTB_BILL_ID - [column description]
> HK_PO.PO_CISPZ
  • LTB_CARD_NUMBER - [column description]
  • 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]

LOYALTY_TMR_SERVICE

[table description]

  • LTMS_ID - [column description]
> H_CP_TOVAR.CTO_ID_TOVAR

LOYALTY_TMR_SYSTEM

[table description]

  • LTM_ID - [column description]
  • LTM_CARD_DIGITS - [column description]
  • LTM_SEND_BILL_TIMEOUT - [column description]
  • LTM_SEND_BREAK - [column description]
  • LTM_SEND_INTERVAL_START - [column description]
  • LTM_SEND_INTERVAL_STOP - [column description]
  • LTM_SEND_REPEATS - [column description]
  • LTM_ABORTED_AT - [column description]

L_ROLA

[table description]

  • RL_ID_ROLA - [column description]
  • RL_ID_MODUL - [column description]
> L_MODUL.ML_ID_MODUL
  • RL_MENO - [column description]

L_ROLA_LANG

[table description]

  • LRL_ID - [column description]
> L_ROLA.RL_ID_ROLA
  • LRL_MENO - [column description]
  • LRL_LANG - [column description]

L_UZIVATEL

[table description]

  • UZ_ID_UZIVATEL - [column description]
  • 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]
> L_UZIVATEL_PREDOK.UP_ID_UZIVATEL_PREDOK
  • UZ_RYCHLE_HESLO - [column description]
  • UZ_SKRME - [column description]
  • UZ_KOD_JAZYKA - [column description]
  • UZ_DELETED - [column description]

L_UZIVATEL_FUNKCIA

[table description]

  • UF_ID_FUNKCIA - [column description]
> L_FUNKCIA.FN_ID_FUNKCIA
  • UF_ID_MODUL - [column description]
> L_MODUL.ML_ID_MODUL
  • UF_ID_UZIVATEL - [column description]
> L_UZIVATEL_PREDOK.UP_ID_UZIVATEL_PREDOK

L_UZIVATEL_MODUL

[table description]

  • UM_ID_UZIVATEL_PREDOK - [column description]
> L_UZIVATEL_PREDOK.UP_ID_UZIVATEL_PREDOK
  • UM_ID_MODUL - [column description]
> L_MODUL.ML_ID_MODUL
  • UM_ENABLED - [column description]
  • UM_AUTH_LEVEL_BOOKING_ID - [column description]
> HC_AUTH_LEVEL_BOOKING.ALB_ID
  • UM_AUTH_LEVEL_BOOK_RECOM_ID - [column description]
> HC_AUTH_LEVEL_BOOKING.ALB_ID
  • UM_AUTH_LEVEL_BOOKING_CHANGE - [column description]
  • UM_AUTH_LEVEL_BOOK_EDIT_MODE - [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]
> L_ROLA.RL_ID_ROLA
  • UR_ID_MODUL - [column description]
> L_MODUL.ML_ID_MODUL
  • UR_ID_UZIVATEL - [column description]
> L_UZIVATEL_PREDOK.UP_ID_UZIVATEL_PREDOK

VERSION

[table description]

  • DATA_VERSION - [column description]