Assortments
Stores detailed records of product assortments, including grouping definitions, categorization logic, and distribution parameters. This data is used to define which products are grouped together for marketing, distribution, or regulatory purposes.
Columns
| Name | Type | ReadOnly | Description |
| ID [KEY] | String | True |
Unique identifier for the assortment record, used as the primary key within the system. |
| Assortment Type | String | True |
Specifies the object type classification of the assortment, corresponding to the Veeva Vault type schema defined for this record. |
| Global ID | String | True |
System-generated global identifier used across environments for consistent reference to the same assortment record. |
| Link | String | False |
Internal system link that provides a direct reference or URL to the assortment record within Veeva Vault. |
| Name | String | False |
Descriptive name assigned to the assortment, typically used for user-friendly display and search. |
| Status | String | False |
Current lifecycle state of the assortment, such as Active, Inactive, or Archived, depending on business rules. |
| Created By | String | True |
User identifier of the individual who originally created the assortment record. |
| Created Date | Datetime | True |
Timestamp representing the date and time when the assortment record was created in the system. |
| Last Modified By | String | True |
User identifier of the last person to make changes to the assortment record. |
| Last Modified Date | Datetime | True |
Timestamp indicating the most recent update to the assortment record. |
| Account Group | String | False |
Name or identifier of the account group associated with the assortment, used to group related accounts together. |
| Account Record Type | String | False |
Specifies the record type associated with the account linked to this assortment, reflecting business-specific categorization. |
| All Others | Bool | False |
Boolean value indicating whether the assortment is inclusive of all other non-explicitly listed records or accounts. |
| Assortment Group | String | False |
Identifier for the grouping of assortments used to manage collections of related assortment records. |
| End Date | Date | False |
The final date on which the assortment is valid or active, after which it is no longer applicable. |
| External ID | String | False |
Custom identifier used by external systems to reference this assortment, allowing cross-system integration and traceability. |
| Inventory Monitoring Record Type | String | False |
Specifies the type of inventory monitoring record associated with the assortment, relevant for integration with inventory systems. |
| Order Record Type | String | False |
Defines the record type of any related orders linked to this assortment, used to categorize order behavior or rules. |
| Product Bound | Bool | False |
Boolean value that indicates whether the assortment is explicitly tied to one or more specific products. |
| Start Date | Date | False |
The initial date when the assortment becomes active or valid for use in processes or reporting. |
| Owner | String | False |
Identifier for the user or role responsible for managing or overseeing the assortment record. |
| Legacy CRM Id | String | False |
Identifier used in legacy Customer Relationship Management (CRM) systems to refer to this assortment, supporting data migration and reference continuity. |