Inventory by location table, Inventory by location table 307 – IntelliTrack Stockroom Inventory User Manual
Page 335
Appendix A
Data Structure
307
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 12.
Inventory Table (Continued)
Field Name
Req’d
Data Type
Field Size
Description
TABLE 13.
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 307 Thursday, July 9, 2009 2:35 PM