ProductCatalog
Stores the master list of all products available within the CRM.
Columns
| Name | Type | ReadOnly | Description |
| ID [KEY] | String | True |
The unique identifier for the product record. |
| Global ID | String | True |
The global system identifier used for integration purposes. |
| Link | String | False |
The system-generated hyperlink or reference to the product record. |
| Product Name | String | False |
The name of the product for display and reference. |
| Status | String | False |
The current status of the product, such as Active or Inactive. |
| Created By | String | True |
The user who created the product record. |
| Created Date | Datetime | True |
The date and time when the product record was created. |
| Last Modified By | String | True |
The user who last modified the product record. |
| Last Modified Date | Datetime | True |
The date and time of the most recent modification to the product record. |
| Bundle Pack | Bool | False |
Indicates whether the product is sold as part of a bundle pack. |
| Cold Chain | Bool | False |
Indicates whether the product requires cold chain storage or transportation. |
| Company Product | Bool | False |
Indicates whether the product is owned or manufactured by the company. |
| Consumer site | String | False |
The consumer-facing site or URL associated with the product. |
| Controlled Substance | Bool | False |
Indicates whether the product is classified as a controlled substance. |
| Cost | Decimal | False |
The local cost of the product. |
| Cost Corp | Decimal | True |
The corporate-level cost of the product used for financial tracking. |
| Local Currency | String | False |
The currency code used to report product cost or value. |
| Create Lot Catalog | Bool | False |
Indicates whether a lot catalog should be created for the product. |
| Description | String | False |
The full descriptive text for the product. |
| Display Order | Decimal | False |
The order in which the product is displayed in the interface or catalog. |
| Distributor | String | False |
The primary distributor of the product. |
| External ID | String | False |
The identifier of the product in an external system. |
| Fixed U/M? | Bool | False |
Indicates whether the unit of measure for the product is fixed and cannot be changed. |
| Height | Double | False |
The height of the product, typically in centimeters or inches. |
| Inventory Monitoring | Bool | False |
Indicates whether the product is subject to inventory monitoring. |
| Inventory Order UOM | String | False |
The unit of measure used when placing inventory orders for the product. |
| Inventory Quantity Per Case | Decimal | False |
The number of units of the product contained in a single case. |
| Manufacturer | String | False |
The name of the organization that manufactures the product. |
| Master Align Id | String | False |
The identifier used to align the product across systems or hierarchies. |
| No Cycle Plans | Bool | False |
Indicates whether the product is excluded from all cycle plans. |
| No Details | Bool | False |
Indicates whether product detail information is unavailable or not applicable. |
| No Metrics | Bool | False |
Indicates whether metrics should be disabled for this product. |
| Pricing Bound | Bool | False |
Indicates whether pricing constraints are enforced for the product. |
| Pricing Rule Quantity Bound | Bool | False |
Indicates whether quantity constraints are enforced by the pricing rule. |
| Product Identifier | String | False |
The unique product identifier used across systems. |
| Product Thumbnail | String | False |
The URL or reference to the thumbnail image of the product. |
| Product Type | String | False |
The category or classification of the product, such as OTC or Prescription. |
| Product Value | Decimal | False |
The commercial value of the product at the local level. |
| Product Value Corp | Decimal | True |
The commercial value of the product at the corporate level. |
| Product info | String | False |
The additional information or summary content about the product. |
| Quantity Per Case | Decimal | False |
The total number of product units included in a case. |
| Require Discussion | String | False |
The discussion topic or flag required when detailing the product. |
| Require Key Message On Detail | Bool | False |
Indicates whether a key message must be delivered during detailing. |
| Restricted States | String | False |
The list of states where the product is restricted from distribution or promotion. |
| Restricted | Bool | False |
Indicates whether the product is restricted in general usage or distribution. |
| Sample Quantity Bound | Bool | False |
Indicates whether sampling quantities are limited by a rule. |
| Sample Quantity | String | False |
The selected quantity from a predefined list for sample distribution. |
| Sample U/M | String | False |
The unit of measure used for product samples (for example, tablets or vials). |
| Schedule | String | False |
The regulatory or legal schedule classification of the product. |
| Sort Code | String | False |
The code used for sorting or grouping the product in listings. |
| State Distributor Category | String | False |
The distributor category used for state-specific classifications. |
| Therapeutic Area | String | False |
The medical or therapeutic area that the product addresses. |
| User Aligned | Bool | False |
Indicates whether the product is aligned with specific users for targeting or access. |
| Veeva External Id | String | False |
The external identifier used by the Veeva platform for integration. |
| Width | Double | False |
The width of the product, typically measured in centimeters or inches. |
| Therapeutic Class | String | False |
The therapeutic classification of the product for regulatory or commercial use. |
| Parent Product | String | False |
The identifier of the parent product in a product family or bundle. |
| Owner | String | False |
The identifier of the user or team responsible for the product record. |
| No Promo Items | String | True |
Indicates whether promotional items are associated with the product. |
| Legacy CRM Id | String | False |
The identifier of the product from a legacy Customer Relationship Management (CRM) system. |
| Brand Color Code | String | False |
The color code used for branding and visual identification. |
| Custom Text | Bool | False |
Indicates whether custom text is enabled for the product configuration. |
| Competitor | String | False |
The name of a competing product or manufacturer. |
| CDS State Schedule | String | False |
The Controlled Drug Substance (CDS) schedule specific to state regulations. |