Transaction Class

The lookup contains a list of all Transfer Transaction Classes, SO Return and SO Shipment.

Saved Searches

Column Filter Show/Hide

Excel

Favorites

Group By Show/Hide

Help

Quick Column Filter

Refresh

Saved Layouts

Search Options

Fields

Description

#Pallets

Identifies the number of pallets in the corresponding container line. This can be edited from the '# Pallets' field on the Container grid of the Export Details Record View.

Database Field: ERPx_LMLoadTransactionContainer.Pallets

Amount

Identifies the Sales Amount for the corresponding container line. This can be edited from the 'Sales Amount' field on the Container grid of the Export Details Record View.

Database Field: ERPx_LMLoadTransactionContainer.Amount

Booking Number

Displays the Booking Number associated with the shipment. This can be edited from the 'Booking #' field in the header of the Export Details Record View.

Database Field: ERPx_LMLoadHeader.BookingNumber

Comment

Displays the comment for the corresponding container line. This can be edited from the 'Comment' field on the Container grid of the Export Details Record View.

Database Field: ERPx_LMLoadTransactionContainer.Comment

Container

Database Field: ERPx_LMLoadTransactionContainer.Container

Container Tare

Database Field: ERPx_LMLoadTransactionContainer.ContainerTare

Delivery Date

Database Field: ERPx_LMLoadHeader.DeliveryDate

Delivery Port

Database Field: ERPx_LMLoadHeader.DeliveryPort

Discharge Date

Database Field: ERPx_LMLoadHeader.DischargeDate

Discharge Port

Database Field: ERPx_LMLoadHeader.DischargePort

Dunnage

Database Field: ERPx_LMLoadTransactionContainer.Dunnage

Entry Date

Database Field: ERPx_LMLoadHeader.EntryDate

Entry Port

Database Field: ERPx_LMLoadHeader.EntryPort

Forwarder

Displays the name/ID of the forwarder that corresponds to the shipment. This can be edited from the 'Forwarder' field in the header of the Export Details Record View.

Database Field: ERPx_LMLoadHeader.Forwarder

Last Updated

Database Field: ERPx_LMLoadTransactionContainer.LastUpdated

Last Updated by

Database Field: ERPx_LMLoadTransactionContainer.LastUser

Load ID

Displays the Load ID that corresponds to the shipment. If the shipment comes from an inventory transaction, then this displays the Transaction ID. This is a system assigned value and and is never editable by a user. 

Database Field: ERPx_LMLoadHeader.LoadID

Loading Date

Database Field: ERPx_LMLoadHeader.LoadingDate

Loading Port

Database Field: ERPx_LMLoadHeader.LoadingPort

Module ID

Displays the ID of the module the transaction is part of (IM = Inventory, LM = Logistics, SO = Sales Order). This is a system assigned value and and is never editable by a user. 

Database Fields: ERPx_MFModule.ModuleID, ERPx_LMLoadHeader.BuildLoadModuleSK

Rate

Displays the Base Rate assigned to the corresponding container line. This can be edited from the 'Base Rate' field on the Container grid of the Export Details Record View.

Database Field: ERPx_LMLoadTransactionContainer.Rate

Seal

Displays the type of seal used to close the container. This can be edited from the 'Seal' field on the Container grid of the Export Details Record View.

Database Field: ERPx_LMLoadTransactionContainer.Seal

Shipped

Displays the date the container is shipped. For containers from the inventory module, this can be edited from the 'Transferred On' field in the 'Home' tab of the Transfer Transaction Record View. For containers from the sales order module, this can be edited from the 'Shipped' field on the 'Shipments' tab of the Sales Order Record View. For containers from the logistics module, this can be edited from the 'Actual Ship' field on the 'Load Plan' tab of the Loads Record View.

Database Field: ERPx_LMLoadHeader.ActaulShipDate

Shipping Line

Database Field: ERPx_LMLoadHeader.ShippingLine

Status

Identifies the status of the shipment as being Open, Shipped, or Posted. For containers from the inventory module, this can be edited from the 'Status' field in the 'Home' tab of the Transfer Transaction Record View. For containers from the sales order module, this can be edited from the 'Status' field on the 'Home' tab of the Sales Order Record View. For containers from the logistics module, this can be edited from the 'Status' field on the 'Home' tab of the Loads Record View.

Database Fields: ERPx_LMLoadHeader.LoadStatusSK

Total Weight

Displays the total weight of the container. This is calculated as [Weight] + [Container Tare] + [Dunnage]. This can be edited by updating the 'Weight', 'Container Tare' or 'Dunnage' field on the Container grid of the Export Details Record View.

Database Field: ERPx_LMLoadTransactionContainer.TotalWeight

Transaction

This field displays the ID of the transaction the container is assigned to if the Module ID is "IM" or "SO".  Displays the Logistics Load ID if the Module ID is "LM". Clicking the link opens the corresponding Transaction/Load Record View. This is a system assigned value and and is never editable by a user. 

Database Fields: ERPx_IMTransactionHeader.TransactionID, ERPx_SOOrderHeader.OrderID, ERPx_LMLoadHeader.LoadHeaderSK

Units

Displays the number of units assigned to the container. This can be edited from the 'Units' field on the Container grid of the Export Details Record View.

Database Field: ERPx_LMLoadTransactionContainer.Units

Vessel

Database Field: ERPx_LMLoadHeader.Vessel

Weight

Displays the weight assigned to the container. This can be edited from the 'Weight' field on the Container grid of the Export Details Record View.

Database Field: ERPx_LMLoadTransactionContainer.Weight