Source

A unique, user-defined code to identify a segment of your customer base and to analyze sales. The source code drives marketing, pricing, freight, and service charge information on an order.

Alphanumeric, 9 positions; optional.

Description

The description of the source code.

Alphanumeric, 30 positions; optional.

Division

A unique code for a profit center or area of financial reporting.

Alphanumeric, 2 positions; optional.

Promotion

A code representing a way of grouping source codes for reporting and marketing purposes. You can also set up a promotion to:

• display a pop-up message in order entry;

• apply a merchandise, freight item category, BOGO (Buy One/Get One), or additional freight discount to eligible orders;

• override the ship via on an order.

Depending on your setup, the promotion you enter here might be automatically assigned to orders using the source code. See Working with Promotions (WPRO) for more information on setting up promotions and how the system determines whether to apply a promotion discount to an order.

Alphanumeric, 7 positions; optional.

Offer

A code for a catalog, space, or television advertisement from which you accept orders.

Note: To review all source codes for a particular offer, use the Source Codes option in Working with Offers (WOFR) to advance to the Work with Source Codes for Offer screen. This screen includes all the same options as the Work with Source Codes Screen.

Alphanumeric, 3 positions; display-only.

Source code

A unique, user-defined code to identify a segment of your customer base and to analyze sales. The source code drives marketing, pricing, freight, and service charge information on an order.

Alphanumeric, 7 positions.

Create screen: required.

Change screen: display-only.

Description

The description of this source code.

Alphanumeric, 30 positions; required.

Division

A unique code for a profit center or area of financial reporting.

Division codes are defined in and validated against the Division table; see Working with Divisions (WDIV).

Alphanumeric, 2 positions; required.

Offer

The code for the catalog, space, or television advertisement from which you accept orders.

Offers are defined in and validated against the Offer table; see Working with Offers (WOFR).

Note: If the Multi Currency by Offer (E03) system control value is set to Y, the system confirms that the division and the offer you select for a source code both point to the same currency.

Alphanumeric, 3 positions; required.

Category

A code to categorize your source codes, such as buyers, recipients, or rented names.

Source code categories are defined in and validated against the Source Code Category table. See Working with Source Categories (WSCT).

Alphanumeric, 2 positions; optional.

Type

A code that specifies whether this source code should be used in the source code profit analysis calculations.

Valid values are:

• Known

• Do not analyze

• Unknown

To total the sales on the Source Code Profit Analysis report, the system first calculates the percentage of the total sales for each type K source code. Sales for the type U source codes are then divided based on these percentages and added proportionately to the type K source codes. Type N (unknown) sales are not added.

The chart below illustrates how sales are calculated.

In the table above, the sales for all type K source codes is 900.00. The percentage of total sales is 33% from source code ABC100 and 67% from source code ABC200.

The total sales for type U source codes is $600.00. 33% of type U sales ($200.00) is added to the sales from source code ABC100. 67% ($400.00) is added to the sales from source code ABC200.

The reported sales for sales from ABC100 becomes $500.00.

The reported sales from ABC200 becomes $1000.00.

The total type K reported sales becomes $1500.00.

Alphanumeric, 1 position; required.

Price method

A code that determines how the system prices items on orders using this source code.

Valid values are:

• Use Item Cost

• Regular Plus Reprice

• No Charge

• No Charge/No Cost

• Regular Hierarchy

Each source code pricing method is described briefly below:

Use Item Cost

This pricing method uses the item's cost from the SKU table. Depending on the Costing Method (A25) you use, the particular field in the SKU table is:

Standard costing: Standard cost

Average costing: Average cost

FIFO costing: FIFO cost (that is, weighted average FIFO cost)

The actual cost of an item may differ when you bill the order; however, the cost on the order line does not change after entry to the current cost. See FIFO Costing Overview.

Typically, this method is used for source codes established for employee sales or internal transfers of merchandise from warehouses to stores. This pricing method overrides any other pricing method. The item's cost is the price your company paid for the product.

Regular Plus Reprice

This is a header-level pricing method that uses the pricing hierarchy defined in the System Control table to determine the price on a line. When the price has been calculated, the system will reprice the line using any header-level discounts that may be in effect, such as Volume Discount Pricing. See Setting Up Order Entry Values.

No Charge

This pricing method indicates that items on orders with this source code will be given to the customer at “no charge,” but the cost of the item will be tracked to calculate the gross profit margin.

For example, this pricing method may be used for source codes created to track external sales from stock liquidations.

No Charge/No Cost

This method indicates that items on orders with this source code will be given to the customer at no charge and the item cost will not be tracked. For example, this pricing method may be used for source codes created to track internal transfers of stock.

Reg Hierarchy

This is a line-level pricing method that uses the pricing hierarchy established in the System Control table to determine the item price.

When the Best Way Pricing (A78) system control value is set to N, the system uses the first price it finds in the pricing hierarchy for the item.

When this system control value is set to Y, the system searches through each level in the pricing hierarchy, finds a price at each level, and uses the best price for the item.

If You Do Not Use Repricing

If you do not use repricing during order entry, set the Price method for your source codes to Regular Hierarchy so that the system does not reprice the order. An error message displays if you select Reprice during order entry: Repricing is not valid with current source price method. By setting the Price method to Regular Hierarchy, you can eliminate repricing processing during order entry and improve order entry performance.

Required.

Discount %

(Discount percentage)

A discount for orders assigned to this source code. This discount does not apply to orders with a Use Item Cost, No Charge, or No Charge/No Cost pricing method, or to order lines with a price override reason code applied. This discount is applied in addition to any discounts resulting from other pricing methods. The discount is calculated during Order Entry or Order Maintenance.

This discount applies only to items with a Y in the Discountable field in the Item or SKU table.

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

Freight method

A code that determines how freight charges will be calculated for this source code. Order-level and line-level freight methods are below.

See Freight Charges for a description of each freight method and set up instructions.

Order-level freight methods:

Dollar chart by offer ($ Chart by Ofr): Allows you to charge freight based on the dollar amount of the merchandise ordered for each shipping address on an order. The dollar tier levels and the corresponding freight charges are defined for each offer. See Dollar chart by offer ($ Chart by Ofr) freight for more information.

Dollar chart by source ($ Chart by Src): Allows you to charge freight or service charges based on the dollar amount of the merchandise ordered for each shipping address on an order. The dollar tier levels and the corresponding freight or service charges are defined for each source code. See Dollar chart by source ($ Chart by Src) freight for more information.

Actual billing amount (Actual Bill Amt): Uses the total weight of all the items on the order and the shipper to determine the actual freight charge during Confirmation or Billing. See Actual billing amount (Actual Bill Amt) freight for more information.

Flat rate by ship-to (Flat Rt/Ship To): Uses the flat freight fee defined for the source code (Flat freight rate field) for the source code. See Flat rate by ship-to (Flat Rt/Ship To) freight for more information.

Percentage by source (% Source): Multiplies the merchandise amount of the order by the percentage in the Freight% field for the source code. See Percentage by source (% Source) freight for more information.

Percentage by ship via (% Ship Via): Multiplies the merchandise amount of the order by the percentage in the Freight percent field in the Ship Via table. See Percentage by ship via ($ Ship VIa) freight for more information.

Recipient: Calculates freight by dollar based on the merchandise total of the order including all recipient orders. The Maximum number of ship to’s field defined for the source code is checked. If the number of recipients on the order is less than or equal to this value, the Dollar Chart by Offer will determine the freight fee, based on the merchandise total.

Once the maximum number of recipient orders is reached, the system includes a flat amount with the freight amount for each additional recipient order. See Recipient freight for more information.

Freight by offer price (By Offer Price): Uses the Dollar Chart by Offer to calculate freight, based on the total merchandise value of the order. For this freight method, the merchandise value is calculated by adding the extended single-unit offer price for each item/SKU, disregarding any discounts, associate pricing, price overrides, quantity break pricing, etc. See By Offer Price freight for more information.

Freight by order weight (Order Weight): This freight method is based on the total weight of the order and the number of cartons required to ship the order. See Freight by order weight (Order Weight) freight for more information.

Line-level Freight Methods:

Flat rate by item (Flat Rt/Item): Allows you to charge one freight amount per item, regardless of the quantity ordered of the item. The Freight is defined for each item in the associated Item Offer (default) or SKU Offer table. The freight total represents the accumulation of each item's flat freight fee. See Flat rate by item (Flat Rt/Item) freight for more information.

Flat rate by quantity (Flat Rt/Qty): Allows you to charge a flat rate for a certain number of units ordered and add an additional charge for each unit thereafter. See Flat rate by quantity (Flat Rt/Qty) freight for more information.

Flat rate by item source (Flat Rt/Itm Src): Uses a flat freight charge for each unit ordered multiplied by the number of units ordered. See Flat rate by item source (Flat Rt/Itm Src) freight for more information.

Item (By Item): Uses the freight charge defined in the Item Offer record, multiplied by the quantity ordered. See Item (By Item) freight for more information.

Weight: Uses the weight of each item (defined in the Item or SKU table) and the rate for the shipper. The weight of the item is multiplied by the quantity ordered to calculate the total weight for the order line. In order to determine the freight charge, the system references the associated rate chart for each line, based on the total weight and delivery zone. See Weight freight for more information.

Required.

Flat amt (Flat amount)

A flat fee for freight, used in the following freight methods:

• Flat Rate/Ship To (F)

• Flat Rate/Quantity (FQ)

• Flat Rate/Item Source (FS)

• Recipient (R)

Each freight method is described briefly below (see Freight method for more details):

Flat Rate/Ship To (F): This method uses the value in the Flat amt field in the Source Code table if any; otherwise, uses the flat fee defined for the Offer. The charge defined in the Flat amt field is used as the freight fee for orders assigned to this source code.

Flat Rate/Quantity (FQ): This method uses the Flat amt as the freight fee for a certain number of units on the order, and then an additional charge is added for each unit thereafter.

Flat Rate/Item Source (FS): This method uses the Flat amt multiplied by the quantity ordered.

Recipient (R): This method includes the Flat amt in the freight bucket for any recipient added to an order that exceeds the number in the Max shp tos-frt (Maximum ship to's, freight) field. See Recipient freight for an example.

Numeric, 7 positions with a 2 place decimal; optional.

Freight % (Freight percentage)

A percentage used to calculate freight on an order, based on the total merchandise amount on the order. Used in the Percentage by Source (PS) freight method. This method also considers the values in the Frt min and Frt max fields in the Source Code table. The system will limit the freight fee to the minimum or maximum amount you define if the results of the freight calculation exceed these values.

Note: If the Include Handling in Freight Charge Calculation (D77) system control value is selected, the system will also include handling along with merchandise in the freight charge calculation.

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

Secondary frt (Secondary freight)

Used in the Flat Rate/Quantity (FQ) freight method, in which you charge a flat rate for a certain number of units ordered and an additional charge for each unit thereafter.

The calculation is: Flat amt + ((Qty ord - Up to Frt qty) * Secondary frt)

The Flat amt and Up to frt qty fields are defined in the Source Code table.

The secondary freight fee is added for each unit above the amount in the Up to frt qty field.

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

Frt min (Freight minimum)

Used in the Percentage/Source (PS) freight method, in which the merchandise total is multiplied by the value in the Freight % field.

Note: If the Include Handling in Freight Charge Calculation (D77) system control value is set to Y, the system will also include handling along with merchandise in the freight charge calculation. The system uses the freight charge in the Frt min field if the result of this calculation is less than the value in the Frt min field.

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

Frt max (Freight maximum)

Used in the Percentage/Source (PS) freight method, in which the total merchandise amount on the order is multiplied by the value in the Freight % field. The system will use the freight charge in the Frt max field if the result of this calculation is greater than the value in the Frt max field.

Note: If the Include Handling in Freight Charge Calculation (D77) system control value is set to Y, the system will also include handling along with merchandise in the freight charge calculation.

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

Up to frt qty (Up to freight quantity)

Used in the Flat Rate/Quantity (FQ) freight method. This method enables you to charge a flat rate for a certain number of units ordered and add an additional charge for each unit thereafter.

The calculation is: Flat amt + ((Qty ord - Up to Frt Qty) * Secondary frt)

The values in the Flat amt, Up to frt qty and Secondary frt fields are defined in this table. The secondary freight fee will be included in this calculation when the quantity ordered exceeds the value in the Up to frt qty field.

Numeric, 5 positions; optional.

Max shp tos-frt (Maximum ship to's, freight)

Used in the Recipient (R) freight method, which uses Working with Dollar Chart by Offer (WDCO) to determine the freight fee, based on the total merchandise dollars on the buyer's order.

• If the number of recipients on the order is less than or equal to the value in the Max ship to's - frt field, the dollar chart freight fee will be used as the freight charge on the order.

• For any recipient added to an order that exceeds the number in this field, the system includes the Flat amt in the freight bucket along with the dollar chart freight fee.

Note: If the Include Handling in Freight Charge Calculation (D77) system control value is Y, the system will also include handling along with merchandise in the freight charge calculation.

See Recipient freight for an example.

Numeric, 3 positions; optional.

Freight table

Defines the freight table to use when using the freight by order weight (OW) freight method. See Working with Weight Tables for Order Weight (WFTB) for more information on working with freight tables.

Alphanumeric, 3 positions; required if using freight by order weight.

Mail date

The date the offer was mailed to this list. You can enter this date manually.

Numeric, 6 positions; optional.

House acct code (House account code)

Specifies whether this list was generated from your company's own “house” list or from a broker's rented list.

Valid values are:

• House Account

• In House

Optional.

Mktg proj (Marketing projection)

The total projected amount of responses (sales) for this source code. User-defined and informational only.

Numeric, 7 positions with a 2 place decimal; optional.

Proj names (Projected names)

The broker's projected number of names that will be generated from this source code. Informational only.

Numeric, 5 positions; optional.

Reqs mailed (Requests mailed)

The total number of catalog requests mailed to this source code. The system updates this field when you select the Catalog Request Printing option.

Numeric, 7 positions; optional.

Net circ (Net circulation)

The number of names rented or generated for the mailing, after duplicate names have been removed.

The calculation is: Gross circulation - Duplicate names

Numeric, 7 positions; optional.

List source

The broker's key code for this list segment. List source codes are defined in and validated against the List Source table.

Alphanumeric, 7 positions; optional.

List cost

The cost to purchase this list from the broker. Informational only.

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

Gross circ (Gross circulation)

The total number of names rented or generated for the mailing, including duplicate names. Informational only.

Numeric, 7 positions; optional.

B/E amount (Break even amount)

A value that allows you to analyze the cost of an offer.

The calculation is: Break even amount / Net circulation = Cost per offer

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

List broker

The code for this list broker who provided the list of names. This code is used for source codes assigned to rented lists and is informational only.

Numeric, 3 positions; optional.

Drop code

The number assigned to the catalog mailing to this list of customers. Drop codes are assigned to each mailing; some customers may be included in several drops of the same catalog, to spread out circulation and encourage purchases.

Alphanumeric, 2 positions; optional.

Promo code (Promotional code)

A code to group source codes together. In the hierarchy of the system, Promotion Codes fit between Source Codes and Offers. Reporting can be performed at the Promotion Code level.

You can also set up a promotion to:

• display a pop-up message in order entry;

• apply a merchandise, freight item category, BOGO (Buy One/Get One), or additional freight discount to eligible orders;

• override the ship via on an order.

A pop-up message you specify for the promotion displays in order entry only if you enter the promotion code here. Also, if an order is qualified for more than one promotion of a certain type, the promotion code you enter here takes first priority.

If you enter a promotion code in this field the Exclude promotion field must be unselected or an error message indicates: Promotion not allowed with Exclude promotions set to Y.

See Working with Promotions (WPRO).

Alphanumeric, 7 positions; optional.

Cover code

A code for the catalog cover mailed to this source code (group of names).

Alphanumeric, 2 position; optional.

B/O priority (Backorder priority)

Determines the backorder priority to default to orders with this source code, where:

• 9 = highest priority

• 0 = lowest priority

The Evaluate Backorders program runs in the background and matches available inventory (received through P.O. Receiving, Inventory Transactions, or any process that increases the on-hand quantity of an item) to backorders.

The backorder priority defined at the source code level does not affect Immediate Reservation.

See Working with the EBO_ASYNC Job for more information on the Evaluate Backorders function.

Numeric, 1 position, optional.

Flex pay code (Flexible payment code)

Represents a deferred or installment flexible payment option for orders with this source code.

An error message similar to the following indicates if you enter a code in this field and also enter Y in the Exclude FPO field: Flexible Payment Option and Exclude FPO both cannot be entered.

Flexible payment codes are defined in and validated against the Flexible Payment Option table. See Working with Flexible Payment Options (WFPO) for more information on deferred and installment payment plans.

Alphanumeric, 5 positions; optional.

Con/Bus (Consumer/Business)

Used in list segmentation that identifies the targets of the list as consumers or businesses. Informational only.

Valid values are:

• Consumer

• Business

Optional.

Price table

Represents a table containing repricing and premium information for orders with this source code. Price table codes are defined in and validated against the Price Table table. See Working with Price Tables (WPTB).

Alphanumeric, 5 positions; optional.

Display on O/E (Display in Order Entry)

Determines whether this source code appears when you prompt on the Source field during Order Entry/Maintenance or when entering a catalog request.

Valid values are:

• selected = The source code displays in the Select Source pop-up window

• unselected = (default): The source code does not display in the Select Source pop-up window

Promo pricing (Promotional pricing)

Indicates whether orders for this source code are eligible for any of the promotional pricing methods, which define bonus items or discounts based on the order, the dollar amount of the order, the items ordered from the same price group, or specific items ordered.

Promotional pricing is controlled by the order type used on the order. In the Order Type table you can suppress promotional pricing windows from appearing, for example, when entering mail or fax orders.

See Setting Up Pricing Information.

• selected = An order with this source code is eligible for promotional pricing.

• unselected = An order with this source code is not eligible for promotional pricing.

Restricted

Restricts the use of a source code. Restricting a source code prevents it from being assigned to an order. This restriction is useful for identifying source codes you no longer use, but cannot delete since there are still open orders outstanding.

Set to N when the source code is created.

During Offer Initialization, you have the option to restrict all sources codes associated with a particular offer; the source codes you restrict are not copied to the offer being initialized. See Initializing an Offer (MOFI).

Valid values are:

• selected = This source code cannot be used.

• unselected = (default): This source code can be used.

Excl FPO (Exclude flexible payment option)

Determines whether the source code is excluded from deferred and installment payment plans.

Valid values are:

• selected = Exclude this source code from deferred and installment payment plans. If an order contains a source code that is excluded from deferred and installment payment plans, the entire order is excluded from the payment plan. An error message similar to the following indicates if you try to assign a payment plan to an order containing a source code that is excluded from a payment plan: Order is not eligible for deferred/installment billing plan.

• unselected = Do not exclude this item from deferred and installment payment plans.

An error message similar to the following indicates if you do not select this field and also enter a code in the Flexible payment code field: Flexible Payment Option and Exclude FPO both cannot be entered.

See Deferred/Installment Billing Overview for more information on deferred and installment payment plans.

Excl serv chg (Exclude service charges)

Indicates whether any service charges by ship via or guaranteed service charges by offer can be added to orders.

• selected = Add ship via service charges and guaranteed service charge by offer to orders with this source code.

• unselected = Do not add ship via service charges or guaranteed service charge by offer to orders with this source code.

See Working with Ship Via Codes (WVIA) for information on establishing a service charge dollar chart for a shipper, and see Working with Offers (WOFR) for information on setting up a guaranteed service charge by offer.

Note: This field does not control whether to add service charges by offer that you set up through a dollar chart.

Excl promotion (Exclude promotion)

Indicates if this source code is excluded from any promotions you create using the Working with Promotions (WPRO) menu option. You may want to exclude a source code from promotions if you want to establish a promotion by offer, but exclude certain source codes.

Valid values:

• selected = Exclude this source code from promotions.

• unselected (default) = Include this source code in promotions if the source code qualifies.

If you select this field, you cannot enter a promotion code in the Promotion code field or an error message indicates: Promotion not allowed with Exclude promotions set to Y.

If you select this field, you receive an error message if you enter this source code in the Qualifying source field on the Create Promotion Screen or Change Promotion Screen: Source code flagged to exclude promotions.

Note: You can only exclude promotions created using the Work with Promotion Values menu option. This field does not apply to promotions created using the Work with Promotional Pricing (WPRP) menu option.

See Working with Promotions (WPRO) for more information on setting up promotions.

Pop up wind msgs (Pop up window messages #1 - #4)

Use these fields to enter messages that display in Order Entry automatically for orders using this source code. You may enter up to 4 short messages for this source code.

Pop-up window messages appear in Order Entry only if the order type allows promotional pricing windows. For example, you can suppress messages from displaying when entering mail or fax orders.

If you set up promotional windows, using options on the Pricing menu, these source code-related windows appear before the promotional pricing windows.

If you set up customer informational windows in the Customer table, these windows appear before the source code windows.

Alphanumeric, 30 positions each line; optional.

Source code

Displays the new source code, which is used to identify a segment of your customer base and analyze sales. The source code drives marketing, pricing, freight, and service charge information on an order.

Alphanumeric, 9 positions; display-only.

% net fill (Percent net fill)

The percent of goods actually shipped for this source code, after cancels and returns.

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

% margin (Percent margin)

The profit margin for this source code, expressed as a percentage. The calculation is:

Retail price - Cost of goods sold

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

Cost per order

The operations expense associated with taking an order for this source code.

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

Recency code

A code used to group buyers who have made purchases within the same time frame, such as within the last 0-12 months. Each source code may be given a recency code to further identify buyers. Recency codes are defined in and validated against the Recency Code table; see Working with Recency Codes (WRCC).

Alphanumeric, 4 positions; optional.

Variable ad expense (Variable advertising expense)

The cost of producing and mailing a catalog.

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

User def % fld (User defined percentage field)

A field for you to enter a percentage for your own usage, such as for entry of a commission rate for the source code. You can use this field for reporting or querying purposes.

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

Warranty required

Defines whether the system displays the Customer Warranty Information screen in order entry and order maintenance. The Customer Warranty Information screen is used to enter warranty information for a warranty product on the order. See Working with Customer Warranty Information (WCST).

Valid values are:

• selected = The system displays the Customer Warranty Information screen in order entry and order maintenance.

• unselected = The system does not display the Customer Warranty Information screen in order entry and order maintenance.

Employee discount

Defines whether this source code is used for employee orders. Informational only.

• selected = The source code is used for employee orders.

• unselected = The source code is not used for employee orders.

Bypass credit check

Indicates whether orders containing this source code bypass the credit check process.

Valid values are:

• selected = Orders containing this source code bypass credit check. The system writes a message to order transaction history indicating that credit checking was bypassed.

• Note: Orders that bypass credit checking are still eligible for credit card authorization.

• unselected = Orders containing this source code do not bypass credit check.

If a user does not have authority to the Maintenance of Bypass Credit Check Field in Source Code File (A87) secured feature, an error message similar to the following indicates if the user tries to change the value defined in this field: Unauthorized to change Credit Check flag.

User fields 1-6

Six extra fields for you to enter additional information about this source code. You can use these fields for reporting or querying purposes.

Alphanumeric, 30 positions; optional.

Item

An item that is eligible for special source pricing.

Alphanumeric, 12 positions; optional.

Qty (Quantity)

The quantity of the item that must be purchased to receive the special price.

Numeric, 5 positions; optional.

Price

The price at which the item will be sold if quantity and source code requirements are met

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

Assoc price (Associate price)

The price at which the item will be sold to associate customers if quantity and source code requirements are met.

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

Tax inclusive price

The price at which the item will be sold to customers if the order is subject to VAT and if the quantity and source code requirements are met. Displayed only if the Tax Included in Price (E70) system control value is selected.

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

Tax-inclusive associate price

The price at which the item will be sold to associate customers if the order is subject to VAT and if the quantity and source code requirements are met. Displayed only if the Tax Included in Price (E70) system control value is selected.

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

Source

A unique user-defined code assigned to a group of customer names that make up a mailing list for an offer or advertisement.

Alphanumeric, 9 positions; display-only.

Item

A code that represents a unit of inventory. Item codes are defined in and validated against the Item table.

Note: If this item has SKUs, the prices defined here will apply to all SKUs associated with this item.

Alphanumeric, 12 positions.

Create screen: required.

Change screen: display-only.

Quantity

The quantity of the item that the customer must purchase to receive this price break.

Numeric, 5 positions.

Create screen: required.

Change screen: display-only.

Price

The selling price of the item when an order meets the defined source code and quantity requirements. This price applies to all SKUs of the item on the order.

Numeric, 7 positions with a 2-place decimal; required.

Tax inclusive price

The selling price of the item when an order meets the defined source code and quantity requirements and the order is subject to VAT. This price applies to all SKUs of the item on the order.

Displayed only if the Tax Included in Price (E70) system control value is selected.

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

Assoc price (Associate price)

The selling price of this item when an order meets the defined source code and quantity requirements and the customer is an associate.

Customers are eligible for associate price breaks if they are identified as associate customers in the Customer table and if Assoc = Selected in Order Entry.

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

Tax inclusive associate price

The selling price of this item when an order meets the defined source code and quantity requirements, the customer is an associate, and the order is subject to VAT.

Customers are eligible for associate price breaks if they are identified as associate customers in the Customer table and if Assoc = Selected in Order Entry.

Displayed only if the Tax Included in Price (E70) system control value is selected.

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

Source code

The unique user-defined code for the source and description of the source code.

(Source) Alphanumeric, 9 positions; display-only.

(Description) Alphanumeric, 30 positions; display-only.

Allow multi gifts? (Allow multiple gifts?)

Indicates if a customer can receive more than one free gift on an order.

• Selected = Apply more than one free gift on an order if the order qualifies.

• Unselected = Apply only free gift with the highest dollar level for which the order qualifies.

$ Required (Dollars required)

The merchandise dollar amount required on an order for the customer to be eligible for the free gift. You must enter a dollar amount of $0.01 or higher. You cannot enter a negative amount.

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

Item

The item to add as a free gift.

Alphanumeric, 12 positions; required.

SKU (Stock keeping unit)

If the specified item has SKUs, enter the SKU to add to qualifying orders.

Alphanumeric, three 4-position fields; required if the item has SKUs.

Qty (Quantity)

The number of units of the free gift item to add to the order.

Numeric, 5 positions; required.

Source code

A code used to identify a segment of your customer base.

Alphanumeric, 9 positions; display-only.

First order date

The date the first order was placed against this source code.

Numeric, 6 positions (in user date format); display-only.

Last order date

The date of the most recent order for this source code.

Numeric, 6 positions (in user date format); display-only.

Response % (Response percentage)

The percentage of response from this source code.

If you have received orders from this source code, the calculation is:

Orders / Net circulation

If you have not received orders from this source code, the calculation is:

# of catalog requests mailed / Net circulation

The net circulation value in both calculations is described in the next field.

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

Net circulation

The number of names rented from another company or generated from your own customer base (house list) for the catalog mailing, after duplicate names have been removed. This total includes customers who received catalogs because they requested them. The calculation is:

Gross circulation - Duplicate names

Numeric, 7 positions; display-only.

Requests mailed

The total number of responses by this source code to an offer.

The Catalog Request Print program updates this field when you use Processing Catalog Requests (PCAT). This number reflects the total number of requests rather than the number of copies; for example, if a customer requests 3 copies of a catalog, the system increases the Requests mailed by 1, not 3.

When you reset the Printed flag at the Change Catalog Request Screen in order to reprint the catalog request label, the system decreases this total. When you reprint the label, the system increases this total again.

Numeric, 7 positions; display-only.

Dollars per book

Average dollar value of orders per catalog distributed. The calculation is:

Total dollar value of orders / Net Circulation

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

Avg $ ordered (Average dollars ordered)

The average dollar value of an order. The calculation is:

Total dollars for orders/ Total orders

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

These fields contain life-to-date totals:

Orders # (Number of orders)

The total number of orders for this source code, including orders which include only sold out items or non-inventory items.

This total does not include:

• batch orders that have not yet been accepted. Once the batch has been accepted, the system updates the total number of orders by the number of orders in the batch for this source code.

• returns processed by negative quantities in order entry.

• order lines added to an existing order through order maintenance, regardless of the setting of the Update Demand for Order Maintenance Transactions (C72) system control value.

If an order includes more than one ship-to address, the entire order is considered one order. For example, an order with two ship to addresses updates the number of orders total by 1.

If the source code on all order detail lines is overridden to a different source code than the one on the order header, the orders are included in the total number of orders for the detail-level source code.

Numeric, 7 positions; display-only.

Orders $ (Order dollars)

The total dollar amount of all items ordered for this source code, including:

• the merchandise dollar total of soldout items or non-inventory items.

• the merchandise dollars for items added to an exiting order through order maintenance if the Update Demand for Order Maintenance Transactions (C72) system control value is selected.

This total does not include:

• merchandise dollars for items returned during order entry.

• merchandise dollars for batch orders that have not yet been accepted.

• merchandise dollars for items added to an existing order through order maintenance if the Update Demand for Order Maintenance Transactions (C72) system control value is unselected.

If the source code on all order detail lines is overridden to a different source code than the one on the order header, the order dollars are included in the total for the detail-level source code.

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

Sales # (Number of sales)

The number of shipments for this source code, including:

• shipments confirmed; the system updates the number of sales for each confirmed shipment.

• non-inventory items confirmed during billing.

• orders that are expressed billed.

This total is not decreased by returns or exchanges.

Numeric, 7 positions; display-only.

Sales $ (Sales dollars)

The merchandise dollar total of shipped items for this source code, including:

• shipments confirmed; the system updates the dollar total as each confirmed shipment.

• non-inventory items confirmed during billing.

• dollars on orders that are expressed billed.

This total does not include dollars for returns processed in order entry.

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

Cancels # (Number of cancellations)

The number of orders cancelled (orders in Cancelled status; all order lines have been cancelled) for this source code.

Note: The system only increments this number for orders cancelled with a cancel reason code whose Reduce demand field is unselected.

Numeric, 7 positions; display-only.

Cancels $ (Dollars canceled)

The merchandise dollar total of orders cancelled (orders in Cancelled status; all order lines have been cancelled) for this source code.

Note: The system only increments this number for orders cancelled with a cancel reason code whose Reduce demand field is unselected.

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

Returns # (Number of returns)

The total number of return transactions processed and credited for this source code.

You can enter a return in:

• order entry (via negative quantity ordered)

• order maintenance

• Work with Return Authorizations (this total increases only when you process the credit)

This total includes simple returns only, as opposed to exchanges.

Numeric, 7 positions; display-only.

Returns $ (Return dollars)

The merchandise dollar total of return transactions processed and credited for this source code.

You can enter a return in:

• order entry (via negative quantity ordered)

• order maintenance

• Work with Return Authorizations (this total increases only when you process the credit)

This total includes simple returns only, as opposed to exchanges.

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

Exchanges # (Number of exchanges)

The total number of exchange transactions processed for this source code.

You can enter an exchange in:

• order maintenance

• Work with Return Authorizations (this total increases only when you process the credit)

Numeric, 7 positions; display-only.

Exchanges $ (Exchange dollars)

The merchandise dollar total of returned items on exchange transactions processed for this source code.

You can enter an exchange in:

• order maintenance

• Work with Return Authorizations (this total increases only when you process the credit)

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

Soldouts # (Number of soldouts)

The total number of items sold out for this source code.

The total number of soldout orders, including orders for which all order lines are soldout, or at least one order line is soldout and all other order lines have been cancelled using any cancel reason code.

This does not include order lines that are sold out if other order lines exist on the order that are not sold out or cancelled.

The system considers an order line sold out if you process soldout order lines in order entry, order maintenance, or the Processing Auto Soldout Cancellations (MASO) menu option.

Numeric, 7 positions; display-only.

Soldouts $ (Soldout dollars)

The merchandise dollar total of items sold out for this source code.

The system considers an order line sold out if you process soldout order lines in order entry, order maintenance, or the Processing Auto Soldout Cancellations (MASO) menu option.

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

Source

The code and description for a segment of your customer base to whom you mail an offer.

(Source) Alphanumeric, 9 positions; display- only.

(Description) Alphanumeric, 30 positions; display-only.

Merch amount (Merchandise amount)

The merchandise dollar amount required to be eligible for the discount.

When evaluating an order to see if it meets the required merchandise total, the system includes sale items (based on the setting of the Sale item flag for the Item Offer or the Sale item flag for the SKU Offer) but does not include non-discountable items (based on the setting of the Discountable flag for the item).

Numeric, 9 positions with a 2-place decimal; required.

Standard discount

The dollar amount of the discount subtracted from the merchandise total on the order if the order is eligible for the source discount.

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

Associate discount

The dollar amount of the discount subtracted from the merchandise total on the order if:

• the order is eligible for the source discount, and

• the customer is identified as an associate customer (Associate = Selected in the Customer table)

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

Add'l code (Additional charge code)

A code that identifies why the discount was applied to the order. The system uses this code only if the Prorate Dollar Discounts and Coupons (D90) system control value is unselected.

Additional charge codes are defined in and is validated against the Additional Charges Code table; see Establishing Additional Charge Codes (WADC). This table contains codes to categorize the different types of charges or credits that may be added to an order.

If the Prorate Dollar Discounts and Coupons (D90) system control value is selected, the system does not use the additional charge code; instead, the discount amount is prorated against the order lines, as described in Prorating Logic.

Alphanumeric, 2 positions; required if the Prorate Dollar Discounts and Coupons (D90) system control value is unselected.