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	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?

See a list of Crystal Reports data (.DAT) files