Common Elements Used in This Section

Field or Control	Description
Delivery ID	Enter a value to limit your search results to one delivery and the demand lines in that delivery.
Source	Limit your search results by the PeopleSoft application where the demand lines originated. Search results include the demand lines or deliveries containing the demand lines that meet this search criteria. The options are: IN: Material stock requests created in PeopleSoft Inventory. OM: Sales orders created in PeopleSoft Order Management. Non-OM: Includes all sources except sales orders created in PeopleSoft Order Management. PL: Material stock requests created from planning requisitions from PeopleSoft Supply Planning. PO: Material stock requests created from demand in PeopleSoft Purchasing PR: Material stock requests created from requisitions in PeopleSoft Purchasing. RT: Material stock request created for return-to-vendor (RTV) transactions.
Src BU	Enter the business unit where the demand lines originated. For sales orders, this is the PeopleSoft Order Management business unit. For material stock requests, this is the PeopleSoft Inventory business unit.
Delivery Status	Limit your search results by the status of the delivery in the IN_DELIVERY table. Search results include the deliveries or demand lines within the deliveries that have this delivery status. See Using PeopleSoft Tables to Store Delivery and Freight Information.
Order Number	Limit your search results to a single order number entered in this field. The order can be a sales order from PeopleSoft Order Management or a material stock request from PeopleSoft Inventory. Search results include the demand lines or deliveries containing the demand lines that meet this search criteria.
Line and To	Limit your search results to one order line or a range of order lines within the order specified in the Order Number field.
Select by Date	Limit your search results based on a date contained in the order demand line. Search results include the demand lines or deliveries containing the demand lines that meet this search criteria. Values are: Order Date: Select demand lines based on the order date. Enter a date range in the Date From and To fields. For just one specific date, use the Date From field only. Orders Placed Today: Select demand lines entered in the system today. Schedule Date: Select demand lines based on a the scheduled shipment date. Enter a date range in the Date From and To fields. For just one specific date, use the Date From field only. Ship Early Date: Select demand lines based on the Earliest Ship Date field. Enter a date range in the Date From and To fields. For just one specific date, use the Date From field only.
Date From and To	Enter the dates to retrieve demand lines. This is based on the entry in the Select by Date field.
Ship ID	Enter the shipping ID to select orders using a previously assigned shipping ID. Search results include the demand lines or deliveries containing the demand lines that meet this search criteria.
Carrier ID	Limit your search results based on one specific carrier. Search results include the demand lines or deliveries containing the demand lines that meet this search criteria.
Include Blank Carrier	Select this check box to include deliveries or demand lines without a carrier ID in your search results.
Load ID	Enter to select demand lines assigned to a single load ID. Search results include the demand lines or deliveries containing the demand lines that meet this search criteria.
Ship Via	Enter to select demand lines or deliveries using this one shipping method.
Include Blank ShipVia	Select this check box to include deliveries or demand lines without a Ship Via code in your search results.
Route Code	Enter to select demand lines that have been grouped together for a single transportation route. Search results include the demand lines or deliveries containing the demand lines that meet this search criteria.
Ship Container ID	Enter to select demand lines assigned to a single shipping container. Search results include the demand lines or deliveries containing the demand lines that meet this search criteria.
Customer ID	Enter to select orders that were entered for a particular customer. Search results include the demand lines or deliveries containing the demand lines that meet this search criteria.
Location	Enter to select orders that were entered for a particular location code. Location codes represent the business unit's address, a branch office, or shipping office. Location codes are defined on the Location Definition page (Set Up Financials/Supply Chain, Common Definitions, Location, Location). Search results include the demand lines or deliveries containing the demand lines that meet this search criteria.
Pro Number	Limit your search results based on one pro number.
Ship To and Address Seq	Select demand lines using a Ship To Customer ID and customer address sequence number. Search results include the demand lines or deliveries containing the demand lines that meet this search criteria.
Country and State	Limit your search results based on the country or state/province. Search results include the demand lines or deliveries containing the demand lines that meet this search criteria.
Select Freight Status	Limit your search results based on the freight and manifest status of the delivery. Search results include the deliveries or demand lines within the deliveries that have this status. The Freight Status field and the Manifest Status field in the IN_DELIVERY table determine the current state of the freighting and manifesting process. Options include: Not Started: No transaction request has been sent to the third-party freight system. Rate Requested: A freight rate request without a manifest action has been sent to the third-party freight provider system. Rate Received: The third-party freight provider has responded to the freight request and the delivery has been updated. Manifest Requested: A shipment request for freight rates and manifesting has been sent to the third-party freight provider system. Manifest Received: The shipment response was received from the third-party freight provider system.
Commit Freight for Billing	Select Yes or No to select deliveries with this value in the Commit Freight for Billing field of the IN_DELIVERY table. Search results include the deliveries or demand lines within the deliveries that have this status. A Yes value in this field indicates that the freight on this delivery is ready to be processed or has been processed by PeopleSoft Billing and by PeopleSoft Cost Management.
Pick Batch ID	Enter to select demand lines by the pick batch ID assigned by the Order Release process in PeopleSoft Inventory. Search results include the demand lines or deliveries containing the demand lines that meet this search criteria.
Line and To	Enter to select demand lines by the pick line number within a pick batch ID or a range of line numbers.
Fulfillment State	Choose the demand fulfillment states of the demand lines to be selected. Search results include the demand lines or deliveries containing the demand lines that meet this search criteria.
Priority and To	Limit your search results based on the shipping priority code or range of codes that are assigned to sales orders in PeopleSoft Order Management. Search results include the demand lines or deliveries containing the demand lines that meet this search criteria. Note: Within PeopleSoft, this field is only relevant for sales orders or interunit transfers created from PeopleSoft Supply Planning. However, the field is always available for entry to support modifications and third-party integration.
Item ID	Limit your search results to demand lines containing one specific item ID. Search results include the demand lines or deliveries containing the demand lines that meet this search criteria.
Item Group	Limit your search results to demand lines containing items within one specific item group. Search results include the demand lines or deliveries containing the demand lines that meet this search criteria.
Product ID	Limit your search results to demand lines containing one specific product ID. Search results include the demand lines or deliveries containing the demand lines that meet this search criteria.
Parent Product ID	Select demand lines by the parent ID of a product kit from PeopleSoft Order Management. Search results include the demand lines or deliveries containing the demand lines that meet this search criteria.
Commodity Code	Limit your search criteria to demand lines or deliveries containing one specific commodity code. Commodity codes, also called freight classes, are used on bills of lading to group and identify shipped products for freight rating and insurance purposes.
Backorders	Select Yes to select demand lines that have been backordered. Select No to select lines that are not backordered. Leave this field blank to select both. Search results include the demand lines or deliveries containing the demand lines that meet this search criteria.
Harmonized Code	Limit your search criteria to demand lines or deliveries containing one specific harmonized tariff code. These codes are required on various documents that accompany shipments across international borders. The codes are established for all commodities by the United States Commerce Department.
Export	Select Yes to retrieve demand lines with the value of Yes in the Export field. Select No to retrieve demand lines with the value of No in the Export field.