The following is a sample file layout for the THECOUNT.EXE program.
Program: THECOUNT.EXE
Data File: THECOUNT.DAT
File Type: Fixed Length (record length = 128 bytes)
THECOUNT.DAT File Layout
Field Name Length Format
----- ---------------- ------ ----------------------------------------------
1 Client Number 12 up to 12 digits (with optional decimal point)
2 Timekeeper 3 up to 3 digits (ignored for costs)
3 Date 8 mm/dd/yy format
4 Transaction Code 6 up to 5 digits preceded by a "$" for costs (trans code cannot be greater than
30320 in value)
5 Hours Worked 6 hours worked in decimal format up to 320.00
maximum (i.e. 1.25 is 1 hr. 15 min.)
6 Amount 10 billable dollar amount up to 9999999.99
7 Hourly Rate 6 hourly billing rate up to 999.99
8 Billing Category 3 optional Tabs3 billing category for fees
9 Description 50 up to 50 characters of text
10 Filler 22 20 spaces with a carriage return/line feed
at the end
NOTES
1) The Timekeeper, Hours Worked, Hourly Rate and Category (fields 2, 5,
7 and 8) are ignored for cost transactions (costs are denoted by prefixing the transaction code number with "$").
2) The Client Number can be from 3 to 12 digits long with an optional
decimal point separating the client number from the matter number.
3) If the Hourly Rate field is blank or zero, then the Tabs3 Merge
Data Capture Transactions program will supply the default rate
assigned in the Tabs3 client record (the Amount field will not be
recomputed by Tabs3).
4) If the Category field is blank or zero, then the Tabs3 Import
program will supply the default category assigned in the Tabs3 client
record.
5) If both Hourly Rate and Amount fields are blank or zero, then Tabs3
will supply a default rate and calculate the Amount automatically.
6) When the data is merged into Tabs3, the Timekeeper, Client Number
and Transaction Code fields are verified as being valid. Transactions
with invalid fields are rejected and a list of rejected transactions can
be printed along with an error code indicating why it was rejected.
Sample THECOUNT.DAT data file: Each record has been divided into 2 separate
64 byte sections so the records won't be truncated on the page. Also, the
first 3 lines are not part of the THECOUNT.DAT file.
1 2 3 4 5 6
1234567890123456789012345678901234567890123456789012345678901234
----------------------------------------------------------------
101.00 202/19/98 1 1.50 90.00 60.00 10Office con
ference with Karen Barrett.
200.01 02/15/98$ 23 25.00 Court fili
ng fee.
101.00 02/15/98$ 21 1.15 Photocopie
s.
101.00 202/19/98 3 1.22 73.20 0.00 Telephone
conference with Ms. Barrett.
200.01 02/19/98$ 21 2.50 Photocopy
originals.
200.02 02/19/98$ 23 25.00 Pay County
Court filing fee in advance.
102.00 102/20/98 5 .50 50.00100.00 1Letter to
client's banker.