Infor ERP Adage (production)

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
				Table	Field	Read	Write	Delete	Create	Update
batch ID	STRING	80					X
choice group	STRING	80					X
company	STRING	80					X
custom data 01	STRING	80					X
custom data 02	STRING	80					X
custom data 03	STRING	80					X
custom data 04	STRING	80					X
custom data 05	STRING	80					X
custom data 06	STRING	80					X
custom data 07	STRING	80					X
custom data 08	STRING	80					X
custom data 09	STRING	80					X
custom data 10	STRING	80					X
custom data 11	STRING	80					X
custom data 12	STRING	80					X
custom data 13	STRING	80					X
custom data 14	STRING	80					X
custom data 15	STRING	80					X
custom date+time 01	DATE						X
custom date+time 02	DATE						X
custom date+time 03	DATE						X
custom date+time 04	DATE						X
custom date+time 05	DATE						X
custom date+time 06	DATE						X
custom date+time 07	DATE						X
custom date+time 08	DATE						X
custom date+time 09	DATE						X
custom date+time 10	DATE						X
custom value 01	REAL						X
custom value 02	REAL						X
custom value 03	REAL						X
custom value 04	REAL						X
custom value 05	REAL						X
custom value 06	REAL						X
custom value 07	REAL						X
custom value 08	REAL						X
custom value 09	REAL						X
custom value 10	REAL						X
date/time stamp	DATE						X
end date	DATE						X
inflow batch	STRING	80		process/tank batch	code		X
model name	STRING	80	X	Global	model name		X
model ID	STRING	80					X
origin	NUM						X
plant	STRING	80					X
process step version	STRING	80		process step	version		X
reference field 1	STRING	80					X
reference field 2	STRING	80					X
reference field 3	STRING	80					X
required quantity	REAL						X
resource	STRING	80		resource	code		X
start date	DATE						X
superitem	STRING	80					X
target	NUM						X
uom required quantity	STRING	20					X