Database Field: ERPx_IMLotCostHistory.Cost

Database Fields: ERPx_MFSite.SiteID, ERPx_MFSite.SiteName, ERPx_IMProductionLot.ManufactureSiteSK

Displays the BOM ID of the Bill of Material record. Clicking on the link opens the corresponding Bill of Materials Record View. This field is only populated if the lot costs have been retrieved from a BOM record. This is not editable.

Database Fields: ERPx_MPBOM.BOMID, ERPx_IMProductionLot.BaseCostBOMSK

Identifies

the Costing Method assigned to the Item ID. This can only be edited from the 'Costing Method' property on the 'Advanced Properties' tab of the Item Record View.

Database Fields: ERPx_IMLotBalance.ItemSK, ERPx_IMItem.ValuationMethodEN

Displays whether cost changes can be made to the Lot. If the Costing Status is "Open" then cost changes can be made.  If the Costing Status is "Closed" then cost changes cannot be made to the Lot.

This can be edited from the 'Layer Costing Status' property on the Mass Update dialog box launched from the Lot Balances List View.

Database Fields: ERPx_IMLotBalance.LayerCostingStatusEN

Displays the calculated age (in days) of the Production Batch. It is calculated as the (Current Date) - [Batch Date]. This can be edited by changing the 'Batch Date' field on the Properties tab of the Production Batch record view. This is not stored in the database.

This is a calculated field that is not stored in the database.

This is a calculated field that is not stored in the database.

Displays the Effective date of the cost update event. If the cost event was manually set, then this field cannot be edited once the 'Effective Date' field is applied on the Mass Update dialog box launched from the Update Costs List View. If the cost was updated from BOM, then this field comes 'Effective' field on the 'Cost Inputs' tab of the Bill of Materials Record View and cannot be edited.

Database Field: ERPx_IMLotCostHistory.EffectiveDate

Database Field: ERPx_IMProductionLot.ExpirationDate

A Yes/No field to identify if a Lot is expired.

• This will display as "Yes" For Lots with a 'Batch Expiration Date' that is <= the current date.
• This will display as "No" for Lots without a 'Batch Expiration Date' or for Lots with a 'Batch Expiration Date' that is >= the current date. 

This is a calculated field that is not stored in the database.

Database Field: ERPx_IMLotCostHistory.LastUser

Production Batch

Identifies the name of the Vendor, Fisherman, or Grower that the product was received from. If there is only one 'Received From' identified on the Production Batch, the name will be displayed. If there is more than one 'Received from' identified on the Production Batch, the word "Multiple" will be displayed. This can be edited from the 'Rec. From' header field on the Inventory Receipt record view before the transaction is posted or from the Production Batch Record View at any time. 

Database Field: ERPh_IMTransactionHeaderFields: ERPx_IMLotBalance.ProductionLotSk, ERPx_IMReceivedFrom.ReceivedFrom

Identifies how the Cost Layer was added. This is automatically assigned based on how the costs were assigned and is not editable. The options include:

• BOM

• Inherited 

• Item Default - Base
• Manual - Base
• Manual - Layer
• Transaction Base

• Transaction Layer

ERPx_IMLotCostHistory.LotCostTypeEN

Identifies the

Database Fields: ERPx_IMItem.UOMScheduleSK, ERPh_IMTransactionDetail.ItemSK