|
RMS- POS Protocols
|
Previous Top Next |
|
|
| RMS communicates to and from the Point Of Sales system using two comma delimited files.
|
|
|
| The first file is used to indicate the activation and deactivation of debtor accounts and is triggered by the Check in and Check out functions within RMS. This file is generated by RMS and can be written to any location available on the network.
|
|
|
| Specific Details:
|
| File Name: RMSddmmyy.csv
|
| · Where dd = the day expressed as a 2 digit number
|
| · Where mm = the month expressed as a 2 digit number
|
| · Where yy = the year expressed as a 2 digit number
|
|
|
| File Contents
|
| 203,192,Smith,Tom,1
|
| 205,190,Jones,Dan,0
|
| 203,205,Southern,Danny,0
|
|
|
| Room Number, RMS Account Number, Surname, Given, Activate/Deactivate
|
|
|
| Where Room Number is the RMS Room number/name that is used to charge back. Maximum of 16 characters being alpha/ numeric.
|
| Where RMS Account Number is the Guest Account/Folio number maintained by RMS. Maximum of 9999999 characters being numeric.
|
| Where Surname is the Surname of the Guest as provided in the reservation within RMS. Maximum of 50 characters being alpha/ numeric.
|
| Where Given is the Given Name of the Guest as provided in the reservation within RMS. Maximum of 20 characters being alpha/ numeric
|
| Where Activate/Deactivate is either a 0 or 1 depending on the status of the reservation within RMS (See Below). Maximum being 1 character being numeric.
|
|
|
| Activate = 0 Means that the reservation has been checked into RMS and is now an active debtor that can accept charges
|
| Deactivate = 1 Means that the reservation has been checked out and can no longer accept charges from the interface
|
|
|
| The second file is generated by the POS system which RMS reads and uses as a basis for billing. This file can be located anywhere that is accessible on the network
|
|
|
| EXAMPLES
|
| RMS Output File – RMS120602.csv
|
|
|
| 02CL,96,VICKERS-WILLIS,Jim & beth,0
|
| 02CO,102,PLUMB,Norm & dorothy,1
|
|
|
| File Name: SYSNETddmmyy.csv
|
| · Where dd = the day expressed as a 2 digit number
|
| · Where mm = the month expressed as a 2 digit number
|
| · Where yy = the year expressed as a 2 digit number
|
|
|
| File Contents
|
| 203,192,1931,Bar Sale,12.5,12/02/02,15:30:08
|
| 105,85,1920,Food Sale,20,12/02/02,15:31:23
|
|
|
| Room Number, RMS Account Number, GL-Code, Description of Charge, Amount, Date dd/mm/yy, Time HH:mm:ss
|
|
|
| Each record is concluded with a Carriage Return Line Feed to start a new record on the next line.
|
|
|
| · Where Room Number/Name is the room that they are checked into within RMS. Maximum of 16 characters being alpha/ numeric (this would likely become your primary key).
|
| · Where Account Number is the Guest Account/Folio number as provided when the account was activated. Maximum of 9999999 characters being numeric.
|
| · Where GL-Code equals the general ledger code of this line item that matches to same GL-Code stored within RMS. Maximum of 30 characters being alpha/ numeric.
|
| · Where Description of Charge is the description of the charge being billed to the customers account. Maximum of 50 characters being alpha/ numeric.
|
| · Where Amount is the Amount of the charge being billed for this item. Maximum of 10 characters being alpha/ numeric.
|
| · Where Date is the date of the charge with leading zeros on numbers less than 10 e.g. 02/07/02. Maximum of 8 characters being alpha/ numeric.
|
| · Where Time is the time of the charge expressed in 24hr format e.g. 23:08:19. Maximum of 8 characters being alpha/ numeric.
|
|
|
| EXAMPLES
|
| POS Output File – SYSNET120602.csv
|
|
|
| 02CL,183,1932,Misc Convenience,0.99,12/06/02,05:33:59
|
| 02CO,203,1931,Soft Drinks,1.44,12/06/02,06:00:06
|
| 02CF,354,1932,Misc Convenience,0.99,12/06/02,06:01:11
|
| 03CS,129,1932,Misc Convenience,2.75,12/06/02,06:11:28
|
| 02CL,50,1932,Soft Drinks,2,12/06/02,06:11:49
|
|
|
| The CHM file was converted to HTML by chm2web software. |