Streamlined Order Inquiry (DORI)
Note:
Classic View Order Entry and Maintenance Screens (OIOM, OEOM, DORI) have been deprecated. Please work with orders in Modern View through the Order Entry option (CCOE).Purpose: Streamlined order inquiry provides a one-screen snapshot of an order for efficient order inquiry. This option includes a subset of the information available through standard order inquiry, so that you can quickly answer the most frequently asked questions about an order.
When would you use standard order inquiry? You might use standard rather than streamlined order inquiry if you need:
- additional search options (for example, search by customer number, order type, or purchase order number)
- more extensive information related to the customer, order, invoices, payment methods, and items (for example, order detail pricing methods, additional charge codes applied, customer warranty information, pick slips, customer action notes, subscriptions, price override reasons, or deferred billing information)
- the ability to advance to order maintenance and maintain or cancel the order
Standard order inquiry is the default: When you select Order Inquiry within another menu option, you advance to standard order inquiry.
Modern View option: You can also review and work with orders through Modern View.
In this topic:
- First Streamlined Order Inquiry Screen (Find Order or Customer)
- Second Streamlined Order Inquiry Screen (Search Results)
- Third Streamlined Order Inquiry Screen (Order Summary)
- Pop-Up Windows
First Streamlined Order Inquiry Screen (Find Order or Customer)
Purpose: Use this screen to select an order for inquiry, or to search for an order based on information you know about the customer or the order.
How to display this screen: Enter DORI in the Fast path field at the top of any menu, or select Streamlined Order Inquiry from a menu.
Field | Description |
---|---|
Enter Order | |
Order # |
Enter a valid order number (without including the ship-to number) to advance directly to the Third Streamlined Order Inquiry Screen (Order Summary), displaying information on that order. No ship-to number: You cannot search on the ship-to number, just the order number. For example, enter 1234 rather than 1234-1. Multiple ship-tos? If the order number you enter has multiple recipients, you cannot advance directly to one of these ship-tos. For example, if order 1234 has three ship-tos (1234-1, 1234-2, and 1234-3), to review the third ship-to:
If the order number you enter is invalid, you need to enter other search criteria in order to review the order. Cannot combine: You cannot use the order number together with other criteria to search. Order number: numeric, 8 positions. |
or Find Customer |
Enter information about the sold-to customer to display the Customer Results Fields (Select Customer from List Below) so you can identify the customer who placed the order. After you use the Customer Results Fields (Select Customer from List Below) to select the customer, you can then use the Order Results Fields to select a particular order for inquiry. More than 100 matches? If there are more than 100 customers that match your search criteria, the Customer Results Fields (Select Customer from List Below) display just the first 100. In this situation, you need to further refine your search criteria to make sure that the correct customer is included in the search results. Note: Ghost customers are omitted from the search results. |
Postal code |
Enter a full or partial postal or zip code to display customers whose postal codes begin with your entry. Can combine: You can use the Postal code in combination with the Last name or Company name to search for customers. Sort order for search results: When you search based on Postal code, the Customer Results Fields (Select Customer from List Below) are initially sorted in ascending order by postal code (lowest postal code first). Within a postal code, results are sorted in ascending order by customer number. Alphanumeric, 10 positions. |
Last name |
Enter a full or partial last name to display customers whose last names begin with your entry. Note: If a customer record that matches your entry also has a company name specified, the company name is listed before the last name in the search results.Can combine: You can use the Last name in combination with the Postal code or Company name to search for customers. Sort order for search results: When you search based on Last name, the Customer Results Fields (Select Customer from List Below) lists customers as follows:
The screen does not use any other fields, such as middle initial or company name, when sorting customers by name. Alphanumeric, 25 positions. |
Company name |
Enter a full or partial company name to display customers whose company names begin with your entry. Can combine: You can use the Company name in combination with the Last name or Postal code to search for customers. Sort order for search results: When you search based on Company name, the Customer Results Fields (Select Customer from List Below) are initially sorted in ascending alphabetical order by company name. If more than one customer has the same company name, results are sorted in ascending order by customer number. Alphanumeric, 30 positions. |
Phone number |
Enter a full phone number to display customers with that day, evening, or third (fax or mobile) phone number.
Cannot combine: You cannot use phone number together with other criteria to search. Sort order for search results: If more than one customer has a matching phone number, the Customer Results Fields (Select Customer from List Below) are sorted in ascending order by customer number. Alphanumeric, 14 positions. |
Email address |
Enter a full or partial email address to display customers with a matching record in the Customer Sold To Email table.
The Customer Results Fields (Select Customer from List Below) list customers matching your entry in numeric order by customer number. Cannot combine: You cannot use the email address together with other criteria to search. Sort order for search results: If more than one customer has a matching email address, the Customer Results Fields (Select Customer from List Below) are initially sorted in numeric order by customer number. Alphanumeric, 50 positions. |
or Find Order |
Cannot combine: You cannot combine any of the following criteria to search. More than 100 matches? If there are more than 100 orders that match your search criteria, the Order Results Fields display just the first 100. In this situation, you need to further refine your search criteria to make sure that the correct order is included in the search results. |
Customer # |
Enter a valid sold-to customer number to display orders placed by that customer. Sort order for search results: The Order Results Fields list orders placed by the customer in ascending order by order number (most recent first). Numeric, 9 positions. |
Web order # |
Enter a valid web order number to display orders whose E-Commerce order number in the Order Header Extended table matches your entry. In the case of a retail pickup or delivery order assigned through the Order Orchestration Integration, the web order number is the order number in the system originating the order. If the originating system is Order Administration, the system prefaces this 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. Important: Searching by a partial web order number is not supported. If you wish to review a retail pickup or delivery order whose originating system is Order Administration, you must enter ORIG#: 9999-001, where 9999 is the order number and 001 is the ship to number. Sort order for search results: If there is more than one order with the specified alternate order number, the Order Results Fieldslist matching orders in reverse chronological sequence (most recent orders first). Alphanumeric, 35 positions. |
Order date |
Enter or select an order date to display orders matching your entry. The order date might differ from the entered date for an order if, for example, you did not create the order on the system the same day it was received, and wanted to back-date the order so it would receive appropriate priority for reservation and backorder purposes. Sort order for search results: The Order Results Fieldslist orders for the specified date in reverse chronological sequence (most recent orders first). Numeric, 6 positions (in user date format). |
User |
Select the user ID of the person or process that entered or created the order. Sort order for search results: The Order Results Fields list matching orders in reverse chronological sequence (most recent orders first). |
Option | Procedure |
---|---|
Search for customers or orders |
Use the fields described above to search for a sold-to customer or for a particular order, and click Search to display the Customer Results Fields (Select Customer from List Below) or the Order Results Fields. |
Clear data from the screen |
Select Clear to clear your search criteria and previous search results from the screen. Note: If you have removed any columns from the results as described under Sort and Expand Column Options, the deleted columns remain hidden when you search based on new results. |
Second Streamlined Order Inquiry Screen (Search Results)
Purpose: Use this screen to review the results of your search from the First Streamlined Order Inquiry Screen (Find Order or Customer). From the:
- Customer Results Fields (Select Customer from List Below): Select a customer to display the Order Results Fields.
- Order Results Fields: Select an order to advance to the Third Streamlined Order Inquiry Screen (Order Summary).
Field and sort options are described below:
- Customer Results Fields (Select Customer from List Below)
- Order Results Fields
- Sort and Expand Column Options
Maximum 100 results: Search results are limited to the first 100 matching customers or orders, based on your search criteria. For example, if your search results display orders in descending sequence by order number, only the 100 most recent orders are displayed. To see additional customers or orders, you must use different search criteria.
How to display this screen: Complete any of the fields under or Find Customer or or Find Order and click Search.
Customer Results Fields (Select Customer from List Below)
Customer-related search results are described below. The screen displays these results when your search was based on the criteria available under or Find Customer.
Select a customer: You can click a customer number to display the Order Results Fields for that customer, and then select an order.
Field | Description |
---|---|
Customer # |
The number identifying a sold-to customer who matches the search criteria you entered under or Find Customer. Click the customer number to display the Order Results Fields for that customer. Numeric, 9 positions. |
Name |
The customer’s:
Company name: alphanumeric, 30 positions. Last name: alphanumeric, 25 positions. First name: alphanumeric, 15 positions. Middle initial: alphanumeric, 1 position. |
Address |
The first line of the customer’s street address. Alphanumeric, 32 positions. |
City |
The customer’s city. Alphanumeric, 25 positions. |
State |
The customer’s state. Alphanumeric, 2 positions. |
Postal code |
The customer’s postal or zip code. Alphanumeric, 10 positions. |
Order Results Fields
Order-related search results are described below. The screen displays these results when your search was based on the criteria available under or Find Order, or when you select a customer from the Customer Results Fields (Select Customer from List Below).
Note:
The order results fields do not display orders if the selected customer was the order recipient.Select order: You can click an order number to advance to the Third Streamlined Order Inquiry Screen (Order Summary).
If no orders displayed: You can click Search again without clearing your search criteria in order to re-display the same list of customers from your previous search and select a different customer.
Group option: The group option is available for the following fields. See Sort and Expand Column Options for more information.
Field | Description |
---|---|
Order # |
The number identifying an order that matches the search criteria you entered under or Find Order. Click the order number to display the Third Streamlined Order Inquiry Screen (Order Summary) for that order. Numeric, 8 positions. |
Status |
The order status. Possible statuses are:
Header and Ship To status different? If the status for the Order Header is different from the status for the Order Ship To, the Order Ship To status is displayed, unless:
|
Date |
The order date. This date might differ from the entered date if, for example, you did not create the order on the system the same day it was received, and wanted to back-date the order so it would receive appropriate priority for reservation and backorder purposes. Numeric, 6 positions; in user date format. |
Customer |
The sold to customer’s:
Company name: alphanumeric, 30 positions. Last name: alphanumeric, 25 positions. First name: alphanumeric, 15 positions. Middle initial: alphanumeric, 1 position. |
Recipient |
The order recipient’s:
The recipient can be a one-time shipping address; a permanent shipping address; a different sold-to customer; or the sold-to customer’s own address. Company name: alphanumeric, 30 positions. Last name: alphanumeric, 25 positions. First name: alphanumeric, 15 positions. Middle initial: alphanumeric, 1 position. |
Sort and Expand Column Options
Default sort: The initial sort of the search results is based on the search criteria you entered at the First Streamlined Order Inquiry Screen (Find Order or Customer). See the field descriptions (under or Find Customer and or Find Order) for more information.
Displaying more than the first 100 results: Regardless of how you sort or group the information in the search results, the screen does not display any records that are not among the first 100 results based on your search criteria. For example, if your search criteria display orders in descending sequence by order number, only the 100 most recent orders are displayed. To see additional customers or orders, you must use different search criteria.
Options:
Sorting by a Column
Click the column name to sort the displayed search results by the information in that column in either ascending or descending order.
For example, click the Order # column to sort the search results by order number.
If the search results are currently sorted in ascending order (for example, by date), the arrow points up:
If the search results are currently sorted in descending order (for example, by date), the arrow points down:
Expanding a Column
To expand a column so that you can see more information, position your cursor on the border between the column you want to expand and the column to its right until you see a double-pointed arrow; then drag the arrow to the right.
Third Streamlined Order Inquiry Screen (Order Summary)
Purpose:
Note:
Depending on the user’s authority to credit card information, the system may write a record to the Credit Card Audit table when this screen is displayed. See Logging Credit Card Data Access in the Data Security Guide on My Oracle Support (2953017.1) for more information.How to display this screen: Select an order from the Order Results Fields.
Screen Header
This area of the Third Streamlined Order Inquiry Screen (Order Summary) screen includes:
Field | Description |
---|---|
Order summary information |
Key information to briefly identify the order is in the upper left corner of the Third Streamlined Order Inquiry Screen (Order Summary) screen. |
Order # |
A unique number the system assigns to identify a quote or order. The ship-to number follows the order number, separated by a hyphen; this number identifies each separate shipping address for the order. Order: numeric, 8 positions. Ship-to: numeric, 3 positions. |
Date |
The order date. This date might differ from the entered date if, for example, you did not create the order on the system the same day it was received, and wanted to back-date the order so it would receive appropriate priority for reservation and backorder purposes. Numeric, 6 positions; in user date format. |
Status |
The order ship-to status. Possible statuses are:
Header and Ship To status different? If the status for the Order Header is different from the status for the Order Ship To, the Order Ship To status is displayed, unless:
|
Ship via |
The code for the shipper who delivers the merchandise to your customer. The description of the ship via is to the right. Ship via codes are defined in and validated against the Ship Via table. See Working with Ship Via Codes (WVIA). Ship via: numeric, 2 positions. Description: alphanumeric, 30 positions. |
Order type |
A code that identifies how the quote or order was received, such as by phone or through the order API. You can also use the order type to identify special kinds of orders, such as those you generate as part of a membership program. Order types are defined in and validated against the Order Type table. See Establishing Order Types (WOTY). Alphanumeric, 1 position. |
Entered by user |
The user ID of the person or process who entered the order. Alphanumeric, 10 positions; display-only. |
Web order # |
The order number, if any, defined in the E-Commerce order number field in the Order Header Extended table. This is the web order 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.
See Retail Pickup (including Ship-for-Pickup) or Delivery Orders for more information. Alphanumeric, 30 positions. |
Order totals |
The totals for the Order Ship To are in the center top of the Third Streamlined Order Inquiry Screen (Order Summary) screen, to the left of the Navigation options and to the right of the Order summary information. |
Merchandise |
The total value of the items on the quote or order, excluding freight, additional charges, service charges, tax (but including hidden tax if the order is subject to VAT), handling, and duty. The merchandise total does not include items that are canceled, sold out, or returned. Note: If you create a return by entering an order for a negative quantity, the merchandise total and the other totals are negative amounts.Numeric, 20 positions with a 2-place decimal. |
Tax |
The total sales tax for the quote or order, based on the value of the merchandise and, optionally, freight and special handling charges. If the order is subject to VAT, tax is generally included in the item price rather than in the Tax field. Use standard order inquiry to review the hidden tax for order lines. Numeric, 20 positions with a 2-place decimal. |
Freight |
The total charge for shipping the quote or order, not including additional freight charges. You can define additional freight charges for a carrier to include standard freight; in this case, the freight charges are 0.00. This field also includes service charges by ship via, if any, or order weight charges based on the ship via defined for each ship to customer on the order. See Working with Ship Via Codes (WVIA). The system calculates freight charges based on the freight method defined for the source code. If the system calculates freight as a percentage of the merchandise charges, there might be a penny variation in total freight amount due to rounding differences. Numeric, 20 positions with a 2-place decimal. |
Add’l freight |
The total dollar amount for freight charges, in addition to the base freight charge for the quote or order. Additional freight charges are defined in the Ship Via table. Examples of additional freight charges are overnight shipping or second day delivery. The Add'l freight field here corresponds to the Frt+ field in Order Entry. Numeric, 20 positions with a 2-place decimal. |
Handling |
The cost of any special handling on the quote or order, such as personalizing, monogramming, or engraving, and any gift wrapping charges. If there are any duty charges on the order, they are included in the Handling total. See Work with Duty Rates Screen. You can review the special handling instructions and charges for items at the Order Detail Window. Numeric, 20 positions with a 2-place decimal. |
Add’l charge |
This field can include charges or credits. Additional charges might include: Additional source code chargeAn additional charge for services that apply to the source code or offer. The system applies the additional charge to the quote or order based on the total dollar value of the merchandise. CreditsA credit you apply to the customer's order, such as reimbursement for long distance telephone charges or a promotion discount that is not applied to the merchandise, freight charges, or additional freight charges. Additional shipper/item chargeAn additional charge that applies to the item based on the shipper. Such charges might apply when the item exceeds established shipping rates, such as for oversized items. Dollar discountsA credit applied based on the total dollar value of the merchandise. You can define dollar discounts by source code or offer. If the Prorate Dollar Discounts and Coupons (D90) system control value is selected, the dollar discounts are applied to the detail lines on the quote or order rather than appearing as a negative additional charge. The Add'l charges field displayed here corresponds to the Chg field in Order Entry. Numeric, 13 positions with a 2-place decimal. |
Total |
The total amount the customer owes for the quote or order, including:
The total does not include charges for canceled, returned or sold out items. Numeric, 20 positions with a 2-place decimal. |
Discount |
The total discount applied to the order shipping address. The total discount is calculated by comparing the selling price of merchandise with the item/SKU offer price. If you use a price override on any of the detail lines:
Note: The setting of the Override item offer price field has no effect on orders you receive through the e-commerce interface. If there is a price override reason code in the new order message, the system always processes these orders as if the field is unselected.See Overriding the Item/SKU Offer Price for an overview of the Override item offer price field. Note: This field is not included if the Display Discount on Order Recap Screen (D38) system control value is unselected or if no discount applies to the order.Any dollar discounts by source code or offer appear as a negative additional charge if the Prorate Dollar Discounts and Coupons (D90) system control value is selected. Numeric, 20 positions with a 2-place decimal. |
Shipment tracking |
Information on each order shipment is below the Order summary information. This information is from the Manifest Upload Audit table, and is not available if the order was shipped as a brokered backorder through integration with Order Orchestration. The screen displays a maximum of 20 shipments. |
Ship via |
The description of the ship via used for the shipment. Ship via: numeric, 2 positions. Description: alphanumeric, 30 positions. |
Tracking number |
The shipping tracking number, as reported through the Generic Pick In API (Shipments, Voids, and Backorders), or through Manually Confirming Shipments (MCON). For more information see the Web Services Guide on My Oracle Support (ID 2953017.1). Live link? The tracking number is a live link:
Shipment tracking is disable for company 123 Unable to construct shipment tracking URL for order 456 Where 123 is the company number and 456 is the order number. Error displayed: Also, if the tracking URL is not defined, when you click on the tracking number link at the screens mentioned above, an error window indicates: Tracking information not available. Check Narvar Order Error Export screen for failures. However, a Narvar Order Error Export record is not created because the tracking number link could not be created correctly if there are no other issues with the order request to Narvar. Alphanumeric, 30 positions. |
Date and time shipped |
The date and time when the package was scanned for shipment, as reported through the Generic Pick In API (Shipments, Voids, and Backorders), or through Manually Confirming Shipments (MCON). For more information see the Web Services Guide on My Oracle Support (ID 2953017.1). Date: numeric, 6 positions; in user date format. Time: numeric, 6 positions (HH:MM:SS format). |
Option | Procedure |
---|---|
Review order history |
Select History to open the History Window. Note: This option is available only if there is at least one Order Transaction History message on the order. |
Review or enter order messages |
Select Messages to open the Order Messages Window. The word Messages is blue if there are already any messages on the order. |
Advance to order maintenance |
Select Maintain to advance to the Work with Order Screen in Order Maintenance. Authority:
Note: When you return to Streamlined Order Inquiry (DORI) from Order Maintenance, the system displays the First Streamlined Order Inquiry Screen (Find Order or Customer) before displaying the information for the order you just maintained. Do not select any options until the system displays the order you maintained; any updates you made in Order Maintenance will be reflected on the Third Streamlined Order Inquiry Screen (Order Summary). |
Review loyalty account information for a customer that is registered in the Oracle Retail Customer Engagement Loyalty program |
Select Loyalty. When you select this option, the system retrieves the sold to customer’s information from Oracle Retail Customer Engagement.
Note: This option displays only if the Use ORCE Loyalty (M06) system control value is selected and a Relate ID is defined for the sold to customer in the Customer Sold To table; see Customer Engagement Loyalty Integration. |
Review the customer’s purchase history from Oracle Retail Customer Engagement |
Select Purch Hist. When you select this option, the system retrieves the sold to customer’s information from Oracle Retail Customer Engagement and advances you to the Display Purchase History Screen where you can review the completed sales and returns transactions from Oracle Retail Customer Engagement. If a connection could not be made to Oracle Retail Customer Engagement, the system displays an error message similar to the following: Unable to connect to ORCE. Note: This option displays only if the ORCE Customer Integration (L37) system control value is set to INTERACT; see Customer Engagement Purchase History Integration. |
Return to your search results |
Select Exit to return to the Second Streamlined Order Inquiry Screen (Search Results). |
Review order properties |
Select Properties or scroll down to display the Properties area. |
Review payment information |
Select Payment or scroll down to display the Payment area. Note: This option is displayed even if there are no payment methods on the order. |
Review invoices |
Select Invoices or scroll down to display the Invoices area. Note: This option is available only if there is at least one Invoice for the order. |
Review carton contents |
Select Carton Contents or scroll down to display the Carton Contents area. Note: This option is available only if there is at least one Carton Contents record for the order. |
Review refunds |
Select Refunds or scroll down to display the Refunds area. Note: This option is available only if there is at least one refund record for the order. |
Products
Purpose: This area of the Third Streamlined Order Inquiry Screen (Order Summary) screen provides information on each item on the order.
Field | Description |
---|---|
Line # |
A number the system assigns to each item as it is added to the order. A quote or order can have up to 999 lines. Numeric, 3 positions. |
Item |
A code that identifies a unit of inventory. Item codes are defined in and validated against the Item table. Note: The code displayed is the item alias if the customer ordered using an alias and the Display Item Alias (D56) system control value is selected.Alphanumeric, 12 positions. |
SKU |
An item's unique characteristics, such as its size and color. Note: The first 14 positions of the SKU description is displayed instead of the SKU elements if the Display SKU Description in place of SKU Element (F25) system control value is selected.Alphanumeric, three 4-position fields or one 14-position field. |
Name |
The first 30 positions of the description of the item. This is the base item description if the item has SKU’s. Alphanumeric, 30 positions. |
S (Status) |
A one-position code indicating the current status of the item on the order. Possible statuses are:
See Managing Soldouts and Backorders for background.
|
B (Order Orchestration) |
This field is set to B if the order is fulfilled through integration with Order Orchestration, regardless of whether this is a ship-for-pickup, store pickup, delivery, or retail pickup order, if the order line is a brokered backorder, or the order status. See the Order Orchestration Integration for more information. |
Price |
The actual unit price of the item after applying any discounts, breaks, or overrides. Discounted or overridden item prices are highlighted if the Display Order Line Discount Messages (F01) system control value is selected. Numeric, 13 positions with a 2-place decimal. |
Qty ordered |
The number of units of the item that the customer ordered. Numeric, 5 positions. |
Qty reserved |
The number of units of the item that are currently reserved from stock. The system does not reserve stock on quotes until they are converted to standard orders; see Converting Quotes to Orders. The reserved quantity is reduced when an item is canceled, confirmed for shipment, or unreserved using Interactive Reservation. The system updates this quantity at billing. Numeric, 5 positions. |
Qty printed |
The number of units included on a printed pick slip. Pre-generated picks: The system does not update this field when you create a pre-generated pick for the order line during pick slip preparation; the system updates this quantity when you generate a pick slip . See Applying Pick Slip Preparation to an Order and Performing Pick Slip Generation. Voiding a pick slip: The system reduces the printed quantity if you void the pick slip and don't reprint, or when shipment of the item is confirmed. Order Orchestration? If the order line has been assigned to Order Orchestration for fulfillment (brokered backorder) or if the customer is picking up the order at a store (store pickup), the print quantity here is equal to the ordered quantity. In the case, the Drop ship flag at the Order Detail Window is set to D, although for a brokered backorder, the BO warehouse indicates your distribution center. See Brokered Backorders or Store Pickup Orders for background. Numeric, 5 positions. |
Qty shipped |
The number of units that have shipped. The system updates this quantity at billing. This quantity is negative for a return processed by entering a negative quantity in order entry. Place your cursor over the shipped quantity to display the most recent shipment date for the item on the order. The text No Ship Date Found displays if the system could not find a shipment date for the item on the order. Numeric, 5 positions. |
Qty returned |
The number of units that the customer has returned. This quantity is zero for a return processed by entering a negative quantity in order entry. Numeric, 5 positions. |
Expected date |
Backordered item: The date a purchase order for this backordered item is expected. Note: This field is not displayed for a reserved item, a brokered backorder item, or if there are no open purchase orders for the item.Drop ship item: This date is displayed for drop ship items if the Assign Drop Ship Expected Ship Date (I59) system control value is selected. See that system control value for more information. Numeric, 6 positions; in user date format. |
Total |
The extended price of the line, calculated as: Unit price * Order quantity = Extended price Numeric, 20 positions with a 2-place decimal. |
Option | Procedure |
---|---|
Review more information about the order detail line |
Click the icon () in the Detail column to open the Order Detail Window. |
Review or enter order detail messages |
Click the icon () in the Msg column to open the Order Detail Messages Window. The icon is blue () if any messages already exist for the order line. |
Customers
This area of the Third Streamlined Order Inquiry Screen (Order Summary) screen provides the name, address, phone number(s), and email address of:
- the sold-to customer who placed the order
- the shipping address for the order
- the bill-to customer, if any, associated with the order
Note:
If the name and address for the bill-to customer and sold-to customer are identical, the bill-to customer is not displayed.Field | Description |
---|---|
Sold To Information |
The sold-to information identifies the customer who placed the order. |
Name |
Last name, first name, and middle initial of the customer placing the order. Last name: alphanumeric, 25 positions. First name: alphanumeric, 15 positions. Middle initial: alphanumeric, 1 position. |
Company |
The name of the company associated with the customer placing the order. Alphanumeric, 30 positions. |
Address |
Up to four lines indicating the street address and apartment or suite number. First address line: alphanumeric, 32 positions. Apartment or suite: alphanumeric, 10 positions (to the right of the first address line). Address lines 2-4: alphanumeric, 30 positions each. |
City |
The city where the customer lives or receives mail and shipments. Alphanumeric, 25 positions. |
State |
The state where the customer lives or receives mail and shipments. State codes are defined in and validated against the State table, accessible through the Work with Countries menu option; see Setting Up the Country Table (WCTY). Alphanumeric, 2 positions. |
Postal code |
The postal or zip code for the customer’s address. Alphanumeric, 10 positions. |
Country |
The three-position code identifying the customer’s country. Included only if the country does not match the Default Country for Customer Address (B17). Country codes are defined in and validated against the Country table; see Setting Up the Country Table (WCTY). Alphanumeric, 3 positions. |
Phone numbers |
The customer’s daytime and evening phone numbers, including any formatting set up through the Work with Telephone Number Format Screen. The mobile phone number is also displayed if the Phone Numbers (D15) system control value is set to MOBILE; however, if this system control value is set to FAX, the fax number is not displayed. Also, any extensions are not displayed. Alphanumeric, 14 positions each. |
Email address |
The order-level email address, if any. See Working with an Order-Level Email Address for information on how the system determines the email address to assign to an order. Alphanumeric, 50 positions. |
OptIn |
The opt-in/opt-out setting for the email address. Possible settings are:
|
Ship to information |
The ship-to information identifies the shipping address of the order, which can be an order ship-to, a permanent ship-to address for the sold-to customer, or a recipient who is another sold-to customer. |
Name |
The last name, first name, and middle initial of the ship-to. Last name: alphanumeric, 25 positions. First name: alphanumeric, 15 positions. Middle initial: alphanumeric, 1 position. |
Company |
The name of the company associated with the ship-to. Alphanumeric, 30 positions. |
Address |
Up to four lines indicating the street address and apartment or suite number. First address line: alphanumeric, 32 positions. Apartment or suite: alphanumeric, 10 positions (to the right of the first address line). Address lines 2-4: alphanumeric, 30 positions each. |
City |
The city where you ship the order. Alphanumeric, 25 positions. |
State |
The state where you ship the order. State codes are defined in and validated against the State table, accessible through the Work with Countries menu option; see Setting Up the Country Table (WCTY). Alphanumeric, 2 positions. |
Postal code |
The postal or zip code for the shipping address. Alphanumeric, 10 positions. |
Country |
The three-position code identifying the country for the shipping address. Included only if the country does not match the Default Country for Customer Address (B17). Country codes are defined in and validated against the Country table; see Setting Up the Country Table (WCTY). Alphanumeric, 3 positions. |
Phone numbers |
The customer’s daytime and evening phone numbers, including any formatting set up through the Work with Telephone Number Format Screen. The mobile phone number is also displayed if the Phone Numbers (D15) system control value is set to MOBILE; however, if this system control value is set to FAX, the fax number is not displayed. Also, any extensions are not displayed. Note: The system stores a single phone number for an order ship-to.Alphanumeric, 14 positions each. |
Email address |
The email address associated with the shipping address. If there is not a separate shipping address, this is the sold-to customer’s primary email address. Alphanumeric, 50 positions. |
Bill to information |
Bill-to information is included if the sold-to customer is associated with a bill-to account and the names and addresses for the two records are not identical. |
Name |
The last name, first name, and middle initial of the bill-to account. Last name: alphanumeric, 25 positions. First name: alphanumeric, 15 positions. Middle initial: alphanumeric, 1 position. |
Company |
The company name for the bill-to. Alphanumeric, 30 positions. |
Address |
Up to four lines indicating the street address and apartment or suite number. First address line: alphanumeric, 32 positions. Apartment or suite: alphanumeric, 10 positions (to the right of the first address line). Address lines 2-4: alphanumeric, 30 positions each. |
City |
The city where the bill-to is located. Alphanumeric, 25 positions. |
State |
The state where the bill-to is located. State codes are defined in and validated against the State table, accessible through the Work with Countries menu option; see Setting Up the Country Table (WCTY). Alphanumeric, 2 positions. |
Postal code |
The postal or zip code for the bill-to address. Alphanumeric, 10 positions. |
Country |
The three-position code identifying the country for the bill-to address. Included only if the country does not match the Default Country for Customer Address (B17). Country codes are defined in and validated against the Country table; see Setting Up the Country Table (WCTY). Alphanumeric, 3 positions. |
Phone numbers |
The bill-to customer’s daytime and evening phone numbers, including any formatting set up through the Work with Telephone Number Format Screen. The mobile phone number is also displayed if the Phone Numbers (D15) system control value is set to MOBILE; however, if this system control value is set to FAX, the fax number is not displayed. Also, any extensions are not displayed. Alphanumeric, 14 positions each. |
Email address |
The bill-to customer’s email address. Alphanumeric, 50 positions. |
Properties
This area of the Third Streamlined Order Inquiry Screen (Order Summary) screen provides additional information about the order as a whole.
Field | Description |
---|---|
Source |
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. |
Entered date |
The date when the order was created. Numeric, 6 positions; in user date format. |
Entered time |
The time of day the order was originally created. Numeric, 6 positions (HH:MM:SS format). |
Ship complete |
Determines whether all the items on an order must ship together. Valid values are:
|
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. |
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. |
Cancel BO |
Identifies whether to automatically cancel items that are unavailable (backordered) with the first shipment on the order. Valid values are:
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. |
Cancel date |
The date, if any, 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. |
BO priority |
A code that determines the priority for order fulfillment on a backordered item. Defaults from the B/O priority (Backorder priority), if any, specified 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. |
Calculate freight |
Determines whether the system calculates and adds freight charges and any service charges by ship via to the order:
|
Weight |
The total shipping weight of the items on the order. Numeric, 20 positions with a 3-place decimal. |
Freight override |
Indicates the freight charges for the Order Ship To if they were applied as an override. Numeric, 13 positions with a 2-place decimal. |
Gift |
If this field is selected, this is a gift order, which means:
|
Tax code |
The code and description of the tax status on the order. Valid values are:
See Working with Customer Tax Status for more information. |
Tax identification |
The customer’s tax identification number, typically the certificate that identifies the customer as a reseller or tax exempt; otherwise, the tax identification number does not control taxability. This number is required when the customer's tax code is R (Reseller) or E (Exempt). Alphanumeric, 30 positions. |
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. |
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. |
Broker delivery type |
Indicates whether the order is being fulfilled through the Order Orchestration Integration. Possible settings are:
|
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. |
Payment
This area of the Third Streamlined Order Inquiry Screen (Order Summary) screen provides summary information about the payment methods used on the order.
Note:
This screen does not include complete payment method details, such as information on deferred or installment billing.Additional options for credit card payment methods: A plus sign next to a credit card payment method indicates that there is additional information available.
Click the plus sign to display any authorization and deposit history. See Credit Card Authorization and Deposit History for field descriptions.
Note:
If you move your cursor over a payment method, it changes color; however, this color change does not indicate that the payment method is an active link.Field | Description |
---|---|
Payment category |
Indicates the category that defines the basic rules for processing a payment. Each payment type is assigned to a payment category. Possible categories are:
See Working with Pay Types (WPAY) for background. |
Pay type description |
The description of the pay type is to the right of the description of the payment category. Alphanumeric, 30 positions. |
Credit card number |
Credit card pay types only: The credit card number the customer used on the order. Alphanumeric, 20 positions; display-only. |
Expiration |
Credit card pay types only: The date the credit card is no longer active. The expiration date might be zero if the Require expiration date flag for the pay type is not selected. For example, a stored value card credit card type typically does not require an expiration date. Numeric, 4 positions (MMYY format); display-only. |
CC last 4 |
The last four positions of the credit card number. From the CC Last 4 field in the Order Payment Method table. Alphanumeric, 4 positions; display-only. |
Amount to charge |
The amount to charge this payment method. Always 0.00 for the “catch-all” payment method on an order, meaning any dollar amount not assigned to another payment method applies to this one. Note: If this is a prepay amount, and part of the prepayment total was applied to a membership program, only the remaining amount appears as the amount to charge or amount billed. For example, if the customer sent a check for 100.00 and 80.00 was applied to the membership program, 20.00 appears here. See Membership Overview.Numeric, 20 positions with a 2-place decimal. |
Credit Card Authorization and Deposit History
The information described below is available in the Payment area of the Third Streamlined Order Inquiry Screen (Order Summary) screen by clicking the arrow next to a credit card payment method.
Field | Description |
---|---|
Authorization history |
The authorization history is flagged with a letter H. See Display Authorization History Screen for background. |
Auth history status |
A description of the status of the authorization as updated by the system. Possible statuses are:
|
Amount authorized |
The amount submitted for authorization and approved by the credit card authorization service. Numeric, 20 positions with a 2-place decimal. |
Auth number |
A number assigned by the authorization service for the authorization transaction. Alphanumeric, 16 positions. |
Auth date |
The date the authorization service approved the amount to be charged. Numeric, 6 positions; in user date format. |
Sent date |
The date you transmitted the authorization to the authorization service. Numeric, 6 positions; in user date format. |
Amount deposited |
The amount deposited to the bank for the charge. Numeric, 20 positions with a 2-place decimal. |
Vendor response 1 |
A code indicating the response, if any, from the authorization service. Although the response can be up to 10 positions, only the first four positions are displayed. Alphanumeric, 4 positions. |
Vendor response 2 |
A code indicating the credit card security response, if any, from the authorization service. Although the response can be up to 10 positions, only the first four positions are displayed. Alphanumeric, 4 positions. |
AVS response |
A code indicating the address verification response, if any, from the authorization service. Although the response can be up to 10 positions, only the first four positions are displayed. Alphanumeric, 4 positions. |
Deposit history |
See Display Deposit History Screen for background. |
Deposit history status |
The status of this deposit:
|
Invoice # |
The number the system assigns to a customer's bill or credit. The system generates an invoice during billing. Numeric, 7 positions. |
Type |
Indicates the type of deposit:
Alphanumeric, 10 positions. |
Deposit date |
The date when this deposit history record was created. This is the date when the invoice pay method was deposited. Numeric, 6 positions; in user date format. |
Deposit amount |
The amount deposited. The amount is negative for a return. For a flexible payment option, calculated as follows:
Numeric, 20 positions with a 2-place decimal. |
Response |
The response code from the Credit Card Deposit History table. Alphanumeric, 10 positions. |
Invoices
This area of the Third Streamlined Order Inquiry Screen (Order Summary) screen provides summary information about the shipment or credit invoices billed against the order.
Field | Description |
---|---|
Invoice # |
The number the system assigns to a customer's bill. Assigned when? If the Generate Invoice Number at Pick Gen (H80) or Generate Invoice # at Pick Gen without Address Match (K81) system control value is selected, the system assigns the invoice number at pick slip generation if the order is eligible; otherwise, it assigns the invoice number at billing. Numeric, 7 positions. |
Date |
The date the invoice record was created by billing. Numeric, 6 positions; in user date format. |
Type |
Indicates the type of invoice:
The system does not consolidate credit invoices with other credits or with debit invoices. Alphanumeric, 1 position. |
Merch |
The total dollar value of the merchandise. Merchandise amount does not include tax (with the exception of hidden tax, or VAT), handling, additional charges, or freight. Numeric, 20 positions with a 2-place decimal. |
Freight |
The freight charges for the invoice. This amount may not be equal to the total of all the line-level freight charges. Numeric, 20 positions with a 2-place decimal. |
Tax |
The sales tax for the invoice. This field includes GST and PST, if any. This field does not include hidden tax. Numeric, 20 positions with a 2-place decimal. |
Handling |
The cost of any special handling billed or credited on the invoice. Examples include personalizing, monogramming, or engraving, and any gift wrapping charges. Any duty charges on the invoice are also included in this total. Numeric, 20 positions with a 2-place decimal. |
Add’l charge |
The total additional charges billed or credited on the current invoice. See Add’l charge for examples. Numeric, 20 positions with a 2-place decimal. |
Add’l freight |
The total dollar amount for freight charges exceeding the order's base freight charge. This is a shipper-level charge directly associated with the order, as opposed to the line item. Additional freight is defined for the shipper in the Ship Via table. Examples of additional freight charges that might apply include charges for overnight shipping, second day delivery, or padded van. Additional freight charges may include the standard freight charges, depending on how you have set up the ship via. If you set up a ship via this way, the Freight field is blank. Numeric, 20 positions with a 2-place decimal. |
Total |
The total amount billed or credited, including all related merchandise charges, freight, tax, handling, additional charges, and additional freight. Numeric, 20 positions with a 2-place decimal. |
Option | Procedure |
---|---|
Print order receipts for each ship-to on the order |
Click the order receipt icon to generate the order receipt:
|
Review the invoice detail records related to the items shipped or returned on the order. |
Click the icon () in the Detail column to open the Invoice Detail Window. This icon is not included for a credit invoice created by applying a negative additional charge to the order, since in this case there are no invoice details. |
Carton Contents
This information can come fromGeneric Pick In API (Shipments, Voids, and Backorders) .
For more information, see the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1).
Field | Description |
---|---|
Pick # |
A unique number assigned by the system to identify the pick slip. Numeric, 7 positions. |
Carton # |
Identifies the carton number containing the items shipped on the pick slip. Set to 1 unless you used multiple cartons to ship the pick slip. Numeric, 3 positions. |
Item |
The code identifying the item shipped. Alphanumeric, 12 positions. |
SKU |
The item’s unique characteristics, such as its color or size. Included only if the item has SKUs. Alphanumeric, three 4-positions fields. |
Qty |
The quantity of the item shipped in this carton. Numeric, 3 positions. |
Pack date |
The date when the carton was packed or shipped. From the shipment date passed through the pick in API. Numeric, 6 positions; in user date format. |
Pack time |
The time when the carton was packed or shipped. From the shipment time passed through the pick in API. Numeric, 6 positions (HH:MM:SS format). |
Packer |
The packer passed through the pick in API. Alphanumeric, 10 positions. |
Refunds
This area of the screen provides information on any refunds that have been generated for the order. See Issuing Refunds for background.
Field | Description |
---|---|
Pay type |
The code identifying the pay type to be refunded. This pay type might be different from the payment method used to pay for the order if the pay type has an alternate refund type or alternate refund category; see Working with Pay Types (WPAY) for background. Numeric, 2 positions. |
Pay type desc |
The description of the pay type to be refunded. Alphanumeric, 30 positions. |
Status |
The status of the refund. Possible statuses are:
|
Deposit |
Indicates whether the refund has been deposited. A deferred or installment payment plan can prevent the system from depositing a refund in order to offset the deferred or installment amount. For example, if the order payment amount of 60.00 is deferred for 30 days and the customer receives a refund for 20.00, instead of refunding the customer 20.00, the system subtracts the refund amount from the order payment amount. The customer will then pay 40.00 at the end of the 30 days. Valid values are:
|
Current category |
The description of the payment category for the pay type to be refunded. Possible categories are:
|
Original category |
The payment category of the original payment method used on the order. Possible categories are:
|
Amt collected |
The amount that you are refunding to the customer. Numeric, 20 positions with a 2-place decimal. |
Date created |
The date the refund was generated through order activity such as a return. Numeric, 6 positions; in user date format. |
Date processed |
The date, if any, when the refund was processed, written off, or canceled. Numeric, 6 positions; in user date format. |
Manual hold |
Indicates whether you applied a manual hold against the refund through Working with Refunds, Writeoffs and Balances Due (WREF): Y = Manual hold applies N = No manual hold applies |
Hold until |
The date when the refund is eligible for processing. Numeric, 6 positions; in user date format. |
Pop-Up Windows
Purpose: The pop-up windows available at the Third Streamlined Order Inquiry Screen (Order Summary) are:
History Window
Purpose: Use this window to review the activity that has taken place related to the order since it was created. This is the same information available at the Display Order History Screen.
How to display this window: Click History in the Navigation area at the top of the Third Streamlined Order Inquiry Screen (Order Summary).
Field | Description |
---|---|
Date |
The date when the order activity occurred. Numeric, 6 positions; in user date format; display-only, updated by the system. |
Time |
The time when the order activity occurred. Numeric, 6 positions (HH:MM:SS format); display-only, updated by the system. |
Type |
A code for a type of update against the order. Valid values are:
|
For more information, see the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1). Narvar notices: When you use the Narvar Integration, the Letter notification type for a shipment email can be:
For more information: See Narvar Troubleshooting.
|
|
|
|
Transaction note |
The description of the activity related to the transaction, such as:
|
Special character? If there are any special characters in an Order Transaction History message, the system replaces the special character, excluding any underscores, with a space when you display the message at the Display Order History Screen; however, the History Window might display the special character as a series of alphanumeric characters, such as \u000F. Alphanumeric, 40 positions; display-only. |
|
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, 20 positions with a 2-place decimal; display-only. |
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 or API; otherwise, the system uses your default user. Alphanumeric, 10 positions; display-only. |
Order Messages Window
Purpose: Use this window to review or work with free-formatted order-level messages. These are the same messages you can work with at the Work with Order Messages Screen.
See Adding Order Messages for background on working with order messages, including the print requirements and limitations of including messages on different forms; however, important differences between the Work with Order Messages screen and the Order Messages window are:
- Default messages: At the Work with Order Messages Screen, you can apply a message set up through Working with Default Messages (WMSG); however, this option is not available through Streamlined Order Inquiry (DORI).
- Message sequence: At the Work with Order Messages Screen, you can select whether to display the messages in LIFO or FIFO sequence; however, in Streamlined Order Inquiry (DORI), messages are always listed in FIFO sequence.
Change or delete existing messages? The Modify Existing Messages (A30) secured feature controls the ability to change or delete an existing order message. If you have authority to this secured feature, double click on a line to change or delete it; see Working with existing message lines for instructions.
How to display this window: Click Messages in the Navigation area at the top of the Third Streamlined Order Inquiry Screen (Order Summary). The word Messages is in blue rather than black if there are any existing order messages.
Field | Description |
---|---|
Entering new message lines |
Optionally, use the upper part of the window to enter new order messages. |
New message |
Use this field to enter new free-form text messages. If your entry exceeds 60 positions and you do not press Enter to start a new line, the system splits the text into separate lines of up to 60 positions each, using the last occurring blank space before position 60 as a line break. |
Highlight the print option to the right of the New message field. Available options are:
|
|
Click Add when you are done to save your changes. |
|
Working with existing message lines The lower part of the window displays existing order messages. You can review, change, or delete these messages. |
To change:
You can also change the Print option next to a message line. To delete:
|
Message |
A message related to the order. Alphanumeric, 60 positions. |
Available options are:
|
|
Date |
The date when the message was written. Numeric, 6 positions; in user date format. |
Time |
The time when the message was written. Numeric, 6 positions (HH:MM:SS format). |
User |
The user ID identifying the person who wrote the message. Alphanumeric, 10 positions. |
Note:
Depending on your screen resolution, if there are multiple message lines the Exit button might not be visible. In this case, press F12 to exit the window and return to the Third Streamlined Order Inquiry Screen (Order Summary).Order Detail Window
Purpose: Use this window to display additional information about an item on the order.
How to display this window: Click the icon () in the Detail column next to an item in the Products area of the Third Streamlined Order Inquiry Screen (Order Summary) screen.
Field | Description |
---|---|
Item |
The item you selected in the Products area of the Third Streamlined Order Inquiry Screen (Order Summary). Note: The code displayed is the item alias if the customer ordered using an alias and the Display Item Alias (D56) system control value is selected.Alphanumeric, 12 positions. |
SKU |
The item's unique characteristics, such as its size and color. Note: The first 14 positions of the SKU description is displayed instead of the SKU elements if the Display SKU Description in place of SKU Element (F25) system control value is selected.Alphanumeric, three 4-position fields or one 14-position field. |
Desc |
The first 30 positions of the description of the item. This is the base item description if the item has SKU’s. Alphanumeric, 30 positions. |
Qty ordered |
The number of units of the item that the customer ordered. Numeric, 5 positions. |
Price |
The actual unit price of the line after applying any discounts, breaks, or overrides. Discounted or overridden item prices are highlighted if the Display Order Line Discount Messages (F01) system control value is selected. Numeric, 13 positions with a 2-place decimal. |
Source |
The source code assigned to the detail line, if any. There might not be a source code on the order detail line if the Use Source Code from Order Header When Creating Order Lines (D73) is not selected. The source code at the line level controls demand and sales information/posting for that item, while the source code on the order controls how to price items and calculate freight. Alphanumeric, 9 positions. |
Offer |
A code for the catalog, space or television advertisement from which you accept quotes and orders. The offer defined for the quote or order controls how to calculate shipping and price items. However, if you override the offer for an item (if the customer is ordering from more than one catalog, for example), demand for the item is attributed to the offer associated with the item rather than the order. Demand represents the number and dollar value of orders placed against an offer. Note: The system automatically overrides the offer for an item if Override Offer on Order Detail Line (D49) system control value is selected and the item is not sold in the offer used on the order.Offers are defined in and validated against the Offer table. See Working with Offers (WOFR). Alphanumeric, 3 positions. |
Offer price |
The item price as defined for the offer. If the order was subject to VAT and tax-inclusive pricing, in which any tax is included in the Hidden tax field rather than the Tax bucket on the order, the offer price presented here is the tax-inclusive offer price. Note: When a price override reason applies to the order line (whether you enter an override reason manually, or if the system applies the override automatically), the override reason’s Override item offer price setting controls whether to use the regular offer price. See Overriding the Item/SKU Offer Price for a discussion.Numeric, 13 positions with a 2-place decimal. |
G/W |
If this flag is selected, it indicates that the item is gift wrapped. |
Freight |
The charge for shipping the item. This total does not include additional freight charges, and is blank if the freight is calculated for the entire order instead of item-by-item. Numeric, 13 positions with a 2-place decimal. |
Add’l freight |
The dollar amount of shipper/item charges, as defined for the shipper and item at the Work with Ship Via/Item Screen. Numeric, 13 positions with a 2-place decimal. |
Quantities | |
Qty reserved |
The number of units of the item that are currently reserved from stock. The system does not reserve stock on quotes until they are converted to standard orders; see Converting Quotes to Orders. The reserved quantity is reduced when an item is canceled, confirmed for shipment, or unreserved using Interactive Reservation. The system updates this quantity at billing. Numeric, 5 positions. |
Qty printed |
The number of units included on a printed pick slip. Pre-generated picks: The system does not update this field when you create a pre-generated pick for the order line during pick slip preparation; the system updates this quantity when you generate a pick slip. See Applying Pick Slip Preparation to an Order and Performing Pick Slip Generation. Voiding a pick slip: The system reduces the printed quantity if you void the pick slip and don't reprint, or when shipment of the item is confirmed. Order Orchestration? If the order line has been assigned to the Order Orchestration for fulfillment (brokered backorder) or if the customer is picking up the order at a store (store pickup), the print quantity here is equal to the ordered quantity. In the case, the Drop ship flag at the Order Detail Window is set to D, although for a brokered backorder, the BO warehouse indicates your distribution center. See Brokered Backorders or Store Pickup Orders for background. Numeric, 5 positions. |
Qty shipped |
The number of units that have shipped. The system updates this quantity at billing. This quantity is negative for returns processed by entering a negative quantity in order entry. Numeric, 5 positions. |
Qty returned |
The number of units that the customer has returned. This quantity is zero for a return created by entering a negative quantity in order entry. Numeric, 5 positions. |
Qty canceled |
The number of units that have been canceled. Numeric, 5 positions. |
Qty sold out |
The number of units that have been sold out, either automatically or manually. Numeric, 5 positions. |
Expected ship date |
Backordered item: the date a purchase order for this backordered item is expected. Note: This field is not displayed for a reserved item, a brokered backorder, or if there are no open purchase orders for the item.Drop ship item, including brokered item: This date is displayed for drop ship items if the Assign Drop Ship Expected Ship Date (I59) system control value is selected. See that system control value for more information. Numeric, 6 positions; in user date format. |
Next BO date |
The next date when the order line is eligible to generate a backorder notice. See Generate Backorder Notices (GBOC) for more information. Numeric, 6 positions; in user date format. |
Entered date |
The date when the order was created, or when the item was added to the order. Numeric, 6 positions; in user date format. |
Arrival date |
The date when the customer wants to receive this item. The arrival date entered here overrides the arrival date defined for the order. The arrival date for each item is initially set to the current date; however, you can enter some future date in order entry or maintenance to delay shipment of the item. The system defaults a future arrival date to an item with a future ship status if the item's status code matches the Future Orders Item Status (E52). The future arrival date that defaults for this item comes from the Default Future Orders Arrival Date (E53). The arrival date controls:
The arrival date for the item controls whether to reserve inventory as follows: Arrival date - Reservation Lead Days (B27) = Date |
The system does not reserve inventory if the result is a future date. In this case, the item is flagged as a future order and assigned a backorder status. When you run the Evaluate Future Orders process (typically, every evening) it evaluates each item flagged as a future order and reruns the arrival date calculation. When the result is no longer in the future, the process reserves the inventory. See Scheduling Jobs for more information. Influence on Pre-Generated PicksThe item's arrival date also controls whether the system creates pre-generated pick. The system uses this calculation: Arrival Date from Order Line (or Order Ship To) - (Pick Processing Days (B37) + Ship Via Lead Days in WSHV) < or = Today's Date The system creates a pre-generated pick for the order line if this system-calculated date is less than or equal to today's date; otherwise, the system does not create a pre-generated pick for the order line until the date is within the allotted time frame. See Selecting Order Lines for Pick Slip Preparation. |
|
Zone reservation rules: For items subject to zone reservation, this date is:
See Shipping Zone Reservation Overview for a complete discussion. You can use an order line's Arrival date as a selection criterion in pick slip generation. For zone reservation coded inventory such as plant stock, this selection insures that the item will ship at a date suitable for planting at its destination. Numeric, 6 positions; in user date format. |
|
Cancel date |
The date when the customer wants to cancel the item if it has not shipped. Numeric, 6 positions; in user date format. |
Inventory | |
Drop ship |
Set to D for a drop ship item, or for a brokered backorder or store pickup order. In the case of a brokered backorder or store pickup, there is a printed quantity; for a brokered backorder, the BO warehouse indicates your distribution center. Alphanumeric, 1 position. |
Warehouse |
The warehouse shipping the item. Typically set to 0. Some reasons why an order line might be assigned to a specific warehouse:
Warehouse code: numeric, 2 positions. Warehouse description: alphanumeric, 30 positions. |
BO warehouse |
A code that identifies the warehouse assigned to ship a backordered item. Note: This field appears only if there is a backordered quantity of the item.Warehouse code: numeric, 2 positions. Warehouse description: alphanumeric, 30 positions. |
Future order |
This flag indicates that the arrival date for the item is too far in the future to reserve stock. The item is reserved when the current date reaches the requested arrival date minus lead days for picking and shipping. Valid values are:
See the Arrival date for a discussion. |
Affect inventory |
Indicates whether the quantity available to sell (on-hand quantity) of the item is reduced during order entry. Valid values are:
|
Bypass reservation |
Indicates whether to reserve this item during order entry if inventory is available.
Valid values are:
This setting defaults from the Item table if the item is set up to bypass reservation, because it is available in a limited quantity or it is a limited edition. |
Special Handling |
This area of the window provides information on custom or standard special handling for the item. See Special Handling Overview for background. |
Special handling |
The special handling code and description identifying the type of work to be performed on the item. Special handling codes are defined in and validated against the Additional Charges table. Code: alphanumeric, 2 positions. Description: alphanumeric, 30 positions. |
Special handling charge |
The charge for special handling of an item. See Special Handling Overview for background. Numeric, 13 positions with a 2-place decimal. |
Handling information |
One or more lines of free-form text describing the handling for the item. Alphanumeric, 30 positions each line. |
The following lines provide information custom special handling. |
For more information on custom special handling information, see:
|
Label |
A special handling option defined for this custom special handling format. Alphanumeric, 15 positions. |
Input |
The response selected for each special handling option available in the custom special handling format. These fields might be blank if, for example, you use the special handling format only to add a charge to the Handling bucket on the order. The Suppress S/H window field for the additional charge code allows you to suppress the automatic display of the special handling screen in order entry if you use a special handling code for this purpose. Alphanumeric, 45 positions. |
Description |
The description of the response, as specified at the Work with Special Format Response Screen when you set up the valid responses for the format. Alphanumeric, 45 positions. |
Charge |
The charge associated with an option in the custom special handling format. This charge is added to the Handling bucket of the order totals. Numeric, 13 positions with a 2-place decimal. |
Activity |
This area of the window displays order line history. See Display Order Line History Screen for background. |
Activity |
A code for a type of update against this item detail line. Valid values are:
|
Description |
The description of the activity. See above. |
Date |
The date when the activity occurred. Numeric, 6 positions; in user date format. |
Qty |
The quantity of the item affected by this activity. For example, 3- indicates that three units of the item were canceled. Activities that do not affect the order quantity, such as changing the pricing of the order line, do not display a quantity here. This quantity is displayed differently depending on how the item was sold out; see Processing Auto Soldout Cancellations (MASO) for details. Numeric, 5 positions. |
Exc reason |
Represents a reason for the customer to exchange one item for another. Exchange reasons are defined in and validated against the Exchange Reasons table; see Establishing Exchange Reason Codes (WEXR). Numeric, 3 positions. |
Can reason |
The reason for canceling the units or reducing the quantity. A cancel reason code is not displayed for soldout cancellations, whether you sell out the item by selecting Sold-out in order entry or order maintenance, or through Processing Auto Soldout Cancellations (MASO). Cancel reason codes are defined in and validated against the Cancel Reason table; see Establishing Cancel Reason Codes (WCNR). Numeric, 2 positions. |
Rtn reason |
Represents a reason for the customer to return an item. Return reasons are defined in and validated against the Return Reason table; see Establishing Return Reason Codes (WRTR). Numeric, 2 positions. |
Add reason |
Represents a reason for adding an item to the order. The system requires an add reason code if:
Add reason codes are defined in and validated against the Add Reason table; see Establishing Add Reason Codes (WADR). Alphanumeric, 5 positions. |
User |
The user ID of the person who performed the activity. No user is listed if you sold out a line through Processing Auto Soldout Cancellations (MASO). Alphanumeric, 10 positions. |
Note:
Depending on your screen resolution and the contents of this window, the complete contents and the Exit button might not be visible. In this case, press F12 to exit the window and return to the Third Streamlined Order Inquiry Screen (Order Summary). You can review the order line information in standard order inquiry, or increase your screen resolution; see How do I display the Order Administration screens correctly on a laptop?Order Detail Messages Window
Purpose: Use this window to review or work with free-formatted order-detail-level messages. These are the same messages you can work with at the Work with Order Line Messages Screen.
Note:
You cannot apply a message set up through Working with Default Messages (WMSG) through this window; to do so, you can use the Work with Order Line Messages Screen.Change or delete existing messages? The Modify Existing Messages (A30) secured feature controls the ability to change or delete an existing order line message.
How to display this window: Click the icon () in the Msg column next to an item in the Products area of the Third Streamlined Order Inquiry Screen (Order Summary) screen.The icon is blue ()if there are any existing order line messages.
Field | Description |
---|---|
Item |
The item and SKU you selected at the Third Streamlined Order Inquiry Screen (Order Summary). Item: alphanumeric, 12 positions. SKU: alphanumeric, three 4-position fields. |
Entering new message lines | Optionally, use the upper part of the window to enter new order line messages. |
New messages |
Use this field to enter new free-form text messages. If your entry exceeds 60 positions and you do not press Enter to start a new line, the system splits the text into separate lines of up to 60 positions each, using the last occurring blank space before position 60 as a line break. |
Highlight the print option to the right of the New message field. Available options are:
|
|
Click Add when you are done. |
|
Working with existing message lines |
The lower part of the window displays existing order detail messages. You can review, change, or delete these messages. To change:
You can also change the Print option next to a message line. To delete:
Secured feature: The Modify Existing Messages (A30) secured feature controls the ability to change or delete an existing order line message. |
Message |
A message related to the order line. Alphanumeric, 60 positions. |
Available options are:
|
|
Date |
The date when the message was written. Numeric, 6 positions; in user date format. |
User |
The user ID identifying the person who wrote the message. Alphanumeric, 10 positions. |
Invoice Detail Window
Purpose: Use this window to review the invoice details for each item on the order that has been billed or credited.
How to display this window: Click the icon () in the Detail column next to an item in the Invoices area of the Third Streamlined Order Inquiry Screen (Order Summary) screen.
Note:
This icon is available only if Invoice Details exist; it is not available for a credit invoice created by applying a negative additional charge to an order.Field | Description |
---|---|
Line # |
The number of the invoice line for the item. Numeric, 3 positions. |
Item |
The code identifying the item that shipped or was returned. Alphanumeric, 12 positions. |
SKU |
The item’s unique characteristics, such as its color or size. Included only if the item has SKUs. Alphanumeric, three 4-position fields. |
Ship qty |
The shipped quantity of the invoiced item. The quantity is negative in the case of a credit invoice created for a return. Numeric, 5 positions. |
Price |
The actual unit price of the shipped or returned item. Numeric, 13 positions with a 2-place decimal. |
Ship date |
The date the invoice line shipped or the return was processed. Numeric, 6 positions; in user date format. |
Return qty |
The quantity of the item returned on this invoice. Numeric, 5 positions. |
Return date |
The most recent date when the customer returned any quantity of the item billed on this invoice. Numeric, 6 positions; in user date format. |