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. |