Database: rtrim("BEAS_APLATZ"."APLATZ_ID")

Integration hub: Importable

Mandatory field

Database: "BEAS_APLATZ"."BEZ"

Database: rtrim("BEAS_APLATZ"."GRUPPE")

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

Integration hub: Importable

Database: case when coalesce("BEAS_APLATZ"."Active",'J')='N' then 0 else 1 end

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)

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

Integration hub: Importable

Database: "BEAS_APLATZ"."BILD1"

Integration hub: Importable

Database: "BEAS_APLATZ"."BILD2"

Integration hub: Importable

Database: "BEAS_APLATZ"."BILD3"

Integration hub: Importable

Database: "BEAS_APLATZ"."UDF1"

Integration hub: Importable

Database: "BEAS_APLATZ"."UDF2"

Integration hub: Importable

Database: "BEAS_APLATZ"."UDF3"

Integration hub: Importable

Database: "BEAS_APLATZ"."UDF4"

Integration hub: Importable

Database: "BEAS_APLATZ"."COLOR_ID"

Integration hub: Importable

Database: "BEAS_APLATZ"."BITMAP_ID"

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

Integration hub: Importable

Database: "BEAS_APLATZ"."BPLId"

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)

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

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

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

Database: case coalesce( (SELECT ressourcenwechsel FROM beas_pers where pers_id=),1 ) when 0 then case when (select count(*)