 |
||
 |
 |
 |
|
|
|||||||||
Last edited: December 15, 2003 08:09 AM
At the close of every check, TouchNet records information to an appropriate .JOU file. This file is stored in the REPORTS subdirectory as a child of the operational directory IE: C:\TouchNet\Joes\Reports. The name of the .JOU file is a 6 digit code representing the business day. This is its format:
YYMMDD.JOU - Where Y=Year M=Month D=Day, using leading 0's where applicable.
An attempt was made in designing the format of the file, to have it be versatile enough to store any and all information necessary for elaborate reporting needs. At the same time speed and size were also given heavy consideration. The result is a non-standard Proprietary file format.
The file is composed of many 14 byte records. A single transaction may require the use of as few as 3 records, and many more depending upon the transaction complexity. Here is the 14 byte record format:
Field Name Type Bytes Code Integer 1-2 Amount1 Long Integer 3-6 Amount2 Long Integer 7-10 Data1 Integer 11-12 Data2 Integer 13-14
NOTE: All fields are stored in LSB,MSB order.
A record may have many different meanings, depending upon the value of it's CODE field. Here is a list of codes, and the meaning of the 4 remaining fields for each:
CODE Value | Description | AMOUNT1 | AMOUNT2 | DATA1 | DATA2
-----------|--------------------|-----------|----------|---------|--------
-1999-+999 | PLU Sales by item | Sold Price| 1=Voided |LSB:Group|Taxes
(negative) | PLU=ABS(Code) | | |MSB:Dept |Computed
-----------|--------------------|-----------|----------|---------|--------
1000 | Trans Declaration | Chk Amount| #Voids | Start |Finish
| | | | Time |Time
-----------|--------------------|-----------|----------|---------|--------
1001 | Responsability Code| Server | Cashier | Server |Cashier
| | Job Code | Job Code | ID |ID
-----------|--------------------|-----------|----------|---------|--------
1002 | General Information| 8Ch Node Name | Table #|Covers
-----------|--------------------|-----------|----------|---------|--------
1003 | Media Information | Media #1 | Media #2 | Media #1|Media #2
| | Amount | Amount |* Method | Method
-----------|--------------------|-----------|----------|---------|--------
1010 | Misc Info | PLU Sub | Customer | Check |Gratuity
| | Total |Account # | ID |
-----------|--------------------|-----------|----------|---------|--------
1011 | Sales Tax A Data | A-Taxable | Amt |Tax Rate |Included
| | Subtotal | Charged | |Rate
-----------|--------------------|-----------|----------|---------|--------
1012 | Sales Tax B Data | B-Taxable | Amt |Tax Rate |Included
| | Subtotal | Charged | |Rate
-----------|--------------------|-----------|----------|---------|--------
1013 | Sales Tax C Data | C-Taxable | Amt |Tax Rate |Included
| | Subtotal | Charged | |Rate
-----------|--------------------|-----------|----------|---------|--------
1014 | Sales Tax D Data | D-Taxable | Amt |Tax Rate |Included
| | Subtotal | Charged | |Rate
-----------|--------------------|-----------|----------|---------|--------
1020 | Declares Trans. | | | |
| was voided | | | |
-----------|--------------------|-----------|----------|---------|--------
1021 | User Variables | UDollar1 | UNumber1 | |
-----------|--------------------|-----------|----------|---------|--------
1022 | User Variables | UDollar2 | UNumber2 | |
-----------|--------------------|-----------|----------|---------|--------
1023 | User Variables | UDollar3 | UNumber3 | |
-----------|--------------------|-----------|----------|---------|--------
1031 | User Variable | 8 Ch UWord1 | |
-----------|--------------------|-----------|----------|---------|--------
1032 | User Variable | 8 Ch UWord2 | |
-----------|--------------------|-----------|----------|---------|--------
1033 | User Variable | 8 Ch UWord3 | |
-----------|--------------------|-----------|----------|---------|--------
1040 | Order Type | 8 Ch OrderType | |
-----------|--------------------|-----------|----------|---------|--------
1050 |PIN (Product ID Num)| LSB: PIN | MSB: PIN | |
| Preceeds each PLU | | | |
| if Secret Global | | | |
| Option is Set. | | | |
-----------|--------------------|-----------|----------|---------|--------
1060 | Tip Out |Tip Amount |Time |From ID |To ID
-----------|--------------------|-----------|----------|---------|--------
1061 | Declared Tip |Tip Amount |Time |Emp ID |Media
-----------|--------------------|-----------|----------|---------|--------
1500 |Priority Information| | |Bit: |
| | | | 0-OvRing|
| | | | |
| | | | |
| | | | |
-----------|--------------------|-----------|----------|---------|--------
5000 | PizzaMGR | Description of Transaction
-----------|--------------------|-----------|----------|---------|--------
5001 | PizzaMGR | Amount | EmpID | Kind(1) |Time
-----------|--------------------|-----------|----------|---------|--------
5002 | PizzaMGR | Bag # | Mileage | |
-----------|--------------------|-----------|----------|---------|--------
5003 | Cash Transactions | Amount | Emp ID | Kind(2) |Time
-----------|--------------------|-----------|----------|---------|--------
5004 | TacoBell InvItem | Description of Item |Number
-----------|--------------------|-----------|----------|---------|--------
5005 | TacoBell InvTrans | Cost | Purchases|Begin Inv|End Inv
-----------|--------------------|-----------|----------|---------|--------
5006 | PizzaMGR(OrderTakr)| CheckAmnt | EmpID |Strt Time|End Time
-----------|--------------------|-----------|----------|---------|--------
5101-5199 |Used by VoidRP |Amt of PLU |EmpID 2byt|PLU # |Check#
|to store voids | |SrvID 2byt| |
-----------|--------------------|-----------|----------|---------|--------
6000-6999 |Custom Computing #'s| | | |
-----------|--------------------|-----------|----------|---------|--------
The media method is a number 0-15 corresponding with the Media Definitions in EditNet.
PLU Notes:
In Version 5, it became possible to have 2000 PLU's. Because a code could be a PLU number, and code numbers 1000 and above had special meanings, PLU's
(1) Kind of Transaction for PizzaManager can be:
- Paid In
- Paid Out
- Deposit
- Drop
- Starting Bank for Store
- Ending Bank for Store
- Driver Drop
- Misc Cash Adjustment (Blimpie)
(2) Kind of Transaction for TacoMGR can be:
- Cash In Till
- Register Fund
- Deposit
- Cash Drop
When a Transaction is recorded, it is first preceded with a CODE 1000,as a transaction Declaration. Note that time values are recorded in military as 'HHMM'. Next if a Server and/or Cashier were involved, their information is recorded using CODE 1001. If the program is styled without this, the Code will not be found in the Journal. If a Table number (Not letter), and/or Cover number is part of the order, CODE 1002, will contain that information. Otherwise the Code will not be recorded into the Journal. Next Code 1010 will store some information, followed by any neccesary Sales Tax information with Codes 1011-1014. Finally each PLU will have a record of it's own, with information relating. If the transaction was voided, CODE 1020 will indicate such.
THIS DOCUMENT IS PROVIDED BY HOSPITALITY DATA SYSTEMS INC. FOR USE BY ITS APPROVED DEALERS AND DISTRIBUTORS, AND IS FOR INFORMATIONAL PURPOSES ONLY. The information contained in this document represents the current view of Hospitality Data Systems Inc. on the issues discussed as of the date of publication. Because Hospitality Data Systems Inc. has no control over the skills of the user, how the information will be used, and must respond to changes in software and market conditions, it should not be interpreted to be a commitment on the part of Hospitality Data Systems Inc.
THE INFORMATION PROVIDED IN THE HOSPITALITY DATA SYSTEMS INC. KNOWLEDGE BASE IS PROVIDED ‘AS IS’ WITHOUT WARRANTY OF ANY KIND. HOSPITALITY DATA SYSTEMS INC. DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL HOSPITALITY DATA SYSTEMS INC., OR IT’S SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF HOSPITALITY DATA SYSTEMS INC., OR IT’S SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.
The user assumes the entire risk as to the accuracy and the use of this document. This document may be copied and distributed subject to the following conditions:
1. All text must be copied without modification and all pages must be included.
2. All copies must contain this notice, Hospitality Data Systems Inc. copyright notice, and any other notices provided therein.
3. This document may not be distributed for profit.
Copyright © Hospitality Data Systems Inc. All Rights Reserved