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 against the item detail 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)

• Express Bill (B)

• Cancel (C)

• Discount (D)

• Exchange (E)

• Change (G)

• Sold Out (O)

• Return (R)

• Shipment (S)

• Sale (X)

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) for details.

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.

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.