plannedorder
The table storing planned orders, used for tracking future orders and production requirements in the supply chain.
Columns
| Name | Type | References | Description |
| customform | String | The custom form associated with the record, used to personalize the fields and layout for specific transactions or entities. | |
| enddate | Date | The end date of the record or transaction, typically used to mark the completion or expiration of an event, process, or schedule. | |
| externalid | String | A unique identifier assigned to the record by an external system, used for integration or synchronization across systems. | |
| firmed | Boolean | Indicates whether the record has been confirmed or finalized, often used in order management or project tracking. | |
| id | Integer | A unique internal identifier assigned to the record, used for tracking and managing the entry within the system. | |
| item | String | The name or identifier of the item, used to track and manage products, goods, or services within the system. | |
| itemlocation | Integer | The location of the item, typically used in inventory or warehouse management to track where the item is stored. | |
| itemtype | String | The type of item (such as raw material, finished product, or service), used to classify and manage the item within the system. | |
| location | String | The physical or virtual location where the item is stored or where the transaction takes place, such as a warehouse, store, or shipping area. | |
| memo | String | A brief note or comment associated with the record, often used for internal communication or providing additional context. | |
| plannedorderstatus | String | The status of the planned order, indicating its progress, such as planned, in progress, or completed. | |
| quantity | String | The quantity of the item involved in the transaction, typically used to track the amount purchased, sold, or produced. | |
| released | Boolean | Indicates whether the record or order has been released for further processing or action, such as shipping or production. | |
| sourceitemlocation | Integer | The location of the source item, typically used to track where the inventory or materials are coming from in a transfer or supply chain process. | |
| sourcelocation | String | The source location of the item, often used to track where goods or materials originate before being moved or sold. | |
| startdate | Date | The start date of the record or transaction, used to mark the beginning of an event, process, or schedule. | |
| supplyplandefinition | String | The definition or criteria used for the supply planning process, outlining the goals, parameters, and strategies for managing supply chain needs. | |
| supplyplanningrunid | Integer | The identifier for the specific run of the supply planning process, used to track and manage multiple planning cycles. | |
| templatestored | Boolean | Indicates whether the record is stored as a template, allowing it to be reused for future transactions or processes. | |
| transactioncreated | String | The date or identifier associated with the creation of the transaction, used to track when the transaction was initiated. | |
| transactionlinecreated | String | The date or identifier associated with the creation of the transaction line, used to track when individual transaction components were generated. | |
| transactiontype | String | The type of transaction (such as purchase, sale, transfer, or refund), used to classify and manage the nature of the record. |