IntelliTrack Inventory Management - Manual (Page 264)

I NTELLI T RACK I NVENTORY V 8.1
User Manual
238
Inventory by Location Table
The Inventory by Location Table holds actual quantity, sites and locations.
Shows where items are stored.
RentalDuration-
Qty No Double 8 Standard Qty of Rental
Duration
RentalCostWeek-
ends No Yes/No 2 Do Rental Costs apply to
Weekends
CheckOutDura-
tion No Integer 2 Selector for Check Out
Duration
CheckOutDura-
tionQty No Double 8 Quantity for Check Out
Duration
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=Inventory, 2=Check,
3=Both
Track Cost No Bit 1 True = enable cost tracking
False = disable cost track-
ing
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 Loca-
tion
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
2287.book Page 238 Thursday, July 7, 2011 4:45 PM