Available in Sage 50 Quantum Accounting.

Bill of Materials Fields

The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports. For Bill of Materials, there are two tables: one that contains history bill of materials data (BOMHIST.DAT) and another that contains current bill of materials data (BOMITEMS.DAT).

Filename: BOMHIST.DAT

BOMHIST.DAT is the Bill of Materials history file. The information below is entered or displayed in the Work Tickets window.

  • To add Sage 50 Bill of Materials history fields to your Crystal reports, select BOMHIST.DAT.

Indexes and Their Uses

BOMHIST.DAT has the following keys:

0 = ByRecordNumber. A unique key that will not change for the lifetime of the record.

1 = ByAssemblyDate. This is an index ordered by the Assembly Item Record Number and then within that by the effective date of that particular version of the assembly.

2 = ByAssemblyRec. This is an index ordered by the Assembly Item Record Number and then within that by the Revision Number of that particular version of the assembly.

3 = By GUID

Fields

The following table shows the fields available in the BOMHIST.DAT file and includes the type and size in number of bytes of each field.

Field Name

Type

Size

Comment

RecordNumber

Integer

Unique record key.

AssemblyRecordNo

Integer

Foreign key into the LINEITEM table. It links to the Assembly LineItem record.

RevisionNumber

Integer

The revision number for the particular version of the assembly represented by the record.

EffectiveDate

Date

The date upon which this revision becomes the “active” revision for the assembly.

GUID

UBinary

GUID (Globally Unique Identifier) used for linking Bill of Materials table.

NoComponents

Integer

The number of components that make up this particular revision.

LastUpdateCounter

Integer

This is a counter that increases incrementally each time a record is modified.

RevisionNote

ZString

250

Description of the revision.

CmpRecordNumberx [1-300]

Integer

4

CmpQtyNeededx [1-300]

Decimal

12

Filename: BOMITEMS.DAT

BOMITEMS.DAT is the Bill of Materials history file. The information below is entered or displayed in the Work Tickets window.

  • To add Sage 50 Bill of Materials fields to your Crystal reports, select BOMITEMS.DAT.

Indexes and Their Uses

BOMITEMS.DAT has the following keys:

0 = ByRecordNumber. A unique key that will not change for the lifetime of the record.

1 = ByAssemblyDate. This is an index ordered by the Assembly Item Record Number and then within that by the effective date of that particular version of the assembly.

2 = ByAssemblyRec. This is an index ordered by the Assembly Item Record Number and then within that by the Revision Number of that particular version of the assembly.

3 = ByComponentsByAssembly

4 = ByGUID

Fields

The following table shows the fields available in the BOMITEMS.DAT file and includes the type and size in number of bytes of each field.

Field Name

Type

Size

Comment

RecordNumber

Integer

Unique record key.

AssemblyRecordNo

Integer

Foreign key into the LINEITEM table. It links to the Assembly LineItem record.

EffectiveDate

Date

The date upon which this revision becomes the active revision for the assembly.

ComponentNumber

Integer

The position of this particular component within its revision.

RevisionNumber

Integer

The revision number for the particular version of the assembly represented by the record.

GUID

UBinary

GUID (Globally Unique Identifier) used for linking Bill of Materials History table.

QtyRequired

Float

The quantity of this particular component that are needed for this assembly (in the associated revision).

ComponentRecordNo

UBinary

Foreign key into the LINEITEM table that lets you look up the LineItem record for this particular component.

LastUpdateCounter

Integer

This is a counter that increases incrementally each time a record is modified.

What do you want to do next?