Distribution order state represents a state of the distribution order as it moves through different stages of the workflow process. Distribution order may have many states, the current state of the order is inferred from the last modification date of the order state.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| distrib_order_state_id | nvarchar(64) | not null | A unique identifier for distribution order state. It is a generated uuid. |
| user_id | nvarchar(128) | with null | The id of the user that transitioned order to this state. |
| user_comment | long nvarchar | with null | The comment submitted with request to transition the order to this state. |
| last_modification_date | integer(8) | with null | Represents the last modification date of the order state. It is stored as a long representing number of milliseconds. |
| state | nvarchar(128) | with null | A string value that represents the state of the order. Possible values are: open, reviewed, canceled, approved, denied. |
| viewed | integer | with null | Flag that denotes whether this order state has been viewed by the order subbmitter. |
| reason | nvarchar(128) | with null | The reason for this state change. |
| distrib_order_id | nvarchar(64) | with null | A unique identifier for the distribution order. It is a generated uuid. |
Product Name: Portal r12
Table Type: Table