The following is a sample file layout for the PHONETRK.EXE program.
Program: PHONETRK.EXE
Data File: PHONETRK.DTA
File Type: Fixed Length (record length = 155 bytes)
PHONETRK.DTA File Layout
Field Name Start Len Used Explanation
----- -------------- ----- --- ---- ---------------------------------------
1 Delete Flag 1 1 No Delete Flag
2 User 2 8 Yes User ID
3 Extension 10 4 No Phone Extension
4 Date 14 4 Yes Month and Day of call (in MMDD format)
5 Time 18 4 No Time of call (HHMM format)
6 Trunk 22 6 No Phone Trunk
7 Phone Number 28 25 Yes Phone Number
8 Duration 53 6 No Call Duration
9 Account Number 59 12 Yes Account Number (101.00 stored as 10100)
10 Name 71 20 No Name
12 Department 91 20 No Department
13 Description 111 20 No Description
14 Cost 131 6 Yes Cost ($123.45 stored as 12345)
15 City 137 10 Yes City
16 Area Code 147 3 No Phone Area Code
17 State 150 2 Yes State
18 Code1 152 1 No Don't know what code is used for
19 Code2 153 1 No Don't know what code is used for
20 CR/LF 154 2 No Carriage Return/Line Feed
Notes:
1) The PHONETRK interface program converts only expense transactions into
Tabs3.
2) The "Used" column indicates if the PHONETRK interface program uses the
field in any way.
3) Fields 2 (User ID), 7 (Phone Number), 15 (City), and 17 (State) are
converted into the Tabs3 transaction description. This description
only shows up on transactions that were rejected when merging them into
Tabs3. The description is ignored when a transaction is successfully
merged.
4) Field 9 (Account Number) is converted as the Tabs3 client/matter
number. It is assumed that the decimal separator between the client and
matter numbers will not be in the Account Number.
5) The transaction date is converted by combining field 4 (Month and Day)
with the year of today's date. If the month in field 4 is greater than
the month in today's date, the transaction is assumed to have taken place
last year and last year is converted instead.
Sample PHONETRK data file: Each record has been divided into a 80 byte
section followed by a 75 byte section so the records won't be truncated on
the page. Also, the first 3 lines are not part of the PHONETRK.DTA file.
1 2 3 4 5 6 7 8
12345678901234567890123456789012345678901234567890123456789012345678901234567890
--------------------------------------------------------------------------------
ASHP 8248 3111730 3 3059954372 12.7 10100ASH, PAUL
A. LITIGATION ABC SUPPLY CORP. 952S.E. PART-305FL 1
ASHP 8248 3131145 5 3059954372 30.6 10100ASH, PAUL
A. LITIGATION ABC SUPPLY CORP. 1437S.E. PART-305FL 1
DEMPT 8251 3111035 5 2052371267 40.7 20376DEMPSEY, T
HOMAS R. LITIGATION MAPLE SUPPLY CORP. 2927STATE OF -205AL 1
DEMPT 8251 3121015 1 2052371267 30.8 20376DEMPSEY, T
HOMAS R. LITIGATION MAPLE SUPPLY CORP. 2217STATE OF -205AL 1
DRAPA 8443 3111230 2 3059954372 12.2 10100DRAPPER, A
LBERT D. CORPORATE ABC SUPPLY CORP. 952S.E. PART-305FL 1
HAMMG 8269 3111115 5 7045985762 2.8 20276HAMMER, GA
RY H. REAL ESTATE XYZ SERVICE CORP. 221WESTERN -704NC 1
HAMMG 8269 3111245 5 2054783746 25.6 20376HAMMER, GA
RY H. REAL ESTATE MAPLE SUPPLY CORP. 1862STATE OF -205AL 1