Field
|
Name
|
M
|
Type
|
Description
|
ItemCode
|
Routing ID
|
X
|
nvarchar(50)
|
|
POS_ID
|
Routing position (ID)
|
X
|
int(4)
|
Link to internal position number from routing position (BEAS_APL.POS_ID)
|
WKZPOS_ID
|
Resource Position Number
|
X
|
int(4)
|
Position number for this resource position
Must be unique for all resource types (toosl, alternativ, parallel)
|
RESOURCENTYP
|
Resource typ (Tool/Resource)
|
X
|
nchar(1)
|
Valid values: Tool=W
Parallel resource=A
Alternativ resource=R
|
POS2_ID
|
Position Number (visible)
|
X
|
int(4)
|
|
WKZ_ID
|
Resouce / Tool Id
|
X
|
nchar(20)
|
Id of the resource
if resource type = W then link to BEAS_WKZ.WKZ_ID
for all other link to resource BEAS_APLATZ.APLATZ_ID
|
ZUSATZINFO
|
Additional Information
|
|
nvarchar(255)
|
|
TR
|
Setup time
|
|
decimal(9)
|
|
TE
|
Mach+Labor Time/unit
|
|
decimal(9)
|
|
MENGE_JE
|
Quantity per Finished Item
|
|
decimal(9)
|
|
MENGE_ZEITJE
|
Time by
|
|
int(4)
|
|
ANTEIL
|
Time reservation %
|
|
decimal(9)
|
only parallel resources:
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.
|
IgnoreOwnResourcePrice
|
Cost not valuate
|
|
int(4)
|
Valid values: yes=1
no=0
|
ANZAHL
|
quantity
|
|
decimal(9)
|
Anzahlfaktor
|
NUTZEN
|
Use
|
|
decimal(9)
|
|
AKTIV
|
Active
|
|
int(4)
|
Valid values: yes=1
no=0
|
MENGE
|
Quantity Warehouse unit
|
|
int(4)
|
Only for tools:
Needed quantity in warehouse unit of the tool
|
ALTERNATIV
|
alternative Parallel Resource
|
|
int(4)
|
Valid values: yes=1
no=0
|
TIMETYPE_ID
|
Time Type
|
|
nvarchar(20)
|
|
LIEGEZEIT
|
Idle time
|
|
int(4)
|
|
ALLOW_MANUAL_CHANGE
|
Allow manual change
|
|
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 for alternative resources:
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)
|
|
UDF9
|
Userfield 9
|
|
nvarchar(50)
|
|
UDF10
|
Userfield 10
|
|
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)
|
|