Bin location table, Tblcheck table, Bin location table tblcheck table – IntelliTrack Check In/Out User Manual
Page 432

I
NTELLI
T
RACK
C
HECK
I
N
-O
UT
V
8.1
User Manual
402
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 14.
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 15.
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 402 Thursday, July 7, 2011 2:29 PM