Field
|
Name
|
M
|
Type
|
Description
|
APLATZ_ID
|
Resource
|
X
|
nchar(20)
|
Resouce id
|
GRUPPE
|
Group
|
|
nvarchar(30)
|
|
BEZ
|
Description
|
X
|
nvarchar(255)
|
|
RESOURCETYPE
|
Type of resource
|
|
nchar(20)
|
|
STANDORT
|
Location
|
|
nvarchar(30)
|
|
BPLName
|
Branch
|
|
nvarchar(200)
|
|
AUSWAERTSBEARBEITUNG
|
Service / registrer costs
|
|
nchar(1)
|
Valid values: Yes=J
No=N
|
SACHB_ID
|
Employee planner
|
|
nvarchar(25)
|
|
KAPAPLANUNG
|
Capacity planning
|
|
int(4)
|
|
POOLGRENZE
|
Pool limit in hrs.
|
|
int(4)
|
|
UEBERGANGSZEIT
|
Transit time in days
|
|
numeric(4)
|
|
ZEITGRAD
|
Efficiency Rate %
|
|
numeric(4)
|
|
SINGLEUSER
|
Single operation per operation sequence
|
|
int(4)
|
If enabled, to the operation sequence, to which the resource has been assigned to, only one employee may logon. That means several orders may be registered to that resource, but per operation sequence only one employee may be working.
Valid values: Yes=1
No=0
|
MEHRAUFTRAGSBEDIENUNG
|
Work order grouping
|
|
nchar(1)
|
Determines, whether several operations may be processed at once on that resource
several orders can be processed at once on on that resource
Enabled
Multiple orders can be processed in parallel on this resource.
The option is activated by default. This is only considered in the new
FDC > Open Work Order or in Pool list with multiple selection.
Disabled
If an order was already registered on a machine (Resource), a second one can not be registered.
In the logon screen on resource selection page a sign "no entry" is displayed.
Valid values: Yes=J
No=N
|
SAME_STARTENDTIME
|
same date for start and finish
|
|
int(4)
|
|
Active
|
Active
|
|
nchar(1)
|
|
not_divide_time
|
Do not split time receipt
|
|
int(4)
|
|
APSVIEW
|
View in APS
|
|
int(4)
|
Valid values: Yes=1
No=0
|
KAPACHECKLIMIT
|
Consider resource limits
|
|
nchar(1)
|
While capacity planing for this resource: Notice resource limiting for this resource?
Valid values: Yes=J
No=N
|
OPTIMIZED_ID
|
Automatic optimization
|
|
int(4)
|
|
SOLLKAPSTDTAG
|
Planned Capacity hrs./day
|
|
numeric(4)
|
|
ANZMASCHPERS
|
Number of Machine / person
|
|
numeric(4)
|
|
LAYERPLAN
|
Shift schedule
|
|
nvarchar(20)
|
|
TETIMETYPE_ID
|
Cost Element Mach+Labor Time/unit
|
|
nvarchar(20)
|
|
VOLLKSTBED
|
Full Cost
|
|
numeric(4)
|
|
GKBED
|
Marginal Cost
|
|
numeric(4)
|
|
KSTST_ID
|
Cost Center
|
|
nchar(20)
|
|
VOLLKSTEINR
|
Full Cost Einrichter
|
|
numeric(4)
|
|
GKEINR
|
Marginal Cost Einrichter
|
|
numeric(4)
|
|
BILD1
|
Picture 1
|
|
nvarchar(100)
|
|
BILD2
|
Picture 2
|
|
nvarchar(100)
|
|
BILD3
|
Picture 3
|
|
nvarchar(100)
|
|
COSTEXTENTED
|
Expand to costelements
|
|
int(4)
|
Define count of cost elements, which you want using for this resource
Valid values: 1 cost element=0
2 cost elements=1
3 cost elements=2
4 cost elements=3
|
TRTIMETYPE_ID
|
Cost Element setting up
|
|
nvarchar(20)
|
|
TRVK
|
Cost of setup Full Cost
|
|
numeric(4)
|
|
TRGK
|
Cost of setup Marginal Cost
|
|
numeric(4)
|
|
TNVK
|
Cost Secondary time Full Cost
|
|
numeric(4)
|
|
TNGK
|
Cost Secondary time Marginal Cost
|
|
numeric(4)
|
|
TNTIMETYPE_ID
|
Cost Element Secondary time
|
|
nvarchar(20)
|
|
THVK
|
Cost Machine Time / unit Full Cost
|
|
numeric(4)
|
|
THGK
|
Cost Machine Time / unit Marginal Cost
|
|
numeric(4)
|
|
THTIMETYPE_ID
|
Cost Element Machine Time / unit
|
|
nvarchar(20)
|
|
PCOSTAKTIV
|
Labor costs Active
|
|
int(4)
|
if activ, you can set personal costs
Valid values: yes=1
No=0
|
PCOSTGK
|
Labor costs Marginal Cost
|
|
numeric(4)
|
|
PCOSTVK
|
Labor costs Full Cost
|
|
numeric(4)
|
|
PTIMETYPE_ID
|
Labor costs Time Type
|
|
nvarchar(20)
|
|
GRUPPENPLATZ
|
Resource group
|
|
nchar(1)
|
If this resource a group definition, then this field is Yes (J) otherwise No (N or NULL)
Valid values: Yes=J
No=N
|
COLOR_ID
|
Color
|
|
int(4)
|
|
BITMAP_ID
|
Picture
|
|
nvarchar(50)
|
|
BPLId
|
Branch
|
|
int(4)
|
|
UDF1
|
Userfield 1
|
|
nvarchar(100)
|
|
UDF2
|
Userfield 2
|
|
nvarchar(100)
|
|
UDF3
|
Userfield 3
|
|
nvarchar(100)
|
|
UDF4
|
Userfield 4
|
|
nvarchar(100)
|
|
UDF5
|
Userfield 5
|
|
nvarchar(100)
|
|
UDF6
|
Userfield 6
|
|
nvarchar(100)
|
|
UDF7
|
Userfield 7
|
|
nvarchar(100)
|
|
UDF8
|
Userfield 8
|
|
nvarchar(100)
|
|
UDF9
|
Userfield 9
|
|
nvarchar(100)
|
|
UDF10
|
Userfield 10
|
|
nvarchar(100)
|
|
UDF11
|
Userfield 11
|
|
nvarchar(100)
|
|
UDF12
|
Userfield 12
|
|
nvarchar(100)
|
|
UDF13
|
Userfield 13
|
|
nvarchar(100)
|
|
UDF14
|
Userfield 14
|
|
nvarchar(100)
|
|
UDF15
|
Userfield 15
|
|
nvarchar(100)
|
|
LOSGR_MIN
|
Lot Size Minimal
|
|
decimal(9)
|
|
LOSGR_MAX
|
Lot Size Maximum
|
|
decimal(9)
|
|