The following is a sample file layout for the CONVTRAK.EXE program.
Program: CONVTRAK.EXE
This program converts data
Data File: CUST.DAT (for H-Link) or ERSCUST.DAT (for ERS)
CUST.DAT File Layout
File Type: Fixed Length (record length = 94 bytes)
Note: The first line of the CUST.DAT file contains a header that is skipped
when the file is converted.
Name Start Length Description
-------------------- ----- ------ ---------------------------------------------
Transaction Type 1 1 Either an "A" (photocopy), "C" (disbursement)
or "E" (fax or phone call)
Client/Matter Number 2 16 Can have a "." or "-" or no separator between
client and matter number
User Name 18 8 Used in descriptions
Transaction Date 26 6 Transaction date in YYMMDD format
Fields specific to photocopies:
-------------------------------
Copy Count 40 8 Used in descriptions
Amount 69 8 $1.23 stored as 00000123
Fields specific to disbursements:
---------------------------------
Function Key 32 1 Will be characters "A" - "H" - they stand
for 8 possible miscellaneous user
defined disbursements
Disbursement Name 62 8 Used in descriptions
Amount 54 8 $1.23 stored as 00000123
Fields specific to faxes or phone calls:
----------------------------------------
Fax or Phone? 55 8 If "PHONETRK" is stored here, the tran is
assumed to be a phone call - otherwise,
it is assumed to be a fax
Amount 63 8 $1.23 stored as 00000123
Phone Number 77 16 Used in descriptions
Sample CUST.DAT data file:
Note: Each record has been divided into 2 separate sections (a 70 byte
section followed by a 24 byte section) so the records won't be truncated on
the page. Also, the first 3 lines are not part of the CUST.DAT file.
1 2 3 4 5 6 7
1234567890123456789012345678901234567890123456789012345678901234567890
----------------------------------------------------------------------
59Control Systems New England
A100.00 BALDWIN 910612000000010000000700000140 000COPIER0100
000140
C101.00 ABBOTT 910611A00000495@@000PHONETRK00000495TELEPHNE
E102.00 POWERS 91061215400000001800001900067FAXTRK0100001900
426 7502
E103.00 POWERS 91061215530000000100000200002PHONETRK00000200
1 508 692 2559
A200.01 FLAHERTY910612000000010000001300000260 000COPIER0100
000260
C200.02 ABBOTT 910611B00000288@@000PHONETRK00000288TELEPHNE
===============================================================================
ERSCUST.DAT File Layout
File Type: Fixed Length (various lengths depending on the transaction type)
Note: The record length for each transaction type is different. The following
table lists the possible transaction types and record lengths:
Type Description Length
---- ----------- ------
C Photocopy 184
F Fax 217
P Phone Call 201
L Laser Copy 176
D Database 195
X Disbursement 175
T Time 187
Name Start Length Description
-------------------- ----- ------ ---------------------------------------------
Transaction Type 1 1 Either a "C", "F", "P", "L", "D", "X", or "T"
Client/Matter Number 2 16 Can have a "." or "-" or no separator between
client and matter number
Transaction Date 20 6 Transaction date in YYMMDD format
Description 70 32 Transaction description - used in converted
descriptions
Fields specific to photocopies:
-------------------------------
Copy Count 159 8 Used in converted descriptions
Amount 175 8 $1.23 stored as 123
Fields specific to faxes:
-------------------------
City 166 8 Used in converted descriptions
State 174 2 Used in converted descriptions
Page Count 184 8 Used in converted descriptions
Amount 208 8 $1.23 stored as 123
Fields specific to phone calls:
-------------------------------
City 166 8 Used in converted descriptions
State 174 2 Used in converted descriptions
Amount 192 8 $1.23 stored as 123
Fields specific to laser copies:
--------------------------------
Page Count 151 8 Used in converted descriptions
Amount 167 8 $1.23 stored as 123
Fields specific to database transactions:
-----------------------------------------
Amount 186 8 $1.23 stored as 123
Fields speccific to miscellaneous disbursments:
-----------------------------------------------
Amount 166 8 $1.23 stored as 123
Fields specific to time transactions:
-------------------------------------
Timekeeper 30 8 Has to correspond to the TABS III timekeeper
number
Amount 178 8 $1.23 stored as 123
Type Description Length
---- ----------- ------
C Photocopy 184
F Fax 217
P Phone Call 201
L Laser Copy 176
D Database 195
X Disbursement 175
T Time 187
Sample ERSCUST.DAT data file:
Note: Each record has been divided into 3 separate sections (2 75 byte
sections followed by a 34/67/51/26/45/25/37 byte section for record type
C/F/P/L/D/X/T) so the records won't be truncated on the page. Also, the
first 3 lines are not part of the ERSCUST.DAT file.
1 2 3 4 5 6 7
123456789012345678901234567890123456789012345678901234567890123456789012345
---------------------------------------------------------------------------
C100.00 199502011116 SUBPOE
NAS COPFAX02WAGNER 5516 1
3 3 75 75
F200.01 199502021626
COPFAX02SMITHC 1186 1
8002530332 NEW CASTDE 68 2 550 0 550
P200.02 199502161125 21
PHONTRAKEXT21 3
023258900 NEW CASTDE 78 61 61
X200.03 199502081210
COPFAX01HENRY 2179 P
OSTAGE 1441 1441
D300.00 199502031124
COPFAX01ADAMS 0796 L
EXIS 180 2995 2995
L400.00 199502031447
COPFAX01GUTH 5804 1
112 1120 1120
T402.00 199502031459003 CORP D
OCUMENTS COPFAX01GUTH 5804 1
99502272314 960 9750 9750