Mandatory Data (CPQ)

Type

Name

Fields

Mandatory

Type

Name

Fields

Mandatory

Master Data

Product

 

Core data

Customer

 

Core data

Product Extension

ProductCost

Mandatory:

  • SKU

  • Cost – defaults to attribute1

Optional:

  • Currency

  • Additional dimensions fields

Core data

Price List

 

Core data

Product Extension

  • PriceByCustomer 

  • PriceByCountry 

  • PriceByRegion 

  • PriceBySegment 

Mandatory:

  • SKU

  • Attribute1 – customer mapping

  • Attribute2 – cost

Optional:

  • Currency

Mandatory if the price of the product is not in the price list

Model Record

PriceOptimizer model

Mandatory:

  • Target price

  • Floor price

  • Stretch price

Optional:

  • Currency

Optional

Product Extension

PriceGuidance

Mandatory:

  • Target price

  • Floor price

  • Stretch price

Optional:

  • Currency

Optional

Product Extension

PriceCompetitors

Mandatory:

  • SKU

  • Competitor

  • Price

Optional:

  • Currency

Optional

Customer Extension

CustomerCashDiscount

Mandatory:

  • Customer ID

  • Discount

Optional

Price Parameter

StandardDiscount

Mandatory:

  • Customer ID

  • Dimensional keys

  • Discount

  • Value Type

Optional:

  • Currency

Optional

ExceptionDiscount

Mandatory:

  • Customer (key1)

  • Product (key2)

  • Discount (attribute1)

Optional:

  • Currency

Optional

Transaction Data

Sales data

Mandatory:

  • SKU

  • Customer ID

  • Quantity

  • Invoice price

  • Net price

  • Margin

  • Pricing data

Optional:

  • Unit price

  • Invoice ID

Optional

Â