IntelliTrack Check In/Out User Manual
Page 431
Appendix A
Data Structure
401
The Inventory by Location Table holds actual quantity, sites and locations.
Shows where items are stored.
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
ItemID
Yes/PKey
Text
25
ID for Check Out Item (Empty if not
using)
QTY
Yes
Cur-
rency
8
Quantity Stocked Location
ID
No
Text
12
ID of Last Physical Inventory or Move
DATE
No
Date/
Time
8
Last Physical Count or Move Date
TIME
No
Date/
Time
8
Time of Last Logged Transaction
IMP QTY
No
Cur-
rency
8
Used with the Import & Compare Func-
tion
CheckOutItem
No
Yes/No
2
Is This a Check Out Item?
CheckedOut
No
Yes/No
2
Is This item Checked Out?
CheckOutDate
Yes
Date/
Time
8
Date item was Checked Out
CheckOutTime
No
Date/
Time
8
Time item was Checked Out
DueBackDate
No
Date/
Time
8
Date Item is Due Back (i.e., 10/15/96))
DueBackTime
No
Date/
Time
8
Time Item is Due Back (i.e., 04:15 PM)
SerialNumber
No
Text
30
Serial Number of Check Out Item
User1
No
Text
25
User Defined Field 1
User2
No
Text
25
User Defined Field 2
User3
No
Text
25
User Defined Field 3
User4
No
Text
25
User Defined Field 4
Account
No
Text
20
Account Checked Out to
Department
No
Text
20
Department Checked Out To
TABLE 13.
Inventory by Location Table
Field Name
Req’d
Data
Type
Field
Size
Description
2283.book Page 401 Thursday, July 7, 2011 2:29 PM