Resource
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 | |||||
| changeover constraint | INTEGER | X | X | X | 1 = Not allowed during resource unavailability; 2 = allowed during resource unavailability | ||||||
| code | STRING | 80 | X | X | X | X | X | X | |||
| description | STRING | 80 | X | X | X | ||||||
| external code | STRING | 80 | X | X | X | ||||||
| setup duration formula | INTEGER | X | X | 1= NONE; 2 = Maximum; 3 = Sum. | |||||||
| setup cost formula | INTEGER | X | X | 1= NONE; 2 = Maximum; 3 = Sum. | |||||||
| changeover duration formula | INTEGER | X | X | 1= NONE; 2 = Maximum; 3 = Sum. | |||||||
| changeover cost formula | INTEGER | X | X | 1= NONE; 2 = Maximum; 3 = Sum. | |||||||
| setup idle time | TIME | X | X | ||||||||
| changeover idle time | TIME | X | X | ||||||||
| last modified | DATE | X | X | X | |||||||
| max batch duration | TIME | X | X | X | |||||||
| max volume | REAL | X | X | X | |||||||
| max weight | REAL | X | X | X | |||||||
| min volume | REAL | X | X | X | |||||||
| min weight | REAL | X | X | X | |||||||
| model name | STRING | 80 | X | timetable | model name | X | X | ||||
| non-standard setup after idle time | BOOLEAN | X | X | X | 2 = Yes; 1 = No | ||||||
| non-standard changeover after idle time | BOOLEAN | X | X | 2 = Yes; 1 = No | |||||||
| setup after idle time | TIME | X | X | X | |||||||
| changeover after idle time | TIME | X | X | ||||||||
| setup constraint | INTEGER | X | X | X | 1 = Not allowed during resource unavailability; 2 = allowed during resource unavailability | ||||||
| std changeover | TIME | X | X | X | |||||||
| std setup | TIME | X | X | X | |||||||
| timetable | STRING | 80 | timetable | code | X | X | X | ||||
| custom data 01 | STRING | 80 | X | X | X | ||||||
| custom data 02 | STRING | 80 | X | X | X | ||||||
| custom data 03 | STRING | 80 | X | X | X | ||||||
| custom data 04 | STRING | 80 | X | X | X | ||||||
| custom data 05 | STRING | 80 | X | X | X | ||||||
| custom data 06 | STRING | 80 | X | X | X | ||||||
| custom data 07 | STRING | 80 | X | X | X | ||||||
| custom data 08 | STRING | 80 | X | X | X | ||||||
| custom data 09 | STRING | 80 | X | X | X | ||||||
| custom data 10 | STRING | 80 | X | X | X | ||||||
| custom data 11 | STRING | 80 | X | X | X | ||||||
| custom data 12 | STRING | 80 | X | X | X | ||||||
| custom data 13 | STRING | 80 | X | X | X | ||||||
| custom data 14 | STRING | 80 | X | X | X | ||||||
| custom data 15 | STRING | 80 | X | X | X | ||||||
| custom date+time 01 | DATE | X | X | X | |||||||
| custom date+time 02 | DATE | X | X | X | |||||||
| custom date+time 03 | DATE | X | X | X | |||||||
| custom date+time 04 | DATE | X | X | X | |||||||
| custom date+time 05 | DATE | X | X | X | |||||||
| custom date+time 06 | DATE | X | X | X | |||||||
| custom date+time 07 | DATE | X | X | X | |||||||
| custom date+time 08 | DATE | X | X | X | |||||||
| custom date+time 09 | DATE | X | X | X | |||||||
| custom date+time 10 | DATE | X | X | X | |||||||
| custom value 01 | REAL | X | X | X | |||||||
| custom value 02 | REAL | X | X | X | |||||||
| custom value 03 | REAL | X | X | X | |||||||
| custom value 04 | REAL | X | X | X | |||||||
| custom value 05 | REAL | X | X | X | |||||||
| custom value 06 | REAL | X | X | X | |||||||
| custom value 07 | REAL | X | X | X | |||||||
| custom value 08 | REAL | X | X | X | |||||||
| custom value 09 | REAL | X | X | X | |||||||
| custom value 10 | REAL | X | X | X | |||||||