Below is a description of the Spire Fields for this Import.
Please refer to the User Manual for more information on how to do Imports.
Spire 3.11 Fields | Explanation | Example |
Vendor No. (Required) | Vendor number | ACMSYS |
Warehouse | Warehouse | VA |
Part number (Required) | Part number | CMATS |
UOM code (Required) | Unit of measure | EA |
Cost price | Cost Price | 10 |
Vendor part no | Vendor part number | MATS100 |
Min order qty | Minimum Order quantity to get this price | 10 |
Start Date | Start date for this price | 01/01/2024 |
End Date | End date for this price | 12/31/2024 |
Update cost price | Automatically update vendor cost in receiving; T to check this box F to leave this box blank | T |
Qty Break - Qty 1 | Minimum order quantity to qualify for price 1 | 100 |
Qty Break - Price 1 | Price when ordering qualifying quantity for price 1 | 15 |
Qty Break - Qty 2 | Minimum order quantity to qualify for price 2 | 200 |
Qty Break - Price 2 | Price when ordering qualifying quantity for price 2 | 14 |
Qty Break - Qty 3 | Minimum order quantity to qualify for price 3 | 300 |
Qty Break - Price 3 | Price when ordering qualifying quantity for price 3 | 13 |
Qty Break - Qty 4 | Minimum order quantity to qualify for price 4 | 400 |
Qty Break - Price 4 | Price when ordering qualifying quantity for price 4 | 12 |
Qty Break - Qty 5 | Minimum order quantity to qualify for price 5 | 500 |
Qty Break - Price 5 | Price when ordering qualifying quantity for price 5 | 11 |
Qty Break - Qty 6 | Minimum order quantity to qualify for price 6 | 600 |
Qty Break - Price 6 | Price when ordering qualifying quantity for price 6 | 10.50 |
Qty Break - Qty 7 | Minimum order quantity to qualify for price 7 | 700 |
Qty Break - Price 7 | Price when ordering qualifying quantity for price 7 | 10 |
Qty Break - Qty 8 | Minimum order quantity to qualify for price 8 | 800 |
Qty Break - Price 8 | Price when ordering qualifying quantity for price 8 | 9.5 |
Qty Break - Qty 9 | Minimum order quantity to qualify for price 9 | 900 |
Qty Break - Price 9 | Price when ordering qualifying quantity for price 9 | 9 |
Qty Break - Qty 10 | Minimum order quantity to qualify for price 10 | 1000 |
Qty Break - Price 10 | Price when ordering qualifying quantity for price 10 | 8.5 |
Qty Break - Qty 11 | Minimum order quantity to qualify for price 11 | 11000 |
Qty Break - Price 11 | Price when ordering qualifying quantity for price 11 | 8 |
Qty Break - Qty 12 | Minimum order quantity to qualify for price 12 | 12000 |
Qty Break - Price 12 | Price when ordering qualifying quantity for price 12 | 7.5 |
Qty Break - Qty 13 | Minimum order quantity to qualify for price 13 | 13000 |
Qty Break - Price 13 | Price when ordering qualifying quantity for price 13 | 7 |
Qty Break - Qty 14 | Minimum order quantity to qualify for price 14 | 14000 |
Qty Break - Price 14 | Price when ordering qualifying quantity for price 14 | 6.5 |