Wasp-barcode Inventory Control Instrukcja Użytkownika Pobierz pdf (Strona 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

1 2 ... 277 278 279 280 281 282 283 284 285 286 287 ... 517 518

Brak uwag

Wasp-barcode Inventory Control Instrukcja Użytkownika Strona 282