Inventory by location table – IntelliTrack Inventory Management User 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