The following is a sample file layout for the ULTIMATE.EXE program.
Program: ULTIMATE.EXE
File Type: Fixed Length (record length = 90 bytes)
File Layout
Field Name Length Format
----- ---------------- ------ ------------------------------------------
1 Extension Number 4 number
2 Filler 1
3 Trunk Number 8 number
4 Filler 1
5 Phone Number 16 phone number with( ) and -
6 Filler 1
7 Date 8 mm/dd/yy format
8 Filler 1
9 Time 6 hh:mmt (t is either A for AM or P for PM)
10 Filler 1
11 Duration 7 decimal
12 Filler 2
13 $ 1 just a $
14 Cost 7 amount
15 Filler 1
16 Client/Matter 12 client and matter separated by # or *
17 Filler 13 optional carriage return/line feed
NOTES
1) The Trunk Number, Time, Duration and Filler fields are ignored.
2) The Client Number can be up to 12 digits long with a pound sign (#)
or asterisk (*) separting the client and matter parts.
3) The program will store a telephone transaction code and how descriptions
are converted in the parameter file. Descriptions can be converted with
the extension number and phone number or the transation code description.
4) The program verifies the record by checking for the slash in the date
and the $ in field 13. Transactions with a zero Cost will not be converted,
but will be noted in the ULTIMATE.ERR file.
5) When the data is merged into TABS III, 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 ULTIMATE 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 file.
1 2 3 4 5 6 7
12345678901234567890123456789012345678901234567890123456789012345678901234567
-----------------------------------------------------------------------------
247 000014 151( )-0836240 05/26/99 10:03A 1.6.666 $ 1.00 0220021
247 000015 ( )153-0756601 05/26/99 10:04A 1.3.333 $ 2.00 4020021
283 000012 ( )171-5833394 05/26/99 10:02A 2.7.666 $ 3.00 999#001
283 000015 ( )153-0673073 05/26/99 10:04A 1..5 $ 4.00 191#002
247 000011 ( )180-0643358 05/26/99 10:01A 3.7.166 $ 5.00 9990011
880 000015 180032 05/26/99 10:05A 0.2.166 $ 6.00 999#001