Offer

A code for the offer whose order and return activity you wish to review.

Offer codes are defined in and validated against the Offer table.

Alphanumeric, 3 positions; required.

Source

A code for the source whose order and return activity you wish to review.

Source codes are defined in and validated against the Source table.

Alphanumeric, 9 positions; required.

Offer

The code and description of the offer whose order and return activity you are reviewing.

From the Offer number in the Order/Billing History table.

Alphanumeric, 3 positions; display-only.

Source

The code and description of the source whose order and return activity you are reviewing.

From the Source code field in the Order/Billing History table.

Alphanumeric, 9 positions; display-only.

Item

An item that exists on an order associated with the specified offer/source combination.

Enter a full or partial item number and select OK to display items in alphanumeric sequence that begin with your entry.

From the Item number field in the Order/Billing History table for records whose Offer number and Source code match the specified offer/source code combination.

Alphanumeric, 12 positions; optional.

SKU

The SKU of the item in an order associated with the specified offer/source combination.

Alphanumeric, three 4 position fields; optional.

Ordered units

The number of units of the item ordered on a single order/billing history record that is associated with the specified offer/source combination.

Enter a number of units and select OK to display items in numeric sequence whose number of units is equal to or greater than your entry.

The system includes units cancelled if the cancel reason used to cancel the item is set to update demand (Reduce demand = Y).

If the Update Demand for Order Maintenance Transactions (C72) system control value is selected, the system includes units added to an order during order maintenance.

From the Qty ordered field in the Order/Billing History table for records whose Offer number and Source code match the specified offer/source code combination.

Numeric, 5 positions; optional.

Ordered value

The merchandise amount of the total units of the item ordered on a single order/billing history record that is associated with the specified offer/source combination.

Enter a dollar amount and select OK to display items in numeric sequence whose ordered merchandise amount is equal to or greater than your entry.

A negative amount displays if the order line has been cancelled and the cancel reason used to cancel the item is set to update demand (Reduce demand = Y).

If the Update Demand for Order Maintenance Transactions (C72) system control value is selected, the system includes items added to an order during order maintenance.

From the $ order total field in the Order/Billing History table for records whose Offer number and Source code match the specified offer/source code combination.

Numeric, 11 positions with a 2-place decimal; optional.

Returned units

The number of units of the item returned on a single order/billing history record that is associated with the specified offer/source combination.

If the item has been returned on more than one order associated with the specified offer/source combination, the item displays multiple times on the screen.

Enter a number of units and select OK to display items in numeric sequence whose number of returned units is equal to or greater than your entry.

From the Qty returned field in the Order/Billing History table for records whose Offer number and Source code match the specified offer/source code combination.

Numeric, 5 positions; optional.

Returned value

The merchandise amount of the total units of the item returned on a single order/billing history record that is associated with the specified offer/source combination.

If the item has been returned on more than one order associated with the specified offer/source combination, the item displays multiple times on the screen.

Enter a dollar amount and select OK to display items in numeric sequence whose returned merchandise amount is equal to or greater than your entry.

From the $ returned total field in the Order/Billing History table for records whose Offer number and Source code match the specified offer/source code combination.

Numeric, 11 positions with a 2-place decimal; optional.

Percent

The percent of units returned for the item on orders associated with the specified offer/source combination.

Populated only if the Qty returned and Qty ordered fields are both populated for a single order/billing history record. Both of these fields may be populated if you consolidate order/billing history using the Consolidating Order Billing History (MOBH) menu option.

The system performs the following calculation to determine the return percent: Returned units / Ordered units x 100 = Percent returned.

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