v25 2020.06.16

Добавлены новые поля

VReservationGuests
CountryName
CountryCitizenshipName
CountryResidenceName

VOccupation
MarketSegmentCode
BookingSourceCode

VTransactions
MarketSegmentCode
BookingSourceCode
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 - ExtraBed
Rate - RateCode
Room - RoomCode
Location - LocationCode
MarketSegment - MarketSegmentCode
BookingSource - BookingSourceCode
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