CRM Product
Global table sourced from CRM product catalog.
| Global ODS Field | Field Type |
Source Data Connector: CRM Table: product_ods__v |
|---|---|---|
| composite_key__v | varchar(100) |
|source_connector_name__v|souce_table_name__v|native_id__v| |
| source_system_id__v | varchar(18) | Extracted from Internal Admin Console |
| native_id__v | varchar(18) | product_ods__v.crm_product_id__v |
| source_connector_name__v | varchar(100) | Extracted from Internal Admin Console |
| source_table_name__v | varchar(100) | product_ods__v |
| global_product_name__v | varchar(240) | product_vod_name__v |
| product_type__v | varcahr(765) | product_type_vod__v |
| therapeutic_area__v | varcahr(765) | therapeutic_area_vod__v |
| therapeutic_class__v | varcahr(765) | therapeutic_class_vod__v |
| parent_product__v | varchar(18) | parent_product_vod__v |
| company_product__v | boolean | company_product_vod__v |
| cost__v | decimal(14,2) | cost_vod__v |
| external_id__v | varchar(75) | external_id_vod__v |
| start_date__v | timestamp | start_date__v |
| end_date__v | timestamp | end_date__v |
| last_modified_date__v | timestamp | lastmodifieddate |
