Column Filter Show/Hide

Delete

Edit

Excel

Favorites

Group By Show/Hide

Help

New

Quick Column Filter

Saved Layout

Fields

Description

Checkbox

# Cost Items

Identifies the total number of rows for Cost Items that are assigned to the 'Cost Items' tab on the BOM Record View. This is a count of the rows and not a count of the unique records so if the same Cost Item was added two times, this would show as 2. This is a calculated field and is not stored in the database.

# Inv. Items

Identifies the total number of rows for Inventory Items that are assigned to the 'Inventory Items' tab on the BOM Record View. This is a count of the rows and not a count of the unique records so if the same Inventory Item was added two times, this would show as 2. This is a calculated field and is not stored in the database.

Batch Units

Identifies the target units of a typical Batch of a BOM Item. For example, if a BOM Item is typically produced in batches of 300 cases then this would be set to 300. This quantity is then used to scale each of the 'Inventory Items' and 'Cost Items' if the BOMs scaling UOM is the Units UOM. This number is formatted to the number of Unit decimals setup on the Item master for the BOM Item.

Database Field: ERPx_IMBOM.Units

Batch Weight

Identifies the target weight of a typical Batch of a BOM Item. For example, if a BOM Item is typically produced in batches of 2,000 lbs then this would be set to 2,000. This quantity is then used to scale each of the 'Inventory Items' and 'Cost Items' if the BOMs scaling UOM is the Weight UOM. This number is formatted to the number of Weight decimals setup on the Item master for the BOM Item.

Database Field: ERPx_IMBOM.Weight 

BOM Class

Identifies the BOM Class of the associated BOM ID and it is not editable after the initial save.

BOM ID

Identifies the unique ID for each BOM record.  Clicking on the link opens the corresponding transaction record view.  This is a system assigned value that comes from the 'Doc Prefix' + 'Next Num.' of the selected BOM Class of the record and is not editable by users.

Database Field: ERPx_IMBOM.BOMID

BOM Item

Identifies the BOM Item, displayed as Item ID: Description. This is a non-editable textbox that displays the Item assigned to the corresponding BOM record.  

Database Fields: ERPx_IMItem.ItemID: ItemDescription, ERPx_IMBOM.ItemSK

BOM Item Description

Database Fields: ERPx_IMItem.ItemDescription, ERPx_IMBOM.ItemSK

BOM Item ID

Database Fields:  ERPx_IMItem.ItemID, ERPx_IMBOM.ItemSK

Cost UOM

Database Fields: ERPx_IMUOM.UOMID, ERPx_IMBOM.CostUOMSK

Created

Database Field: ERPx_IMBOM.CreatedDate

Created By

Database Field: ERPx_IMBOM.CreatedBy

Fixed Cost Rate

Identifies a Fixed cost rate for the BOM Item. BOM Items are typically valued from the sum of the costs of all the 'Inventory Items' and 'Cost Items'. However, in some cases the BOM Item needs to be assigned a standard or fixed cost. This is most commonly used to cost By-Products and/or waste items. This is editable from the record view.

Database Field: ERPx_IMBOM.FixedCostRate

Last Updated

Database Field: ERPx_IMBOM.LastUpdated

Last Updated By

Database Field: ERPx_IMBOM.LastUser

Scaling UOM

Database Fields: ERPx_IMUOM.UOMID, ERPx_IMBOM.ScalingUOMSK

Site ID

Database Fields: ERPx_MFSite.SiteID, ERPx_IMBOMSite.SiteSK

Status

Identifies the status of the BOM.

This is editable from the record view. 

Note: Temporarily we will display 'Closed' records in this List View. 

Database Fields: ERPx_ , ERPx_IMBOM.StatusSK 

Units UOM

Database Fields: ERPx_IMUOM.UOMID, ERPx_IMBOM.UnitsUOMSK

Weight UOM

Database Fields: ERPx_IMUOM.UOMID, ERPx_IMBOM.WeightUOMSK