Date

The date the Pricing Upload record was created.

Enter a valid date and select OK to display Pricing Upload records in descending date sequence, starting with the date you enter.

Numeric, 6 positions (in user date format); optional.

Type

The type of Pricing Upload record.

Valid values are:

• SRC = Special Pricing by Source upload record. The system creates, updates, or deletes a record in the Special Pricing by Source table.

• QPM = QPM Detail upload record. The system creates, updates, or deletes a record in the QPM Detail table.

Select a type and select OK to display Pricing Upload records that match the type you selected.

Alphanumeric, optional.

Action

Indicates whether the Pricing Upload record creates, updates, or deletes a record in the Special Pricing by Source or QPM Detail table.

Valid values:

• Update = Create or update a record. The system determines whether the Pricing Upload record creates or updates an existing record by comparing the information in the Pricing Upload record with the existing records in the Order Management System table. See Uploading Special Pricing by Source Records and Uploading Quantity Price Matrix Detail Records for more information on how the system determines if the Pricing Upload record creates a new record or updates an existing record.

• Delete = Delete a record. The system uses the information in the Pricing Upload record to determine which record in the Special Pricing by Source or QPM Detail table to delete.

Select an action and select OK to display Pricing Upload records that match the action you selected.

Alphanumeric, optional.

Status

The status of the Pricing Upload record.

Valid values:

• Unprocessed = The Pricing Upload record has not yet been processed.

• Processed = The Pricing Upload record has been processed, but the update to the Order Management System table has not yet occurred.

• Error = The Pricing Upload record contains errors. See Pricing Upload Interface Errors.

Select a status and select OK to display Pricing Upload records that match the status you selected.

Alphanumeric, optional.

Error

A description of the error.

Enter a full or partial error and select OK to display Pricing Upload records whose error description contains your entry.

Alphanumeric, 30 positions; optional.

Type

The type of Pricing Upload record.

Valid values are:

• SRC = Special Pricing by Source upload record. The system creates, updates, or deletes a record in the Special Pricing by Source table.

• QPM = QPM Detail upload record. The system creates, updates, or deletes a record in the QPM Detail table.

Alphanumeric, 3 positions; display-only.

Status

The status of the Pricing Upload record.

Valid values:

• Unprocessed = The Pricing Upload record has not yet been processed.

• Processed = The Pricing Upload record has been processed, but the update to the Order Management System table has not yet occurred.

• Error = The Pricing Upload record contains errors. See Pricing Upload Interface Errors.

Alphanumeric, display-only.

Action

Indicates whether the Pricing Upload record creates, updates, or deletes a record in the Special Pricing by Source or QPM Detail table.

Valid values:

• Update = Create or update a record. The system determines whether the Pricing Upload record creates or updates an existing record by comparing the information in the Pricing Upload record with the existing records in the Order Management System table. See Uploading Special Pricing by Source Records and Uploading Quantity Price Matrix Detail Records for more information on how the system determines if the Pricing Upload record creates a new record or updates an existing record.

• Delete = Delete a record. The system uses the information in the Pricing Upload record to determine which record in the Special Pricing by Source or QPM Detail table to delete.

Alphanumeric, display-only.

Error

A description of the error. See Pricing Upload Interface Errors for a list of errors.

Alphanumeric, 30 positions; display-only.

Seq #

A unique sequence number assigned to the Pricing Upload record.

Numeric, 9 positions; display-only.

Date

The date the Pricing Upload record was created.

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

Item

The item defined for the Pricing Upload record.

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

Special Pricing by Source

The item associated with the special source price.

Corresponds to the ITM Number field in the Special Pricing by Source table.

QPM Detail

A code for the item associated with the quantity price matrix detail.

You must define an item category or item for a quantity price matrix price, but not both.

Corresponds to the Item field in the QPM Detail table.

Alphanumeric, 12 positions; required for SRC record type.

SKU

Displays for QPM Pricing Upload records only.

A code for the SKU of the item associated with the quantity price matrix detail. SKU codes are defined in and validated against the SKU table.

• If you define a SKU for the item, only the SKU specified qualifies for the quantity price matrix detail.

• If you do not define a SKU for the item, all of the SKUs for the item qualify for the quantity price matrix detail.

Corresponds to the SKU field in the QPM Detail table.

Alphanumeric, 14 positions; optional.

Quantity

Special Pricing by Source

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

Corresponds to the Qty field in the Special Pricing by Source table.

QPM Detail

The quantity of the item that must be ordered to qualify for the quantity price matrix detail. The item qualifies for the quantity price matrix detail if the order line quantity is less than or equal to the quantity pice matrix detail.

You cannot create more than one quantity price matrix price break for the same item category and quantity, item and quantity, or item and SKU and quantity.

Corresponds to the Quantity field in the QPM Detail table.

Numeric, 5 positions; required.

Source

The source code associated with the pricing upload record.

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

Special Pricing by Source

The source code associated with the Special Pricing by Source record. Corresponds to the Source Code field in the Special Pricing by Source table.

QPM Detail

The source code that must exist on the order header in order to qualify for the QPM price. Corresponds to the Source field in the QPM Detail table.

Alphanumeric, 9 positions; required for Record Type SRC.

Price

The price at which the item will be sold if the pricing requirements are met.

Special Pricing by Source

Corresponds to the Price field in the Special Pricing by Source table.

Note: For Special Pricing by Source records, the price cannot be greater than 7 positions with a 2 place decimal.

QPM Detail

Corresponds to the Price field in the QPM Detail table.

Numeric, 9 positions with a 2 place decimal; required for Record Type SRC.

Tax Inclusive Price

The price at which the item will be sold to customers if the order is subject to VAT and if the pricing requirements are met.

Note: This field displays only if the Tax Included in Price (E70) system control value is selected.

Special Pricing by Source

Corresponds to the Tax Price field in the Special Pricing by Source table.

Note: For Special Pricing by Source records, the tax price cannot be greater than 7 positions with a 2 place decimal.

QPM Detail

Corresponds to the Tax Price field in the QPM Detail table.

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

Associate Price

Displays for SRC Pricing Upload records only.

The price at which the item will be sold to associate customers if the pricing requirements are met.

Corresponds to the Associate Price field in the Special Pricing by Source table.

Note: The associate price cannot be greater than 7 positions with a 2 place decimal.

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

Tax Inclusive Associate Price

Displays for SRC Pricing Upload records only.

Note: This field displays only if the Tax Included in Price (E70) system control value is selected.

The price at which the item will be sold to associate customers if the order is subject to VAT and if the pricing requirements are met.

Corresponds to the Associate Tax Price field in the Special Pricing by Source table.

Note: For Special Pricing by Source records, the associate tax price cannot be greater than 7 positions with a 2 place decimal.

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

QPM Code

Displays for QPM Pricing Upload records only.

The quantity price matrix code associated with the QPM Detail price. QPM codes are defined in and validated against the QPM Header table.

Corresponds to the Code field in the QPM Detail table.

Alphanumeric, 4 positions; required for Record Type QPM.

Item Category

Displays for QPM Pricing Upload records only.

A code for the item category associated with the quantity price matrix detail.

You must define an item category or item for a quantity price matrix price, but not both.

Item category codes are defined in and validated against the Item Category table.

Corresponds to the Item Category field in the QPM Detail table.

Alphanumeric, 4 positions; optional.

Customer Sold To #

Displays for QPM Pricing Upload records only.

The sold to customer that must exist on the order in order to qualify for the QPM price.

Customer sold to numbers are defined in and validated against the Customer Sold To table.

Corresponds to the Customer field in the QPM Detail table.

Numeric, 9 positions; optional.

Customer Price Group

Displays for QPM Pricing Upload records only.

The customer price group for the sold to customer on the order header in order to qualify for the QPM price.

Customer price group codes are defined in and validated against the Customer Price Group table.

Corresponds to the Price Group field in the QPM Detail table.

Alphanumeric, 4 positions; optional.

Expire date

Displays for QPM Pricing Upload records only.

The date the quantity price matrix price expires. The date cannot be earlier than the current date.

Corresponds to the Exp Date field in the QPM Detail table.

Numeric, 6 positions (in user date format); optional.

Discount %

Displays for QPM Pricing Upload records only.

The percentage of the quantity price matrix detail price when the item ordered is eligible for the quantity price matrix special. For example, 10 means the item qualifies for a 10% discount. Corresponds to the Discount % field in the QPM Detail table.

Example: The % discount is based on the following criteria:

• customer price group = QPM1

• item category = HG

• quantity = 2

• % discount = 10

The 10% discount is based on the quantity price matrix detail defined for item category HG and quantity 2:

• item category = HG

• quantity = 2

• price = 10.00

In this example, the 10% discount is a 1.00 discount (10.00 QPM detail - 10% QPM special = 9.00 discount price)

If a quantity price matrix detail is not defined for item category HG and quantity 2, the system uses the next lowest quantity for the item category (in this example, the system uses item category HG and quantity 1). See Calculating the QPM Price for more information on how the system finds the price for a quantity price matrix detail and quantity price matrix special.

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