Reviewing Order-Level Properties

Purpose: In addition to reviewing detailed information, you can use Order Inquiry to review information that pertains to the overall order, including:

• Conditions that affect the order, such as ship complete, gift order, etc.
• History of order transactions
• Messages added to the order during Order Entry, Order Maintenance, or Order Inquiry

For more information: See Display Order History Screen for a discussion of the Order History option that is also available from the Order Inquiry screens, and see Work with Order Messages Screen for a discussion or working with or reviewing order messages.

Streamlined order inquiry: As an alternative to standard order inquiry, the Streamlined Order Inquiry (DORI) option provides a consolidated, one-page view of the order, including some of the order-level properties fields.

Display Order Properties Screen

Purpose: Use this screen to obtain additional information about the order. This screen displays extra fields that do not appear on the header screen. Also, this screen identifies the representative or operator who took the order and the time when the order was accepted on the system.

How to display this screen: Select Properties at the Order Inquiry Header Screen or Order Inquiry Detail Screen.

Field	Description
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. For more information see the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1). In the case of a retail pickup or delivery order assigned through the Order Orchestration Integration, this is the order number in the system originating the order. If the originating system is Order Administration, the system prefaces the originating order number with the text ORIG#:. For example: ORIG#: 9999-001, where ORIG#: indicates the order originated in Order Administration, 9999 is the original order number in Order Administration, and 001 is the ship to number. See Retail Pickup (including Ship-for-Pickup) or Delivery Orders for more information. Created in order entry: If the Alternate Order Number Prefix for Order Creation (M76) system control value specifies a prefix and the order was created in Classic View or Modern View order entry or through Generate Customer Membership Orders (EGMO), this is the specified prefix followed by the order number. The order number is zero-filled, for example, ABC00000123, where ABC is the prefix code and 123 is the order number. 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 Orchestration 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, 20 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, 13 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). For more information see the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1). Selected for orders received from Order Orchestration. See Tax on Freight (B14) for a discussion. Numeric, 13 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 Order Orchestration. Numeric, 13 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 Order Orchestration. 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. For more information see the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1). 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 Orchestration 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 Orchestration Integration. Possible settings are: Retail Pickup = The order originated in an external system and Order Administration 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 Administration ships the order directly to the customer Ship for Pickup = The order originated in Order Administration, and Order Administration 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 Administration, 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 Administration assigns backordered items to Order Orchestration for fulfillment), this is not indicated here. See the Order Orchestration 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 Orchestration 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. For more information see the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1).