Skip to content

catalog_product_groups

Sales Proposition product group (contract) definitions, scoped to client workspaces.

Column Description
id Unique identifier for the product group
internal_reference Internal reference code for the product group
contract_earliest_start_date Earliest allowed contract start date for products in this group
contract_latest_start_date Latest allowed contract start date for products in this group
contract_earliest_end_date Earliest allowed contract end date for products in this group
contract_latest_end_date Latest allowed contract end date for products in this group
workspace_id The ID of this workspace
created_at Timestamp indicating when the product group was created
updated_at Timestamp indicating when the product group was last updated
default_expiry_duration_in_seconds Default duration, in seconds, before an unconfirmed booking against this group expires
allow_booking_expiry_timer Whether the booking expiry timer is enabled for this product group
academic_year Academic year this product group applies to
agreement_id Identifier of the agreement associated with this product group
cancellation_policy_id Identifier of the cancellation policy applied to this product group
state Current lifecycle state of the product group
publish_start_date Date from which this product group is published
publish_end_date Date after which this product group is no longer published
publish_state Publish status of the product group
type Type of the product group
product_segment Sales segment this product group belongs to
contract_template_external_id External identifier of the contract template used by this product group
requires_cancellation_policy Whether products in this group require a cancellation policy
timestamp Date when the table was last synchronized