LotCatalog
Catalog of lot numbers available for sampling, shipment, or order purposes.
Columns
| Name | Type | ReadOnly | Description |
| ID [KEY] | String | True |
The unique identifier for each record in the system. This serves as the primary key for referencing and managing individual records. |
| Global ID | String | True |
A globally unique identifier that ensures the record can be identified across different systems and databases, preventing conflicts. |
| Link | String | False |
The URL or path that points to an external resource associated with the record, enabling easy access to related content or documentation. |
| Lot # | String | False |
The identifier or number assigned to the lot, often used for tracking batches of items or materials in the system. |
| Status | String | False |
The current state of the record, such as 'active', 'inactive', 'pending', or 'completed', reflecting its progress or lifecycle stage. |
| Created By | String | True |
The name or identifier of the user who initially created the record, providing accountability for its creation. |
| Created Date | Datetime | True |
The timestamp that records when the record was first created, helping track the record's inception date and data entry. |
| Last Modified By | String | True |
The name or identifier of the user who most recently modified the record, offering accountability for updates or changes. |
| Last Modified Date | Datetime | True |
The timestamp indicating the most recent modification to the record, tracking changes over time and ensuring data is up-to-date. |
| Active | Bool | False |
A flag indicating whether the record is active or inactive. If 'true', the record is currently in use; if 'false', it is archived or inactive. |
| Expiration Date | Date | False |
The date on which the record, product, or lot expires, helping to manage lifecycle and compliance with shelf-life requirements. |
| Item Id | String | False |
A unique identifier for the item associated with the record. This links the record to a specific product or material in the inventory. |
| Lot Catalog External Id | String | False |
An external identifier for the lot catalog, often used for integration with other systems or databases to track lots and batches. |
| Sample Description | String | False |
A brief description of the sample associated with the lot or product, providing context about the sample's properties or characteristics. |
| Suppress Lot | Bool | False |
A flag that determines whether the lot should be suppressed or excluded from certain processes, such as reporting or visibility in the catalog. |
| U/M | String | False |
The unit of measure (UOM) for the lot or item, specifying the standard measurement unit, such as kilograms, liters, or pieces. |
| Product | String | False |
The name or identifier of the product associated with the record. This links the lot or item to a specific product in the catalog or inventory. |
| Owner | String | False |
The identifier or name of the person or entity responsible for the record, helping to track ownership and accountability for the lot or item. |
| Legacy CRM Id | String | False |
An identifier from a legacy Customer Relationship Management (CRM) system, used for linking historical data with the current system. |
| Sample | String | False |
The identifier or name of the sample associated with the lot, often used to track specific units or portions of material for testing or analysis. |