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