Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

DEFINTION.  The purpose of this page is to 

(lightbulb) This record view also contains columns for each Attribute that is set up for the 'ADD ALL TYPES HERE (Prod batch and items)' attribute types ALSO ADD CERTIFICATIONS. Because these are user defined, they are not included in the default view but can be added a saved column layout. ADD TYPES HERE attributes are not included in the help documentation.

Software Version: 2020.xx.xx and newer

...


Search Options
Description
Batch Date


Include


Item
Item Class
Lot Owner
Saved Search OptionsDisplays the saved search options lookup and related icons. This tool allows users to select previously saved search options, create a new set of search options, save changes to existing search options, forget/delete saved search options and/or assign a saved search option as the default for the page. Once changes are made to the search options, the user can click the Save Options icon and save the changes. The new search option can also be set as the default.
Search

A non-required text box that defaults to blank and is used to search across multiple fields. When the page is 'Refreshed', the data returned will be limited by what was included in the Search box (in addition to any other Search Options). 

Refer to this FAQ for advanced search options.

The Search field can be used to search across the following fields: 

Site

Used to select one or more Sites. This is a multi-select standard lookup that is not required to return results. It defaults as blank.

Sites represent Plants, Warehouses, Distribution Centers, or virtual objects that are used to store and/or maintain inventory balances.

The lookup contains a list of all active Sites.

Page Header

Order Summary Tab 


Fields
Description
Alloc. Units


Database Field: ERPx_SOOrderHeader.AllocatedUnits

Alloc. Weight


Database Field: ERPx_SOOrderHeader.AllocatedWeight

Is Sub Item


This field is not stored in the database.

Item


Database Fields: ERPx_IMItem.ItemDescription, ERPx_SOOrderItem.OrderItemSK

Ord. Units


Database Field: ERPx_SOOrderItem.OrderedUnits

Ord. Weight


Database Field: ERPx_SOOrderItem.OrderedWeight

Ship By


Database Fields: ERPx_SOOrderItem.ScheduledShipDate, ERPx_LMLoadHeader.ScheduledShipDate

Site

Used to select one or more Sites. This is a multi-select standard lookup that is not required to return results. It defaults as blank.

Sites represent Plants, Warehouses, Distribution Centers, or virtual objects that are used to store and/or maintain inventory balances.

The lookup contains a list of all active Sites.

Database Fields: ERPx_MFSite.SiteID, ERPx_LMLoadHeader.SiteSk

Units UOM


Database Fields: ERPx_IMUOM.UOMName, ERPx_SOOrderItem.UnitUOMSK

Weight UOM


Database Fields: ERPx_IMUOM.UOMName, ERPx_SOOrderItem.WeightUOMSK

Saved Search OptionsDisplays the saved search options lookup and related icons. This tool allows users to select previously saved search options, create a new set of search options, save changes to existing search options, forget/delete saved search options and/or assign a saved search option as the default for the page. Once changes are made to the search options, the user can click the Save Options icon and save the changes. The new search option can also be set as the default.



...

Toolbar IconsDescription
Column Filter Show/Hide
Insert excerpt
Column Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue
Excel
Insert excerpt
Excel - LV 3.0
Excel - LV 3.0
nopaneltrue
Group By Show/Hide
Insert excerpt
Group By Show/Hide - Global
Group By Show/Hide - Global
nopaneltrue
Help
Insert excerpt
Help - Global 3.0
Help - Global 3.0
nopaneltrue
Quick Filter
Insert excerpt
Quick Filter
Quick Filter
nopaneltrue
Refresh
Saved Column Layouts
Insert excerpt
Column Layouts for Framework 3.0 - Global
Column Layouts for Framework 3.0 - Global
nopaneltrue
FieldsDescription
Alloc Units

Identifies the total number of allocated units for all line items, formatted to 2 decimal places. This is a calculated field and can be edited by changing the unit allocation of one or more line items.

Database Field:  This value is not stored in the database. Calculated field? 

Alloc WeightIdentifies the total allocated weight for all line items, formatted to 2 decimal places. This is a calculated field and can be edited by changing the weight allocation of one or more line items.

Database Field: This value is not stored in the database. Calculated field?  

Batch 


Database Field: ERPx_IMProductionLot.ProductionLotID

Item


Database Fields: Field: ERPx_IMItem.ItemDescription

Owner


Database FieldsField: ERPx_IMLotOwner.OwnerName

Site

Insert excerpt
Site ID
Site ID
nopaneltrue
 
Insert excerpt
Site
Site
nopaneltrue
 This is required and can be edited from the 'Site ID' and 'Site Name' fields on the 'Properties' tab of the Site Record View. It comes from the 'Default Site' field on the 'Home' tab of the Sales Order Record View.

Insert excerpt
Def - Site
Def - Site
nopaneltrue

Database Fields: ERPx_MFSite.SiteID, ERPx_MFSite.SiteName, ERPx_SOOrderHeader.SiteSK

Units


Database Field: This is a calculated field and not stored in the database.

Units UOM


Database Fields: ERPx_IMUOM.UOMName, ERPx_SOOrderItem.UnitUOMSK 

Weight


Database Field: This is a calculated field and not stored in the database.

Weight UOM


Database Fields: ERPx_IMUOM.UOMName, ERPx_SOOrderItem.WeightUOMSK

WLot

 

Database FieldsField: ERPx_IMWarehouseLot.WarehouseLotID

Related Topics

User Guide: Sales Order

...