Inventory by location table, Inventory by location table 376 – IntelliTrack Check In/Out User Manual
Page 404
I
NTELLI
T
RACK
C
HECK
I
N
-O
UT
V
7.0
User Manual
376
Inventory by Location Table
USER23
No
Number
Long
Integer
User Defined Field 23
USER24
No
Date/Time
8
User Defined Field 24
LinkField
No
Long Inte-
ger
4
Use for linking to a Numeric Field
Mfr
No
Text
25
Manufacturer of Check Out Item
Model
No
Text
25
Model for Check Out Item
Rental Cost
No
Currency
Rental Cost Per Rental Duration
Rental Duration
No
Integer
2
Selector for Rental Cost Calculations
RentalDurationQty
No
Double
8
Standard Qty of Rental Duration
RentalCostWeek-
ends
No
Yes/No
2
Do Rental Costs apply to Weekends
CheckOutDuration
No
Integer
2
Selector for Check Out Duration
CheckOutDuration-
Qty
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=Consumable, 2=Check, 3=Both
Track Cost
No
Bit
1
True = enable cost tracking; False =
disable cost tracking
TABLE 13.
Inventory Table (Continued)
Field Name
Req’d
Data
Type
Field
Size
Description
TABLE 14.
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
2283.book Page 376 Thursday, July 9, 2009 11:26 AM