Page Comparison

Identifies the carrier associated with the corresponding leg. This is a single-select standard lookup that is sometimes required. This field is only required if the sales preference for 'Do Sales Orders Require a Carriers?' is set to "Yes". It defaults as blank. This field is always editable while the associated transaction is in a Status less than 'Approved'. If required and missing, the message "Carrier is required for all Legs" will be displayed on Save.

This lookup contains a list of all active Carriers.

Database Field: ERPx_SOCarrier.CarrierName, ERPx_LMLoadHeader.CarrierSK, ERPx_LMLoadTransactionLeg.CarrierSK

Displays the Country associated with the address for the corresponding leg. This is a text box that is not required. If entered, it must be <= 50 characters. Else, the message "String or binary data would be truncated." will be displayed on Save. It defaults as blank and is always editable while the associated transaction is in a Status less than 'Approved'.

Database Field: ERPx_LMLoadTransactionLeg.Country

Displays the rate used to calculate the Total Freight Amount in the transaction currency. This is a non-editable text box that is required. If the 'Leg Currency' is the same as the Currency of the associated transaction, then this defaults to "1.00000". Else if the 'Leg Currency' is the different from the Currency of the associated transaction, this defaults from the exchange table based on the 'Invoiced' date field for the associated shipment. If the transaction does not have an 'Invoiced' date, the rate is assigned based on the 'Order Date' of the associated transaction. If the exchange table does not contain a rate for the Invoiced/Order Date, then the most recent rate prior to the current date will be used. This field is for information only and cannot be edited.

Database Field: ERPx_LMLoadTransactionLeg.ExchangeRate

Displays the ID of the Exchange Table where the ‘Exch. Rate – Leg to Transaction’ was retrieved. This is a non-editable text box that is sometimes required. It is only required if the 'Leg Currency' is different from the Currency of the associated transaction. It defaults from the 'Exchange Table ID' field on the associated Exchange Table. This field is for information only and cannot be edited.

Database Fields: ERPx_MFCurrencyExchange.ExchangeID, ERPx_LMLoadTransactionLeg.ExchangeSK

Identifies the Leg ID from an external source. This is a text box that is not required. If entered, it must be <= 50 characters. Else, the message "String or binary data would be truncated." will be displayed on Save. It defaults as blank and is always editable while the associated transaction is in a Status less than 'Approved'.

Database Field: ERPx_LMLoadTransactionLeg.ExternalLegID

Identifies the Load ID from an external source. This is a text box that is not required. If entered, it must be <= 50 characters. Else, the message "String or binary data would be truncated." will be displayed on Save. It defaults as blank and is always editable while the associated transaction is in a Status less than 'Approved'.

Database Field: ERPx_LMLoadTransactionLeg.ExternalLoadID

Identifies the rate used to calculate the Total Freight for the shipment. This is a numeric text box that is not required. It defaults as "0.00000" and is always editable while the associated transaction is in a Status less than 'Approved'.

Database Field: ERPx_LMLoadTransactionLeg.FreightRate

Identifies how the total freight is calculated. This is a single-select standard lookup that is required. If missing, the message "Freight Rate Type is required when other components of freight are filled in." will be displayed on Save. This defaults as blank and is always editable while the associated transaction is in a Status less than 'Approved'.

This lookup contains the values in the FreightRateType Enumeration Class.

Database Field: ERPx_LMLoadTransactionLeg.FreightRateTypeEN

Identifies the total Freight Weight assigned to the leg. The weight is calculated from the allocated weight if the order has been allocated and from the ordered weight if the order has no allocations.This is a non-editable text box that is required. It defaults from the 'Shipping Wt." field in the 'Home' tab of this Record View if the ‘Freight Rate Type’ is either the "Fixed Amt – Gross Wt." or "$/UOM -Gross Wt.". If the ‘Freight Rate Type’ is either "Fixed Amt. – Net Wt." or "$/UOM – Net Wt.", then this field defaults from the 'Total Wt.' field. This is for information only and is never editable.

Q1: Is this field dependent on Load Status or Order Status when it determines whether to use ordered weight or allocated weight? Or neither?

Q2: Using the "$/UOM - Gross Wt." or "Fixed Amt - Gross Wt." rate types does not yield a value in the field as expected. Expectation is that is uses the "Shipping Wt." field in the 'Home' tab. Additionally, using the "$/UOM - Net Wt." or "Fixed Amt - Net Wt." rate types uses the 'Shipping Wt." field, when it should use the "Total Wt." field.

2/10 Update: Discussed with JS and when this page is converted to the 3.0 framework, this portion will mostly likely be rewritten.

Database Field: ERPx_LMLoadTransactionLeg.FreightWeight

Identifies the Unit of Measure for the leg freight rate. This is a single-select standard lookup that is sometimes required. This is required when the 'Freight Rate Type' field is either "$/UOM – Gross Wt." or "$/UOM – Net Wt". If required and missing, the message "Freight Rate UOM is required when a Freight Rate Type is $/UOM." will be displayed on Save. The field defaults to the ‘Order Weight UOM’ in the 'Home' tab of this Record View. It is always editable while the associated transaction is in a Status less than 'Approved'.

This lookup contains all 'Active' Weight UOMs configured on the Units of Measure Master File.

Database Fields: ERPx_IMUOM.UOMName, ERPx_LMLoadTransactionLeg.FreightWeightUOMSK

This field identifies if an inverse of an exchange table was used to calculate the Total Freight Amount. This is a non-editable text box that is not required. It defaults as blank if the 'Leg Currency' is the same as the Currency of the associated transaction. Else, if the 'Leg Currency' is different from the Currency of the associated transaction, then this field will display as "No" when the 'Leg Currency' equals the 'From Currency' of the Exchange Table Record View and the transaction currency equals the 'To Currency' on the Exchange Table Record View. If the 'Leg Currency' is different from the Currency of the associated transaction, then this field will display as "Yes" when 'Leg Currency' equals the 'To Currency' of the Exchange Table Record View and the transaction currency equals the 'From Currency' on the Exchange Table Record View. This is a system assigned value, for information only and is never editable.

Database Field: ERPx_LMLoadTransactionLeg.IsInverseExchange

Identifies the sequence of the leg on the shipment. This is a non-editable text box that is required. This is a system assigned value, for information only and is never editable.

Database Field: ERPx_LMLoadTransactionLeg.LegSequence

Identifies the currency for the corresponding leg. This is a single-select standard lookup that is required. If missing, the message "Currency is required for all Legs." will be displayed on Save. The field defaults from the 'Currency' field on the 'Home' tab of the Sales Transaction Record View. It is always editable while the associated transaction is in a Status less than 'Approved'.

Database Field: ERPx_MFCurrency.CurrencyID, ERPx_LMLoadTransactionLeg.CurrencySK

Identifies an additional charge amount, in the Leg Currency, which is added to the Total Freight Amount. This is a numeric text box that is not required. It defaults as "0.00000" and is always editable while the associated transaction is in a Status less than 'Approved'.

Database Field: ERPx_LMLoadTransactionLeg.OtherCharges

Identifies the calculation method (multiply or divide) used to calculate the Total Freight Amount in the transaction currency. This is a non-editable text box that is required. It defaults from the 'Calculation Method' field on the 'Properties' tab of the Currency Exchange Record View if the 'Exch. Table - Leg to Transaction' exchange table is set to calculate from the 'Leg Currency' to the transaction currency. Else, this field defaults to the inverse of the 'Calculation Method' field on the 'Properties' tab of the Currency Exchange Record View if the 'Exch. Table - Leg to Transaction' exchange table is set to calculate from the transaction currency to the 'Leg Currency'. This field is for information only and cannot be edited.

Database Field: ERPx_LMLoadTransactionLeg.ExchangeRateCalculationMethodEN

Identifies where the leg originated. The source can be Manual or Integrated. This is a non-editable text box that is required. This is a system assigned value, for information only and is never editable.

Database Field: ERPx_LMLoadTransactionLeg.LoadTransactionSourceEN

Identifies the surcharge percentage of the corresponding leg. This is a numeric text box that is not required. It defaults as "0.00000" and is always editable while the associated transaction is in a Status less than 'Approved'.

Database Field: ERPx_LMLoadTransactionLeg.Surcharge

Identifies the Total Freight Amount in the transaction currency.This is a non-editable text box that is required. This field is for information only and is never editable. It is calculated as:

• If the ‘Freight Rate Type’ is a "$/UOM" type: [Freight Weight] * [Freight Rate] * (1+ [Surcharge%]/100) + [Other Charges]
• If the ‘Freight Rate Type’ is a "Fixed Amt." type: [Freight Rate] * (1 + [Surcharge%]/100) + [Other Charges]
  

Database Field: ERPx_LMLoadTransactionLeg.TotalFreight

Identifies the Total Freight Amount in the transaction currency. This is a non-editable field that is required. It is calculated as [Total Frt Amt – Leg Currency] [Rate Type - Leg to Transaction] [Exch. Rate – Leg to Transaction], where the [Rate Type – Leg to Transaction] determines the calculation method.  This field is for information only, is not editable and is not stored in the database.