Process step (transition matrix criteria)
Note: The X icon indicates Yes. In Mode columns, X indicates that the
fields are optional in the specified operation. Where noted as mandatory, the field is
required in the specified action.
Type | Length | PK | FK | Mode | Mandatory | Remarks | |||||
---|---|---|---|---|---|---|---|---|---|---|---|
Table | Field | Read | Write | Delete | Create | Update | |||||
matrix code | STRING | 80 | X | transition matrix | matrix code | X | X | X | X | ||
matrix criterion | STRING | 80 | transition attributes | transition attribute code | X | X | X | X | |||
model name | STRING | 80 | X | process step | model name | X | |||||
product code | STRING | 80 | X | process step | code | X | X | X | X | ||
transition type | NUM | X | X | X | X | X | X | The transition type to which the matrix applies: 0 = setup, 1 = changeover. Default value is 1 (changeover). | |||
unique key | STRING | 255 | X | X | X | [process step]main product (padded with spaces to 80 characters) + [process step]version (padded with spaces to 80 characters) + transition matrix]code (padded with spaces to 80 characters) + transition matrix criterium (padded with spaces to 80 characters) | |||||
version | STRING | 80 | X | process step | version | X | X | X | X | ||
[process step]custom data 01 | STRING | 80 | X | ||||||||
[process step]custom data 02 | STRING | 80 | X | ||||||||
[process step]custom data 03 | STRING | 80 | X | ||||||||
[process step]custom data 04 | STRING | 80 | X | ||||||||
[process step]custom data 05 | STRING | 80 | X | ||||||||
[process step]custom data 06 | STRING | 80 | X | ||||||||
[process step]custom data 07 | STRING | 80 | X | ||||||||
[process step]custom data 08 | STRING | 80 | X | ||||||||
[process step]custom data 09 | STRING | 80 | X | ||||||||
[process step]custom data 10 | STRING | 80 | X | ||||||||
[process step]custom data 11 | STRING | 80 | X | ||||||||
[process step]custom data 12 | STRING | 80 | X | ||||||||
[process step]custom data 13 | STRING | 80 | X | ||||||||
[process step]custom data 14 | STRING | 80 | X | ||||||||
[process step]custom data 15 | STRING | 80 | X | ||||||||
[process step]custom date+time 01 | DATE | X | |||||||||
[process step]custom date+time 02 | DATE | X | |||||||||
[process step]custom date+time 03 | DATE | X | |||||||||
[process step]custom date+time 04 | DATE | X | |||||||||
[process step]custom date+time 05 | DATE | X | |||||||||
[process step]custom date+time 06 | DATE | X | |||||||||
[process step]custom date+time 07 | DATE | X | |||||||||
[process step]custom date+time 08 | DATE | X | |||||||||
[process step]custom date+time 09 | DATE | X | |||||||||
[process step]custom date+time 10 | DATE | X | |||||||||
[process step]custom value 01 | REAL | X | |||||||||
[process step]custom value 02 | REAL | X | |||||||||
[process step]custom value 03 | REAL | X | |||||||||
[process step]custom value 04 | REAL | X | |||||||||
[process step]custom value 05 | REAL | X | |||||||||
[process step]custom value 06 | REAL | X | |||||||||
[process step]custom value 07 | REAL | X | |||||||||
[process step]custom value 08 | REAL | X | |||||||||
[process step]custom value 09 | REAL | X | |||||||||
[process step]custom value 10 | REAL | X | |||||||||