JDBC Driver for Vault CRM

Build 25.0.9434

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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434