Coupled product flow

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  
flow type NUM           X       The type of the flow from batch to batch. There are two flows possible: from a process batch to a downstream tank batch (type = 1) and from a tank batch to a downstream process batch (type = 2).
model name STRING 80 X process batch, tank batch model name   X        
process batch STRING 80 X process batch code   X        
quantity REAL           X       The quantity is the product quantity which flows from process batch to tank batch or from tank batch to process batch.
start time DATE           X        
stop time DATE           X        
tank batch STRING 80 X tank batch code   X        
unique key STRING 255 X       X       [process batch]code (padded with spaces to 80 characters) + [tank batch]code (padded with spaces to 80 characters) {if flowtype=1} [tank batch]code (padded with spaces to 80 characters) + [process batch]code (padded with spaces to 80 characters) {if flowtype=2}