Installation

Copy the files into the TOUCHNET directory. The application then needs to be styled to allow the server to select a member and post the information properly to the journal. A styling module does not currently exist for this interface.
Technical

HAND2BUK requires that HandiComp’s CLUB.DAT file be located in the DATA subdirectory. It then creates three files. IMP.BUK is a bucket file that can be read by TouchNet’s Get and Put commands. IMPALPHA.TXT is a text file formatted to work with LIST-IT and allows the server to select the customer by name from a list. IMPNUM.TXT is a text file formatted to work with LIST-IT and allows the server to select the customer by number from a list. File formats are detailed in the next section.

HANDICOM allows you to select a date, then reads the appropriate journal file and generates an export file called CF(date).PRN in the REPORTS subdirectory. HANDICOM looks at the Word1 variable for the account number. If it is blank, that check is not included in the export. If it is not blank, the following information is grabbed by the utility:

    Check Information Handicomp Data Journal Source
    Account Number Word 1
    Family Number Word 2 (first 2 digits)
    Reciprocating Number Word 3
    Check Number Check Number
    Table Number Table Number
    Partysize Covers
    Time Opened Start Time
    Time Printed End Time
    Station Always 1
    Costcenter Always 1
    Server Number Server ID
    Check Printed Total Check Amount
    Discount Printed Always 0.00
    Discount Type Always 0
    Tax Printed Sales Tax
    Tax Total Sales Tax + Included Tax
    Cashier Number Cashier ID
    Terminal Number NodeName (first 2 digits)
    Drawer Number Always 0
    Payment Type Always 0
    Amount Tendered Check Amount + Gratuity
    Tip Portion Gratuity
    Cash Paidout Portion Always 0
    Issue Portion Always 0
    Sales Cat Total 1 to 20 Department Total 1 to 20
    Sales Unassigned Total Sum of other Departments

    Item Information Handicomp Data Journal Source
    Main Item Inv Number Priced Item PLU Number
    Option Inv Number Unpriced Item PLU Number
    Printed Price Price Charged
    Tax Code 1=Taxed,2=Included,3=Exempt
    Tax Flag Sales Tax Number
    Discount Number Always 0
    Cover Flag Always 0
    Deletion Reason Always 0
    Multiplier Always 1

In addition to the journal file HANDICOM reads GLOBAL.DAT, and GENERAL.DAT.
File Formats

IMP.BUK

This uses TouchPro’s bucket format where each 200 characters corresponds to one row. There are no carriage returns or line feeds. Members are imported in the exact order they are listed in HandiComp’s CLUB.DAT file. Data is written directly as it appears in the file.

    Column Contents

    1-5 Member Number

    11-12 Family Number

    41-67 Name (Last,First,MI)

    81-93 Phone

    121 Member Type

    131 Reciprocating Flag

    141-145 Credit Limit

    151 Status Code

    161-164 Mag Card Number

    171-175 Key

IMPALPHA.TXT

This file contains 40 characters per line with the member name in the first 30 characters and the account and family number taking the last 10 characters. This format is designed specifically for viewing with LIST-IT. Members are listed in the same order as in IMP.BUK, allowing the server to select the member from a LIST-IT window, after which TouchPro can select additional information from the bucket file.

IMPNUM.TXT

This file is identical to IMPALPHA.TXT except that the names and numbers are reversed. This allows the server to select a member by number.

CFmmddyy.PRN

The date selected when running HANDICOM will be the date used in the file name. The file is formatted as comma delimited, with text fields enclosed in quotes. The first field in each line is the record type. There are seven record types. Each check will generate one record type 1, 4, 5, 6, and 7. Each priced item on a check will generate a record type 2. Each unpriced item will generate a record type 3.

    Type Fields
    1 Check#, Table#, Time Opened, Time Printed, Station,
    Costcenter, Server#, Partysize

    2 Main Item Inv#, Printed Price, Tax Code, Tax Flags,
    Discount#, Cover Flag, Deletion Reason, Multiplier

    3 Option Inventory#

    4 Sales Cat1 Total, Sales Cat2 Total, …, Sales Cat20 Total,
    Sales Unassigned Total

    5 Check Printed Total, Discount Printed, Discount Type,
    Tax 1 Printed, Tax 1 Total, …, Tax 4 Printed, Tax 4
    Total

    6 Station, Server#, Cashier#, Check#, Terminal#, Drawer#

    7 Payment Type, Amount Tendered, Tip Portion, Cash Paidout
    Portion, Issue Portion, Export Information
      Note: Export Info consists of Account#, Family#,
      Amount Tendered, and Recip# as a single text field.

Example
1,4297,123,17:20,17:20,1,1,999,3
2,1,8.00,1,1,0,0,0,1
3,226
3,504
2,2,9.10,2,10,0,0,0,1
2,3,11.35,1,100,0,0,0,1
4,8.00,9.10,11.35,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00, …, 0.00
5,29.15,0.00,0,0.70,0.70,0.00,0.73,0.00,0.00,0.00,0.00
6,1,999,999,4297,01,0
7,0,34.15,5.00,0,0,”123456-78,34.15,abcd  “
Restrictions

These utilities do not check any data for validity or restrictions of the receiving program. It is assumed that the source program is designed not to generate any invalid data. Some known restrictions are:

1. Server numbers cannot be over 3 digits.

2. Node names must have the first two characters be numeric, such as 01CASH.

3. Do not close checks as overrings.
Revisions

1/31/97 Version 1.0

    Initial Release

4/30/97 Version 6.00

    Upgrade to version 6. These executables are still compatible with TouchPro 5.xx applications. Removed requirement that DOS Share be running.

1/27/00  Version 6.01  rw