Infor ERP Adage (production)
|
Type
|
Length
|
PK
|
FK
|
Mode
|
Mandatory
|
Remarks
|
|
|
|
|
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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|