Resource (transition matrices and rules)

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  
transition matrix STRING 80   transition matrix matrix code X X X X X either this or transition rule mandatory
transition rule STRING 80   transition rule rule code X X X X X either this or transition matrix mandatory
transition type NUM         X X X X X the type of the matrix or rule; 0 = setup, 1 changeover. Default is 1 (changeover).
model name STRING 80 X       X        
resource code STRING 80   resource code X X X X X  
unique key STRING 240 X     X X X     [resource]code (padded with spaces to 80 characters) + [transition matrix]code (padded with spaces to 80 characters) + [transition rule]code (padded with spaces to 80 characters)
[resource]custom data 01 STRING 80         X        
[resource]custom data 02 STRING 80         X        
[resource]custom data 03 STRING 80         X        
[resource]custom data 04 STRING 80         X        
[resource]custom data 05 STRING 80         X        
[resource]custom data 06 STRING 80         X        
[resource]custom data 07 STRING 80         X        
[resource]custom data 08 STRING 80         X        
[resource]custom data 09 STRING 80         X        
[resource]custom data 10 STRING 80         X        
[resource]custom data 11 STRING 80         X        
[resource]custom data 12 STRING 80         X        
[resource]custom data 13 STRING 80         X        
[resource]custom data 14 STRING 80         X        
[resource]custom data 15 STRING 80         X        
[resource]custom date+time 01 DATE           X        
[resource]custom date+time 02 DATE           X        
[resource]custom date+time 03 DATE           X        
[resource]custom date+time 04 DATE           X        
[resource]custom date+time 05 DATE           X        
[resource]custom date+time 06 DATE           X        
[resource]custom date+time 07 DATE           X        
[resource]custom date+time 08 DATE           X        
[resource]custom date+time 09 DATE           X        
[resource]custom date+time 10 DATE           X        
[resource]custom value 01 REAL           X        
[resource]custom value 02 REAL           X        
[resource]custom value 03 REAL           X        
[resource]custom value 04 REAL           X        
[resource]custom value 05 REAL           X        
[resource]custom value 06 REAL           X        
[resource]custom value 07 REAL           X        
[resource]custom value 08 REAL           X        
[resource]custom value 09 REAL           X        
[resource]custom value 10 REAL           X