Field

Description

Batch #

The system-assigned number for a group of orders, such as orders you create through batch order entry. Orders you receive through the order API are assigned to the Default Batch for E-Commerce Orders in Error (G41) if they are in error; similarly, retail pickup or delivery orders that are in error are assigned to the Order Broker Error Batch Number (K90). The system removes the batch number when you accept the batch if the order is error-free.

Numeric, 5 positions; display-only.

Entered by

The user ID of the person or process who entered the order; otherwise, your default user.

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 Generic Order Interface (Order API) and used to identify the order in an external system. In the case of a retail pickup or delivery order assigned through the Order Broker Integration, this is the order number in the system originating the order. The system assigns a CWSerenade order number at the time it creates the order.

Alphanumeric, 35 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.

Mbr ID (Membership ID)

The code identifying the membership program that generated the order. Customers can purchase memberships in order to generate orders for selected items on a periodic basis. Blank if the order was not generated through a membership program.

The sequence number to the right of the membership ID uniquely identifies the orders generated for the same customer and membership program at the same time. For example, a customer creates a customer membership to receive coffee at his home address, and another to send coffee to a different recipient, both through the same membership program. When you generate the membership orders, the generation program assigns a sequence number of 001 to the first order and a sequence number of 002 to the second order. The sequence number is 00 if the order was not generated through a membership program.

See Membership Overview for background on membership programs, customer memberships, and membership order generation.

Mbr ID: alphanumeric, 12 positions; display-only.

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

Ship to name

The name of the customer to receive the order, including the company name, if any. In the case of a retail pickup or ship-to-store order, this is the name of the store location where the customer picks up the order; see the Order Broker Integration for an overview.

Alphanumeric, 41 positions; display-only.

Source code

The source code from the order header. Source codes are unique codes 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 total shipping weight of the items on the order, excluding soldout, cancelled, and returned items.

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

Gift

If this field is selected, this is a gift order, which means:

• item prices do not print on the pick slip.

• the system generates a gift acknowledgment to notify the sold-to customer who placed the order that the order has shipped.

E-mail gift certificate

If this field is selected, this indicates to email a gift certificate notice to the recipient, rather than printing a gift certificate, for gift certificates purchased on this order

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.

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 table. See 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 requests to receive the order. The arrival date defaults to the order date, but you can override this default.

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

Order date

The processing date for the order. Defaults to the current date, but you can override it to date-stamp orders you received on an earlier date but did not enter. However, if you change the order date to a date which falls within a closed accounting period, the following error message indicates:

Order date falls within the closed accounting period.

The order date determines which orders the system reserves first, if using Batch Reservation or running the Evaluate Backorders program.

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

Enter date

The date when the order was created.

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

Ship complete

Determines whether all the items on an order must ship together.

Valid values are:

• Selected = Ship all items on the order in one shipment; delay performing pick slip preparation and printing pick slips until all items are available in the requested quantities.

• Unselected = (default): Ship the items on the order as soon as they are reserved.

Quote Origin

If this field is selected, the order originated from a pre-order quote.

See Entering Pre-Order Quotes for an overview and the required setup.

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 you entered a priority in the B/O priority (Backorder priority) field for the source code; in this case, the header-level value 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)

Identifies whether to automatically cancel items that are unavailable (backordered) with the first shipment on the order.

Valid values are:

• Selected = Cancel backordered items with first shipment.

• Unselected = (default): Do not cancel backordered items.

If this field is selected, any unshipped line on an order is canceled during billing using the Auto Soldout Cancel Reason (C20), provided this system control value specifies a valid cancel reason code.

Freight override

Indicates the amount of a freight override, if you entered an override amount for the order.

Note: If a freight override exists, the system does not apply any additional freight, item charges, weight charges, or service charges to the order.

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

Calculate freight

Indicates whether the system will calculate and add freight charges to the order.

• Selected = Freight will be calculated.

• Unselected = Freight will not be calculated; the freight method for the source is ignored.

To change this setting for the order, use the Calculate freight field at the Work with Order Screen.

Freight tax override

The tax override amount on freight for the order ship to.

If defined, the system does not calculate tax on freight. Used only if a freight override amount is defined.

Note: You can define a tax override amount on freight only on orders received through the Generic Order Interface (Order API).

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

Freight tax rate

unlabeled field next to Freight tax override

The tax rate for the freight tax override. The system uses the following calculation to determine the freight tax rate:

(freight override amount / freight tax override) x 100 = freight tax rate

Example: If the freight override amount is 6.00 and the freight tax override amount is 3.00, the freight tax rate is 50.00.

The system uses the freight tax rate during return and cancellation processing when calculating the amount of tax on freight that should be returned or deducted during cancellation.

Numeric, 5 positions with a 2-place decimal; display-only.

Carrier #

The number of the customer's account with the carrier. When a number is present in this field, the customer doesn't pay for shipment of orders via the carrier. Instead, the carrier 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 when the payment method is accounts receivable if the PO Required for A/R Orders (D79) system control value is selected.

From the ref_transaction_no if the order is a retail pickup or delivery order received from the Order Broker. See Building the Retail Pickup or Delivery Order for more information.

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.

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)

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:

• Selected = The system prints a master pick slip for this order. If you are entering a business to business order, you selected the Master carton field on the Work with Business to Business Order screen. See Entering a Business to Business Order.

• Unselected = The system does not print a master pick slip for this order.

See Performing Pick Slip Generation, for more information on printing a master pick slip for an order.

Cancel date

The date the customer wants the order canceled if it has not been shipped. 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.

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, 123.234.123.234). 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 table, 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 table. 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 ships. A value appears in this field only if it was entered during order entry or order maintenance or was passed through the Order Broker Integration for a retail pickup or delivery order. The warehouse description is to the right.

Warehouse code: numeric, 3 positions; display-only.

Warehouse description: alphanumeric, 30 positions; display-only.

Placer

The individual within an organization that placed the order. The first 40 positions of the placer’s name fields are to the right. See Creating and Updating Individuals for background.

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

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. The first 40 positions of the originator’s name fields are to the right. See Creating and Updating Individuals for background.

Note: You can delete an individual only if the individual 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 is displayed.

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

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

Indicates whether the individual who originated or approved the order is unknown. Valid values are:

Selected = The originator is unknown.

Unselected = The originator is not unknown.

Store restock order

This field is selected if the order is a retail store restock order.

The system automatically selects this field:

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

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

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

Broker delivery type

Indicates whether the order is being fulfilled through the Order Broker Integration. Possible settings are:

• Retail pickup = The order originated in an external system and CWSerenade ships the order to the originating retail store location, where the customer picks it up

• Delivery = The order originated in an external system, and CWSerenade ships the order directly to the customer

• Ship to Store = The order originated in CWSerenade, and CWSerenade ships the order ships the order to a designated retail store location, where the customer picks it up

• Store Pickup = The order originated in CWSerenade, and the customer picks up the order in a designated retail store location where the inventory is currently available

Note: If the order includes any brokered backorder lines (in which CWSerenade assigns backordered items to the Order Broker for fulfillment), this is not indicated here.

See the Order Broker Integration for an overview.

Sales Rep Store

The store number assigned to the order.

Store numbers are defined in and validated against the Store Cross Reference table; see Work with Store Cross Reference (WSCR).

Note: The store number defined here does not have to be associated with the salesrep from the Order Header.

Included in CWEmailOut: If the order is not fulfilled through the Order Broker integration, the OriginatingStore element in the Outbound Email XML Message (CWEmailOut) specifies the sales rep store and the description and address information from its Store Cross Reference record. See the OriginatingStore element for more information.

Alphanumeric, 10 positions; display-only.