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 value in this field 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 the operator enters it. The Order Inquiry detail screen displays lines in descending numeric sequence by line number so that the most recently entered item appears first. An order can have up to 999 lines.

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

TBD code: The code TBD (To Be Delivered) is below the line number if the item on the order line is in an “In Transit” status, indicating the item is in the process of being delivered to the customer. The system displays a TBD code for an order line if an order line history record exists for activity code I (In Transit). The system removes the TBD code from the order line if there is an order line history record for activity code V (Delivered), R (Return), or E (Exchange) that is more recent than the order line history record for activity code I (In Transit). The system creates an order line history record for activity code I (In Transit) when an Order Line History In Message (CWORDLNHSTIN) is received with an activity_code of I. See Order Line History In API.

OBR code: The code OBR (Order Broker) is below the line number if the item is fulfilled through the Order Broker integration, either because the order is assigned to an external location for shipment (brokered backorder) or because the order originated in an external location and is assigned to your default warehouse for shipment (retail pickup or delivery order). In either case, you can enter 15 next to the item to advance to the Display Order Broker Details Screen; however, in the case of a drop ship item fulfilled through the integration with CWCollaborate or Locate’s Supplier Direct Fulfillment module, you advance first to the Display P/O Drop Ship Screen. See the Order Broker Integration for an overview.

Numeric, 3 positions; display-only.

S (Status)

A code that represents the status of an item. The status is open unless one of the following codes appears:

B = Express Bill

C = Canceled

E = Error

H = Held

S = Soldout

X = Closed

Alphanumeric, 1 position; display-only.

Item #

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

Note: An item alias displays if the customer ordered using an alias and the Display Item Alias (D56) system control value is set to Y.

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 displays in place of the SKU elements if the Display SKU Description in place of SKU Element (F25) system control value is set to Y.

Alphanumeric, three 4-position fields (split SKU) or one 14-position field (full SKU); display-only.

H (Handling)

A code that represents the type of special handling for the item. Handling codes are defined in and validated against the Additional Charge Codes file. See Establishing Additional Charge Codes (WADC).

Alphanumeric, 2 positions; display-only.

Ord (Order)

The number of units of an item the customer ordered.

Numeric, 8 positions; display-only.

Rsv (Reserved)

The quantity of the item that the system has reserved from stock. 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.

Order Broker: The line can also have a printed quantity if it has been assigned to the Order Broker for fulfillment (brokered backorder). In this situation, there is a code of OBR below the line number, although there is no reserved quantity and there might also be an expected ship date indicated. See the Order Broker Integration for background.

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 is below this number.

Numeric, 5 positions; display-only.

Prt (Print)

The number of units included on a printed pick slip. The system reduces the printed quantity if you void the pick ticket and don't reprint, or when shipment of the item is confirmed. The system updates this quantity at billing.

Order Broker: The line can also have a printed quantity if it has been assigned to the Order Broker for fulfillment (brokered backorder). In this situation, there is a code of OBR below the line number, although there is no reserved quantity and there might also be an expected ship date indicated. See the Order Broker Integration for background.

Numeric, 5 positions; display-only.

Price

The unit price of the line.

The item price will be highlighted in a reverse 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 set to Y. However, the system does not highlight the price if the price was overridden on the order line, and:

• no item/SKU offer price exists, or

• the price override reason code’s Override item offer price is set to Y.

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 set to N.

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

Order Broker code (unlabeled field below the line number)

A code of OBR indicates that the item has been assigned to the Order Broker for fulfillment. When the order line is processing, there is a printed quantity even though the line is backordered (not reserved), and an expected ship date might also be indicated.

The code of OBR remains on the line even after the fulfilling location ships the item, or if the Order Broker cannot fulfill the order line.

See the 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

For a backordered item: the date a purchase order containing this backordered item is expected.See Determining the Expected Ship Date.

System calculated date? The system calculates the expected ship date for backordered items that are not on any open purchase orders if the Calculate Expected Date in OE if No PO (J61) system control value is set to Y. The calculation updates the order detail record by adding the FTC -- # of Days for Items without Expected Ship Date (C71) system control value when you first add the item to the order, and again each time you run batch PO layering. See the Calculate Expected Date in OE if No PO (J61) system control value for a discussion.

This field is blank for a reserved item, or if the Calculate Expected Date in OE if No PO (J61) system control value is set to N and there are no open purchase orders for the item. If you receive purchase orders into suspense, run Batch Purchase Order Layering to update this date.

Finished goods: For finished good items created through work order processing, this field indicates when the finished good will be ready for sale. See Warehousing Finished Good Work Order Processing (WWOR) for more information on work orders.

Order Broker: An expected ship date might be indicated even if the item has been assigned to the Order Broker for fulfillment (brokered backorder). In this situation, there is a printed quantity even though the line is backordered, but there is no reserved quantity and the item is flagged with a code of OBR. See the Order Broker Integration for background.

Drop ship items: This date is displayed for drop ship items only if the Assign Drop Ship Expected Ship Date (I59) system control value is set to Y. See that system control value for more information. For drop ship sets, the date is indicated for the drop ship components only.

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

Invoice date (unlabeled field to the right of the expected ship 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.

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 displays in place of the SKU elements if the Display SKU Description in place of SKU Element (F25) system control value is set to Y or the Display SKU Description on Scan Order Detail Screens (J90) system control value is set to Y.

Alphanumeric, three 4-position fields (split SKU) or one 14-position field (full SKU); 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.

Delivery type

Indicates the type of order sent from Locate:

• Retail Pickup: You ship the order to the originating location, where the customer picks it up

• Delivery: You ship the order directly to the customer

This field is not included for a brokered backorder.

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

Item/SKU code: alphanumeric, 12 positions.

Description: alphanumeric, 40 positions.

Order quantity

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

Numeric, 5 positions.

Location

The location where the item is currently assigned for fulfillment, which might be a store location (brokered backorder) or the CWDirect warehouse (retail pickup or delivery order). From the description of the location set up through Working with Store Cross References (WSXR). Truncated if it exceeds 15 positions.

Alphanumeric, 15 positions.

Sts (status)

The code identifying the current status of the Order Broker request. See Order Broker Statuses for more information.

Alphanumeric, 1 position.

Qty

The quantity currently assigned to the fulfilling location. The same as the ordered quantity.

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_STS process evaluated whether to request a status update for a brokered backorder, or for a retail pickup order line that has been shipped to the requesting store location. Not used for delivery orders.

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

Polled time

The most recent time when the BROKER_STS process evaluated whether to request a status update for a brokered backorder, or for a retail pickup order line that has been shipped to the originating store location. Not used for delivery orders.

Status inquiry schedule:

• Brokered backorder: The job uses the Order Broker Status Update Interval (K10) system control value to determine how often to check on the status of a brokered backorder.

• Retail pickup: The job checks the status of a shipped retail pickup order once daily between the Limited Status Beginning and Limited Status End times to see if the customer has picked up the order at the originating store location.

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.

When you integrate with Locate 2.1 or 2.5 through the cw_locate site, the request ID is blank for requests whose status is:

• Z: Canceled

• C: Closed

• J: Rejected

• R: Ready

• U: Unfulfillable

• 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 CWDirect is up to 25 positions, Locate does not support a request ID longer than 10 positions.

Numeric, 25 positions.

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.

Delivery type

Indicates the type of order sent from Locate:

• Retail Pickup: You ship the order to the originating location, where the customer picks it up

• Delivery: You ship the order directly to the customer

This field is not included for a brokered backorder.

Alphanumeric, 12 positions.

Item/SKU

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

The item description is displayed even if the item has SKUs.

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.

Item/SKU code: alphanumeric, 12 positions.

Item description: alphanumeric, 40 positions.

Order quantity

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

Numeric, 5 positions.

Date

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

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 CWDirect.

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.

Numeric, 5 positions.

Transaction type

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

• Send Status Request = CWDirect sent an request to the Order Broker to inquire about the order’s current status.

• Receive Status Response = CWDirect received the status inquiry response message from the Order Broker.

• Maintenance Transaction or Maintained = You canceled the brokered backorder.

• Send Update Request = CWDirect sent a status update request message to the Order Broker.

• Receive Update Response = CWDirect received the status update response message from the Order Broker.

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

Alphanumeric, 25 positions.

Status

The status of the Order Broker line at the time of the activity. See Order Broker Statuses for more information.

When you cancel a brokered backorder, either by canceling the Order Broker request at the Work with Order Broker Screen or canceling the order line in order inquiry, the status of the history record is Y (Pending Cancel) rather than Z (Canceled). CWDirect does not create an additional Order Broker History record when Locate acknowledges the cancellation and the status of the Order Broker record itself changes to Z (Canceled).

Alphanumeric, 1 position.

Fulfilling location

The location where the item was assigned for fulfillment (brokered backorder, retail pickup, or delivery) at the time the activity occurred. From the store cross reference description set up through Working with Store Cross References (WSXR). For a retail pickup or delivery order, the fulfilling location is your default warehouse.

If the description exceeds 20 positions, it is truncated.

Alphanumeric, 20 positions.

Qty

The quantity of the Order Broker line at the time of the activity. The same as the ordered quantity.

Numeric, 5 positions.