The following is a sample file layout for the TAPIT.EXE program.
Program: TAPIT.EXE
Data File: TABSIII.DTA
File Type: Fixed Length (record length = 128 bytes)
TABSIII.DTA File Layout
Field Name Length Format
----- ---------------- ------ ----------------------------------------------
1 Client Number 12 up to 12 digits (decimal point required)
2 Timekeeper 3 up to 3 digits (ignored for costs)
3 Date 8 mm/dd/yy format
4 Transaction Code 6 up to 3 digits preceded by a "$" for costs,
where the tcode does not exceed 999 in value
(i.e., fee tcodes would look like " 123"
and cost tcodes would look like "$ 123")
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) Each telephone transaction exported from the TAPIT unit contains two
records: a fee record and a cost record. Only cost records are converted by
the TAPIT conversion program. Fee records are ignored.
2) 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 field with "$").
3) The Client Number can be from 3 to 12 digits long with a required
decimal point separating the client number from the matter number.
4) When the data is merged into Tabs3, Client Number, Date, 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 TABSIII.DTA 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 TABSIII.DTA file.
1 2 3 4 5 6
1234567890123456789012345678901234567890123456789012345678901234
----------------------------------------------------------------
101.00 05/04/93$ 399 0.43 |Extension
0130 made a call to 19144721567
101.00 05/04/93 398 0.01 -Extension
0130 made a call to 19144721567
200.01 05/04/93$ 399 9.31 |Extension
0135 made a call to 19148999000
200.01 05/04/93 398 0.17 -Extension
0135 made a call to 19148999000
102.00 05/04/93$ 399 1.21 |Extension
0113 made a call to 12014050300
102.00 05/04/93 398 0.02 -Extension
0113 made a call to 12014050300
1003.21 05/04/93$ 399 0.43 |Extension
0130 made a call to 14079942464
1003.21 05/04/93 398 0.01 -Extension
0130 made a call to 14079942464