Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
This list view also contains columns for each Attribute that is set up for the 'Sales Order' and 'Logistics' attribute types. Because these are user defined, they are not included in the default view but can be added a saved column layout.Sales Order and Load Management (Logistics) attributes are not included in the help documentation.
Software Version: 2021.06.04 and newer
Table of Contents | ||
---|---|---|
|
...
Toolbar Icons | Description | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Column Filter Show/Hide |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Excel |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Export Details |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Favorites |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Group By Show/Hide |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Help |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Mass Update |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Quick Column Filter |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Saved Layouts |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Fields | Description | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Checkbox |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
# Legs | Identifies the number of legs associated with the shipment. This is required and can be edited by adding a new leg on the Shipment Details Record View. Database Field: ERPx_LMLoadTransaction.CountofLegs | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Address ID |
Database Fields: ERPx_ARCustomerAddress.AddressID, ERPx_SOOrderHeader.AddressSK | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Address Name |
Database Fields: ERPx_ARCustomerAddress.AddressName, ERPx_SOOrderHeader.AddressSK | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Amount | Identifies the total allocated extended amount for all line items on the shipment, formatted to 2 decimals. This is a calculated field and can be edited by changing the unit/weight allocations or by updating the 'Price' field of a line item associated with the shipment on the Sales Transaction Record View. It is calculated as [Allocated Quantity] * [Price], where [Allocated Quantity] is the Allocated Units if the 'Price UOM' for the item is is a Unit UOM and is the Allocated Weight if the 'Price UOM' for the item is a Weight UOM. Database Field: ERPx_SOOrderItem.AllocatedAmount | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Amount - Ord. | Identifies the total ordered extended amount for all line items on the shipment, formatted to 2 decimals. This is a calculated field and can be edited by changing the unit/weight Ordered Quantities or by updating the 'Price' of a line item associated with the shipment on the Sales Transaction Record View. It is calculated as [Ordered Quantity] * [Price], where [Ordered Quantity] is the Ordered Units if the 'Price UOM' for the item is is a Unit UOM and is the Ordered Weight if the 'Price UOM' for the item is a Weight UOM. Database Field: ERPx_SOOrderItem.OrderedAmount | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Attention To | | Def - Under Development | Def - Under Development | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
nopanel | true | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Insert excerpt |
|
Database Fields: ERPx_ARCustomerAddress.AttentionTo, ERPx_SOOrderHeader.ShipAttentionTo
This is not required and can be edited from the 'BOL' field on the 'Shipments' tab of the Sales Transaction Record View. Insert excerpt BOL BOL nopanel true
Insert excerpt Def - Bill of Lading Def - Bill of Lading nopanel true
Database Field: ERPx_LMLoadTransaction.BOL
This is not required and can be edited from the 'Booking #' field on the Export Details Record View. Insert excerpt Def - Booking # Def - Booking # nopanel true
Database Field: ERPx_LMLoadHeader.BookingNumber
Insert excerpt Def - Under Development Def - Under Development nopanel true
This field displays the 'Program Amt.' of all items on the shipment that qualify for the program. This field is not required. This field is a calculated field and may be edited from the Sales Program Details Record View. Insert excerpt Def - Brokerage Amt. Def - Brokerage Amt. nopanel true
This field uses the Ordered Ext Amount for calculations on transactions where the Status is less than "Shipped" and the Allocated Ext Amount on transactions where the Status is "Shipped" or greater.
Database Field: ERPx_SPProgramSettlementItem.ComputedAmount
Identifies the Carrier Name of the first leg of the shipment. This is not required and can be edited from the 'Carrier' field on the 'Home' tab of the Sales Transaction Record View or the 'Carrier' field on Leg 1 on the Shipment Details Record View.
Insert excerpt Def - Carrier Def - Carrier nopanel true
Database Fields: ERPx_SOCarrier.CarrierName, ERPx_SOOrderItem.CarrierSK
This value comes from the Created Date & Time of the Order. This field is required. Insert excerpt Created Created nopanel true
Database Field: ERPx_SOOrderHeader.CreatedDate
This value comes from the Created Date & Time of the Order. This field is required. Insert excerpt Created By Created By nopanel true
Database Field: ERPx_SOOrderHeader.CreatedBy
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Fields: ERPx_ARCustomer.CustomerID, ERPx_SOOrderHeader.CustomerSK
This is required and can be edited from the 'Customer ID' field on the 'Properties' tab of the Customer Record View. It comes from the 'Ship To' field on the 'Home' tab of the Sales Transaction Record View. Insert excerpt Customer ID - Transaction Customer ID - Transaction nopanel true
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Fields: ERPx_ARCustomer.CustomerID, ERPx_SOOrderHeader.CustomerSK
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Fields: ERPx_ARCustomer.CustomerName, ERPx_SOOrderHeader.CustomerSK
Identifies the number of days before the Shipment is to be shipped. This is a calculated field that can be either positive or negative. It is calculated as [Ship By Date] - [Current Date]. It is a positive number when the 'Ship By' is in the future and a negative number when the 'Ship By' is in the past. This is required and can be edited from the 'Ship By' field on the 'Shipments' tab of the Sales Transaction Record View. This field is not stored in the database.
This is required and can be edited from the 'Deliver On' field on the 'Home' tab of the Sales Transaction Record View. Insert excerpt Deliver On Date - Default Deliver On Date - Default nopanel true
Database Field: ERPx_LMLoadTransaction.DeliverOnDate
Displays the name/ID of the forwarder that corresponds to the shipment. This is not required and can be edited from the 'Forwarder' field on the Export Details Record View.
Insert excerpt Def - Forwarder Def - Forwarder nopanel true
Database Field: ERPx_LMLoadHeader.Forwarder
Identifies the total freight amount for the shipment. This is a calculated field. It is calculated as [Freight Weight] x [Freight Rate] x ([Surcharge %] / 100) + [Other Charges] for all legs of the shipment. This can be edited by updating the 'Freight Rate', 'Surcharge %' or 'Other Charges' fields on the Shipment Details Record View. Insert excerpt Def - Under Development Def - Under Development nopanel true
Insert excerpt Def - Freight Amt. Def - Freight Amt. nopanel true
This field uses the Ordered Ext Amount for calculations on transactions where the Status is less than "Shipped" and the Allocated Ext Amount on transactions where the Status is "Shipped" or greater.
Database Fields: ERPx_LMLoadHeader.TotalFreight, ERPx_LMLoadTransaction.FreightAmount
Identifies the Freight Terms assigned to the shipment. This is not required and can be edited from the 'Freight Terms' field on the 'Shipments' tab of the Sales Transaction Record View.
Insert excerpt Def - Freight Terms Def - Freight Terms nopanel true
This lookup contains a list of all 'Active' Freight Terms.
Database Fields: ERPx_LMLoadHeader.SOFreightTermsEN, ERPx_LMLoadTransaction.SOFreightTermsEN
This is required for transactions saved with a 'Status' of "Approved" or "Ready to Post" and can be edited from the 'GL Date' field on the 'Shipments' tab of the Sales Transaction Record View. Insert excerpt GL Date GL Date nopanel true
Database Field: ERPx_SOInvoiceHeader.GLDate
Identifies the fiscal period based on the GL Date on the shipment. This is required for the transaction to be saved in a status of 'Approved' or greater and can be edited from the 'GL Date' field on the 'Shipments' tab of the Sales Transaction Record View. This field is not stored in the database. Insert excerpt GL Period GL Period nopanel true
Identifies the fiscal year based on the GL Date on the shipment. This is required for the transaction to be saved in a status of 'Approved' or greater and can be edited from the 'GL Date' field on the 'Shipments' tab of the Sales Transaction Record View. This field is not stored in the database. Insert excerpt GL Year GL Year nopanel true
Identifies the profit amount, using only product costs, of the Shipment. This field is not required and not stored in the database. This field may be edited by editing any of the fields used in calculating this amount. Insert excerpt Def - Under Development Def - Under Development nopanel true
Insert excerpt Def - Gross Margin Amt. Def - Gross Margin Amt. nopanel true
Identifies the percentage of profit, using only product costs, of the Shipment. This field is not required and not stored in the database. This field may be edited by editing any of the fields used in calculating this amount. Insert excerpt Def - Under Development Def - Under Development nopanel true
Insert excerpt Def - Gross Margin Pct. Def - Gross Margin Pct. nopanel true
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Field: ERPx_SOInvoiceHeader.InvoiceNumber
Identifies the date the shipment was invoiced, formatted from the users 'Date Format' preference. This is required for the transaction to be saved in a status of 'Shipped' and greater. It can be edited from the 'Invoiced' field on the 'Shipments' tab of the Sales Transaction Record View.
Database Field: ERPx_SOInvoiceHeader.InvoiceDate
This is a system assigned value and is never editable by a user. This field is required. Insert excerpt Last Updated Last Updated nopanel true
Database Field: ERPx_LMLoadHeader.LastUpdated
This is a system assigned value and is never editable by a user. This field is required. Insert excerpt Last Updated By Last Updated By nopanel true
Database Field: ERPx_LMLoadHeader.LastUser
Identifies the final profit amount of the Shipment. This field is not required and not stored in the database. This field may be edited by editing any of the fields used in calculating this amount. Insert excerpt Def - Under Development Def - Under Development nopanel true
Insert excerpt Def - Net Margin Amt. Def - Net Margin Amt. nopanel true
Identifies the percentage of final profit of the Shipment. This field is not required and not stored in the database. This field may be edited by editing any of the fields used in calculating this amount. Insert excerpt Def - Under Development Def - Under Development nopanel true
Insert excerpt Def - Net Margin Pct. Def - Net Margin Pct. nopanel true
Insert excerpt Def - Under Development Def - Under Development nopanel true
This field displays the total 'Program Amt.' of all items on the shipment that qualify for the program. This field is not required. This field is a calculated field and may be edited from the Sales Program Details Record View. Insert excerpt Def - Other Accrual Amt. Def - Other Accrual Amt. nopanel true
This field uses the Ordered Ext Amount for calculations on transactions where the Status is less than "Shipped" and the Allocated Ext Amount on transactions where the Status is "Shipped" or greater.
Database Field: ERPx_SPProgramSettlementItem.ComputedAmount
This is not required and can be edited from the 'Place of Delivery' field in the header of the Export Details Record View. Insert excerpt Place of Delivery Place of Delivery nopanel true
Database Field: ERPx_LMLoadHeader.DeliveryPort
This is not required and can be edited from the 'Place of Delivery / Date' field in the header of the Export Details Record View. Insert excerpt Date - Delivery Date - Delivery nopanel true
Database Field: ERPx_LMLoadHeader.DeliveryDate
This is not required and can be edited from the 'Port of Discharge' field in the header of the Export Details Record View. Insert excerpt Port of Discharge Port of Discharge nopanel true
Database Field: ERPx_LMLoadHeader.DischargePort
This is not required and can be edited from the 'Port of Discharge / Date' field in the header of the Export Details Record View. Insert excerpt Date - Discharge Date - Discharge nopanel true
Database Field: ERPx_LMLoadHeader.DischargeDate
This is not required and can be edited from the 'Port of Entry' field in the header of the Export Details Record View. Insert excerpt Port of Entry Port of Entry nopanel true
Database Field: ERPx_LMLoadHeader.EntryPort
This is not required and can be edited from the 'Port of Entry / Date' field in the header of the Export Details Record View. Insert excerpt Date - Entry Date - Entry nopanel true
Database Field: ERPx_LMLoadHeader.EntryDate
This is not required and can be edited from the 'Port of Loading' field in the header of the Export Details Record View. Insert excerpt Port of Loading Port of Loading nopanel true
Database Field: ERPx_LMLoadHeader.LoadingPort
This is not required and can be edited from the 'Port of Loading / Date' field in the header of the Export Details Record View. Insert excerpt Date - Loading Date - Loading nopanel true
Database Field: ERPx_LMLoadHeader.LoadingDate
Identifies the actual cost of all items on the Shipment. This field is not required. If the item is ordered, but not allocated, this field may be edited from the 'Actual Cost' field for the Item in the Item Master File. It the item is allocated, this field may be edited from the 'Actual Cost' assigned on the Inventory Lot. Insert excerpt Def - Under Development Def - Under Development nopanel true
Insert excerpt Def - Product Cost Amt. Def - Product Cost Amt. nopanel true
Database Fields: ERPx_SOOrderItem.ItemActualCost, ERPx_IMLotCostHistory.Cost, ERPx_IMLotBalance.LotSK
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Field: ERPx_SOOrderHeader.PurchaseOrder
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Fields: ERPx_SPSalesperson.Salespersonname where SalespersonTypeEN = 2, ERPx_SOOrderHeader.InsideSalespersonSK
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Fields: ERPx_SPSalesperson.Salespersonname where SalespersonTypeEN = 1, ERPx_SOOrderHeader.SalesPersonSK
This is required and can be edited from the 'Ship By' field on the 'Home' tab of the Sales Transaction Record View. Insert excerpt Ship By - Default Ship By - Default nopanel true
Database Fields: ERPx_SOOrderItem.ScheduledShipDate, ERPx_LMLoadHeader.ScheduledShipDate
Displays the destination City and State the shipment containing the item. This not is required and comes from the 'City' and 'State' fields on the 'Properties' tab of the Customer Addresses Record View when the transaction was created. Once the transaction is created, this field is not editable.
Insert excerpt Def - Address - City Def - Address - City nopanel true Insert excerpt Def - Address - State Def - Address - State nopanel true
Database Fields: ERPx_ARCustomerAddress.City, ERPx_ARCustomerAddress.State, ERPx_SOOrderHeader.ShipCity, ERPx_SOOrderHeader.ShipState
Displays the Country the shipment will be shipped to. This is not required and comes from the 'Country' field on the 'Properties' tab of the Customer Addresses Record View when the transaction was created. Once the transaction is created, this field is not editable.
Insert excerpt Def - Address - Country Def - Address - Country nopanel true
Database Fields: ERPx_ARCustomerAddress.Country, ERPx_SOOrderHeader.ShipCountry
Displays the phone number at the address where the shipment will be shipped to. This is not required and comes from the 'Phone' field on the 'Properties' tab of the Customer Addresses Record View when the transaction was created. Once the transaction is created, this field is not editable.
Insert excerpt Def - Address - Phone 1 Def - Address - Phone 1 nopanel true
Database Fields: ERPx_ARCustomerAddress.Phone1, ERPx_SOOrderHeader.ShipPhone1
Clicking on the link opens the corresponding Shipment Details Record View. The shipment ID is auto generated based on a combination of Carrier, Site and Ship By Date. This is required, is a system assigned value and is not editable. Insert excerpt Shipment ID Shipment ID nopanel true
Database Field: ERPx_LMLoadHeader.LoadID
Identifies the status of the shipment. This is required and comes from the 'Load Status' field on the 'Shipments' tab of the Sales Transaction Record View. This field displays as "New" for transactions in a Status of 'New' or 'Released'. This field displays as "Shipped" for transactions in a Status of 'Shipped', 'Approved', and 'Ready To Post'. This field displays as "Posted" for transactions in a Status of 'Posted'. This field is not editable.
Database Field: ERPx_LMLoadHeader.LoadStatusSK
Identifies the date the shipment left the site, formatted from the users 'Date Format' preference. This field is required for the transaction to be saved in a status of 'Shipped' or greater. It can be edited from the 'Actual Ship' field on the 'Home' tab of the Sales Transaction Record View.
Database Fields: ERPx_LMLoadHeader.ActualShipDate, ERPx_SOOrderHeader.ActualShipDate
This is not required and can be edited from the 'Shipping Line' field on the Export Details Record View. Insert excerpt Shipping Line Shipping Line nopanel true
Database Field: ERPx_LMLoadHeader.ShippingLine
Identifies the Site ID (warehouse ID) where the shipment will ship from. This is required and can be edited from the 'Site' field on the 'Home' tab of the Sales Transactions Record View.
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Fields: ERPx_MFSite.SiteID, ERPx_LMLoadHeader.SiteSk
Identifies the name of the Site where the shipment will ship from. This is required and can be edited from the 'Site' field on the 'Home' tab of the Sales Transactions Record View.
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Fields: ERPx_MFSite.SiteName, ERPx_LMLoadHeader.SiteSk
This is required and can be edited from the 'Status' on the 'Home' tab of the Sales Transaction Record View. Insert excerpt Status Status nopanel true
The Statuses that apply to transactions in this List View include: Insert excerpt Def - Status Def - Status nopanel true
Insert excerpt Def - Status - New Def - Status - New nopanel true
Insert excerpt Def - Status - Released Def - Status - Released nopanel true
Insert excerpt Def - Status - Shipped Def - Status - Shipped nopanel true
Insert excerpt Def - Status - Approved Def - Status - Approved nopanel true
Insert excerpt Def - Status - Ready to Post Def - Status - Ready to Post nopanel true
Database Fields: ERPx_SOOrderStatus.OrderStatusName, ERPx_SOOrderHeader.OrderStatusSK. ERPx_SOOrderItem.OrderStatusSK
Identifies the tracking number associated with the shipment(s) on the order. This is not required and can be edited from the 'Tracking #' field on the 'Shipments' tab of the Sales Transaction Record View.
Database Field: ERPx_LMLoadTransaction.TrackingNumber
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Field: ERPx_SOOrderTypeDocument.DocumentID
It is formatted from the users 'Date Format' preference. This is required and can be edited from the 'Order Date' field on the 'Home' tab of the Sales Transaction Record View. Insert excerpt Doc Date Doc Date nopanel true
Database Field: ERPx_SOOrderHeader.OrderDate
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Field: ERPx_SOOrderType.OrderTypeName
Identifies the unique Transaction ID containing the shipment. Clicking on the link opens the corresponding transaction record view. This is required, is a system assigned value and is not editable.
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Field: ERPx_SOOrderHeader.OrderID
Identifies the total number of allocated units for all line items on the shipment, 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 associated with the shipment.
Database Field: ERPx_SOOrderItem.AllocatedUnits
Identifies the total number of ordered units for all line items on the shipment, formatted to 2 decimal places. This is a calculated field and can be edited by changing the 'Ord. Units' of one or more line items associated with the shipment.
Database Field: ERPx_SOOrderItem.OrderedUnits
This is not required can edited from the 'Vessel' field in the header of the Export Details Record View. Insert excerpt Vessel Vessel nopanel true
Database Field: ERPx_LMLoadHeader.Vessel
Displays the Vessel Number of the Vessel carrying the shipment. This is not required and can edited from the 'Vessel Number' field in the header of the Export Details Record View.
Database Field: ERPx_LMLoadHeader.VesselNumber
Identifies the total allocated weight for all line items on the shipment, 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 associated with the shipment.
Database Field: ERPx_SOOrderItem.AllocatedWeight
Identifies the total ordered weight for all line items on the shipment, formatted to 2 decimal places. This is a calculated field and can be edited by changing the 'Ord. Weight' of one or more line items associated with the shipment.
Database Field: ERPx_SOOrderItem.OrderedWeight
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt Def - Workflow Def - Workflow nopanel true
Database Fields: ERPx_MFWorkflow.WorkflowName, ERPx_SOOrderType.WorkflowSK
...