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}