Name
|
Type
|
Description
|
ResourceId
|
Edm.String(20)
|
Database: rtrim("BEAS_APLATZ"."APLATZ_ID")
|
|
ResourceDescription
|
Edm.String(20)
|
Integration hub: Importable
Mandatory field
Database: "BEAS_APLATZ"."BEZ"
|
|
ResourceGroup
|
Edm.String(20)
|
Database: rtrim("BEAS_APLATZ"."GRUPPE")
|
|
GroupDefinition
|
Edm.Boolean
|
If this resource a group definition, then this field is Yes (J) otherwise No (N or NULL)
Constraints:
Yes=J
No=N
Integration hub: Importable
Database: case when coalesce("BEAS_APLATZ"."GRUPPENPLATZ",'')='J' then 1 else 0 end
|
|
Active
|
Edm.Boolean
|
Integration hub: Importable
Database: case when coalesce("BEAS_APLATZ"."Active",'J')='N' then 0 else 1 end
|
|
SingleOperationPerRouting
|
Edm.Boolean
|
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.
Default Value: 0
Constraints:
Yes=1
No=0
Integration hub: Importable
Database: coalesce("BEAS_APLATZ"."SINGLEUSER",0)
|
|
WorkorderGrouping
|
Edm.Boolean
|
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.
Default Value: J
Constraints:
Yes=J
No=N
Integration hub: Importable
Database: case when coalesce("BEAS_APLATZ"."MEHRAUFTRAGSBEDIENUNG",'J')='J' then 1 else 0 end
|
|
Picture1
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APLATZ"."BILD1"
|
|
Picture2
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APLATZ"."BILD2"
|
|
Picture3
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APLATZ"."BILD3"
|
|
PlannedCapacity
|
Edm.Decimal
|
Integration hub: Importable
Database: "BEAS_APLATZ"."SOLLKAPSTDTAG"
|
|
NumberMachines
|
Edm.Decimal
|
Integration hub: Importable
Database: "BEAS_APLATZ"."ANZMASCHPERS"
|
|
SetupMarginalCostRate
|
Edm.Decimal
|
setup marginal cost per minute
Integration hub: Importable
Database: coalesce("BEAS_APLATZ"."TRGK",0)
|
|
ProcessingMarginalCostRate
|
Edm.Decimal
|
processing marginal cost rate per minute
Integration hub: Importable
Database: coalesce("BEAS_APLATZ"."GKBED",0)
|
|
SecondaryTime1MarginalCostRate
|
Edm.Decimal
|
Secondary time 1 marginal cost rate per minute
Integration hub: Importable
Database: coalesce("BEAS_APLATZ"."TNGK",0)
|
|
SecondaryTime2MarginalCostRate
|
Edm.Decimal
|
Secondary time 2 marginal cost rate per minute
Integration hub: Importable
Database: coalesce("BEAS_APLATZ"."THGK",0)
|
|
SetupFullCostRate
|
Edm.Decimal
|
setup full cost per minute
Integration hub: Importable
Database: coalesce("BEAS_APLATZ"."TRVK",0)
|
|
ProcessingFullCostRate
|
Edm.Decimal
|
processing full cost rate per minute
Integration hub: Importable
Database: coalesce("BEAS_APLATZ"."VOLLKSTBED",0)
|
|
SecondaryTime1FullCostRate
|
Edm.Decimal
|
Secondary time 1 full cost rate per minute
Integration hub: Importable
Database: coalesce("BEAS_APLATZ"."TNVK",0)
|
|
SecondaryTime2FullCostRate
|
Edm.Decimal
|
Secondary time 2 full cost rate per minute
Integration hub: Importable
Database: coalesce("BEAS_APLATZ"."THVK",0)
|
|
EfficiencyRate
|
Edm.Decimal
|
Integration hub: Importable
Database: coalesce("BEAS_APLATZ"."ZEITGRAD",100)
|
|
ResourceColor
|
Edm.Int32
|
Integration hub: Importable
Database: "BEAS_APLATZ"."COLOR_ID"
|
|
ResourceBitmap
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_APLATZ"."BITMAP_ID"
|
|
TimeTypeCount
|
Edm.Int32
|
Return count of Time Types
Name and Properties of TimeTypes: See TimeType
1 = Only Work time: TimeType("A")
2 = Additional Setup Time = TimeType("A") + TimeType("R")
3 = Additional Second time TimeType("A") + TimeType("R") + TimeType("N")
4 = Additional Third time TimeType("A") + TimeType("R") + TimeType("N") + TimeType("H")
Example: Return all Time Types for this Resource
In Variable ll_timetypecount the result form Resource/TimeTypeCount is saved
TimeType&$filter=TimeTypeCount le [ll_tyimetypecount]
{
"value": [
{
"TimeTypeId": "A",
"TimeTypeDescription": "Work time",
"ChangeQuantity": true,
"ChangeScrap": true,
"ReceiptAssembly": true,
"IssueMaterial": true,
"ClosePosition": true,
"ActivateNextPosition": true,
"TimeTypeCount": 1
},
{
"TimeTypeId": "R",
"TimeTypeDescription": "Tool time",
"ChangeQuantity": false,
"ChangeScrap": false,
"ReceiptAssembly": false,
"IssueMaterial": false,
"ClosePosition": false,
"ActivateNextPosition": false,
"TimeTypeCount": 2
}
]
}
Define count of cost elements, which you want using for this resource
Constraints:
1 cost element=0
2 cost elements=1
3 cost elements=2
4 cost elements=3
Integration hub: Importable
Database: coalesce("BEAS_APLATZ"."COSTEXTENTED",0) +1
|
|
BranchId
|
Edm.Int32
|
Integration hub: Importable
Database: "BEAS_APLATZ"."BPLId"
|
|
InterruptionId
|
Edm.String(20)
|
Database: (select min("BEAS_APLATZ_STILLSTAND"."INTNR") from "BEAS_APLATZ_STILLSTAND" WITH (NOLOCK) where "BEAS_APLATZ_STILLSTAND"."APLATZ_ID"="BEAS_APLATZ"."APLATZ_ID" and year("BEAS_APLATZ_STILLSTAND"."DATUM_BIS")=2050)
|
|
CurrentRunningCurrentPersonnel
|
Edm.Boolean
|
Database: case when (select count(*) from "BEAS_FTSTMP" WITH (NOLOCK) where "BEAS_FTSTMP"."APLATZ_ID" = "BEAS_APLATZ"."APLATZ_ID" and "BEAS_FTSTMP"."PERS_ID"=) > 0 then 1 else 0 end
|
|
CurrentRunning
|
Edm.Boolean
|
Database: case when (select count(*) from "BEAS_FTSTMP" WITH (NOLOCK) where "BEAS_FTSTMP"."APLATZ_ID"="BEAS_APLATZ"."APLATZ_ID") > 0 then 1 else 0 end
|
|
ForPersonnelId
|
Edm.String(20)
|
Define, if user can use the Resource. This is defined in Personnel - FDC - Resource 1..6
For using, you must define the ForPersonnelId in the filter
Example
Return all resources, which Personnel Id 5 can choose
Resource?$select=ResourceId,ResourceDescription&$filter=ForPersonnelId eq '5'
{ "value": [
{
"ResourceId": "1300",
"ResourceDescription": "Welding"
}
]
}
Database: case when ='' then '' when (select count(*) from "BEAS_PERS" p where p."PERS_ID"= and ( (rtrim("BEAS_APLATZ"."APLATZ_ID") like rtrim(p."APLATZ_ID") and rtrim(coalesce(p."APLATZ_ID" ,''))<>'' ) or (rtrim("BEAS_APLATZ"."A
|
|
ForRoutingId
|
Edm.String(20)
|
Database: case coalesce( (SELECT ressourcenwechsel FROM beas_pers where pers_id=),1 )when 0 thencase when(select count(*)
|
|
ProductionLine
|
Edm.String(50)
|
Database: "BEAS_APLATZ"."WMS_PRODLINE"
|
|
UDF1
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APLATZ"."UDF1"
|
|
UDF2
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APLATZ"."UDF2"
|
|
UDF3
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APLATZ"."UDF3"
|
|
UDF4
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APLATZ"."UDF4"
|
|
UDF5
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APLATZ"."UDF5"
|
|
UDF6
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APLATZ"."UDF6"
|
|
UDF7
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APLATZ"."UDF7"
|
|
UDF8
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APLATZ"."UDF8"
|
|
UDF9
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APLATZ"."UDF9"
|
|
UDF10
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APLATZ"."UDF10"
|
|
UDF11
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APLATZ"."UDF11"
|
|
UDF12
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APLATZ"."UDF12"
|
|
UDF13
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APLATZ"."UDF13"
|
|
UDF14
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APLATZ"."UDF14"
|
|
UDF15
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APLATZ"."UDF15"
|
|
