Inventory by location table – IntelliTrack Stockroom Inventory User Manual
Page 317

Appendix A
Data Structure
289
Inventory by Location Table
The Inventory by Location Table holds actual quantity, sites and locations.
Shows where items are stored.
CheckOutDura-
tionQty
No
Double
8
Quantity for
Check Out Dura-
tion
CheckOutSkip-
Weekends
No
Yes/No
2
Skip Weekends
for Return Date?
CheckInTime
No
Date/Time
8
Default Check In
Time (i.e. 04:15
PM)
ItemType
No
Integer
2
1=Consumable,
2=Check,
3=Both
Track Cost
No
Bit
1
True = Enable
cost tracking
False = Disable
cost tracking
TABLE 11.
Inventory Table (Continued)
Field Name
Req’d
Data Type
Field Size
Description
TABLE 12.
Inventory by Location Table
Field Name
Req’d
Data Type
Field Size
Description
Site
Yes/PKey
Text
18
Site for this item
and Location
BINLOC
Yes/PKey
Text
15
Bin Location
Code (Location)
ITEM#
Yes/PKey
Text
25
Item Number
Lot
Yes/PKey
Text
15
Lot (Empty field
allowed if not
using Lots)
ExpDate
Yes/PKey
Date/Time
8
Expiration Date
(#1/1/20#) is not
using
2289.book Page 289 Thursday, July 7, 2011 5:10 PM