ProductFamilies
product_family__v
Columns
| Name | Type | ReadOnly | Description |
| ID [KEY] | String | True |
id |
| Global ID | String | True |
global_id__sys |
| Link | String | False |
link__sys |
| Product Family Name | String | False |
name__v |
| Status | String | False |
status__v |
| Created By | String | True |
created_by__v |
| Created Date | Datetime | True |
created_date__v |
| Last Modified By | String | True |
modified_by__v |
| Last Modified Date | Datetime | True |
modified_date__v |
| Original Source ID | String | False |
original_source_id__v |
| Generic Name | String | False |
generic_name__v |
| Therapeutic Area | String | False |
therapeutic_area__v |
| Product Family Abbreviation | String | False |
abbreviation__v |
| Source Status | String | False |
source_status__v |
| Deleted in Source? | Bool | False |
deleted_in_source__v |
| Product Category | String | False |
product_category__v |
| Scientific Name | String | False |
scientific_name__v |
| Source Vault ID | String | False |
source_vault_id__v |
Pseudo-Columns
Pseudo-column fields are used in the WHERE clause of SELECT statements and offer more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| ExternalIdColumn | String |
Specifies the External Id column to be used for Update and Upsert operations. Should be set to an unique column different from Id |