The following table lists the fields available for import or export, with a brief description of the field and (when necessary) a character limit for the field. The Import? column identifies which fields are available for import (all are available for export).
Note: The Bill of Materials list, including revision history, is exported using BOMLIST.CSV as the default file name.
Tips on Importing Inventory Items
Field Name |
Import? |
Description of Field |
Limit |
---|---|---|---|
Assembly ID |
Y |
Alphanumeric characters |
up to 20 characters |
Assembly Description |
N |
Alphanumeric characters |
up to 30 characters |
Revision Number |
Y |
Numeric (Real) - Sequential number assigned to each new saved revision |
|
Revision Note |
Y |
Alphanumeric - Revision note |
Up to 250 characters |
Effective Date |
Y |
Date - Date of the revision. Must be in ##/##/## (month/day/yr) format. |
|
Total No. of Components |
N |
Numeric (Real) - total of all component items in the assembly |
300 (Sage 50 Quantum Accounting); 100 (Sage 50 Premium Accounting and Sage 50 Pro Accounting) |
Component Number |
Y |
Numeric (Real) - The position the component occupies in the assembly; order may be important with subassemblies or in a step-like procedure. Note: This field is ignored during export; components will be ordered the way they were imported. |
300 (Sage 50 Quantum Accounting); 100 (Sage 50 Premium Accounting and Sage 50 Pro Accounting) |
Component ID |
Y |
Alphanumeric - ID of the component inventory items |
up to 20 characters |
Component Description |
N |
Alphanumeric - Descriptions of the component inventory items |
up to 30 characters |
Component Qty Needed |
Y |
Numeric (Real) - Qty of each component, as defined on Bill of Materials tab of Maintain Inventory Items window |