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 (in user date format); display-only, updated by the system.

Type

A code for a type of update against the order.

Valid values are:

• Auth (A) = Authorization received for credit card order

• Subscription (B) = Issue sent for subscription item

• Cancel (C) = Cancel through Order Maintenance

• D/S PO (D) = Drop ship purchase order

• Upsell Promo (E) = Promotion discount applied

• Refund (F) = Refund processed or changed

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

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

• BO Cards (K) = Backorder card evaluation and update to the Order Detail record. See Purchase Order Layering and Backorder Notifications for an overview. The actual generation of the backorder notice is listed under Letter.

• Letter (L) = Notification (card, email, or Outbound Email XML Message (CWEmailOut)) generated for the customer or vendor related to the order.

• Maint (M) = Maintenance through Order Maintenance. The system also uses this code when it applies a prorated discount, when activity takes place related to the Order Broker Integration, when an order is released from hold, when an order is accepted in batch order entry, or when the system posts a contribution (based on the setting of the Method for Processing Overpayments in Order Entry (D70)).

• Rtn Auth (N) = Return authorization processed

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

• Pick Gen (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.

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

• Shipment (S) = Shipment billed

• Unreserved (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 or WSVP).

• Void/Reprint (V) = Pick ticket voided through Working with Interactive Reservation (MIRV) or Reprinting and Voiding Pick Slips (WVRP or WSVP).

• Price Override (W) = Price override. The price of an item was overridden. The system does not write a price override history message here when it applies the Default Price Override Reason (B35).

• System Update (Y) = CSV removed for security or a promotion was not applied to the order because the Allow Manual Entry of Promotion Code (I63) system control value was selected.

• User Defined (Z) = The order activity was received through the Generic Order Transaction History API.

• ROL Error (2) = The system did not print a pick slip for the specified order line because the Qty remaining or Qty printed in the Reserved Order Line table does not tie correctly to the Qty reserved or Qty printed in the Order Detail table. The system also prints the order line on the Unmatched Reserved/Remaining Qty Report.

• Call Tag = Call tag printed. This option is not currently implemented.

Display-only, updated by the system.

Transaction note

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

• Authorization

• Flag for cancellation due to declined authorization

• Backorder notification evaluation and Order Detail update

• Backorder notice generated (for example. BO 1st Ntf for a first backorder notification)

• Cancel

• Cancel request for a drop ship item

• Cancel confirm or reject for a drop ship item

• CSV removed for security

• Drop ship

• Hold

• Ln#: 2 Submitted To Broker (or other activity related to the Order Broker; see Order Broker Integration for more information)

• Ord Conf to ssmith@msn.com (Order confirmation email or Outbound Email XML Message (CWEmailOut))

• Pk 1236612 Whs 1 Ct/Bn 1234734/411/1 if you performed pick slip generation and the Use Cart/Bin Picking? (B38) system control value is selected and the Bypass Creation of Pick Forms during WSPS Pick Generation (K55) system control value is unselected

• Pk 1236609 Whs 1 Batch # 1234731 if you performed pick slip generation and:

• the Use Cart/Bin Picking? (B38) system control value is unselected, or

• the Bypass Creation of Pick Forms during WSPS Pick Generation (K55) system control value is selected

• Promotion (PROMO1) not applied

• Maintenance

• Release

• Request ID: 78388 Under Review: N = Order Management System has send an order update message to Order Broker when an order including any brokered backorder items has changed from held to open. Order Management System sends these updates only if the Send Held Orders to OROB (M18) system control value is selected. If the order changed from open to held, the message indicates Under Review: Y.

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

• Shipment

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

• Sold out

• Subscription generation

• Pick not printed Ln # 001 qty mismatch

• User price override - Order line 2 Note:

- The line number in this message refers to the sequence number in the Order Detail table, which may differ from the current line number.

- The system does not write a price override history message here when it applies the Default Price Override Reason (B35).

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

• If the activity took place through a system process or an API, the user ID indicates the process, API, or your default user.

• EXTERNAL defaults for order transaction history created through the Generic Order Transaction History API.

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