Bin location table – IntelliTrack Inventory Management User Manual
Page 265
Appendix A
Data Structure
239
Bin Location Table
Definition table for Locations where items can be stored. Can be different
for each site.
ItemID
Yes/PKey
Text
25
ID for Check Out Item
(Empty if not using)
QTY
Yes
Currency
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 Trans-
action
IMP QTY
No
Currency
8
Used with the Import & Com-
pare Function
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 12.
Inventory by Location Table (Continued)
Field Name
Req’d
Data Type
Field Size
Description
2287.book Page 239 Thursday, July 7, 2011 4:45 PM