The following section describes the table used to hold order marker information.
dcs_order_marker
This table holds information about markers assigned to orders when an order reaches a business process stage.
Column | Data Type | Constraint | |
---|---|---|---|
| VARCHAR(40) | NOT NULL | |
(primary key) | The unique identifier associated with the marker. | ||
| VARCHAR(40) | NOT NULL | |
The ID of the order for that has an order marker. | |||
| VARCHAR(100) | NOT NULL | |
The name of the business process associated with the marker. | |||
| VARCHAR(100) | NULL | |
The name of the business process stage associated with the marker. | |||
| VARCHAR(100) | NULL | |
This column is not currently in use. | |||
| timestamp | NULL | |
The date the business process stage is reached and the order marker is assigned to the order. | |||
| INTEGER | NOT NULL | |
The order marker repository version number. This information is managed and used internally by the repository. | |||
| INTEGER | NULL | |
This column is not currently in use. |