GetJobBomData Method
- Last UpdatedNov 06, 2025
- 7 minute read
The GetJobBomData() method retrieves the job BOM data for the specified job or BOM position from the Job_Bom table.
'Declaration
Public Shared Function GetJobBomData( _
ByVal woId As String, _
ByVal operId As String, _
ByVal seqNo As Nullable(Of Integer), _
ByVal bomPos As Nullable(Of Integer) _
) As DataSet
'Usage
Dim woId As String
Dim operId As String
Dim seqNo As Nullable(Of Integer)
Dim bomPos As Nullable(Of Integer)
Dim value As DataSet
value = JobBom.GetJobBomData(woId, operId, seqNo, bomPos)
public static DataSet GetJobBomData(
string woId,
string operId,
Nullable<int> seqNo,
Nullable<int> bomPos
)
Parameters
- woId
Required. Holds the ID of the work order for the job.
- operId
Optional. Holds the ID of the operation for the job.
- seqNo
Optional. Holds the operation sequence number of the job.
- bomPos
Optional. Holds the BOM position.
Return Value
Returns a DataSet that contains all the records in the Job_Bom table that satisfy the specified filters. If no matching records are found, an empty DataSet is returned.
The columns of the returned DataSet are described below.
|
ColumnName |
Description |
|---|---|
|
wo_id |
A string that is the ID of the work order for the job. |
|
oper_id |
A string that is the ID of the operation for the job. |
|
seq_no |
An integer that is the sequence number for the job. |
|
bom_pos |
An integer that is the BOM position. |
|
job_bom_subst_exist |
A Boolean that is a flag that indicates whether substitutes exist for the BOM item. |
|
current_subst |
An integer that is the alt_no of the currently used substitute from the Job_BOM_Subst table. The default is null. |
|
pref |
An integer that indicates the preference of the substitute from the Job_Bom_Substitute table. The lower numbered alternatives are preferable than the higher numbered ones. |
|
subst_level |
An integer that is the substitution level that a user must have to be able to use the substitute item. 0 means any user can use the substitute item. |
|
item_id |
A string that is the ID of the item. |
|
item_desc |
A string that is the description of the item. |
|
item_display |
A string that is a value that indicates what format to use to display the item identification in the user interface. The format values are defined in the system attribute Item display (attr_id 210 in the System_Attr table). Possible values and their formats are:
|
|
uom_id |
An integer that is the ID of the item’s units of measure. |
|
description |
A string that is the description of the units of measure. |
|
abbreviation |
A string that is the abbreviation of the units of measure that is appended to quantities. |
|
lifetime |
An integer that indicates the number of days left before the item expires. It never expires if the value is null. |
|
reqd_grade_cd |
An integer that is the required grade code for the BOM Item. If null, the required grade code is disabled. |
|
item_grade_desc |
A string that is the item grade description of the Item_Grade table. |
|
color |
An integer that is the RGB background color associated with the required grade of the Item_Grade table. |
|
instruction |
A string that contains the instructions on how to consume or produce this item. |
|
qty_per_parent_item |
A floating point number that is the nominal quantity of the item required per unit of the parent item. |
|
max_qty_per_parent_item |
A floating point number that is the maximum acceptable quantity of this BOM component. |
|
min_qty_per_parent_item |
A floating point number that is the minimum acceptable quantity of this BOM component. |
|
reqd_start_val |
A floating point number that is the amount of the component required before running the job. |
|
reqd_start_val_is_pct |
A Boolean that is a flag that specifies whether the required start value is a percentage or an absolute quantity. |
|
qty_prod |
A floating point number that is the quantity of the item produced up to the current date. |
|
qty_rejected |
A floating point number that is the quantity of the item rejected up to the current date. |
|
update_inv |
A Boolean that is a flag that specifies whether the inventory table is updated with the consumed items. |
|
backflush |
A Boolean that is a flag that specifies whether consumption is backflushed. |
|
def_reas_cd |
An integer that specifies the default consumption or production code of an item. If null, it defaults to the value specified for the entity that runs the job. |
|
reas_desc |
A string that is the description of the default reason code from the Item_Reas table. |
|
def_lot_no |
A string that is the default lot number for the item. |
|
def_sublot_no |
A string that is the default sublot number for the item. |
|
def_storage_ent_id |
An integer that is the ID of the default storage entity for the item or the by-product. |
|
ent_name |
A string that is the default storage entity (def_storage_ent_id) from the Ent table. |
|
scaling_factor |
A floating point number that is the scaling factor to get the correct units from counts if the counts are item dependent. |
|
must_consume_from_inv |
A Boolean that is a flag that specifies whether consumption must occur from inventory for this item. |
|
may_choose_alt_inv_loc |
A Boolean that is a flag that specifies whether the user can select alternate inventory locations when consuming or producing this item. |
|
may_create_new_lots |
A Boolean that is a flag that specifies whether the user can create new lots when consuming or producing this item. |
|
must_consume_from_wip |
A Boolean that is a flag that specifies whether the lots consumed during the job are limited to the lots produced to the Item_Inv table for the same work order in an upstream job. |
|
must_consume_before_prod |
A Boolean that is a flag that specifies whether the production transactions are prevented until acceptable quantities of BOM components are consumed, as specified in the maxQtyPerParentItem and minQtyPerParentItem parameters. |
|
consumed_so_far |
A floating point number that is the quantity of the item consumed up to the current date. |
|
constant_qty |
A Boolean that is a flag that specifies whether the quantity of the consumed item is independent of the quantity of the parent item that is produced. |
|
est_time |
A floating point number that indicates the number of hours it should take to consume or produce the component per unit of BOM position zero. If null, the BOM position is zero. |
|
spare1 |
A string that is the contents of the user-defined spare1 field. |
|
spare2 |
A string that is the contents of the user-defined spare2 field. |
|
spare3 |
A string that is the contents of the user-defined spare3 field. |
|
spare4 |
A string that is the contents of the user-defined spare4 field. |
|
qty_reqd |
A floating point number that is the quantity required for the job specified in the Job table. |
|
qty_at_start |
A floating point number that is the starting quantity for the job specified in the Job table. |
|
num_decimals |
An integer that is the number of decimal places used for quantity values of the item in the Item table. |
|
item_spare1 |
A string that is the contents of the user-defined spare1 field from the Item table. |
|
item_spare2 |
A string that is the contents of the user-defined spare2 field from the Item table. |
|
item_spare3 |
A string that is the contents of the user-defined spare3 field from the Item table. |
|
item_spare4 |
A string that is the contents of the user-defined spare4 field from the Item table. |
|
last_edit_comment |
A string that contains comments about why the record was added or updated. |
|
last_edit_by |
A string that is the ID of the user who added or last updated this record. |
|
last_edit_at |
A date/time that indicates when the record was added or last updated. |
|
qty_used_in_steps |
A floating point number that is the sum of all the qty_per_parent_item parameters in the Job_Bom_Step table for the job for which the BOM position is not zero. |
|
mod_id |
The current modification ID of the record in the table. This ID is binary number that increments each time the record’s table row is modified. Optionally used for optimistic concurrency control when performing updates or deletes. |
|
actual_qty |
The calculated quantity for the Job_Bom record. If the Job_Bom record is for a consumed item and the consumption quantities of the consumed item do not depend on the number of produced parent items (that is, the BOM item is configured as "constant quantity"), then this quantity will be equal to the quantity per parent item. For all other records, it will be one of the following, whichever value is greater:
|
|
actual_min_qty |
The calculated minimum quantity for the Job_Bom record. If the Job_Bom record is for a consumed item and the consumption quantities of the consumed item do not depend on the number of produced parent items (that is, the BOM item is configured as "constant quantity"), then this quantity will be equal to the minimum quantity per parent item. For all other records, it will be one of the following, whichever value is greater:
|
|
actual_max_qty |
The calculated maximum quantity for the Job_Bom record. If the Job_Bom record is for a consumed item and the consumption quantities of the consumed item do not depend on the number of produced parent items (that is, the BOM item is configured as "constant quantity"), then this quantity will be equal to the maximum quantity per parent item. For all other records, it will be one of the following, whichever value is greater:
|
|
qty_good_at_bom_pos |
A floating point number that is the produced quantity of the BOM position item. |
|
qty_rejected_at_bom_pos |
A floating point number that is the rejected quantity of the BOM position item. |