Manual

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