Products
Stores core product master data, including product names, abbreviations, compound IDs, INNs, therapeutic areas, and both internal and external identifiers.
Columns
| Name | Type | Description |
| ID | String | The unique identifier for the product record within the system. |
| Product_Name | String | The full name of the product used for display and reference. |
| Status | String | The current status of the product, such as active, inactive, or discontinued. |
| Product_Abbreviation | String | The abbreviated or shortened form of the product name. |
| Generic_Name | String | The generic or non-branded name of the product. |
| Internal_Name | String | The internal name used by the organization for reference or tracking. |
| Compound_ID | String | The identifier assigned to the chemical compound associated with the product. |
| INN | String | The International Nonproprietary Name (INN) officially assigned to the product. |
| Therapeutic_Area | String | The medical or therapeutic area addressed by the product. |
| External_ID | String | The identifier of the product from an external system or data source. |
| Created_By | String | The user who originally created the product record. |
| Created_Date | Datetime | The date and time when the product record was created in the system. |
| Last_Modified_By | String | The user who most recently modified the product record. |
| Last_Modified_Date | Datetime | The date and time when the product record was last updated. |