Instruction Manual

INTELLITRACK INVENTORY V8.1
User Manual
240
Field Types
Following is a brief summary of the field types and size settings for fields
associated with your database tables:
TABLE 13. Bin Location Table
Field Name Required
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
TABLE 14. Data Type Settings
Field Type Size Settings
Field Types Size Settings
Text (Default) Text up to 255 characters or the length set by
the FieldSize property, whichever is less.
Memo Text with a maximum length of 64,000 bytes. Memo
fields can't be indexed.
Number Any numeric type. See the FieldSize property for more
information.
Date/Time Date and time values for years from 100 to 9999.
Currency Accurate to 15 digits on the left side of the decimal
point and 4 digits on the right.
Counter A number automatically incremented whenever a new
record is added to a table. Counter fields can't be
updated.
2287.book Page 240 Thursday, July 7, 2011 4:45 PM