Field

Description

Batch #

The system-assigned number for a group of orders.

Numeric, 5 positions; display-only.

Entered by

The user ID of the person who entered the order. For orders that you create through an interface, this field indicates the source of the information. For example, for orders you process through the E-Commerce Interface, this appears as E-COMMERCE.

Alphanumeric, 10 positions; display-only.

Time

The time of day the order was originally entered.

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

Order #

A unique number assigned by the system to identify an order. The order ship-to number is separated from the order number by a hyphen.

Order number: numeric, 8 positions; display-only.

Ship-to number: numeric, 3 positions; display-only.

Alt ord

The order number, if any, that was passed through the E-Commerce Interface. The system assigns a CWDirect order number at the time it creates the order.

Alphanumeric, 30 positions; display-only.

Sold to name

The name of the customer who placed the order, including the company name, if any.

Alphanumeric, 41 positions; display-only.

Ship to name

The name of the customer to receive the order, including the company name, if any.

Alphanumeric, 41 positions; display-only.

Source code

The source code from the order header. Source codes are unique code used to identify segments of your customer base or a rented list. Each source code is assigned to one offer and one division. Source codes control the freight and pricing method used on an order.

Alphanumeric, 7 positions; display-only.

Weight

The shipping weight of the items on the order.

Numeric, 7 positions with a 3-place decimal; display-only.

Gift

A code that identifies whether the order is a gift order. If the order is a gift:

• item prices do not print on the pick slip

• the system generates a gift acknowledgment card to notify the sold-to customer who placed the order that the order has been shipped if the buyer is not eligible to receive a shipment confirmation email; see Automatic Generation of Gift Acknowledgement (B92) for more information

• a SmartLabel does not print on the pick slip if you use SmartLabel returns processing; see Using SmartLabel Returns Processing

Valid values are:

Y = This is a gift order.

N = This is not a gift order.

Alphanumeric, 1 position; display-only.

E-mail gift certificate

This value indicates whether to email a gift certificate notice to the recipient, rather than printing a gift certificate, if the customer purchases a gift certificate on the order. Valid values are:

Y = Email the gift certificate.

N (or blank) = Print the gift certificate.

The system generates an email gift certificate only if the customer orders one, if there is an email specified for the recipient, and if the Gift Certificate E-Mail Program (H07) system control value specifies a valid email program; see that system control value for more information.

Alphanumeric, 1 position; display-only.

Ship via

A code for the shipper. A different ship via may also exist at the item level.

Ship via codes are defined in and validated against the Ship Via file. See Fulfillment Chapter 30: Working with Ship Via Codes (WVIA).

Numeric, 2 positions; display-only.

Ship via description (Unlabeled field to the right of the ship via field)

The description of the shipper.

Alphanumeric, 30 positions; display-only.

Arrival date

The date the customer requested to receive the order. Arrival date is the same as the order date on a new order, unless changed in Order Entry or Order Maintenance, at either the order or item level.

Numeric, 6 positions (MMDDYY format); display-only.

Ship complete

A code that determines whether all the items on an order must ship together.

Valid values are:

Y = Ship all items on the order in one shipment; delay printing pick slips until all items are available in the requested quantities.

N = (default): Items on the order ship as soon as they are reserved.

The system assigns a coordinate group to items on a ship complete order (this field is set to Y), based upon each item's arrival date if the Generate Coordinate Groups at Pick Gen for Ship Complete Orders (E10) system control value is set to Y. The system overrides any coordinate groups you assigned to items before you generated pick slips and assigns a new coordinate group based upon arrival date; each item with the same arrival date receives the same coordinate group code. See Fulfillment Chapter 2: Reviewing Other Reservation Conditions.

Alphanumeric, 1 position; display-only.

Broker delivery type

Indicates the type of order assigned for fulfillment through the Order Broker. Valid values are:

• D Delivery = The order ships to the customer

• R Retail Pickup = The order ships to the originating store location, where the customer picks it up

This field is included only for retail pickup or delivery orders. See Fulfilling Retail Pickup and Delivery Orders in CWDirect for background.

Alphanumeric, 17 positions; display-only.

B/O priority (Backorder priority)

A code that determines the priority for order fulfillment on a backordered item. A value defaults to this field if a priority was entered in the B/O priority (Backorder priority) field for the source code; and the header-level value, in turn, defaults to the Priority field on the order detail line.

Priority codes range from 0-9, where:

0 = Low priority.

9 = High priority.

Numeric, 1 position; display-only.

Cancel BO (Cancel backorder)

A code that identifies whether items that are unavailable (backordered) should be canceled automatically with the first shipment on the order.

Valid values are:

Y = Cancel backordered items with first shipment.

N = (default): do not cancel backordered items.

Alphanumeric, 1 position; display-only.

Freight override

A code that indicates whether the freight charges on the order were overridden in Order Entry or Order Maintenance.

Valid values are:

Y = The freight charge was overridden.

N = (default): The freight charge was not overridden.

Alphanumeric, 1 position; display-only.

Federal express #

The number of the customer's account with Federal Express. This feature is not yet implemented. When it is implemented, and when a number is present in this field, the customer doesn't pay for shipment of orders via Federal Express. Instead, Federal Express receives the bill for shipment.

Alphanumeric, 10 positions; display-only.

Purchase order

The purchase order number under which the order was placed. A purchase order number is required if paying for the order on account (A/R payment type) if the PO Required for A/R Orders (D79) system control value is set to Y.

Retail pickup or delivery order: The purchase order number, if any, for a retail pickup or delivery order is from the ref_transaction_no passed for the order from the Order Broker. See Fulfilling Retail Pickup and Delivery Orders in CWDirect for background.

Alphanumeric, 15 positions; display-only.

Tax code

The code and description of the tax status on the order. Valid values are:

T (Standard tax): The customer is subject to all applicable state sales tax on merchandise.

N (Non taxable): The customer is not taxed on purchases.

R (Resale): The customer purchases goods for resale, and is, therefore, exempt from tax. A valid resale number must exist in the customer record or be entered during Order Entry.

E (Exempt): The customer is a school, or charity, and, therefore, is exempt from tax. A valid tax exempt number must exist in the customer record or be entered during Order Entry.

G (GST only): The customer is subject to the Canadian Goods and Services Tax (GST) because the order is shipping to a Canadian province.

P (PST only): The customer is subject to the Canadian Provincial Services Tax (PST), but exempt from the GST.

See Working with Customer Tax Status for more information.

Alphanumeric, 1 position; display-only.

Resale/Exempt

The number of the certificate that identifies the customer as a reseller or tax exempt. This number is required when the customer's tax code equals R (Reseller) or E (Exempt).

Alphanumeric, 15 positions; display-only.

Master label (Master carton label)

This field indicates whether the system prints a master pick slip for this order. The master pick slip displays the sold to customer's name and address and the order totals across all ship to customers on the order.

Valid values are:

Y = The system prints a master pick slip for this order. If you are entering a business to business order, you set the Master carton field on the Work with Business to Business Order screen to Y. See Order Entry Chapter 39: Entering a Business to Business Order.

N or blank = The system does not print a master pick slip for this order.

See Fulfillment Chapter 4: Introducing Pick Slip Generation, for more information on printing a master pick slip for an order.

Alphanumeric, 1 position; display-only.

Cancel date

The date the customer wants the order canceled if it has not been shipped. The system stops trying to reserve merchandise for this order a predefined number of days before the cancel date. The order is not canceled automatically, but is listed on the Order Cancellation List. You can cancel the order manually or contact the customer to extend the deadline.

Numeric, 6 positions (MMDDYY format); display-only.

IP address

The ip_addr, if any, in the Inbound Order XML Message (CWORDERIN) for an order received through the generic order API, or in the CWCreateOrder message for an order created through the e-commerce interface.

IP address validation: If the IP address received was invalid, the system writes an Order Transaction History message such as INVALID IP ADDRESS: 1.2.3 where 1.2.3 represents the invalid IP address received, and does not update this field. The IP address is made up of a series of four numbers separated by three periods (for example, 12.34.234.8). Each number between the periods must be from 1 to 255. The IP address must:

• not include any non-numeric characters besides the periods

• not include any blank spaces

• start with and end with a numeral

• include all three periods

• include all four numbers, each from 1 to 255

Fraud checking: If the IP address received matches an entry in the Miscellaneous Fraud file, the system puts the order on IP (IP address) hold and writes a message reading SYS HLD---IP ADDRESS HOLD to the Order Transaction History file. See Working with Miscellaneous Frauds (WMFF) for more information on IP addresses and fraud checking.

Alphanumeric, 15 positions; display-only.

Warehouse

A code that identifies the warehouse from which merchandise on the order will be shipped. A value appears in this field only if it was entered by an operator during order entry or order maintenance.

Numeric, 3 positions; display-only.

Placer

The individual within an organization that placed the order. See Chapter 38: Creating and Updating Individuals.

Placer number: numeric, 3 positions; display-only.

The first 40 positions of the following 3 name fields display:

Placer first name: alphanumeric, 15 positions; display-only.

Placer middle initial: alphanumeric, 1 position; display-only.

Placer last name: alphanumeric, 25 positions; display-only.

Originator

The individual within an organization who originated or approved the order. See the Placer field.

Note: The system allows you to delete an individual who has not placed an order. If you have deleted the individual who was identified as the originator on an order from your system since the order was entered, the originator number but not the name will display.

Originator number: numeric, 3 positions; display-only.

The first 40 positions of the following 3 name fields display:

Originator first name: alphanumeric, 15 positions; display-only.

Originator middle initial: alphanumeric, 1 position; display-only.

Originator last name: alphanumeric, 25 positions; display-only.

Originator unknown

This value indicates whether the individual who originated or approved the order is unknown. Valid values are:

Y = The originator is unknown.

N = The originator is not unknown.

Alphanumeric, 1 position; display-only.

Store restock order

This value indicates whether the order is a retail store restock order.

The system automatically sets this field to Y:

• when you create a retail store restock order in Working with Retail Store Restock (WRSR)

• if the customer sold-to has a Warehouse and the order type matches the Default Order Type for Store Restock Orders (G23)

Valid values are:

Y = This is a store restock order.

N or blank = This is not a store restock order.

See Understanding Store Restock for more information on retail store restock orders.

Alphanumeric, 1 position; display-only.