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 be 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 Order Management System for fulfillment by the Order Broker (retail pickup or delivery)

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

- 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-for-pickup, or store pickup order. This option is available whenever there is a related Order Broker record in Order Management System, 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-for-pickup order is also fulfilled through integration with Oracle Retail Order Broker’s Supplier Direct Fulfillment module, and the drop ship information has already been sent to Oracle Retail Order Broker, 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.

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.

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, including brokered 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 (in user date 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 (in user date 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 (in user date 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 (including Ship-for-Pickup) or Delivery Orders for background.

• RETAIL PICKUP: See Retail Pickup (including Ship-for-Pickup) or Delivery Orders for background.

• SHIP FOR PICKUP: See Ship-for-Pickup Orders for background.

• STORE PICKUP: See Store Pickup Orders for background.

Originating Location

The location originally assigned to fulfill the 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 Originating Location, Fulfilling Location, and Pickup 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.

Pickup Location

The location where the customer has selected to pick up the 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 Originating Location, Fulfilling Location, and Pickup 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.

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 initially 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 Order Management System, while the Allow Split Order and Allow Split Line settings at Oracle Retail Order Broker’s Preferences screen control these options in Oracle Retail Order Broker. In this situation, there is a single request ID assigned by Oracle Retail Order Broker.

• If the Create Separate Picks for Ship for Pickup Orders (L89) system control value is selected and a line on a ship-for-pickup order splits across multiple warehouses for shipment, Order Management System creates a separate SubmitOrder request to Oracle Retail Order Broker for each warehouse. In this situation, each SubmitOrder request creates a separate request ID assigned by Oracle Retail Order Broker.

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

Fulfilling Location

The location where:

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

• the customer picks up the order (store pickup or ship-for-pickup 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 Originating Location, Fulfilling Location, and Pickup 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 Oracle Retail Order Broker are also selected.

Numeric, 5 positions.

Created date/time

The date and time when the Order Broker request was created.

Date: Numeric, 6 positions (in user date format).

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

Polled date/time

The most recent date and 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 Order Management System.

Date: Numeric, 6 positions (in user date format).

Time: 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 Oracle Retail Order Broker when the system submits the lines to the Order Broker in the same request message.

• If the Create Separate Picks for Ship for Pickup Orders (L89) system control value is selected, Order Management System submits each order line to Oracle Retail Order Broker as a separate order, and Oracle Retail Order Broker 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 Order Management System is up to 25 positions, Oracle Retail Order Broker does not support a request ID longer than 10 positions.

Numeric, 25 positions.

History tab

History records sort by the line number assigned in Oracle Retail Order Broker, 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 Order Management System.

Numeric, 6 positions (in user date format).

Time

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

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

OROB Ln#

The line number currently assigned in Oracle Retail Order Broker at the time the response was sent or received. The line number is blank for history that occurs before Oracle Retail Order Broker sends a response message indicating the current line number. If the order line is initially split at creation in Oracle Retail Order Broker, 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 = Order Management System sent an request to the Order Broker to inquire about the order’s current status.

D - Receive Status Response = Order Management System 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 = Order Management System sent a status update request message to the Order Broker.

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

See Sample Order Broker Messages for examples of the different messages generated or received by Order Management System as part of the Order Broker integration.

Alphanumeric, 25 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.

Fulfilling Location

The location where the item was assigned for fulfillment (brokered backorder, retail pickup, or delivery) or pickup (store pickup, ship-for-pickup) 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 Originating Location, Fulfilling Location, and Pickup 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.

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 Oracle Retail Order Broker 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 OROB indicates that the OROB Account (K49) system control value is not set correctly. See Troubleshooting the Order Broker Integration and the Oracle Retail Order Broker Operations Guide for more information on possible errors.

Alphanumeric, 30 positions; display-only.