IntelliTrack Stockroom Inventory - Manual (Page 319)

Appendix A
Data Structure
291
Bin Location Table
Definition table for Locations where items can be stored. Can be different
for each site.
Field Types
Following is a brief summary of the field types and size settings for fields
associated with your database tables::
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
TABLE 13. Bin Location Table
Field Name Req’d
Data
Type
Field
Size Description
Site Yes/PKey Text 18 Site of this Location
BINLOC Yes/PKey Text 15 Bin Location Code (Location)
Description No Text 25 Description of this Location
UDF1 No Text 25 User Defined Field Number 1
UDF2 No Text 25 User Defined Field Number 2
UDF3 No Text 25 User Defined Field Number 3
UDF4 No Text 25 User Defined Field Number 4
2289.book Page 291 Thursday, July 7, 2011 5:10 PM