Field

Description

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.

This value 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 file. See Merchandising Chapter 24: 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 file.

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

Activity

A code for a type of update against the item on the order line.

Order line history activity codes are defined in and validated against the Order Line Activity Code file; see Working with Order Line Activity Codes (WOLA).

System-Delivered Order Line Activity Codes are:

• A (Add)

• B (Express Billed)

• C (Cancel)

• D (Discount)

• E (Exchange)

• F (Future Use; not implemented)

• G (Change)

• H (Return HDL Warehouse)

• I (In Transit)

• O (Sold Out)

• R (Return)

• S (Shipment)

• V (Delivered)

• X (Sale)

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

Activity description (Unlabeled field to the right of Activity field)

The description associated with the activity code. The first 10 positions of the description displays.

System-Delivered Order Line Activity Codes are:

• Add

• Express Billed

• Cancel

• Discount

• Exchange

• Change

• Return HDL Warehouse

• In Transit

• Sold Out

• Return

• Shipment

• Delivered

• Sale

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

Date

The date when this activity occurred.

Numeric, 6 positions (MMDDYY 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.

This quantity displays 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)

A code that represents a reason for the customer to exchange one item for another.

Exchange reasons are defined in and validated against the Exchange Reasons file; see Chapter 7: Establishing Exchange Reason Codes (WEXR).

Numeric, 3 positions; display-only.

Can reason (Cancel reason code)

The reason for canceling the units. This is the Auto Soldout Cancel Reason (C20) for a line sold out through Processing Auto Soldout Cancellations (MASO); however, no cancel reason code is displayed for a line that you sell out by entering 13 next toin order entry or order maintenance.

Cancel reason codes are defined in and validated against the Cancel Reason file; see Chapter 5: Establishing Cancel Reason Codes (WCNR).

Alphanumeric, 2 positions; display-only.

Rtn reason (Return reason code)

A code that represents a reason for the customer to return an item.

Return reasons are defined in and validated against the Return Reason file; see Chapter 6: Establishing Return Reason Codes (WRTR).

Numeric, 3 positions; display-only.

Add reason (Add reason code)

A code that 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 set to Y.

• the Required reason code field for the item offer or SKU offer is set to Y.

Add reason codes are defined in and validated against the Add Reason file; see Chapter 10: Establishing Add Reason Codes (WADR).

Alphanumeric, 5 positions; display-only.

Contact date

The date the activity occurred.

For example, if the Activity is I (In Transit), this date represents the date the item on the order line is scheduled to be delivered; if the Activity is V (Delivered), this date represents the date the item on the order line was delivered to the customer.

A contact date only displays for order line activity received through the Order Line History In API.

Numeric, 7 positions (MM/DD/YY format); display-only.

Contact time

The time the activity occurred.

For example, if the Activity is I (In Transit), this time represents the time the item on the order line is scheduled to be delivered; if the Activity is V (Delivered), this time represents the time the item on the order line was delivered to the customer.

Numeric, 6 positions (HH:MM format); display-only.

User

The user ID of the person who performed this activity.

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

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

Field

Description

Order #

A unique number to identify an order.

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

Ship to #

(unlabeled field)

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

This value 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.

If the item contains SKUs, the description of the SKU displays below the item number; otherwise, the description of the item displays below the item number.

Item codes are defined in and validated against the Item file. See Merchandising Chapter 24: Performing Initial Item Entry (MITM).

Alphanumeric, 12 positions; display-only.

SKU

(unlabeled field)

The item's special characteristics, such as its size or color.

If the item contains SKUs, the description of the SKU displays below the item number; otherwise, the description of the item displays below the item number.

SKUs are defined in and validated against the SKU file.

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

Date

The date when this activity occurred.

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

Activity type

A code for a type of update against the item on the order line. The description of the activity displays to the right of the activity code.

System-Delivered Order Line Activity Codes are:

A = Add

B = Express Billed

C = Cancel

D = Discount

E = Exchange

G = Change

H = Return HDL Warehouse

I = In Transit

O = Sold Out

R = Return

S = Shipment

V = Delivered

X = Sale

Order line activity codes are defined in and validated against the Order Line Activity Code file; see Working with Order Line Activity Codes (WOLA).

Code: Alphanumeric, 2 positions; display-only.

Description: Alphanumeric, 25 positions; display-only.

Quantity

The quantity of the item affected by this activity. For example, 3- indicates that three units of the item were canceled.

This quantity displays 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)

A code that represents a reason for the customer to exchange one item for another.

Exchange reasons are defined in and validated against the Exchange Reasons file; see Chapter 7: Establishing Exchange Reason Codes (WEXR).

Numeric, 3 positions; display-only.

Can reason

(Cancel reason code)

The reason for canceling the units. This is the Auto Soldout Cancel Reason (C20) for a line sold out through Processing Auto Soldout Cancellations (MASO); however, no cancel reason code is displayed for a line that you sell out by entering 13 next toin order entry or order maintenance.

Cancel reason codes are defined in and validated against the Cancel Reason file; see Chapter 5: Establishing Cancel Reason Codes (WCNR).

Alphanumeric, 2 positions; display-only.

Rtn reason

(Return reason code)

A code that represents a reason for the customer to return an item.

Return reasons are defined in and validated against the Return Reason file; see Chapter 6: Establishing Return Reason Codes (WRTR).

Numeric, 3 positions; display-only.

Add reason

(Add reason code)

A code that 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 set to Y.

• the Required reason code field for the item offer or SKU offer is set to Y.

Add reason codes are defined in and validated against the Add Reason file; see Chapter 10: Establishing Add Reason Codes (WADR).

Alphanumeric, 5 positions; display-only.

User

The user ID of the person who performed this activity.

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

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

Contact date/time

The date and time the activity occurred.

For example, if the Activity is I (In Transit), this date and time represents the date and time the item on the order line is scheduled to be delivered; if the Activity is V (Delivered), this date and time represents the date and time the item on the order line was delivered to the customer.

A contact date and time only displays for order line activity received through the Order Line History In API.

Numeric, 7 positions (MM/DD/YY format); display-only.

Delivery provider

A code that identifies the delivery provider used to deliver the merchandise to the customer, if any. For example, this represents the HDL (Home Delivery Service) provider; see HDL (Home Delivery Service) Processing.

A delivery provider displays for:

• order line activity received through the Order Line History In API.

• order line activity H (Return HDL Warehouse); see Return HDL Warehouse (H) Order Line Activity Code.

Alphanumeric, 15 positions; display-only.

External system date

The date the order line activity was performed in the external system.

An external system date only displays for order line activity received through the Order Line History In API.

Numeric, 6 positions (MM/DD/YY format); display-only.

External reference number

A code that represents a reference number provided by an external system.

An external reference number displays when:

• order line activity is received through the Order Line History In API.

• an order line history record is created for activity V (Delivered) during return/exchange processing; in this situation, the system updates the external reference number with System Gen’ed by Retu.

• an order line history record is created for activity V (Delivered) during discount processing; in this situation, the system updates the external reference number with System Gen’ed by Disc.

• an order line history record is created for activity V (Delivered) during express bill processing; in this situation, the system updates the external reference number with System Gen’ed by Expr.

See Delivered (V) Order Line Activity Code.

Alphanumeric, 20 positions; display-only.