Data Spec POS import for F&B Analytics

#Data elementDescriptionMandatory / OptionalComment
1Property ID and/or nameIdentification of the property (hotel, restaurant)MThe import flow for a property is mostly set up per property. In this case the property identifier is specified in the flow. If a data set (file) includes data for multiple properties, the property identifier needs to be part of the data set (file).
2Department ID and/or nameIdentification of the department within the propertyMThis field is mandatory if the file contains more than one unit.
3Date and time stampTransaction date and timeMWill be used to drill down into daily activity pattern, useful for planning and staffing
4Account ID and/or nameIdentification of the accountM 
5Aticle ID and/or nameIdentification of the item soldMThe items sold will be mapped to item category like starter, main or dessert/wine, beer, non-alcoholic. And mapped to a higher level, i.e. Food and Beverage
6MealPeriod ID and/or nameIdentification of the meal periodORequired when using covers. If this field is not available in the source system, the records can be grouped based on time of the day.
7Table numberWhich tables are soldMMainly used to identify number of tables sold
8Check numberIdentification of checksMUsed to link sales to covers and segments
9CoversNumber of covers/guestsMRequired when using covers.
10Cover segmentInhouse, External etc.M 
11RevenueRevenue without VAT and other authority charge ratesMIf the revenue includes VAT this can be corrected in the mapping. Only one percentage can be used in the mapping to subtract additional charges. Note: Usually, revenue registered in POS (e.g. Micros) is automatically fed to PMS (Opera). However, adjustments (at higher level) are often made in PMS without these changes being fed back to POS. Therefore, it is common that revenue in PMS is used to update in PMI – not revenue from Micros.

This spec is for the new F&B Analytics module only. Some elements may not be valid for all properties, like segment, then ignore that.

Article Attachments

Was this article helpful?

Related Articles