Spreadsheet: 101716d1299785457-lookup-quantity-of-part-by-warehouse-2300_inventory-upload-template_upload
Sheet: Inventory Upload

[NAME] | 2300
R - is a required field, don't leave it blank.
Part Number | Description | Parts Category | Stocking Items | Minimum Number | Maximum Number | Quantity OnHand | Selling Price | Cost Price | [NAME] | Supplied By | Unit of Measure | Last Ordered | [NAME] | Sold To | Type of Part | Std/Avg Costing | Comment | Supplier Cost #1 - Code | Supplier Cost #1 - Price | Supplier Cost #1 - Part# | Supplier Cost #2 - Code | Supplier Cost #2 - Price | Supplier Cost #2 - Part# | Supplier Cost #3 - Code | Supplier Cost #3 - Price | Supplier Cost #3 - Part# | Supplier Cost #4 - Code | Supplier Cost #4 - Price | Supplier Cost #4 - Part# | Supplier Cost #5 - Code | Supplier Cost #5 - Price | Supplier Cost #5 - Part# | Alternate Part Number | Superceded Part Number | UPC Code | Unit of Measure | Average Cost | [NAME] Percent 1 | [NAME] Percent 2 | [NAME] Percent 3 | [NAME] 4 | [NAME] Percent 5 | Preferred Supplier | Job Cost Item | Job Cost Type | W/O Cost Type | Price Update Code | Print 1 Label Per | Default Cost Takeoff | Warehouse code | [NAME]
Field Length 15 | Field Length 35 | Field Length 10 | Field Length 1 | Field Length 5 | Field Length 5 | Field Length 8 | Field Length 8 | Field Length 9 | Field Length 10 | Field Length 10 | Field length 1 | Field Length 8 | Field Length 8 | Field Length 10 | Field Length 1 | Field Length 1 | Filed Length 27 | Field Length 10 | Field Length 10 | Field Length 10 | Field Length 10 | Field Length 10 | Field Length 10 | Field Length 10 | Field Length 10 | Field Length 10 | Field Length 10 | Field Length 10 | Field Length 10 | Field Length 10 | Field Length 10 | Field Length 10 | Field Length 25 | Field Length 25 | Field Length 12 | Field Length 3 | Field Length 9 | Field Length 5 | Field Length 5 | Field Length 5 | Field Length 5 | Field Length 5 | Field Length 1 | Field Length 10 | Field Length 10 | Field Length 10 | Field Length 16 | Field Length 6 | Field Length 1 | Field Length 5 | Field Length 8
R | R | R |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] 99999.99
1526004 | Dual Pressure Control | ELECPARTS | Y | 2 | 15 | 4 | 20.02 | 10.15 | 457 | TRENT | E | 20001013 | 20000812 | JONESCO | Y | A |  | QUESCO | 10.45 | 15555664 | JONESCO | 10.05 | 45551111151 | SMITHESCO | 10.75 | 849546516 | FREEDCO | 10.65 | 8465221145 | GROUCHESCO | 10.55 | 126548245 |  |  | 4123456789 |  |  | 10.25 |  |  |  |  | 1 |  |  |  |  | 999999 | 1-Std,2-Avg,3-Selling,4-Supl Cost
1452 | DECAL STAND CLEAR LONGYELLOW | MISC | Y |  |  | 100 |  |  |  |  | E |  |  |  | Y | A
1453 | DECAL-CAUTION AUTOMATIC DOOR6-1/2 I | MISC | Y |  |  | 100 |  |  |  |  | E |  |  |  | Y | A
1455 | DECAL-DO NO ENTER/OUT6-1/2 IN ROUND | MISC | Y |  |  | 100 |  |  |  |  | E |  |  |  | Y | A
1456 | DECAL-IN EMERGENCY PTO12 IN X 1-3/4 | MISC | Y |  |  | 100 |  |  |  |  | E |  |  |  | Y | A
1457 | DECAL-HANDICAP LOGO6-1/2 IN ROUND | MISC | Y |  |  | 100 |  |  |  |  | E |  |  |  | Y | A
1461 | HORTON DECAL CAUTION AUTO.DOORACTIV | MISC | Y |  |  | 100 |  |  |  |  | E |  |  |  | Y | A
1462 | DECAL - STAND CLEAR2 IN X 4 IN | MISC | Y |  |  | 100 |  |  |  |  | E |  |  |  | Y | A
1463 | CUSTOM STAND CLEAR DECAL | MISC | Y |  |  | 100 |  |  |  |  | E |  |  |  | Y | A
1464 | AUTOMATIC DOOR DECALDORMA | MISC | Y |  |  | 100 |  |  |  |  | E |  |  |  | Y | A