PMS – Citybreak

The table below shows the data relationship between PMI data elements/fields (target) and corresponding source data elements/fields (source). You will find the transformation/load rules meant to explain any programmatic manipulation and calculation applied in the adapter to get the desired data format and/or result in the PMI staging table where such have been applicable. An example of the source file data, format and structure is also attached below the table. This table will be updated whenever the source file or the adapter in question are changed throughout the interface life-cycle.
Used for registration of tickets.

The file structure is the same for actual and on the book. The only difference is that the date is before today (actual) or from today onward (otb).

Interface name incl. versionComment
Citybreak_Hist_V101Retrieving actual data
Citybreak_OTB_V100Retrieving data on the book
#PMI data element (target)DescriptionMandatory / OptionalData transformation/load rulesData element (source)Comment
1DateTransaction/OTB dateMDirectly mapped from source fileArrivalDateIn the format dd.MM.yyyy hh:mm:ss
2DepartmentID or name of the departmentMNot in source file
3AccountID or name of the accountMNot in source file
4DescriptionAccount descriptionMDirectly mapped from source systemName
5RevenueRevenue without authority charge ratesMDirectly mapped from source fileRevenueUsing Norwegian punctuation and including VAT
6CoversNumber of coversMDirectly mapped from source fileGuestsImported as room nights

Output examples for download:

Was this article helpful?

Related Articles