IntelliTrack Check In/Out - Manual (Page 406)

I NTELLI T RACK C HECK I N -O UT V 7.0
User Manual
378
Bin Location Table
Definition table for Locations where items can be stored. Can be different
for each site.
tblCheck Table
Table holding ItemID information for Check In-Out items. Each record is
associated with a record in the Inventory table. Also stores maintenance,
and purchase information for each item.
TABLE 15. Bin Location Table
Field Name Req’d Data Type Field Size Description
Site Yes/PKey Text 18 Site of this Loca-
tion
BINLOC Yes/PKey Text 15 Bin Location
Code (Location)
Description No Text 25 Description of
this Location
UDF1 No Text 25 User Defined
Field Number 1
UDF2 No Text 25 User Defined
Field Number 2
UDF3 No Text 25 User Defined
Field Number 3
UDF4 No Text 25 User Defined
Field Number 4
TABLE 16. tblCheck Table
Field Name Req’d
Data
Type
Field
Size Description
ITEM# Yes/PKey Text 25 Item Number
ItemID Yes/PKey Text 25 ID for Check Out Item (Empty if not
using)
2283.book Page 378 Thursday, July 9, 2009 11:26 AM