JDBC Driver for Vault CRM

Build 25.0.9434

MaterialOrderLineItems

Represents individual items within a broader material order, including quantity and product details.

Columns

Name Type ReadOnly Description
ID [KEY] String True

The unique identifier for the record in the system. It acts as the primary key used for referencing, linking, and querying related data across tables.

Global ID String True

A globally unique identifier assigned to the record, ensuring its identification remains consistent across different systems or databases.

Link String False

The URL or hyperlink associated with the record, providing a direct reference to its location or related resource within the system.

Line Item ID String True

The unique identifier for the line item associated with this record. It is used to track individual items within an order or inventory.

Status String False

The current state or condition of the record, such as 'active', 'inactive', 'completed', or 'pending', reflecting the progress or status within a process.

Created By String True

The identifier or name of the individual who created the record, helping track accountability and trace who initiated the record in the system.

Created Date Datetime True

The timestamp when the record was created in the system, providing a reference for tracking the record's age and creation time.

Last Modified By String True

The identifier or name of the individual who last modified or updated the record, allowing visibility into who made the most recent changes.

Last Modified Date Datetime True

The timestamp of the last modification to the record, indicating the most recent changes made and providing insight into the timeliness of the record's data.

Quantity Decimal False

The numerical value representing the quantity of items involved in the record, typically used in the context of stock, inventory, or order volume.

Material Order String False

A unique identifier for the material order associated with this record. It links the record to a specific order in the system for inventory or procurement purposes.

Products String False

A list of products associated with the record, typically identifying the items that are part of the transaction or inventory being tracked.

Legacy CRM Id String False

An identifier used in the legacy CRM system, ensuring compatibility and the ability to cross-reference records between the current system and previous CRM databases.

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