Manual

INTELLITRACK CHECK IN-OUT V7.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