Field
|
Name
|
M
|
Type
|
Description
|
AG_ID
|
Operation
|
X
|
nchar(20)
|
|
WKZPOS_ID
|
Internal Position
|
X
|
int(4)
|
|
POS_ID
|
position number visible
|
|
int(4)
|
|
RESOURCENTYP
|
Resourcentyp
|
X
|
nchar(1)
|
Type of Resource
Valid values: Tools/Utils=W
parallel=A
alternativ=R
|
WKZ_ID
|
Resource Id
|
X
|
nchar(20)
|
This is the resource or tool id
linked with BEAS_APLATZ.APLATZ_ID or BEAS_WKZ.WKZ_ID
|
TR
|
set-up time
|
|
decimal(9)
|
|
TE
|
Mach+Labor Time/unit
|
|
decimal(9)
|
|
MENGE_JE
|
Quantity per
|
|
decimal(9)
|
|
MENGE_ZEITJE
|
Times Unit
|
|
int(4)
|
Valid values: per hour=60
per minute=1
|
ZUSATZINFO
|
Additional Information
|
|
nvarchar(255)
|
|
NUTZEN
|
Use Factor
|
|
decimal(9)
|
|
ANTEIL
|
Time Reservation (%)
|
|
decimal(9)
|
If no setup and edit time was entered, the time of the main operation * time reservation is used as reference.
At which % shall the resource be scheduled?
Example: The parallel resource is an employee operating four machines at once. He need to be available for the machine at the whole time but only at 25%.
If the setup time or processing time is entered, in pre-calculation this input will be ignored.
See note above at Setup time.
|
AKTIV
|
Active
|
|
int(4)
|
only for tools.
Valid values: activ=1
not activ=0
|
ANZAHL
|
Number Factor
|
|
decimal(9)
|
|
MENGE
|
Quantity Tools
|
|
int(4)
|
|
ALTERNATIV
|
alternative Parallel Resource
|
|
int(4)
|
|
IgnoreOwnResourcePrice
|
Cost not valuate
|
|
int(4)
|
only parallel resource:
If enabled, the resource costs of this parallel resource are ignored. Affected: pre-calculation and post-calculation. Costs created with time receipts are not taken into account as well.
Use this option, if you included the costs already with your main resource.
Default: disabled.
Valid values: allow=1
do not allow=0
|
ALLOW_MANUAL_CHANGE
|
Allow manual selection
|
|
int(4)
|
only alternative resource:
This alternative resource can only be selected manually, if this option has been enabled. The event will be canceled and receipted with the error message "(aktivaplatz440)Resource cannot be selected when flag "allow manual change" is off" if this option has been disabled and an attempt has been made to select the resource.
Note: A change is only possible if a change has been allowed according to the production position (Production position - Allow change has to be allowed).
Valid values: yes=1
no=0
|
OPTIMIZED_ID
|
Activate Optimization
|
|
int(4)
|
only alternative resource:
If active, at the calculation the lead time will be checked, whether with this resource a faster processing is possible and if yes, the resource will be replaced automatically
Valid values: yes=1
no=0
|
UDF1
|
Userfield 1
|
|
nvarchar(100)
|
|
UDF2
|
Userfield 2
|
|
nvarchar(100)
|
|
UDF3
|
Userfield 3
|
|
nvarchar(100)
|
|
UDF4
|
Userfield 4
|
|
nvarchar(100)
|
|
UDF5
|
Userfield 5
|
|
nvarchar(50)
|
|
UDF6
|
Userfield 6
|
|
nvarchar(50)
|
|
UDF7
|
Userfield 7
|
|
nvarchar(50)
|
|
UDF8
|
Userfield 8
|
|
nvarchar(50)
|
|
UDF10
|
Userfield 10
|
|
nvarchar(50)
|
|
UDF9
|
Userfield 9
|
|
nvarchar(50)
|
|
UDF11
|
Userfield 11
|
|
nvarchar(50)
|
|
UDF12
|
Userfield 12
|
|
nvarchar(50)
|
|
UDF13
|
Userfield 13
|
|
nvarchar(50)
|
|
UDF14
|
Userfield 14
|
|
nvarchar(50)
|
|
UDF15
|
Userfield 15
|
|
nvarchar(50)
|
|