FRS – 2Book (SAAS only)

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 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 interface in question are changed throughout the interface life-cycle.
The two adapters that are now used are utilizing XML data retrieved from a web service. The web service creates a separate file for each restaurant based on the <Restaurant> tag.

Interface name incl. versionComment
2Book_Otb_V001Deprecated, use one of the other interfaces instead
2Book_OtbTentative_V001Registers the number of guests as room nights tentative
2Book_OtbCoversRegisters the number of guests as covers/units.
#PMI data element (target)DescriptionMandatory / OptionalData transformation/load rulesData element (source)Comment
1DateOTB dateMDirect mapping from source fileDate
2DepartmentID or name of the departmentMDirect mapping from source fileArea
3AccountID or name of the accountONot in source file
4DescriptionAccount descriptionMDirect mapping from source fileType
5RevenueRevenue without authority charge ratesMDirect mapping from source fileAmount
6CoversNumber of coversMDirect mapping from source fileNrOfGuestsSee the interfaces for specific handling of this value

Download an example of the source file format: File:2Book OtbTentative

Was this article helpful?

Related Articles