POS – Micros

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.

Interface name incl. versionComment
Micros_revenue_V001File name pattern: *.csv
Space delimited.
Micros_revenue_V002File name pattern: *.csv
Comma delimited.
Micros_revenue_V003Not currently used
Micros_revenue_V004File name pattern: 20*.txt
Semicolon delimited.
UTF-8 Encoding.
Micros_revenue_V005File name pattern: Micro*.txt
Micros_revenue_V006File name pattern: {chain custom}*.csv
Micros_Covers_V100File name pattern: micros_covers_MID\d{3}_HID001_DID\d{3}.txt
ColumnName V001Name V002Name V003Name V004Name V005Name V006Name Covers V100
1Not usedNot usedDateDateDatePropertyServicePeriod
3AccountNot usedAccountDepartmentDepartmentDateNot used
4Not usedNot usedDescriptionAccountRevenueAccount
5DescriptionNot usedRevenueDescriptionDescriptionMeal period
6DepartmentDescriptionRevenueNot usedCovers
7Not usedDepartmentCoversRevenue
8-13Not usedNot used
14RevenueNot used
#PMI data element (target)DescriptionMandatory / OptionalData transformation/load rulesData element (source)Comment
1DateTransaction DateMDirect mapping from source fileDate
2DescriptionDescriptionMDirect mapping from source fileDescriptionAll versions except V004/V006
2DescriptionDescriptionM{Description} – Hours: {Hour}Description and HourV004 only
2DescriptionDescriptionMMeal period : {Meal period}DescriptionV006 only
3DepartmentDepartmentMDirectly mapped from source fileDepartment
4AccountAccountMDirectly mapped from source fileAccount
5RevenueRevenue without authority charge ratesMDirectly mapped from source fileRevenue
6Covers/UnitsCovers/UnitsMDirectly mapped from source fileCoversV004/V006 only
#PMI data element (target)DescriptionMandatory / OptionalData transformation/load rulesData element (source)Comment
1DateTransaction DateMThe previous day’s dateIn short date format
2DescriptionDescriptionMFood Cover – Service Period {ServicePeriod}ServicePeriod
3DepartmentDepartmentMTaken from the file nameLast 2 digits from the 3 after DID
4AccountAccountMHard coded to 0
5Covers/UnitsCovers/UnitsMDirectly mapped from source fileFoodCover

Output examples for download:

Flat file in CSV format for Micros_revenue interface:

Flat file in CSV format for Micros_Covers interface:

Was this article helpful?

Related Articles