| Table of Contents |
|---|
v25 2020.06.
...
16
...
Добавлены новые поля
VReservationGuests
Country - CountryName
CountryCitizenship - CountryCitizenshipName
CountryResidence - CountryResidenceName
VOccupation
MarketSegment - MarketSegmentCode
BookingSource - BookingSourceCode
VTransactions
MarketSegment - MarketSegmentCode
BookingSource - BookingSourceCode
Tax - TaxCode
Переименованы поля
VMainStatisticInfo
DopMesta - ExtraBed
Rate - RateCode
Location - LocationCode
MarketSegment - MarketSegmentCode
BookingSource - BookingSourceCode
Company - CompanyName
Country - CountryName
Tax - TaxCode
ParentRoom - ParentRoomCode
ParentRoomType - ParentRoomTypeCode
RoomType - RoomTypeCode
RoomTypeCategory - RoomTypeCategoryCode
Room - RoomCode
Folio - FolioNo
VMainStatisticInfoShort
DopMesta - ExtraBedVMainStatisticInfoShort
Rate - RateCode
Room - RoomCode
Location - LocationCode
MarketSegment - MarketSegmentCode
BookingSource - BookingSourceCode
DopMesta - ExtraBed
Folio - FolioNo
Company - CompanyName
Country - CountryName
Tax - TaxCode
v27 2020.06.17
Добавлены новые поля
VReservationGuests
CountryCode
CountryCitizenshipCode
CountryResidenceCode
Добавлены новые представления и таблицы для справочников
/Rollout/Common/Base/DbScripts/z_Reporting/03 Views/50_VDictBusinessUnit.sql
/Rollout/Common/Base/DbScripts/z_Reporting/03 Views/51_VDictCountry.sql
/Rollout/Common/Base/DbScripts/z_Reporting/03 Views/52_VDictCountryType.sql
/Rollout/Common/Base/DbScripts/z_Reporting/03 Views/53_VDictGeoCode.sql
/Rollout/Common/Base/DbScripts/z_Reporting/03 Views/54_VDictLocation.sql
/Rollout/Common/Base/DbScripts/z_Reporting/03 Views/55_VDictOpenCode.sql
/Rollout/Common/Base/DbScripts/z_Reporting/03 Views/56_VDictRate.sql
/Rollout/Common/Base/DbScripts/z_Reporting/03 Views/57_VDictRevenueType.sql
/Rollout/Common/Base/DbScripts/z_Reporting/03 Views/58_VDictRoom.sql
/Rollout/Common/Base/DbScripts/z_Reporting/03 Views/59_VDictRoomType.sql
/Rollout/Common/Base/DbScripts/z_Reporting/03 Views/60_VDictRoomTypeCategory.sql
/Rollout/Common/Base/DbScripts/z_Reporting/03 Views/61_VDictServiceItem.sql
v28 2020.06.18
Добавлены новые поля
VQuotas
CompanyNo
Добавлены новое представление и таблица
/Rollout/Common/Base/DbScripts/z_Reporting/03 Views/12_VCompanyProfiles.sql
v29 2020.06.18
В представлениях и таблицах соответсвенно в нижеперечисленных полях теперь содержатся связки полей Код объекта . Код счета (компании, брони и т.п.)
На этих колонках построены дополнительные индексы.
VReservationGuests
VInvoices: FolioNo
VReservations: ReservationNo, FolioNo, CompanyNo, PayingCompanyNo, AgentCompanyNo
VReservationGuests: ReservationNo, ProfileNo
VOccupation: ReservationNo
VTransactions: FolioNo
VFolios: FolioNo
VQuotas: FolioNo
VCompanyProfiles: CompanyProfileNo