Pricing [sn_shop_m2m_product_contract] table
The Pricing [sn_shop_m2m_product_contract] table stores contract-specific product pricing information.
This table contains the following fields.
| 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. |