The purpose of this inquiry is to list container details from Export Details records. From the inquiry, users may also click the Transaction/Load ID hyperlink to open the corresponding Transaction/Load Record View.
Software Version: 2020.12.04 and newer
...
| Filter Items | Description | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Transaction Class |
The lookup contains a list of all Transfer Transaction Classes, SO Return and SO Shipment. | ||||||||||||||||
| Saved Search Options |
|
...
| Toolbar Icons | Description | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Column Filter Show/Hide |
| ||||||||||
| Excel |
| ||||||||||
| Favorites |
| ||||||||||
| Group By Show/Hide |
| ||||||||||
| Help |
| ||||||||||
| Quick Filter |
| ||||||||||
| Refresh |
| ||||||||||
| Saved Column Layouts |
| ||||||||||
| 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 | This
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 |
Related Topics
| Expand | ||
|---|---|---|
| ||
Page Definitions |
...