Pricing [sn_shop_m2m_product_contract] table

  • Release version: Australia
  • Updated July 13, 2026
  • 1 minute to read
  • The Pricing [sn_shop_m2m_product_contract] table stores contract-specific product pricing information.

    This table contains the following fields.

    Table 1. Pricing table
    Field Data type Description
    Contract Reference Contract associated with the supplier product.
    Price Currency Single contractual price associated with the supplier product.
    Maximum price Currency Maximum price from price breaks for the supplier product.
    Minimum price Currency Minimum price from price breaks for the supplier product.
    Original unit cost Currency Original unit cost of the supplier product.
    Price type Choice Type of contractual pricing for the supplier product. The options are Single Price or Price Break.
    Display name String Display name for this relation.
    Price duration Choice Whether the contractual price is for a one-time purchase or a term purchase. The options are One Time or Term.
    ERP source Reference ERP source system associated with the supplier product contract.