Tank batch (claimed utility allocation)
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 | |||||
code | STRING | 80 | X | tank batch | code | X | |||||
end outflow | DATE | X | |||||||||
index | INTEGER | X | X | ||||||||
model name | STRING | 80 | X | tank batch, resource, utility | model name | X | |||||
quantity | REAL | X | |||||||||
segment | NUM | X | X | 1 = setup; 2 = inflow; 3 = offset; 4 = slack; 5 = outflow; 6 = changeover | |||||||
start inflow | DATE | X | |||||||||
utility code | STRING | 80 | X | utility | code | X | |||||
tank batch resource | STRING | 80 | X | resource | code | X | |||||
[tank batch] custom data 01 | STRING | 80 | X | ||||||||
[tank batch] custom data 02 | STRING | 80 | X | ||||||||
[tank batch] custom data 03 | STRING | 80 | X | ||||||||
[tank batch] custom data 04 | STRING | 80 | X | ||||||||
[tank batch] custom data 05 | STRING | 80 | X | ||||||||
[tank batch] custom data 06 | STRING | 80 | X | ||||||||
[tank batch] custom data 07 | STRING | 80 | X | ||||||||
[tank batch] custom data 08 | STRING | 80 | X | ||||||||
[tank batch] custom data 09 | STRING | 80 | X | ||||||||
[tank batch] custom data 10 | STRING | 80 | X | ||||||||
[tank batch] custom data 11 | STRING | 80 | X | ||||||||
[tank batch] custom data 12 | STRING | 80 | X | ||||||||
[tank batch] custom data 13 | STRING | 80 | X | ||||||||
[tank batch] custom data 14 | STRING | 80 | X | ||||||||
[tank batch] custom data 15 | STRING | 80 | X | ||||||||
[tank batch] custom date+time 01 | DATE | X | |||||||||
[tank batch] custom date+time 02 | DATE | X | |||||||||
[tank batch] custom date+time 03 | DATE | X | |||||||||
[tank batch] custom date+time 04 | DATE | X | |||||||||
[tank batch] custom date+time 05 | DATE | X | |||||||||
[tank batch] custom date+time 06 | DATE | X | |||||||||
[tank batch] custom date+time 07 | DATE | X | |||||||||
[tank batch] custom date+time 08 | DATE | X | |||||||||
[tank batch] custom date+time 09 | DATE | X | |||||||||
[tank batch] custom date+time 10 | DATE | X | |||||||||
[tank batch] custom value 01 | REAL | X | |||||||||
[tank batch] custom value 02 | REAL | X | |||||||||
[tank batch] custom value 03 | REAL | X | |||||||||
[tank batch] custom value 04 | REAL | X | |||||||||
[tank batch] custom value 05 | REAL | X | |||||||||
[tank batch] custom value 06 | REAL | X | |||||||||
[tank batch] custom value 07 | REAL | X | |||||||||
[tank batch] custom value 08 | REAL | X | |||||||||
[tank batch] custom value 09 | REAL | X | |||||||||
[tank batch] custom value 10 | REAL | X |