Whse (Warehouse)

The code for the warehouse this item shipped from, if the order entry operator selected a warehouse other than the one the system assigned; otherwise, the warehouse code is zero.

You can review the actual warehouse code on the Display Order Detail Screen (Reviewing Order Line Detail); however, the warehouse code does not appear on this screen either until the order has been shipped.

Numeric, 3 positions; display-only.

Ln #

A number the system assigns to each item as it is added to the order. The Order Inquiry detail screen displays lines in descending numeric sequence by line number so that the most recently entered item appears first. A quote or order can have up to 999 lines.

Note:

• The code RTN appears below the line number if there has been a return against the order line.

• The code EXC appears below the line number if there has been an exchange against the order line. The system identifies an order detail line as containing an exchange item if an associated Order Line History record contains an exchange reason code. You can review order line history on the Display Order Line History Screen.

Numeric, 3 positions; display-only.

S (Status)

A one-position code indicating the current status of the item on the order. Possible statuses are:

• blank = The order line is currently open.

• Express Bill = You have entered the order using an express-bill ship via, but the BILL_ASYNC process has not yet processed the invoice. See Working with the BILL_ASYNC Job for background.

• Cancelled = You have canceled the item using a cancel reason code that is not flagged to reduce demand. See Establishing Cancel Reason Codes (WCNR) for background on cancel reason codes.

• Error = The order line is currently flagged with an error, and the order is suspended in an order batch. See Order Creation Errors for background.

• Held = The order line is currently held. You can hold a line on an open order to prevent it from printing on a pick slip, even if it is available.

• Soldout = The item has been sold out. An order line can by sold out:

• manually in order entry or maintenance through the Sell Out option

• automatically in order entry or maintenance, based on the soldout control code assigned to the item

• through the Process Auto Soldouts option

See Managing Soldouts and Backorders for background.

• Closed = The item has been shipped, canceled with a cancel reason flagged to reduce demand, or partially shipped and the remainder of ordered quantity canceled.

Display-only.

Item #

A code that identifies a unit of inventory. Item codes are defined in and validated against the Item table.

Note: An item alias is displayed if the customer ordered using an alias and the Display Item Alias (D56) system control value is selected.

Alphanumeric, 12 positions; display-only.

SKU (Stock keeping unit)

An item's unique characteristics, such as its size and color.

The first 14 positions of the SKU description defined at the Create SKU 1 of 2 (With Overrides) Screen are displayed in place of the SKU elements if the Display SKU Description in place of SKU Element (F25) system control value is selected.

Alphanumeric, three 4-position fields; display-only.

H (Handling)

Represents the type of special handling for the item. Handling codes are defined in and validated against the Additional Charge Codes table. See Establishing Additional Charge Codes (WADC).

Alphanumeric, 2 positions; display-only.

Ord (Ordered)

The number of units of an item the customer ordered.

Numeric, 5 positions; display-only.

Rsv (Reserved)

The quantity of the item that the system has reserved from stock. The system does not reserve stock on quotes until they are converted to standard orders; see Converting Quotes to Orders. The reserved quantity is reduced when an item is canceled, confirmed for shipment, or unreserved using Interactive Reservation. The system updates this quantity at billing.

Numeric, 5 positions; display-only.

Shp (Ship)

The number of units that have shipped. The system updates this quantity at billing.

If an item has shipped, the shipping date displays below this number.

Numeric, 5 positions; display-only.

Prt (Print)

The number of units included on a printed pick slip.

Pre-generated picks: The system does not update this field when you create a pre-generated pick for the order line during pick slip preparation; the system updates this quantity when you generate a pick slip. See Applying Pick Slip Preparation to an Order and Performing Pick Slip Generation.

Voiding a pick slip: The system reduces the printed quantity if you void the pick slip and don't reprint, or when shipment of the item is confirmed.

Order Broker? For a brokered backorder or a store pickup order line that has been selected for fulfillment through integration with the Order Broker, the print quantity is equal to the ordered quantity unless a shipment or pickup has already taken place, the order line has been canceled, or a partial quantity of the line is unfulfillable through the Order Broker (brokered backorders only).

See Brokered Backorders or Store Pickup Orders for an overview.

Numeric, 5 positions; display-only.

Price

The unit price of the line.

The item price is highlighted in a different color if the price represents a discount over the regular offer price for the item, and if the Display Order Line Discount Messages (F01) system control value is selected. However, the system does not highlight the price if the price was overridden on the detail line, and:

• no item/SKU offer price exists, or

• the price override reason code’s Override item offer price is selected.

See Overriding the Item/SKU Offer Price for more information on the effects of the Override item offer price field.

Note: The setting of the Override item offer price field has no effect on orders you receive through the e-commerce interface. If there is a price override reason code in the new order message, the system always processes these orders as if the field is unselected.

Numeric, 7 positions with a 2-place decimal; display-only.

Brokered? (unlabeled field below the Ln#)

Order Broker? The line is flagged as:

• OBR if the order line:

• has been assigned to the Order Broker for fulfillment (brokered backorder)

• has been assigned to CWSerenade for fulfillment by the Order Broker (retail pickup or delivery)

• ships to a store location, where the customer picks it up (ship-to-store)

• a return or exhange has not been processed against the line; in this situation, RTN or EXC displays instead

• SPU if the customer is picking up the order at a retail store location where the inventory is already available (store pickup) and a return or exhange has not been processed against the line (in this situation, RTN or EXC displays instead)

Note: The OBR or SPU flag remains on the order line even if the line has been fulfilled, canceled, or rejected by the fulfilling store location.

• For a brokered backorder or a store pickup order line that has been selected for fulfillment through integration with the Order Broker:

• the print quantity is equal to the ordered quantity unless a shipment or pickup has already taken place, or a partial quantity of the line is unfulfillable through the Order Broker (brokered backorders only)

• if the order line has not yet been fulfilled, the Drop ship flag for the order line is set to D

Reviewing Order Broker details: You can select D/S Status for the item to advance to the Display Order Broker Details Screen and review information about a brokered backorder line, or a line on a retail pickup, delivery, ship-to-store, or store pickup order. This option is available whenever there is a related Order Broker record in CWSerenade, regardless of whether the line has been fulfilled or canceled, or rejected by the fulfilling store location.

Note: If the order line on a retail pickup, delivery, or ship-to-store order is also fulfilled through integration with CWCollaborate or Locate’s Supplier Direct Fulfillment module, and the drop ship information has already been sent to CWCollaborate or Locate, you advance first to the Display P/O Drop Ship Screen. From that screen, you have the option to advance to the Display Order Broker Details Screen.

For more information: See Order Broker Integration for background.

Alphanumeric, 3 positions; display-only.

Item description (unlabeled field below the item code)

The description of the item.

Alphanumeric, 25 positions; display-only.

Expected ship date

Backordered item: the date a purchase order for this backordered item is expected.

Note: This field is not displayed for a reserved item, or if there are no open purchase orders for the item. If you receive purchase orders into suspense, you must run Batch Purchase Order Layering to update this date.

Finished good item: This field indicates when a finished good item created through work order processing will be ready for sale if the Use Work Order Processing (E37) system control value is selected. See Finished Good Work Order Processing (WWOR) for more information on work orders.

Drop ship item: This date is displayed for drop ship items if the Assign Drop Ship Expected Ship Date (I59) system control value is selected. See that system control value for more information.

Numeric, 6 positions (MMDDYY format); display-only.

Invoice date

The most recent date when you billed for shipment on this order detail line. This field is blank for order detail lines that have not yet shipped.

Numeric, 6 positions (MMDDYY format); display-only.

Extended price

The extended price of the line, calculated as:

Unit price x Order quantity = Extended price

Numeric, 7 positions with a 2-place decimal; display-only.

Inv dt (Invoice date)

The date when the item was billed.

Numeric, 6 positions (MMDDYY format); display-only.

Rtn (Returned quantity)

The quantity of the item that has been returned.

Numeric, 5 positions; display-only.

Order #

A unique number the system assigns to identify the order. The ship-to number is to the right, separated by a hyphen.

Order number: numeric, 8 positions.

Ship-to number: numeric, 3 positions.

Line #

A number the system assigns to each item as it is added to the order.

Numeric, 3 positions.

Broker delivery type

Indicates the type of order:

• blank = brokered backorder. See Brokered Backorders for background.

• DELIVERY: See Retail Pickup or Delivery Orders for background.

• RETAIL PICKUP: See Retail Pickup or Delivery Orders for background.

• SHIP TO STORE: See Ship-to-Store Orders for background.

• STORE PICKUP: See Store Pickup Orders for background.

Item/SKU

A code that identifies a unit of inventory. Item codes are defined in and validated against the Item table.

Note: The regular item code is displayed, regardless of whether the customer ordered using an alias and the Display Item Alias (D56) system control value is selected.

Alphanumeric, 12 positions.

Order qty

The number of units of the item that the customer ordered.

Numeric, 5 positions.

Details tab

Multiple locations?

• If you use the split order and split line options and the Order Broker cannot find a single location to fulfill a brokered backorder line, it might split the across multiple fulfilling locations; splitting can occur either when the Order Broker in it ally receives the order, or if the first assigned location rejects the line and the Order Broker “reshops” it. The Use Split Order (L56) system control value controls this option in CWSerenade, while the Allow Split Order and Allow Split Line settings at Locate’s Preferences screen control these options in Locate. In this situation, there is a single request ID assigned by Locate.

• If the Create Separate Picks for Ship to Store (L89) system control value is selected and a line on a ship-to-store order splits across multiple warehouses for shipment, CWSerenade creates a separate SubmitOrder request to Locate for each warehouse. In this situation, each SubmitOrder request creates a separate request ID assigned by Locate.

Note: It is not possible to have a split line on other types of Order Broker orders.

Location

The location where:

• the item is currently assigned for fulfillment, which might be a store location (brokered backorder) or the CWSerenade warehouse (retail pickup or delivery order)

• the customer picks up the order (store pickup or ship-to-store order)

From the cross-reference record set up through Work with Store Cross Reference (WSCR). The description of the location is separated from the location code by a hyphen (-).

See the Order Broker Fulfilling Location for a discussion, including information on when the location field is blank.

The location description is truncated if it exceeds the allotted space.

Location code: alphanumeric, 10 positions.

Location description: alphanumeric, 40 positions.

Status

The current status of the Order Broker request. Possible statuses are described at the Order Broker Status Summary Table.

Qty

The quantity currently assigned to the fulfilling location. Might be less than the ordered quantity if this is a brokered backorder, the Use Split Order (L56) system control value is selected, and the Allow Split Order and Allow Split Line preferences in Locate are also selected.

Numeric, 5 positions.

Created date

The date when the Order Broker request was created.

Numeric, 6 positions (MM/DD/YY format).

Created time

The time when the Order Broker request was created.

Numeric, 6 positions (HH:MM:SS format).

Polled date

The most recent date when the BROKER job evaluated whether to request a status update for the order line. Not used for retail pickup or delivery orders, which do not originate in CWSerenade.

Numeric, 6 positions (MM/DD/YY format).

Polled time

The most recent time when the BROKER job evaluated whether to request a status update for the order line. The job uses the Order Broker Status Update Interval (K10) system control value to determine how often to check on status. Not used for retail pickup or delivery orders, which do not originate in CWSerenade.

Numeric, 6 positions (HH:MM:SS format).

Request ID

A unique ID number assigned by the Order Broker to identify the order line or order:

• If you do not split orders, each individual brokered backorder item submitted to the Order Broker receives a unique request ID, and the Order Broker treats it as a separate order; otherwise, lines on an order create a single request ID in Locate when the system submits the lines to the Order Broker in the same request message.

• If the Create Separate Picks for Ship to Store (L89) system control value is selected, CWSerenade submits each order line to Locate as a separate order, and Locate assigns each its own request ID.

• Store pickup orders cannot be split.

The request ID is blank for requests whose status is:

• Z: Canceled

• C: Closed

• J: Rejected

• R: Ready

• W: Waiting

The field might also be blank for requests in E: Error status, depending on the nature of the error. For example, requests that the Order Broker did not receive and create successfully are not assigned request ID’s.

Although the field in CWSerenade is up to 25 positions, Locate does not support a request ID longer than 10 positions.

Numeric, 25 positions.

History tab

History records sort by the line number assigned in Locate, and then by date and time within line number.

Date

The date when the request was sent to the Order Broker, or when the response was received in CWSerenade.

Numeric, 6 positions (MM/DD/YY format).

Time

The time when the request was sent to the Order Broker, or when the response was received in CWSerenade.

Numeric, 6 positions (HH:MM:SS format).

Line#

The line number currently assigned in Locate at the time the response was sent or received. The line number is blank for history that occurs before Locate sends a response message indicating the current line number. If the order line is initially split at creation in Locate, the first few history records might have blank line numbers.

Numeric, 5 positions.

Transaction type

The type of activity that occurred. Possible transaction types are:

C - Send Status Request = CWSerenade sent an request to the Order Broker to inquire about the order’s current status.

D - Receive Status Response = CWSerenade received the status inquiry response message from the Order Broker.

M - Maintenance Transaction = You canceled the brokered backorder or store pickup request. You can cancel a brokered backorder either through order maintenance, or by canceling the Order Broker request itself (but not the order line) at the Work with Order Broker Screen; however, you can only cancel a store pickup request through order maintenance.

E - Send Update Request = CWSerenade sent a status update request message to the Order Broker.

F - Receive Update Response = CWSerenade received the status update response message from the Order Broker.

For more information: See Sample Order Broker Messages for examples of the different messages generated or received by CWSerenade as part of the Order Broker integration.

Alphanumeric, 25 positions.

Location

The location where the item was assigned for fulfillment (brokered backorder, retail pickup, or delivery) or pickup (store pickup, ship-to-store) at the time the activity occurred. The description of the location is separated from the location code by a hyphen (-). If there is no Store Cross Reference record for the location, no description is displayed. See the Order Broker Fulfilling Location for a discussion.

The location description is truncated if it exceeds the allotted space.

Location code: alphanumeric, 10 positions.

Location description: alphanumeric, 40 positions.

Status

The status of the Order Broker line at the time of the activity. Possible statuses are described at the Order Broker Status Summary Table.

Qty

The quantity of the Order Broker line at the time of the activity. Might be less than the ordered quantity if this is a brokered backorder, the Use Split Order (L56) system control value is selected, and the Allow Split Order and Allow Split Line preferences in Locate are also selected.

Numeric, 5 positions.

Error

The error, if any, received from the Order Broker. The error message is truncated if it exceeds 30 positions. An error of Null response from Locate indicates that the Locate Account (K49) system control value is not set correctly. See Troubleshooting the Order Broker Integration and the Locate Operations Guide for more information on possible errors.

Alphanumeric, 30 positions; display-only.