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. version | Comment |
|---|---|
| Micros_revenue_V001 | File name pattern: *.csv Space delimited. |
| Micros_revenue_V002 | File name pattern: *.csv Comma delimited. |
| Micros_revenue_V003 | Not currently used |
| Micros_revenue_V004 | File name pattern: 20*.txt Semicolon delimited. UTF-8 Encoding. |
| Micros_revenue_V005 | File name pattern: Micro*.txt |
| Micros_revenue_V006 | File name pattern: {chain custom}*.csv |
| Micros_Covers_V100 | File name pattern: micros_covers_MID\d{3}_HID001_DID\d{3}.txt |
| Column | Name V001 | Name V002 | Name V003 | Name V004 | Name V005 | Name V006 | Name Covers V100 |
|---|---|---|---|---|---|---|---|
| 1 | Not used | Not used | Date | Date | Date | Property | ServicePeriod |
| 2 | Date | Date | Department | Hour | Account | Department | FoodCover |
| 3 | Account | Not used | Account | Department | Department | Date | Not used |
| 4 | Not used | Not used | Description | Account | Revenue | Account | – |
| 5 | Description | Not used | Revenue | Description | Description | Meal period | – |
| 6 | Department | Description | – | Revenue | Not used | Covers | – |
| 7 | Not used | Department | – | Covers | – | Revenue | – |
| 8-13 | Not used | Not used | – | – | – | – | – |
| 14 | Revenue | Not used | – | – | – | – | – |
| 15 | – | Revenue | – | – | – | – | – |
| # | PMI data element (target) | Description | Mandatory / Optional | Data transformation/load rules | Data element (source) | Comment |
|---|---|---|---|---|---|---|
| 1 | Date | Transaction Date | M | Direct mapping from source file | Date | |
| 2 | Description | Description | M | Direct mapping from source file | Description | All versions except V004/V006 |
| 2 | Description | Description | M | {Description} – Hours: {Hour} | Description and Hour | V004 only |
| 2 | Description | Description | M | Meal period : {Meal period} | Description | V006 only |
| 3 | Department | Department | M | Directly mapped from source file | Department | |
| 4 | Account | Account | M | Directly mapped from source file | Account | |
| 5 | Revenue | Revenue without authority charge rates | M | Directly mapped from source file | Revenue | |
| 6 | Covers/Units | Covers/Units | M | Directly mapped from source file | Covers | V004/V006 only |
| # | PMI data element (target) | Description | Mandatory / Optional | Data transformation/load rules | Data element (source) | Comment |
|---|---|---|---|---|---|---|
| 1 | Date | Transaction Date | M | The previous day’s date | In short date format | |
| 2 | Description | Description | M | Food Cover – Service Period {ServicePeriod} | ServicePeriod | |
| 3 | Department | Department | M | Taken from the file name | Last 2 digits from the 3 after DID | |
| 4 | Account | Account | M | Hard coded to 0 | ||
| 5 | Covers/Units | Covers/Units | M | Directly mapped from source file | FoodCover |
Output examples for download:
Flat file in CSV format for Micros_revenue interface:
- File:Micros revenue V001.txt
- File:Micros revenue V002.txt
- File:Micros revenue V004.txt
- File:Micros revenue V005.txt
Flat file in CSV format for Micros_Covers interface: