Coupled product flow


	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}