IntelliTrack Stockroom Inventory - 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