Order #

A unique number to identify an order.

Numeric, 9 positions; display-only, assigned by the system.

Ship to number (unlabeled field)

A hyphen (-) separates this field from the Order# field.

Indicates the number of shipping addresses for the order. The system assigns a ship-to suffix of 1 to a single recipient order.

Numeric, 3 positions; display-only, assigned by the system.

Line #

The detail line number of this item on the order.

Numeric, 3 positions; display-only.

Item

A code for a unit of inventory. Item codes are defined in and validated against the Item table. See Performing Initial Item Entry (MITM).

Alphanumeric, 12 positions; display-only.

SKU (Stock keeping unit; unlabeled fields to the right of the item number)

The item's special characteristics, such as its size or color. SKUs are defined in and validated against the SKU table.

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

Activity

Indicates the type of update performed for the order line.

Order line activity codes are defined in the Order Line Activity table; see Working with Order Line Activity Codes (WOLA).

System Delivered Order Line Activity Codes are:

• Add (A): Includes adding an order line through an maintenance or exchange, or through a system process, such as Process Item Substitutions (PSUB). The quantity added is listed.

• Cancel (C): A quantity of the item on the order line is cancelled during order maintenance or through a system process, such as Process Item Substitutions (PSUB). This includes canceling using a cancel reason code not flagged to reduce demand. The quantity canceled is displayed as a negative number.

• Change (G): Changes to the order line, including:

- increasing the quantity. An increase in quantity is displayed as a positive number.

- decreasing the quantity when the cancel reason code used had the Reduce demand flag selected, regardless of whether you used the Cancel or Change option. A canceled quantity is displayed as a negative number, and the cancel reason code is listed. Canceling a partial quantity with a cancel reason code that had the Reduce demand flag unselected creates an Item Partially Cancelled entry, described below.

- changing the price or other information for the order line. When the change does not affect the quantity, no quantity is displayed.

• Discount (D): A discount was applied to the order line after shipment. The quantity of the item discounted is displayed.

• Exchange (E): The exchanged quantity is displayed as a positive number. The exchange reason code description is also displayed.

• Express Bill (B): The quantity express billed and the ID of the user who started the async jobs are indicated.

• Item Hold (J): The order line was put on hold. The open quantity on the line when it is held is displayed.

• Item Partially Cancelled (#): A partial quantity was canceled, either through the Cancel option or through the Change option, if the cancel reason code’s Reduce demand flag was unselected. A partial cancel can also occur when a partial quantity of the line was shipped, and then the remaining quantity or the entire order was canceled. The quantity canceled is displayed as a negative number, and the cancel reason code is also listed.

Note: If the cancel reason code had the Reduce demand flag selected, the activity is listed as a Change rather than as Item Partially Cancelled.

• Item Partially Shipped (P): A partial quantity of the item was shipped. The quantity shipped and the ID of the user who started the async jobs are indicated.

• Item Released from Hold (+): The line was released from held status. The quantity on the order line when it was released is indicated.

• Item Unreserved (9): The item was unreserved through Work with Void/Reprint Picks, Interactive Reservation, or the PickIn message. When the line is unreserved through the PickIn message, the default user ID is displayed. This record is not created through the Void Pick Batch option. The unreserved quantity is displayed as a negative number.

• Order Line Message Added (8): An order line message was added. The order line quantity when the order line message was added is displayed. A single order line history entry is created each time you accept your entries, regardless of whether you create a single order line message or multiple message lines.

• Return (R): Displays the quantity returned as a negative number.

• Shipment (S): Displays the quantity shipped. Also, the user ID displayed is for the user who started the async jobs.

• Sold Out (O): When an item sells out automatically in order entry or creation, the quantity displayed is a positive number. If the item was sold out through Sell Out, the quantity is negative and the name of the user who sold out the item is listed. When an item sells out through Process Auto Soldouts, the quantity displayed is negative; also, in this case, the user ID displayed is for the user who submitted Process Auto Soldouts.

Display-only, updated by the system.

Date

The date when this activity occurred.

Numeric, 6 positions (in user date format); display-only, updated by the system.

Quantity

The quantity of the item affected by this activity. For example, 3- indicates that three units of the item were canceled. Activities that do not affect the order quantity, such as changing the pricing of the order line, do not display a quantity here.

This quantity is displayed differently depending on how the item was sold out; see Processing Auto Soldout Cancellations (MASO). Also, see each individual Activity, above, for more information.

Numeric, 5 positions; display-only, updated by the system.

Exc reason (Exchange reason code)

Represents a reason for the customer to exchange one item for another.

Exchange reasons are defined in and validated against the Exchange Reasons table; see Establishing Exchange Reason Codes (WEXR).

Numeric, 3 positions; display-only.

Can reason (Cancel reason code)

The reason for canceling the units or reducing the quantity. A cancel reason code is not stored for soldout cancellations, whether you sell out the item by selecting Sold-out in order entry or order maintenance, or through Processing Auto Soldout Cancellations (MASO); however, the Auto Soldout Cancel Reason (C20) is displayed here if a backordered line was canceled at billing because the Canc B/O (Automatically cancel backorders) flag for the order was selected.

Cancel reason codes are defined in and validated against the Cancel Reason table; see Establishing Cancel Reason Codes (WCNR).

Numeric, 2 positions; display-only.

Rtn reason (Return reason code)

Represents a reason for the customer to return an item.

Return reasons are defined in and validated against the Return Reason table; see Establishing Return Reason Codes (WRTR).

Numeric, 3 positions; display-only.

Add reason (Add reason code)

Represents a reason for adding an item to the order. The system requires an add reason code if:

• the Require Reason for Lines Added in Order Maintenance (D75) system control value is selected, or

• the Required reason code field for the item offer or SKU offer is selected.

Add reason codes are defined in and validated against the Add Reason table; see Establishing Add Reason Codes (WADR).

Alphanumeric, 5 positions; display-only.

User

The user ID of the person who performed this activity. Your default user ID defaults for some activities. In most cases, the ID of the user who maintained the order is displayed; however, activities that show the ID of the user who started the async jobs are indicated in the description of the Activity, above.

The user ID does not display if you sell out an item through Processing Auto Soldout Cancellations (MASO) rather than order entry or order maintenance.

Alphanumeric, 10 positions; display-only, updated by the system.