Compsee
11
Apex-0698-Part 2: Apex-trak
Part 2
As installed, this program is straight forward, easy to use, and meets most data collection needs. A computer
programmer could modify Apex-Trak to meet any asset inventory requirements.
Table 3-2 lists and describes the Asset Inventory data fields. The operator enters data for all fields except the date
and time stamps. The Apex II Apex-Trak program automatically enters the date and time as a record entry is
completed. These fields are user definable in name and length. Fields which are not required can be turned off by
setting the field length to zero.
Table 3-2. Asset Inventory Data Field Descriptions
Fields Siz
e
Type
Major Division*
8
Alpha/Numeric, Right justified, Zero filled.
Minor Division
8
Alpha/Numeric, Right justified, Zero filled.
Item Number*
16
Alpha/Numeric, Right justified, Zero filled.
Item Desc.
16
Alpha/Numeric, Left justified.
Remarks
16
Alpha/Numeric, Left justified.
Condition
16
Alpha/Numeric, Left justified.
Date*
6
Date, in the form YYYYMMDD (19950928).
Time*
5
Time, in the form HH:MM, in 24 hour format (23:30).
* Required fields are identified by an asterisk next to their names.
When data from the Asset Inventory program is transferred to the PC using procedures starting on page 27, the file
is named AIFILE. Characters for each record are in strings. Each record is separated by a carriage return. Fields
are padded with spaces to their defined length, but are not separated from other fields of a record by spaces or tabs.
Figure 3-1 illustrates a typical ASCII file for Asset Inventory. Columns in the table and figure are shaded to make
the ASCII file easy to read.
00000001 00000023 0000A 9302 83746 COMPUTER, IBM MODEL NO 5559933 NEW 19960205 10:41
00000001 00000023 0000A 9302 84029 EXECUTIVE DESK
POOR
19960205 10:45
00000001 00000023 0000A 9302 83333 ROUND TABLE
GOOD
19960205 10:47
00000001 00000023 0000A 9302 83777 STORAGE BIN
NEW
19960205 10:49
00000002 00000023 0000A 9302 8186 COMPUTER, MAC MODEL NO 5422232 NEW
19960205 12:37
00000002 00000045 0000A 9302 8927 COMPUTER, DEC MODEL NO 9793737 FAIR
19960205 12:38
00000002 00000045 0000A 9302 8222 CHAIR, ERGONOM ON LEFT ARM REST SCRATCHED
19960205 12:39
00000002 00000045 0000A 9302 83157 FAX MACHINE
OBSOLETE
19960205 12:45
Figure 3-1. Typical ASCII File For Asset Inventory