Order #

A unique number to identify an order.

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

Sold to (Sold to customer name)

The name of the customer who placed the order.

Last name

The customer's last name.

Alphanumeric, 25 positions; display-only.

First name

The customer's first name.

Alphanumeric, 15 positions; display-only.

Initial

The initial of the customer's middle name.

Alphanumeric, 1 position; display-only.

Ship to (Ship to customer name)

The name of the customer to receive the order. These fields are blank if the Sold To Customer receives the order.

Last name

The customer's last name.

Alphanumeric, 25 positions; display-only.

First name

The customer's first name.

Alphanumeric, 15 positions; display-only.

Initial

The initial of the customer's middle name.

Alphanumeric, 1 position; display-only.

Date

The date when the order activity occurred.

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

Type

A code for a type of update against the order.

System delivered order history updates are:

A = Authorization received for credit card order

B = Issue sent for subscription item

C = Cancel through Order Maintenance

D = Drop ship purchase order

E = Promotion discount applied

F = Refund processed

G = Gift certificate

H = Hold through Order Maintenance or as a result of credit checking

I = Retail transaction. Used only if you use the Retail Integration (External System to CWDirect).

J = Change in gift certificate number. See Assigning Gift Certificate Numbers for an overview.

K = Backorder card. See Purchase Order Layering and Backorder Notifications for an overview.

L = Order-related email notification or Outbound Email XML Message (CWEmailOut) sent to customer.

M = Maintenance through Order Maintenance. The system also uses this code when it applies a prorated discount or logs Order Broker activity.

N = Return authorization processed

O = Order sold out automatically during Billing, based on the value in the S/O field for the Item, and a soldout notification generated.

P = Pick slip generated. The system also uses this code when an item stock allocation error occurs, or when the ship via on the order is overridden through the best way shipping option at pick slip generation. Note: The system does not create these transaction history messages if the Use Cart/Bin Picking? (B38) system control value is set to N.

R = Release through Order Maintenance, Release Held Orders program or by the system (from time hold for prepaid orders)

S = Shipment logged when pick slips generated for all order lines

T = Call tag printed. The system also uses this code when you create a call tag.

U = Interactive reservation. Indicates that an item was reserved or unreserved manually, such as through Working with Interactive Reservation (MIRV) or Reprinting and Voiding Pick Slips (WVRP).

V = Pick ticket voided and reprinted.

W = Price override. Indicates that the user entered a price override.

Y = CSV (card security value) removed for security.

Z = Reserved for user-defined order transaction history entries.

1 = Activity related to submitting an order for store fulfillment. See Merchandise Locator and Store Fulfillment API through .NET.

3 = A user changed a refund associated with the order. See Working with Refunds, Writeoffs and Balances Due (WREF).

4 = A user pressed F9 to accept an order that is part of a remote order batch. The system considers an order to be part of a remote order batch if:

• the order is included in the e-commerce order batch (this the order batch number defined in the Default Batch for E-Commerce Orders in Error (G41) system control value).

• the order is included in the retail channel order batch (this is the order batch number defined in the Batch Number for Retail Channel Orders (I78) system control value).

• the order is included in the phone order batch (this is the order batch number defined in the Batch # field in the Phone Order file).

• the order is included in the membership order batch (this is the order batch number assigned during membership order generation; see Generating Membership Orders (EGMO)).

Alphanumeric, 1 position; display-only, updated by the system.

Transaction note

The description of the activity related to the transaction, such as:

• Authorization

• B/O First (First backorder notification email or Outbound Email XML Message (CWEmailOut))

• B/O Second (Second backorder notification email or Outbound Email XML Message (CWEmailOut))

• C/C Ack (Credit card acknowledgement email or Outbound Email XML Message (CWEmailOut))

• Call tag (call tag number and detail line)

• Flag for cancellation due to declined authorization

• Cancel

• Cancel request for a drop ship item

• Cancel confirm or reject for a drop ship item

• Drop ship

• Hold

• Letter (This option is not currently supported)

• Activity related to the Order Broker, such as LN#: 00001 SUBMITTED TO BROKER. See the Order Broker Integration for background

• Maintenance

• Ord conf (Order confirmation email or Outbound Email XML Message (CWEmailOut))

• Release

• Retrn conf (Return confirmation email or Outbound Email XML Message (CWEmailOut))

• S/O Notice (Soldout notification email or Outbound Email XML Message (CWEmailOut))

• Sale

• Ship conf (Shipment confirmation email or Outbound Email XML Message (CWEmailOut))

• Shipment Confirmed for drop ship PO # XXXX (For confirmed shipment of a drop ship item, the transaction notes also include item code, meter charge, weight, ship via and description, and tracking number. For a ship via defined in CWCollaborate but not defined in CWDirect, the ship via code is indicated, but not the description.)

• Sold out

• Subscription generation

• SYS HLD---SHIP TO FRAUD (order put on hold by the system)

• Refund has been released

• Batch order changed - Ecomm.

• VIA and TRK# for an order shipped through the Brokered Backorder Integration with Locate version 5.1 or higher. This information is available to include in the shipment confirmation when you use the Outbound Email API.

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

Amount

The total order amount following the order activity, including merchandise, freight, tax, handling, etc.

No amount is associated with issuing a subscription, as the system bills the customer for the entire amount of the subscription when billing the order.

Numeric, 9 positions with a 2-place decimal; display-only, updated by the system.

User

The user ID of the person who performed this activity against the order.

If the system performs the activity automatically, such as releasing prepaid orders on time hold, the User ID is the name of the person who started the ASYNC processing program (background jobs).

The user ID is SUB_EXTR when a subscription issue is picked up by the Subscription Extract program.

The user ID is ORD_BROKER when the activity is related to the Order Broker. See the Order Broker Integration for more information.

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

Transaction note

The description of the activity related to the transaction, such as:

• Authorization

• B/O First (First backorder notification email or Outbound Email XML Message (CWEmailOut))

• B/O Second (Second backorder notification email or Outbound Email XML Message (CWEmailOut))

• C/C Ack (Credit card acknowledgement email or Outbound Email XML Message (CWEmailOut))

• Call tag (call tag number and detail line)

• Flag for cancellation due to declined authorization

• Cancel

• Cancel request for a drop ship item

• Cancel confirm or reject for a drop ship item

• Drop ship

• Hold

• Letter (This option is not currently supported)

• Activity related to the Order Broker, such as LN#: 00001 SUBMITTED TO BROKER

• Maintenance

• Ord conf (Order confirmation email or Outbound Email XML Message (CWEmailOut))

• Release

• Retrn conf (Return confirmation email or Outbound Email XML Message (CWEmailOut))

• S/O Notice (Soldout notification email or Outbound Email XML Message (CWEmailOut))

• Sale

• Ship conf (Shipment confirmation email or Outbound Email XML Message (CWEmailOut))

• Shipment Confirmed for drop ship PO # XXXX (For confirmed shipment of a drop ship item, the transaction notes also include item code, meter charge, weight, ship via and description, and tracking number. For a ship via defined in CWCollaborate but not defined in CWDirect, the ship via code is indicated, but not the description.)

• Sold out

• Subscription generation

• SYS HLD---SHIP TO FRAUD (order put on hold by the system)

• Refund has been released

• Batch order changed - Ecomm.

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

Date

The date when the order activity occurred.

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

Time

The time when the order activity occurred.

Numeric, 6 positions (HH:MM:SS format); display-only, updated by the system.