The following is a sample file layout for the CONVASCF.EXE program.
Program: CONVASCF.EXE
Data File: TABS3.ASC
File Type: Fixed Length (record length = 128 bytes)
TABS3.ASC 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
30999 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 72 up to 72 characters of text
10 Filler 2 optional carriage return/line feed
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) Tabs3 transaction codes can be from 1 to 999. It is possible to
convert the Tabs3 bill code combined with the transaction code. A bill
code of 10 (non-billable/non-printable), 20 (non-billable/printable) or 30
(billable/non-printable) can be added to the beginning of the transaction
code. No bill code is an indication of a billable/printable transaction.
If bill code 10, 20 or 30 is used, the Tabs3 transaction code number must
be zero padded on the left to be 3 digits long (e.g., if using bill code 20
with transaction code 9, change 9 to 009 and convert transaction code 20009).
4) If both Hourly Rate and Amount fields are blank or zero, then Tabs3
will supply a default rate and calculate the Amount automatically.
5) If the Hourly Rate field is blank or zero (and the Amount field is not),
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.
6) If the Category field is blank or zero, then the Tabs3 Import
program will supply the default category assigned in the Tabs3 client
record.
7) 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.
8) Payment transactions cannot be merged into Tabs3.
Sample TABS3.ASC 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 TABS3.ASC file.
1 2 3 4 5 6
1234567890123456789012345678901234567890123456789012345678901234
----------------------------------------------------------------
101.00 202/19/88 1 1.50 90.00 60.00 10Office con
ference with Karen Barrett and all of the apartment managers.
200.01 02/15/88$ 23 25.00 Court fili
ng fee.
101.00 02/15/88$ 21 1.15 Photocopie
s.
101.00 202/19/88 3 1.22 73.20 0.00 Telephone
conference with Ms. Barrett.
200.01 02/19/88$ 21 2.50 Photocopy
originals.
200.02 02/19/88$ 23 25.00 Pay County
Court filing fee in advance on behalf of client.
102.00 102/20/88 5 .50 50.00100.00 1Letter to
client's banker.