Production Order
What is this data
A production order represents a specific production run or batch of one product — it carries run-specific attributes such as batch number, quantity, and production/expiry dates, in addition to a link to the product being produced.
Where it is used
The Select production order coding-scenario step identifies the order matching the current input and loads it, its linked product, and any linked Various Data into the scenario. See Production Data for the related coding scenario steps, and Preparing Production on a Production Line for how an order is assigned to a line.
Fields
| Field | Label | Mandatory | Notes |
|---|---|---|---|
prodOrder | Production order | Yes | Max 100 characters. The match key. |
productCode | Product code | Yes | Used together with productVariant to resolve (or auto-create) the linked product. |
productVariant | Product variant | No | Blank/empty is treated as no variant. |
batchNumber | Batch number | No | Max 255 characters. |
companyPrefix | Company prefix | No | Max 10 characters. |
expiry | Expiry | No | Free-text field — not validated as a date. |
bestBefore | Best before date | No | Free-text field — not validated as a date. |
quantity | Quantity | No | Free-text field — not validated as a number. |
prodDate | Production date | No | Free-text field — not validated as a date. |
prodStart | Production start | No | Free-text field — not validated as a date/time. |
prodStop | Production stop | No | Free-text field — not validated as a date/time. |
If the Statuses feature is enabled, a Status field is also available, along with two read-only fields (Status changed at, Status change type).
Matching & updates
A production order is matched to an existing one by production order number (prodOrder) alone. If a match is found, only the columns present in the incoming row are overwritten; other fields keep their current value. If no match is found, a new order is created. The order’s linked product is always re-resolved from productCode/productVariant, so updating an order’s product reference this way is possible, and supplying a stale product code onto an existing order can re-point it.
Auto-created related records
If the referenced product (productCode + productVariant) doesn’t exist yet, it is created automatically.
Custom / additional columns
Beyond the fixed fields above, a production order can carry custom columns to describe whatever else your company needs to track about it. Up to 150 custom columns are supported, each storing up to 3200 characters.
Unlike Product, a production order has no direct link of its own to Various Data — Various Data is only ever matched against a product. When a production order’s Various Data is loaded into a coding scenario (see above), it’s resolved via the order’s linked product, not the order itself. See Various Data for details.