Production Event Status
A key consideration for this is the status of the production event status. For example, the production event status of ‘Complete’ has a status of ‘Good’ while the production event status of ‘Hold’ has a status of ‘Bad’. The status of the production status is defined in the ‘Production Status Editor’. For example,
Production event statuses are stored in the Production_Status table. The key fields are as follows:
| Field | Description |
|---|---|
| ProdStatus_Id | Unique identifier that linked to the other tables (for example, Events.Event_Status). |
| ProdStatus_Desc | Text of the status (for example, ‘Complete’, ‘Consumed’, ‘Hold’). |
| Status_Valid_For_Input | Boolean value defining whether the status is ‘Good’/’Bad’ (for example, 1/0). Correspondingly, this defines whether the production event is ‘Good’ or ‘Bad’. |
| Count_For_Production | Determines whether to count the event in net production. |
| Count_For_Inventory | Determines whether to count the event as inventory. |
There are a number of default reserved statuses. Of particular importance is the ‘Consumed’ status, which defines whether a production event (for example, WIP material) has been consumed in the creation of finished goods.