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 |
| Warehouse (Required) | Warehouse | 00 |
| Part No (Required) | Part No | CMATS |
| Description | Description of Part | Crash mats |
| Product Code | Existing Product Code | ACC |
| Status | 0 = Active, 1 = On Hold, 2 = Inactive | 0 |
| Cost Price | Current cost | 10.00 |
| Average Cost | Average cost | 9.00 |
| Stock UOM: Code | Stock unit of measure code | EA |
| Stock UOM: Description | Stock unit of measure description | Each |
| Stock UOM: Location | Stock unit of measure location | Aisle 12 |
| Stock UOM: Allow Fractional Qty. | Stock unit of measure fractional quantity; T = True and checks the box F = False and does not check the box | F |
| Stock UOM: Weight | Stock unit of measure weight (Weight Units set in Company Settings > Inventory) | 5 |
| Stock UOM: Sell Price | Stock unit of measure sell price | 13.00 |
| Buy UOM: Code | Buy unit of measure code | CS |
| Buy UOM: Description | Buy unit of measure description | Case |
| Buy UOM: Location | Buy unit of measure location | Whse |
| Buy UOM: Conversion Factor | Buy unit of measure conversion factor number | 10 |
| Buy UOM: Direct Factor | Buy unit of measure direct factor T = True, F = False (T = 10 EA per CS in this example) | T |
| Buy UOM: Allow Fractional Qty. | Stock unit of measure fractional quantity; T = True and checks the box F = False and does not check the box | F |
| Buy UOM: Weight | Buy unit of measure weight (Weight Units set in Company Settings > Inventory) | 50 |
| Sell UOM: Code | Sell unit of measure code | EA |
| Sell UOM: Description | Sell unit of measure description | Each |
| Sell UOM: Location | Sell unit of meafure location | Aisle 12 |
| Sell UOM: Conversion Factor | Sell unit of measure conversion factor number | 1 |
| Sell UOM: Direct Factor | Sell unit of measure direct factor T = True, F = False | T |
| Sell UOM: Allow Fractional Qty. | Sell unit of measure fractional quantity; T = True and checks the box F = False and does not check the box | F |
| Sell UOM: Weight | Sell unit of measure weight (Weight Units set in Company Settings > Inventory) | 5 |
| Sell UOM: Sell Price | Sell unit of measure sell price | 13.00 |
| Price Factor | Price Factor number | 1 |
| Preferred Vendor | Primary vendor's Vendor No | ACMSYS |
| Min. Order Qty. | Minimum order quantity | 10 |
| Last P.O. Number | Last Purchase Order number | 100555 |
| Last P.O. Due Date | Last Purchase Order date | 01/01/2024 |
| Discountable | Checks the Discountable box T =True, F + False | T |
| Serialized | 0 = Non Serialized 1 = Serialized | 0 |
| Sales Department | Existing Sales Department | ACC |
| Allow Backorder | Allow backorders; T= True F = False | T |
| Allow Returns | Allow returns; T= True F = False | T |
| Reorder Point | Reorder Point number | 5 |
| Alternate | Alternate part's Part No | CMAT2 |
| User Defined 1 | Value for first User Defined field | AAA |
| User Defined 2 | Value for second User Defined field | 1 |
| Type | Inventory Type; C = Macro K = Kitted M = Manufactured N = Normal R = Raw Material V = Non-Physical | N |
| Image File | File path for the image file | C:\Users\Desktop |
| Extended Description | Extended Description | This is the new model of crash mat. |
| Accessory Warehouse | Warehouse of accessory part | RAW |
| Accessory Part No | Part No of accessory part | ACMFITSB |
| Harmonized Code | Harmonized Tariff/Customs Code | 640192 |
| Country of Origin | Country of Origin 3 digit code | CAN |
| Standard Cost | Standard Cost | 10.00 |
| Pack Size | Numeric pack size | 1.000 |
| Duty % | Duty percentage | 5 |
| Freight % | Freight percentage | 5 |
| Default Expiry Days | Default number of days from today for new lot number expiry | 14 |
| Levy Code | Existing Levy Code | 300 |
| Lot Numbered | Lot number item; T = True, F = False | T |
| Lot Consume Type | 0 = Consume By Choice 1 = Consume By Date Received 2 = Consume By Alphanumeric Order 3 = Consume By Expiry Date | 0 |