SupName

(Required) Existing In-Store Supplier Name for In-Store Warehouse

Contr_no

(Required) Contract Number (If contract already exists the contract number entered must match existing)  

qty_oh

(Required) Quantity On-Hand

part_no

(Required) Existing Internal Part Number with exsiting In-Store Warehouse Setup

revision

(Required) Existing Revision (if applicable)

partmfgr

(Required) Existing Part Manufacturer with existing In-Store Warehouse Setup

mfgr_pt_no

(Required) Existing Manufacturer Part Number with existing In-Store Warehouse Setup

Warehouse

(Required) Existing In-Store Warehouse

location

(Required) Existing In-Store Warehouse Location

price

(Option) Contract Price (If price is omitted it will use material price for the part as entered in the inventory module).

LotCode

(Required if Lot Coded Part)  Lot Code

ExpDate

(Required if Lot Code Part) Expiration Date

Reference

(Required if Lot Coded Part) Reference

SerialNoM

(Required if Part is Serialized)  If the part is serialized the users can enter all serial numbers into the “SerialNoM” column of the spreadsheet separated by one of the following; coma, semicolon, space, tab.  If the user wants to enter range of the serial numbers they have to separate starting and beginning of the range with the dash surrounded by spaces like “ – “. The reason for that is that serial number itself might have “-“ as a part of the serial numbers. For example serial numbers entered as

98 – 103 (98, 99, 100, 101, 102, 103)

V5678888X - V32787382S (V5678888X, V32787382S)