Tank batch
           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 | |||||
| any related order code | STRING | 80 | order | code | X | The code of the order related to this tank batch (or one of the orders if more than one order is related). | |||||
| changeover | NUM | X | Changeover is the last segment of a tank batch and follows the outflow. This represents the period when a resource is still in use (for example for cleaning), but in which no further storage can take place. | ||||||||
| changeover cost | NUM | X | Maximum changeover cost for jobs related to this tank batch | ||||||||
| code | STRING | 80 | X | X | X | X | X | ||||
| color | STRING | 80 | X | X | If the batch uses the color of the default process step, the "color" attribute exports the value "-1". | ||||||
| color2 | STRING | 80 | X | This attribute exports the actual display color of the batch, as opposed to the "color" attribute. This attribute can only be exported. To change the display color of a batch through the batch interface, use the "color" attribute. | |||||||
| custom data 01 | STRING | 80 | X | X | |||||||
| custom data 02 | STRING | 80 | X | X | |||||||
| custom data 03 | STRING | 80 | X | X | |||||||
| custom data 04 | STRING | 80 | X | X | |||||||
| custom data 05 | STRING | 80 | X | X | |||||||
| custom data 06 | STRING | 80 | X | X | |||||||
| custom data 07 | STRING | 80 | X | X | |||||||
| custom data 08 | STRING | 80 | X | X | |||||||
| custom data 09 | STRING | 80 | X | X | |||||||
| custom data 10 | STRING | 80 | X | X | |||||||
| custom data 11 | STRING | 80 | X | X | |||||||
| custom data 12 | STRING | 80 | X | X | |||||||
| custom data 13 | STRING | 80 | X | X | |||||||
| custom data 14 | STRING | 80 | X | X | |||||||
| custom data 15 | STRING | 80 | X | X | |||||||
| custom date+time 01 | DATE | X | X | ||||||||
| custom date+time 02 | DATE | X | X | ||||||||
| custom date+time 03 | DATE | X | X | ||||||||
| custom date+time 04 | DATE | X | X | ||||||||
| custom date+time 05 | DATE | X | X | ||||||||
| custom date+time 06 | DATE | X | X | ||||||||
| custom date+time 07 | DATE | X | X | ||||||||
| custom date+time 08 | DATE | X | X | ||||||||
| custom date+time 09 | DATE | X | X | ||||||||
| custom date+time 10 | DATE | X | X | ||||||||
| custom value 01 | REAL | X | X | ||||||||
| custom value 02 | REAL | X | X | ||||||||
| custom value 03 | REAL | X | X | ||||||||
| custom value 04 | REAL | X | X | ||||||||
| custom value 05 | REAL | X | X | ||||||||
| custom value 06 | REAL | X | X | ||||||||
| custom value 07 | REAL | X | X | ||||||||
| custom value 08 | REAL | X | X | ||||||||
| custom value 09 | REAL | X | X | ||||||||
| custom value 10 | REAL | X | X | ||||||||
| end inflow | DATE | X | X | The end inflow of a tank batch is the point in time that the inflow segment ends. | |||||||
| end outflow | DATE | X | X | The end outflow of a tank batch is the point in time that the outflow segment ends. | |||||||
| filling/standing time | TIME | X | X | The filling/standing time is the offset (in minutes) between the inflow and the outflow segment of the batch. | |||||||
| max duration | DATE | X | X | ||||||||
| model name | STRING | 80 | X | X | X | ||||||
| process step | STRING | 80 | process step | code | X | X | Code for the pstep that gives inflow | ||||
| product | STRING | 80 | product | code | X | X | outflow [product] code | ||||
| quantity | REAL | X | Batch quantity is the quantity of the main product that flows out of the batch, expressed in the units of that product. | ||||||||
| reg. Inflow quantity | DATE | X | X | X | The registered inflow quantity can be used to track the (inflow) progress of a tank batch or as an initial level in a tank. | ||||||
| remarks | STRING | 80 | X | X | |||||||
| resource | STRING | 80 | resource | code | X | X | |||||
| resource group | STRING | 80 | resource group | code | X | X | |||||
| setup | NUM | X | The set-up is the first segment of a tank batch. The set-up precedes the start time of the batch and represents the period that a resource is occupied, but in which the resource is not yet operational. There is no inflow or outflow during set-up time | ||||||||
| setup cost | NUM | X | Maximum setup cost for jobs related to this tank batch | ||||||||
| split link | STRING | 80 | X | X | Group name for linked split tank batches | ||||||
| start inflow | DATE | X | X | The start inflow of a tank batch is the point in time that the inflow segment starts. | |||||||
| start outflow | DATE | X | X | The start outflow of a tank batch is the point in time that the outflow segment starts. | |||||||
| status | STRING | 80 | status | code | X | X | |||||
| surplus quantity | REAL | X | The surplus quantity is the quantity of the tank batch that is not linked as inflow for a following process batch. | ||||||||
| version | STRING | 80 | process step | version | X | X | Version of the pstep that provides the inflow | ||||
| [order]custom data 01 | STRING | 80 | X | ||||||||
| [order]custom data 02 | STRING | 80 | X | ||||||||
| [order]custom data 03 | STRING | 80 | X | ||||||||
| [order]custom data 04 | STRING | 80 | X | ||||||||
| [order]custom data 05 | STRING | 80 | X | ||||||||
| [order]custom data 06 | STRING | 80 | X | ||||||||
| [order]custom data 07 | STRING | 80 | X | ||||||||
| [order]custom data 08 | STRING | 80 | X | ||||||||
| [order]custom data 09 | STRING | 80 | X | ||||||||
| [order]custom data 10 | STRING | 80 | X | ||||||||
| [order]custom data 11 | STRING | 80 | X | ||||||||
| [order]custom data 12 | STRING | 80 | X | ||||||||
| [order]custom data 13 | STRING | 80 | X | ||||||||
| [order]custom data 14 | STRING | 80 | X | ||||||||
| [order]custom data 15 | STRING | 80 | X | ||||||||
| [order]custom date+time 01 | DATE | X | |||||||||
| [order]custom date+time 02 | DATE | X | |||||||||
| [order]custom date+time 03 | DATE | X | |||||||||
| [order]custom date+time 04 | DATE | X | |||||||||
| [order]custom date+time 05 | DATE | X | |||||||||
| [order]custom date+time 06 | DATE | X | |||||||||
| [order]custom date+time 07 | DATE | X | |||||||||
| [order]custom date+time 08 | DATE | X | |||||||||
| [order]custom date+time 09 | DATE | X | |||||||||
| [order]custom date+time 10 | DATE | X | |||||||||
| [order]custom value 01 | REAL | X | |||||||||
| [order]custom value 02 | REAL | X | |||||||||
| [order]custom value 03 | REAL | X | |||||||||
| [order]custom value 04 | REAL | X | |||||||||
| [order]custom value 05 | REAL | X | |||||||||
| [order]custom value 06 | REAL | X | |||||||||
| [order]custom value 07 | REAL | X | |||||||||
| [order]custom value 08 | REAL | X | |||||||||
| [order]custom value 09 | REAL | X | |||||||||
| [order]custom value 10 | REAL | 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 | |||||||||