The following is a sample file layout for the NORSTARC.EXE program.
Program: NORSTARC.EXE
Data File: Can be any name (an extension of ".EXP" is assumed)
File Type: Fixed Length (record length = 88 bytes)
TABS3.ASC File Layout
Field Name Start Len Used Explanation
----- -------------- ----- --- ---- ---------------------------------------
1 Not Used 1 8 No Don't know what field is used for
2 Date 9 6 Yes Date in YYMMDD format
3 Phone Number 15 16 Yes Phone number dialed
4 Line/Extension 31 4 Yes Line Number/Extension
5 Not Used 35 6 No Don't know what field is used for
6 Time 41 4 No Time
7 Line Type 45 4 No Line Type
8 Cost 49 6 Yes Call cost ($1.23 stored as 1.23)
9 State 55 2 Yes State called
10 Account Number 57 12 Yes Client/Matter number
11 City 69 10 Yes City called
12 Not Used 79 8 No Don't know what field is used for
13 CR/LF 87 2 No Carriage Return/Line Feed
Notes:
1) The data file name (without the ".EXP" extension) is stored in the
NORSTARC parameter file. This name can be overridden when the program
is executed. For example, if the input file name is "DATA.TXT", the
text "NORSTARC DATA.TXT" could be entered at the command prompt and
the DATA.TXT file would be used instead of the default data file name.
2) The NORSTARC interface program converts only expense transactions into
TABS III.
3) The "Used" column indicates if the NORSTARC interface program uses the
field in any way.
4) Fields 3 (Phone Number), 4 (Line/Extension), 9 (State), and 11 (City) are
converted into the TABS III transaction description. This description
only shows up on transactions that were rejected when merging them into
TABS III. The description is ignored when a transaction is successfully
merged.
5) Field 10 (Account Number) is converted as the TABS III client/matter
number. It is assumed that the decimal separator between the client and
matter numbers will not be in the Account Number.
Sample NORSTARC data file:
Notes:
1) Each record has been divided into a 70 byte section followed by a 18 byte
section so the records won't be truncated on the page.
2) The first 3 lines are not part of the data file.
3) The "[" and "]" characters have been added to illustrate where the
carriage return/line feed combination would appear in each record.
1 2 3 4 5 6 7
1234567890123456789012345678901234567890123456789012345678901234567890
----------------------------------------------------------------------
990307(408) 657-9500 001 0911CO S 1.51CA10000 Pa
cfic Grove []
990307(860) 549-8795 001 1402CO I 0.58CT10100 Ha
rford []
990312(713) 739-7909 002 0931CO S 0.77TX12345 Ho
uston []
990321(305) 698-2789 001 1007CO I 1.01FL10200 Mi
ami Lakes []
990327(970) 242-3921 003 1557CO S 0.00CO20001 Gr
and Junction []
990327(800) 738-6083 002 1641CO S 3.05VA20002 Wa
rrenton []
990402(408) 765-6886 003 0815CO S 1.21CA20003 Sa
nta Clara []
990405(877) 324-7411 001 1213CO S 0.15VA30000 Vi
enna []
990406(630) 924-6131 001 0835CO I 0.12IL40000 Ro
selle []
990411(215) 814-6264 003 1420CO S 1.58PA40200 Ph
iladelphia []