Bill of Materials List Fields (Import/Export)

How Do I...

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