Manual

INTELLITRACK CHECK IN-OUT V7.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