The following is a sample file layout for the SUPERPRO.EXE program.
Program: SUPERPRO.EXE
Data File: SUPERPRO.DTA
File Type: Variable Length (though each data record is fixed length)
Note: This program was written to accommodate variances in the account number
field length. The account number can be 10, 11, or 12 characters long. The
length is determined by the position of the slashes in the date field. The
length is assumed to be 10 characters long if the slashes are in positions
25 & 28, 11 characters if they are in positions 26 & 29, or 12 characters if
they are in positions 27 & 30.
These variable record lengths are reflected in the layout below by the letter
"n". "n" is 0 if the account number is 10 characters long, 1 if the account
number is 11 characters long, or 2 if the account number is 12 characters
long.
Name Start Length Description
----------- ------ ------ -------------------------------------------------
Account 1 10 + n Client/Matter code - has a "." separator between
client and matter numbers - if no decimal,
the matter is assumed to be all zeroes
Record Type 12 + n 1 See list of possible record types below
Date 23 + n 8 Date in mm/dd/yy format
Amount 47 + n 10 Amount ($1.23 appears as 1.23)
Possible Record Types:
<space> Photocopy
A Photocopy
P Postage
T Phone
F Fax
X Federal Express
R Courier
M Mileage
Sample SUPERPRO.DTA data file (with 10 character account numbers):
Notes:
1) The first 3 lines are not part of the SUPERPRO.DTA file.
2) The sample data represents data with 10 character account numbers only.
The only difference between files with 11 or 12 character account numbers is
that all the data following the account number is shifted to the right by 1
or 2 characters.
3) The presense or absense of commas in the record does not affect the data.
The data fields are in precisely the same positions regardless of whether the
commas are present or not. If there are no commas, the positions where the
commas would be located are replaced with spaces.
4) To illustrate where commas would be, every other record listed below has
commas. Keep in mind that all records in the "real world" would either have
commas or not have commas.
1 2 3 4 5 6
123456789012345678901234567890123456789012345678901234567890
------------------------------------------------------------
MACHINE : GREGG
DATE : 09:38:57 08/08/98
REPORT SORTED BY ACCOUNT
ACCOUNT TIME DATE USE UNITS CHARGES
100.00 17:08:25 08/05/98 100 12 1.200
100.00 , ,17:16:15,08/05/98,100,,, 2, .200
SUB TOTAL FOR ACCT= 100.00
14 1.400
TOTAL FOR DEFAULT TYPE 1.400
101.00 A 09:32:45 08/04/98 240 2 .200
SUB TOTAL FOR ACCT= 101.00
2 .200
TOTAL FOR TYPE A .200
102.00 , ,12:15:15,08/07/98,240,,, 25, 2.500
102.00 P 12:15:15 08/07/98 240 11 3.630
SUB TOTAL FOR ACCT= 102.00
36 6.130
TOTAL FOR DEFAULT TYPE 2.500
TOTAL FOR TYPE P 3.630
103.00 ,T,15:30:08,08/07/98,290,,, , 1.380
SUB TOTAL FOR ACCT= 103.00
0 1.380
TOTAL FOR TYPE T 1.380
200.01 F 18:31:02 08/03/98 240 11 2.200
SUB TOTAL FOR ACCT= 200.01
11 2.200
TOTAL FOR TYPE F 2.200
200.02 , ,11:17:32,08/03/98,170,,, 3, .300
200.02 X 16:46:12 08/03/98 170 11.250
200.02 , ,16:09:01,08/04/98,170,,, 2, .200
SUB TOTAL FOR ACCT= 200.02
5 11.750
TOTAL FOR DEFAULT TYPE .500
TOTAL FOR TYPE X 11.250
200.03 R 11:03:02 08/07/98 180 6.310
SUB TOTAL FOR ACCT= 200.03
0 6.310
TOTAL FOR TYPE R 6.310
300.00 ,M,17:30:11,08/03/98,130,,, , 27.520
SUB TOTAL FOR ACCT= 300.00
0 27.520
TOTAL FOR TYPE M 27.520
TOTALS ==> 68 56.890