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 |