Technical Note: 20011004048

Sales Transfer File

(Maitre'D 2002, and later versions of Maitre'D)
The sales transfer file is a transaction file generated when preparing a sales report for printing. These files bear the names jour, semaine, mois, periode, annee and lecture according to the type of report generated and they all bear the extension .asc. The report does not have to be printed so that the transfer file are generated, all it needs is to be prepared.
Modified for versions 4.17.21 and 5.02.55
See modification reasons at end of this document
Specifications for the transfer file.

General format:

field length format description
1 2 numeric transaction code
2 2 numeric menu number
3 1 numeric mode number
4 3 numeric miscellaneous
5 4 numeric record number
6 20 alphanumeric description
7 9 -numeric quantity
8 11 -numeric value, with decimals
9 2 separator CR,LF
total 54    
-Numeric means numerical with sign in front
Note: an unused field is filled with zeroes or spaces.

Code 0:

File identification. It is the first transaction in the file.
The fields 2,3,5 are not used.
The field 4 contains the code corresponding to the type of report according to the table:
  Current Passed
week 1 5
period 2 6
month 3 7
year 4 8
day 9 10
X cumulative 11 N / A
X non cumulative 12 N / A
pay week 13 14
pay period 15 16
Field 6 contains the report description.
Field 7 contains the starting date.
Field 8 contains the ending date.
For the reports number 9 to 12, that field is unused. The date is encoded as: ddmmyyyy justified to the right.

Code 1:

Total of sales by item by mode by revenue center.
Field 4 is unused.

Code 2:

Total sales by miscellaneous by modes by revenue centers.
Note: 4.17.xx supports miscellaneous by taxes only
Field 4 is unused.

Code 3:

Total of bergs by modes by revenue centers.
Fields 4,6,8 are unused.

Code 4:

Total sales by divisions by modes by revenue centers.
Field 4 is unused.

Code 5:

Total taxes by modes by revenue centers.
Fields 4,7 are unused.

Code 6:

Total discounts by modes by revenue centers.
Field 4 is unused.

Code 7:

Total service by modes by revenue centers.
Record 1 contains service.
Fields 4,7 are unused.

Code 8:

Total non taxable sales by taxes by modes by revenue centers.
Fields 4,7 are unused.

Code 9:

Total taxable sales by taxes by modes by revenue centers.
Fields 4,7 are unused.

Code 10:

Total payments by modes by revenue centers.
Field 4 is unused.
Field 7 is unused for record 1.

Code 11:

Void list of items.
Field 4 contains the waiter number.
Field 6 contains the item description.

Code 12:

Void list of miscellaneous.
Field 4 contains the waiter number.
Field 6 contains the miscellaneous description.

Code 13:

Void list of items training.
Field 4 contains the waiter number.
Field 6 contains the item description.

Code 14:

Void list of miscellaneous training.
Field 4 contains the waiter number.
Field 6 contains the miscellaneous description.

Code 15:

Total sales by divisions by waiters.
Fields 2,3 are unused.
Field 4 contains the waiter number.

Code 16:

Total discounts by waiters.
Fields 2,3 are unused.
Field 4 contains the waiter number.

Code 17:

Total services by waiters.
Record 1 contains service.
Record 2 not used.
Record 3 contains delivery fees.
Fields 2,3 are unused.
Field 4 contains the waiter number.

Code 18:

Total payments by waiters.
Fields 2,3 are unused.
Field 4 contains the waiter number.
Record 1 quantity is unused.

Code 19:

Total taxes and number of clients by waiters.
Fields 2,3,4 are unused.
Field 5 contains the waiter number.
Field 6 contains the waiter name.
Field 7 contains the number of clients.
Field 8 contains the tax.

Code 20:

Waiter times.
Fields 2,3,8 are unused.
Fields 4 contains the waiter number.
Field 7 contains the time in hundreds of seconds.
Record 1 contains last report time.
Record 2 contains first order time.
Record 3 contains last bill time.

Code 21:

Total sales by divisions by waiters training.
Fields 2,3 are unused.
Field 4 contains the waiter number.

Code 22:

Total discounts by waiters training.
Fields 2,3 are unused.
Field 4 contains the waiter number.

Code 23:

Total services by waiters training.
Record 1 contains included service.
Record 2 contains excluded service.
Fields 2,3 are unused.
Field 4 contains the waiter number.

Code 24:

Total payments by waiters training.
Fields 2,3 are unused.
Field 4 contains the waiter number.
Record 1 quantity is unused.

Code 25:

Total taxes and number of clients by waiters training.
Fields 2,3,4 are unused.
Field 5 contains the waiter number.
Field 6 contains the waiter name.
Field 7 contains the number of clients.
Field 8 contains the tax.

Code 26:

Waiter training times.
Fields 2,3,8 are unused.
Fields 4 contains the waiter number.
Field 7 contains the time in hundreds of seconds.
Record 1 contains last report time.
Record 2 contains first order time.
Record 3 contains last bill time.

Code 27:

Statistics by modes by revenue centers.
Fields 4,8 are unused.
Record 1 contains the number of clients.
Record 2 contains the number of meals.

Code 28:

File stamps.
Field 2 contains value 1.
Field 3,4 are unused.
Record 1 contains the first and last bill number.
Record 2 contains the first and last daily report number.
Record 3 contains the starting and ending date.
The date is defined as a sequential number starting from the birth of the Christ.
Record 4 contains the starting and ending time.
The time is in 1 / 100s of seconds.

Code 29:

Daily numbering.
Fields 3,4,8 are unused.
Field 2 contains value 1.
Record 1 contains the number of days cumulated.
Record 2 contains the daily number.

Code 30:

Total of segmentations.
Field 7 contains the number of clients.
Field 8 contains total sales after discount.
Fields 2,3,4,6 are unused.

Code 31:

Total of sales by category by mode by revenue center.
Field 4 is unused.

Code 32:

Miscellaneous information on waiters.
Fields 2 and 3 are unused.
Field 4 contains the waiter number.
Record 1 contains the cash tips.
Record 2 contains the charges with tips.
Record 3 contains the number of meals and their value.
Record 4 contains the inclusive tax.
Record 5 contains the tips due to this employee.
Record 6 contains the tips paid to this employee.
Record 7 contains the number of times the no sale button was used.

Code 33:

Miscellaneous information on waiters in training.
Fields 2 and 3 are unused.
Field 4 contains the waiter number.
Record 1 contains the cash tips.
Record 2 contains the charges with tips.
Record 3 contains the number of meals and their value.
Record 4 contains the inclusive tax.
Record 5 contains the tips due to this employee.
Record 6 contains the tips paid to this employee.
Record 7 contains the number of times the no sale button was used.

code 34:

Contains the store number.
Only field 6 is used.

code 35:

Information on the media types
field 2 contain the menu number
field 3 contain the mode number
field 4 contain the media type number
field 5 contain the number of the server who received the payment
field 6 contain the folio
field 7 contain the expiration date

code 36:

Total discounts by divisions by modes by revenue centers.
Fields 4,7 are unused.

Code 37:

Total discounts by division category by modes by revenue centers.
Fields 4,7 are unused.

Code 38:

Total taxes by category by modes by revenue centers.
Fields 4,7 are unused.
Modifications list:
Modified for Version 4.17.xx
The transaction code 17 does not contain excluded and included service because the notion is no longer supported. Instead the record 1 will contain the service charged and record 2 is unused. Record 3 was added to contain the delivery fees charged.
Modified for versions 4.17.21 and 5.02.55
The field for menu identifying was increased from 1 to 2 chars because the 5.02.xx supports 32 menus instead of 4 for the 4.17.xx
The 4.17.xx version has also been updated to 2 chars for compatibility with the 5.02.xx versions. The total length of the transaction is thus increased to 54 bytes.
The transaction code 2 for miscellaneous contains the proper breakdown of miscellaneous by miscellaneous instead of grouping them by taxes. The 4.17 does not support this enhancement of the 5.02.xx
In the 5.02, new categories of reports have been created covering pay week and pay period. So new identification codes have been added to the file.
Modifications for versions 5.02.65
Modification added in version 7.01.05
Code 38 added to separate taxes from tax category.

Samples:

JOUR.ASC sample

00 0000100000JOURNAL REPORT +20031994+0000000000
34 0000000000RESTAURANT CODE +00000000+0000000000
01 0110000000CHICKEN SAUCE +00000003+0000000510
02 0110000003CHICKEN +00000001+0000000100
04 0110000001ENTREES +00000040+0000006130
09 0110000001T.V.Q. +00000000+0000161317
05 0110000001T.V.Q. +00000000+0000012909
06 0120000009DISCOUNT +00000000+0000000900
10 0110000002VISA +00000014+0000030889
27 0110000001Number of clients +00000175+0000000000
28 0100000001BILL NUMBER +00180392+0000180757
10 0420000009DIRECT PAYMENT +00000001+0000002146
27 0420000002Number of Meals +00000007+0000000000
35 01100200034501160715952 +00009505+0000000954
VERSION MAITRE'D 99 (Rev. 4.00)
With this release, it is possible to generate standard ASCII files. Instead of the jour, semaine, mois, periode, annee and lecture file described above, the day, week, month, period, year and reading files is generated, these file will have a .txt extension. If this option is turned on, the structure of the files will be:

General format:

field format description
1 alphanumeric transaction code
2 alphanumeric menu number
3 alphanumeric mode number
4 alphanumeric miscellaneous
5 alphanumeric record number
6 alphanumeric description
7 numeric quantity
8 numeric with 2 decimals
9 alphanumeric report start date
10 alphanumeric report end date
"0","0","0","10","0","DAILY REPORT",0,0.00,"25 / 11 / 1994","25 / 11 / 1994"
"34","0","0","0","0","",0,0.00,"",""
"1","1","1","0","0","CUISSE",1,6.15,"",""
"1","1","2","0","0","CUISSE",1,6.15,"",""
"1","1","1","0","0","POITRINE",1,7.35,"",""
"1","1","2","0","0","POITRINE",1,7.35,"",""
For the detail of the transaction code, please refer to the description explain above in this document.
The transaction codes 36 and 37 have been added to the system. They supply the discount totals per divisions or division categories.