Outbounds QRY (Query/History)
Table of Contents
Outgoing orders (both historical and WIP) retrieved from the database.
QRY style action grids are designed so that you can view both historical and work-in-process data together in the same place. However, they are not pre-loaded with data from the database. Instead, you must compose and submit a query to populate the grid. For more information on this subject, see Queries.
This query-based action grid will retrieve orders from the database. Records will display a single order which may be of any type (deferred, regular, etc.) and status (created, picked, bill of lading printed, etc.).
Data Elements of the Outbounds QRY Action Grid
Each row (record) in the WiP Outbounds action grid is comprised of several columns (fields). Click on one of the column titles below for a definition of the data element it represents:
Whs Ref
3PL reference number assigned to an order. Each order represents a request from a client to ship specific products from a warehouse to a customer.
Client
A business that owns stock stored in a warehouse. Clients are billed for various logistics services (e.g. handling, storage, inventory tracking, transportation, etc.).
Note: It is possible for the Warehouse to bill Clients for services without tracking their inventory.
CSR
Client Service Representative (account manager) responsible for processing and/or trouble-shooting any/all client requests; e.g., create inbounds and outbounds, perform inventory queries/reporting, generate billing, etc.
Broker
Third party business that is permitted to request that an order be filled with stock from multiple clients. Both the warehouse and the related clients must agree to this arrangement.
Client Ref
Client reference code (or order number) that they (the client) associates with the order request from a warehouse
Whs
Warehouse building used to store clients' inventory. A warehouse contains multiple location codes each of which may be composed of an aisle, side, column and tier code. It is possible to define a single logical warehouse that represents multiple physical buildings.
To Shp Dte
Date on which an order is required to be shipped from the warehouse.
To Shp Tm
Time when an order is required to be shipped from the warehouse.
Ord Mode
Indicates if stock may be reserved during the creation of the order. Deferred mode means that the stock is not reserved. Regular mode means it may or may not be reserved.The order mode may be changed from Deferred to Regular by means of order committal. Once an order is committed, the stock is typically reserved
Ord Typ
User-defined code that may be attached to an order for multiple query and reporting purposes. Most orders are type "R" (Regular orders). Note: order type "T" is a system-defined code that is reserved for internal transfers of stock between clients.
Rush
Yes/No setting for defining a rush order. When an order has been deemed to be a rush, then it is possible to request the printing of pick slips for rush orders and also have the system automatically apply a charge for the tasks related and required to process a rush.
Mst Ord#
Master Order, alphanumeric code representing a collection of individual orders typically created to print Master Pick Slips and Master Bills of Lading. A master pick slip allows warehouse staff to minimize order picking/travel time and cost (where a picker makes fewer trips to pick stock for multiple orders). A master bill of lading displays a summarization of multiple orders for quick review/validation by the carrier and warehouse and reduces paper/form costs.
Parent
Order that is too large to be handled as a single order. Instead, very large orders are broken down into smaller Child orders to be shipped separately by different carriers. An order becomes a Parent if it has Cild orders. Splitting the large order may take place before picking (for carriers of known capacity of weight and cube) or after picking (for carriers of unknown capacity, rail cars, etc.). The Parent order never ships as a whole. The stock related to a Parent reduces to nothing once all Child order are shipped
Sale Grp
Client sales group used to categorize like clients together (e.g., clients that store metals) for query, reporting and billing purposes. Sales group codes are user-defined and a specific code is attached to each to client
Assgn Ops
Names of operators who are assigned to this order to perform various tasks (picking, loading, etc.) leading up to its shipment
Stock
Click view to link to Outbound Stock; i.e., products (description, location, quantities, etc.) being shipped out from the warehouse.
Conveyances
Click view to link to Outbound Conveyances; i.e., pallet IDs that contain the stock when it when it leaves the warehouse.
Unit IDs
Click view to link to Outbound Unit IDs (if stock is organized into units, serial numbers, etc.) being shipped out from the warehouse.
Pieces
Total number of pieces associated with all requested products to be shipped on an order. Each piece refers to one SKU, Stock Keeping Unit (box, case, bag, etc.) of a specific product that determines how it is tracked, counted, moved, etc.
Example:
Product A is tracked by the Box and 10 are to be shipped.
Product B is tracked by the Case and 20 are to be shipped.
Product C is tracked by the Bag and 30 are to be shipped.
A Total of 60 Pieces are to be shipped on the Order.
Weight
Total weight of all stock to be shipped on an order.
Cube
The total cube (volume) of all products to be shipped on an order. A specific product's cube is calculated by multiplying its standard SKU dimensions together (length x width x height).
Pallets
Estimated total number of pallets for the order. This calculation is based on each product's standard quantity of Stock Keeping Units per pallet and the assumption that products will not be mixed together on a pallet for shipment.
Standard Pallet Configurations:
Product A: 100 cases per pallet
Product B: 60 cases per pallet
Product C: 75 cases per pallet
Order Lines Quantities:
Product A = 200 cases. 200/100 = 2 pallets
Product B = 80 cases. 80/60 = 2 pallets
Product C = 50 cases. 50/75 = 1 pallet
Estimated total number of pallets on the order: 5
# Pk Ln
Number of lines on an order for which there is sufficient stock for the requested product quantity.
#NPKs
Non-pickable line exists when the order line quantity requested exceeds the stock that is on-hand and available for picking.
ECQ-B Pks
Estimated remaining number of ECQ Picks (Entire and Standard Conveyance Quantity) from bulk locations (non-pick line locations) required to complete the picking of the order.
Sample Order:
Product A - 180 pieces. Standard conveyance/pallet is 60 pieces
Product B - 50 pieces. Standard conveyance/pallet is 50 pieces
Calculation:
Product A = 180/60 = 3 ECQ picks from bulk locations
Product B = 50/50 = 1 ECQ pick from a bulk location
Total = 4 ECQ picks from bulk locations
LCQ-B Pks
The estimated remaining number of LCQ Picks (Less than Standard Conveyance Quantity) from Bulk Locations (non-pick line locations) required to complete the picking of the order.
Sample Order:
Product A - 185 pieces. Standard conveyance/pallet is 60 pieces
Product B - 20 pieces. Standard conveyance/pallet is 50 pieces
Calculation (Note: Any non-zero remainder is 1 LCQ):
Product A = 185/60 = 1 LCQ pick (5 pieces) from bulk location
Product B = 20/50 = 1 LCQ pick (20 pieces) from bulk location
Total = 2 LCQ picks from bulk locations
LCQ-B Qty
Estimated remaining quantity of pieces related to LCQ Picks (Less than Standard Conveyance Quantity) from bulk locations (non-pick line locations) required to complete the picking of the order.
Sample Order:
Product A - 185 pieces. Standard conveyance/pallet is 60 Pieces
Product B - 20 pieces. Standard conveyance/pallet is 50 pieces
Calculation (Note: Quantity is the non-zero remainder):
Product A = 185/60 = 5 pieces from bulk location
Product B = 20/50 = 20 pieces from bulk location
Total = 25 pieces from bulk locations
LCQ-P Pks
The estimated remaining number of LCQ picks (Less than Standard Conveyance Quantity) from pick line locations required to complete the picking of the order.
Sample Order:
Product A - 185 pieces. Standard conveyance/pallet is 60 pieces
Product B - 20 Pieces. Standard conveyance/pallet is 50 pieces
Calculation (Note: Any remainder is 1 LCQ pick):
Product A = 185/60 = 1 LCQ pick (5 pieces) from pick line location
Product B = 20/50 = 1 LCQ pick (20 pieces) from pick line location
Total = 2 LCQ picks from pick line locations.
LCQ-P Qty
Estimated remaining quantity of pieces related to LCQ picks (Less than Standard Conveyance Quantity) from pick line locations required to complete the picking of the order.
Sample Order:
Product A - 185 Pieces. Standard conveyance/pallet is 60 pieces
Product B - 20 Pieces. Standard conveyance/pallet is 50 pieces
Calculation (Note: Quantity is the non-zero remainder):
Product A = 185/60 = 5 pieces from pick line location
Product B = 20/50 = 20 pieces from pick line location
Total = 25 pieces from pick line locations
Life Cycle
Codes marking the stages in the progress of an Order through its life cycle. See Life Cycle Codes, below.
Pct Picked
Percentage of order that has already been picked.
Ord Stat
Order's current/last status. The system automatically assigns pre-defined status codes to an order when an application task is performed or completed (e.g. pick slip printed, order confirmed as shipped).
It is also possible for a user to assign a user-defined status to an order after a manual task has been performed; e.g. Quality Inspection Performed
BOL Prtd
Confirmation that a Bill of Lading has been printed
Operators
RF operators in the warehouse who are assigned to a specific order/receipt to perform various tasks. See RF Operators.
Hold
Indicates if a hold is placed against the entire order to prevent its shipment.
Holds may be applied by the warehouse or as instructed by the client for various financial or other related reasons.
Any combination of the following three hold codes may be attached to an order.
C = Credit
H = Manual Hold
S = Ship Complete
Lab Est
Estimated labor costs.
Lab Act
Actual labor costs.
Loc Stg
Location in the warehouse where picked stock is placed prior to shipment.
Stock for an order may be staged for a number of reasons/activities including inspection, packing, label attachment, shrink wrapping, etc.
Loc Load
Location in the warehouse where the order will be loaded into/onto a carrier for shipment.
This is normally a "dock door" in a warehouse. During the physical loading process verification may also be performed (either manually or via Radio Frequency) to ensure that the stock being loaded belongs to the correct order and is loaded into/onto the correct carrier.
Appt#
Outbound appointment number representing pick-up information which is linked to an Order that is (typically) transported by a carrier from a warehouse to a customer.
The appointment information includes the following:
Order Number
Date of Pick-Up
Time of Pick-Up
Carrier
Client
Client Reference
Customer Reference
Dock Door/Location
# of Pieces
Weight of Order
# of Pallets
etc
Status
Order's current/last status. The system automatically assigns pre-defined status codes to an order when an application task is performed or completed (pick slip printed, order confirmed as shipped).
It is also possible for an operator to assign a user-defined status to an order after a manual task has been performed; e.g., Quality Inspection Performed.
Door
Refers to a warehouse location at which the carrier has been scheduled to pick-up the stock related to the order for delivery to a customer; e.g., Dock Door 15.
Note: A door location need not be assigned to an appointment at the time of its creation or anytime afterwards.
Del Dte
Day when the goods are scheduled to be delivered
Del Tm
Time when the goods are scheduled to be delivered
Cust Cd
Code representing the business entity to which an order is shipped.
Typically, a customer will purchase stock from a client and then the client will request the shipment of the stock from a warehouse. Customers are also known as "consignees" and "ship to's".
Cust Name
Name of the customer to which the order is being shipped.
Address
Address (street name and number) of the customer to which the order is being shipped.
City
City (or Town, Village, etc.) of the customer to which the order is being shipped.
St/Prv
State (or Province) code of the customer to which the order is being shipped.
Zip/Pst
Zip (or Postal) code of the customer to which the order is being shipped.
Carrier Cd
Code representing the carrier who transports stock related to the order from the warehouse to the customer.
The carrier may be selected and assigned to the order by the client or warehouse. A carrier is typically a third party but could be owned/operated by the customer, carrier or warehouse.
Carrier Name
Name of the carrier assigned to transport the order from the warehouse to the customer.
Srv Lvl
In general, an order service level relates to how "quickly" an order must be delivered (e.g. Regular, Expedited, Over-Night, etc.).
The system may be configured to ensure that only appropriate carriers are selected for orders that are defined with a specific service level.
Fgt Typ
In general, order freight types relate to how an order is to be shipped (Road, Rail, Ocean, Air, etc.).
The system may be configured to ensure that only appropriate carriers may be selected for orders with a specific freight type.
Ctrl Mthd
Control method relates to how (and to whom) order freight/transportation may be charged.
Samples:
Prepaid (paid by the client)
Collect (to be paid by the customer upon delivery)
etc.
TMS ProBill
Request, normally initiated by a client, to ship stock from a warehouse to a customer.
A probill is assigned an alphanumeric code by the Transportation Management System at the time it is created.
Note: A Probill does not contain detailed information (Product, Lot, IDs, etc.) associated with the stock being shipped.
Instr
Special Instructions normally originate from the client and contain information concerning tasks that need to be performed before the order is shipped.
If this column displays "NO" then no special instructions are associated with the order
Notes
Order notes, typically containing information concerning tasks that may need to be performed before the order is shipped.
Notes are created and used for communication between warehouse staff (and contain the note author and date/time sent) and are not available for viewing by Clients. Whether or not Notes display on various Warehouse documents (e.g. on a Pick Slip) may be configured with the system.
Remarks
Multiple order remarks may originate from either the client and/or Warehouse and typically contain information concerning tasks that need to be completed before the oprder is shipped.
Notes: Although a remark may contain information concerning specific stock it is NOT associated with a specific Order line. If this column contains "No" then no remarks are associated with the Order.
Using standard Action Grid Functionality, the data may be sorted, filtered, and sub-totaled for various types of analysis. The results may be converted to a chart and/or output to external format (PDF, Excel, XML etc.). Selected data may also be used as the source from which to take action to change the status of ASN/Receipts.
Drill-Downs From Outbounds QRY
Some of the data elements for Outbounds QRY act as hyperlinks to other action grids that may contain further details related to the record selected.
Stock | Invokes the Outbound Stock action grid which provides details about the products (description, location, quantities, etc.) listed within an outgoing order. |
Conveyances | Invoke the Outbound Conveyances action grid which provides information associated with the conveyances (pallet IDs) in which the outgoing stock is contained. |
Unit IDs | Invoke the Outbound Unit IDs action grid which provides information about the units (if stock is organized into units, serial numbers, etc.) leaving the warehouse. |
|
Exits the current level of a drill-down (if activated). The Back All (double arrow) and the Back (single arrow) buttons are activated (turn red) whenever the current action grid is the result of a drill-down invoked by hyperlinked data elements. If activated, you can use the Back button to exit one level of grid at a time. Use the Back All button to navigate out of all levels and return to the initial action grid. |