Data tables, Site, Inventory table – IntelliTrack Check In/Out User Manual
Page 402: Data tables site inventory table, Data tables 374, Site 374, Inventory table 374
I
NTELLI
T
RACK
C
HECK
I
N
-O
UT
V
7.0
User Manual
374
Data Tables
This section contains information about the site, inventory, inventory by
location, bin location, tbl check, and upload tables.
Site
The Sites Table is the main table where site definitions are stored.
Inventory Table
The Inventory Table is the main table where inventory item definitions,
and part numbers are stored.
TABLE 12.
Site Table
Field Name
Req’d
Data Type
Field Size
Description
SITE
Yes
Text
18
Site
TABLE 13.
Inventory Table
Field Name
Req’d
Data
Type
Field
Size
Description
ITEM#
Yes/
PKey
Text
25
Item Number
QTY
No
Currency
8
Quantity on Hand (Total all sites)
DESC
No
Text
35
Description
UNIT COST
No
Currency
8
Price Per Unit
CATEGORY
No
Text
15
Category
MINIMUM QTY
No
Currency
8
Minimum Quantity on Hand
MAXIMUM QTY
No
Currency
8
Maximum Quantity on Hand
REORDER QTY
No
Currency
8
Reorder Quantity
2283.book Page 374 Thursday, July 9, 2009 11:26 AM