Dear All,
May I ask if anyone here knows about the MICROS system that is for hospitality industry?
Can you help me for the below inquiry please?
The sales data will be stored in MICROS database as and when the transactions are carried out on the POS. After each EOB day; we will schedule the Micros POS Server to run a SQL script which will export the data as required by Microsoft Dynamics 365 into a flat file and copy the same on to an identified directory on Micros Server. The flat file directory can then be mapped to Microsoft Dynamics 365 server to automatically pickup or can be manually imported as well.
The flat file’s format will be ‘csv’. The format of data can be decided along with the Microsoft Dynamics 365 team or we can share the details or currently existing generic flat file data formats. Below is one example of a similar flat file used.
Once these are confirmed as acceptable by dynamics then we could set the same. Please feel free to call for any clarifications.
Export Layout - SAMPLE
|
COLUMN NAME
|
DATA TYPE
|
NULL ALLOWED
|
COMMENTS
|
EXAMPLE
|
|
Store ID:
|
|
|
Unique ID of store - Location Name in MM
|
9210
|
|
POS ID:
|
|
|
Unique ID of machine - Location Reference in MM
|
1
|
|
Date:
|
|
|
YYYYMMDD - Business Date in mentioned format
|
21-04-2014
|
|
Time:
|
|
|
HHMMSS - Check open time
|
0.322917
|
|
USER_ID:
|
|
|
ID of user logged in - First Name of transaction employee
|
1234
|
|
Transaction ID:
|
|
|
Unique ID of transaction - Check Number
|
4567
|
|
Transaction Mode :
|
|
|
N(Normal)/ R (Return)/ V (Void)/ DO (Draw Open)
|
N
|
|
Item code:
|
|
|
Code of item sold - OBJ/PLU Number of menu item
|
51001
|
|
Item description:
|
|
|
Description of item - Menu Item name
|
Latte Med
|
|
Item quantity:
|
|
|
Quantity of item sold - Qty of Item in check
|
1
|
|
Category:
|
|
|
Category of item if exists - MAJOR GROUP
|
Beverage
|
|
Sub category:
|
|
|
Sub category of item if exists - FAMILY GROUP
|
Coffee
|
|
Item Amount:
|
|
|
Actual retail price of the item - Unit Price (xx.xx) 2 Decimal
|
15
|
|
Discount %:
|
|
|
Percentage of discount on the item if any - ITEM DISCOUNT (5%)
|
0.1
|
|
Transaction Discount:
|
|
|
Percentage of discount on the whole sale if any - SUBTOTAL DISCOUNT (5%)
|
0
|
|
Returned Amount:
|
|
|
If the transaction mode is R (Return) the amount of the item should be provided in returned amount
|
0
|
|
Net sale amount:
|
|
|
If net sale is no different than Item Amount, it should be sent same as Item Amount.
|
13.5
|
|
Gross Amount:
|
|
|
Final Price before tax and discounts(if no tax and discounts it should be same as net sale amount)
|
15
|
|
Other tax %:
|
|
|
To be sent as zero if no tax applicable
|
0
|
|
Liqueur tax %:
|
|
|
To be sent as zero if no tax applicable
|
0
|
|
Currency Mode-M:
|
|
|
Cash
|
M
|
|
Currency Mode-C:
|
|
|
Card
|
0
|
|
Currency Mode-V:
|
|
|
Voucher
|
0
|
|
Period:
|
|
|
(For car rentals only, for the rest the field shall be sent empty)
|
0
|
|
Currency:
|
|
|
Currency of Transaction - Currency used in Tender
|
AED
|
|
Exchange rate:
|
|
|
Rate used to do the exchange to AED. In case sale is in AED rate will be 1
|
1
|
Thanks & Best Regards
