Field types, Field types 379 – IntelliTrack Check In/Out User Manual
Page 407
Appendix A
Data Structure
379
Field Types
Following is a brief summary of the field types and size settings for fields
associated with your database tables:
Site
No
Text
18
Site Lookup Table for Locations.
SerialNumber
No
Text
30
Serial Number for this Check Out Item
NormalLocation
No
Text
15
Normal Location for this Item
LastMaintDate
No
Date/
Time
8
Date of Last Maintenance (i.e., 03/15/95)
NextMaintDate
No
Date/
Time
8
Date for Next Maintenance (i.e., 03/15/
97)
LastCalibDate
No
Date/
Time
8
Date of Last Calibration (i.e., 03/15/95)
NextCalibDate
No
Date/
Time
8
Date for Next Calibration (i.e., 11/15/97)
PurchaseCost
No
Cur-
rency
8
Purchase Cost of Item
PurchaseDate
No
Date/
Time
8
Purchase Date of Item
Condition
No
Text
15
Condition of Item
Comments
No
Text
25
Any Desired Comments about item
Reserved
No
Yes/No
1
Identifies Reserved Items
Reserve Date
No
Date/
Time
8
Reservation Date
Order#
No
Text
15
Order# Data
Calibration
Period
No
Integer
4
Calibration Period, in days
Maintenance
Period
No
Integer
4
Maintenance Period, in days
Warranty Expira-
tion Date
No
Date/
Time
8
Date warranty expires
TABLE 16.
tblCheck Table (Continued)
Field Name
Req’d
Data
Type
Field
Size
Description
2283.book Page 379 Thursday, July 9, 2009 11:26 AM