Order - batch relationship

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
batch code	STRING	80	X	process/tank batch	code	X	X	X
model name	STRING	80	X				X
order code	STRING	80	X	order	code	X	X	X
quantity	REAL					X	X	X			The quantity is the product quantity which flows from end stage batch to order.
unique key	STRING	255	X			X	X	X			order code (padded with spaces to 80 characters) + batch code (padded with spaces to 80 characters)
[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 batch]custom data 01	STRING	80					X
[process batch]custom data 02	STRING	80					X
[process batch]custom data 03	STRING	80					X
[process batch]custom data 04	STRING	80					X
[process batch]custom data 05	STRING	80					X
[process batch]custom data 06	STRING	80					X
[process batch]custom data 07	STRING	80					X
[process batch]custom data 08	STRING	80					X
[process batch]custom data 09	STRING	80					X
[process batch]custom data 10	STRING	80					X
[process batch]custom data 11	STRING	80					X
[process batch]custom data 12	STRING	80					X
[process batch]custom data 13	STRING	80					X
[process batch]custom data 14	STRING	80					X
[process batch]custom data 15	STRING	80					X
[process batch]custom date+time 01	DATE						X
[process batch]custom date+time 02	DATE						X
[process batch]custom date+time 03	DATE						X
[process batch]custom date+time 04	DATE						X
[process batch]custom date+time 05	DATE						X
[process batch]custom date+time 06	DATE						X
[process batch]custom date+time 07	DATE						X
[process batch]custom date+time 08	DATE						X
[process batch]custom date+time 09	DATE						X
[process batch]custom date+time 10	DATE						X
[process batch]custom value 01	REAL						X
[process batch]custom value 02	REAL						X
[process batch]custom value 03	REAL						X
[process batch]custom value 04	REAL						X
[process batch]custom value 05	REAL						X
[process batch]custom value 06	REAL						X
[process batch]custom value 07	REAL						X
[process batch]custom value 08	REAL						X
[process batch]custom value 09	REAL						X
[process batch]custom value 10	REAL						X