Batch #

The system-assigned number for a group of orders. 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. If the originating system is Order Management System, the system prefaces the originating order number with the text ORIG#:. For example: ORIG#: 9999-001, where ORIG#: indicates the order originated in Order Management System, 9999 is the original order number in Order Management System, and 001 is the ship to number. See Retail Pickup (including Ship-for-Pickup) or Delivery Orders for more information.

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-for-pickup 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.

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 (in user date 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 (in user date format); display-only.

Enter date

The date when the order was created.

Numeric, 6 positions (in user date 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).

Selected for orders received from Oracle Retail Order Broker. See Tax on Freight (B14) for a discussion.

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.

See Tax on Freight (B14) for a discussion of how the freight tax rate is determined for orders received from Oracle Retail Order Broker.

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.

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 (including Ship-for-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.

Tax identification

The customer’s tax identification number, typically the resale or exempt certificate number assigned to a customer who is identified as tax exempt (E) or as a reseller (R); otherwise, the tax identification number does not control taxability. Any combination of letters, numbers, or special characters is accepted.

Alphanumeric, 30 positions.

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.

• 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 (in user date 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, 192.168.255.255). 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.

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 Order Management System ships the order to the originating retail store location, where the customer picks it up

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

• Ship for Pickup = The order originated in Order Management System, and Order Management System ships the order ships the order to a designated retail store location, where the customer picks it up

• Store Pickup = The order originated in Order Management System, 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 Order Management System 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.