Technical Note: 20011004047

Inventory Transfer File

(Maitre'D 2002, and later versions of Maitre'D)
The codes higher than 60 contains a different structure
Transfer file for the inventory.
The inventory Transfer file can be generated any time, however the purchase bills will be posted only once. This file has the name of STOCK.ASC
Specifications for the ASCII transfer file

General Format:

Field Length Format Description
1 2 numerical transaction code
2 16 alphanumerical Inventory item code
3 20 alphanumerical description
4 14 -numerical quantity, 3 decimals
5 2 alphabetical CR,LF
total 54    
-numerical Numerical with the sign in front
Note : a field not used contains either zeros or spaces depending on the case.

Code 60:

Total quantity of inventory stock in the beginning of the day (just
after the running End of day) for each inventory item.
field 2 : product code
field 3 : product description
field 4 : quantity

Code 61:

details of the purchases journal for the new bills of purchase
(not posted in the last report)
field 2 : product code
field 3 : product description
field 4 : quantity

Code 62:

contains the branch number
only the 3rd field is used.

Code 63:

contains the inventory date in the 4th field.
the other fields are not used.

Code 64:

invoice number
field 3 : invoice number

Code 65:

invoice supplier
field 2 : supplier code
field 3 : supplier description

Code 66:

invoice date
field 2 : date received (YYYYMMDD)
field 3 : date due (YYYYMMDD)

Code 67:

invoice total amount
field 4 :total invoice

Code 68:

Invoice item detail for preceding invoice
field 2 : product code
field 3 : product description
field 4 : quantity

Code 69:

Accounting item detail for preceding invoice
field 2 : Account code
field 3 : Account description
field 4 : price

Code 70:

end of detail

STOCK.ASC sample

62 RESTAURANT CODE +0000000000000
60 REC GARN.FRUITS REC GARN.FRUITS +0000000000000
60 REC OMELETTE REC OMELETTE +0000000000000
61 REC PAIN DORE REC PAIN DORE +0000000000000
61 MOLSON EXPORT MOLSON EXPORT +0000000001000
61 MILK 20L MILK 20 LITRES +0000000001000
61 CREME GODET CREME A CAFE (200UN) +0000000004000
61 CREME SURE CREME SURE (500ML) +0000000004000
64 CELERI PIED DE CELERI (UN) +0000000003000
64 A123456 +0000000000000
65 SUPPLIER CODE SUPPLIER DESCRIPTION +0000000000000
66 19970322 19970422 +0000000000000
67   +0000000200000
68 CELERI PIED DE CELERI (UN) +0000000003000
68 MOLSON EXPORT MOLSON EXPORT +0000000001000
68 MILK 20L MILK 20 LITRES +0000000001000
68 CREME GODET CREME A CAFE (200UN) +0000000004000
68 CREME SURE CREME SURE (500ML) +0000000004000
69 T.P.S. TPS +0000000002750
67   +0000000000000
The inventory transfer file will be named stock.txt and will use the following format:
Since this is a standard ASCII file, the size of the fields are variable, the strings are enclosed in "" and each record is terminated by a carriage return / linefeed (cr / lf).

General Format :

Field Format Description
1 alphanumeric transaction code
2 alphanumeric inventory item code
3 alphanumeric description
4 numerical quantity, 3 decimals
5 alphanumeric date de l'inventaire
"62","","",0.000,""
"63","","",0.000,"29 / 11 / 1994"
"60","CARROT JUMBO","CARROT JUM(22.68KG)",19.449,""
"60","LAITUE ICEBERG","LAITUE ICEBERG (UN)",0.296,""
"60","REC CREME BROCOL","REC CREME BROCOLI",0.000,""
"60","VIN CHOUX","VIN SAL.CHOU 12x1.4l",87.330,""
"60","CHOUX","CHOUX GROS (22.68KG)",88.147,""