Wasp Barcode Inventory Control - Manual (Page 282)

InventoryControl Printable Help
16.3 Related Data Fields
Location Table Supplier Table Manufacturer
Table
Item Table Inventory
Table
Site Site
Location Location
Supplier Code Supplier Code Supplier Code
Name Manufacturer
Item Number Item Number
The chart above shows the related data fields that exist within the database tables. The chart should be
interpreted from left to right:
 If you will be importing data into both the Location table and the Inventory table:
The same values that reside within the Import Data Columns you choose to map to the Location
table's Site and Location fields must also occur within the Import Data Columns you choose to
map to the Inventory table's Site and Location fields. The actual Import file used for the Location
import does not have to be used for the Inventory import. It's the Site and Location values
themselves which must be the same in both Imports to create the proper connections between the
Location and Inventory tables.
If, while importing Inventory data, a previously unknown Site or Location value is read, a new
Site and/or Location will be created using the new value; the Inventory record being imported will
not be associated with an existing Site and Location.
 If you will be importing data into the Supplier table and the Item table (or into the Supplier table
and both the Item and Inventory tables):
The same values that reside within the Import Data Columns you choose to map to the Supplier
table's Supplier Code field must also occur within the Import Data Columns you choose to map to
the Item or Inventory table's Supplier Code field. The actual Import file used for the Supplier import
does not have to be used for the Item or Inventory import. It's the Supplier Code values
themselves which must be the same in both Imports (or in all three Imports) to create the proper
connections between the Supplier and Item tables (or between the Supplier, Item and Inventory
tables).
If, while importing Item data, a previously unknown Supplier Code value is read, a new
Supplier Code will be created using the new value; the Item record being imported will not be
associated with an existing Supplier Code.
If, while importing Inventory data, a previously unknown Supplier Code value is read, a new
Supplier Code will not be created using the new value; the Inventory record being imported will be
rejected.
267