Interruption

Interruption

 

Property

Description

Table

BEAS_APLATZ_STILLSTAND

Primary key

ResourceId/c,DocEntry/i

$transaction

no

$branch

no

$mask

no

 

Fields

Name

Type

Description

ResourceId

Edm.String(20)

Entity Relation: Resource -> ResourceId

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

DocEntry

Edm.Int32

Database: "BEAS_APLATZ_STILLSTAND"."INTNR"

ResourceType

Edm.String(20)

Database: coalesce("BEAS_APLATZ_STILLSTAND"."RESOURCETYPE",'resource')

ReasonId

Edm.String(20)

Entity Relation: InterruptionReason -> ReasonId

Database: rtrim("BEAS_APLATZ_STILLSTAND"."GRUNDID")

Description

Edm.String(255)

Database: rtrim("BEAS_APLATZ_STILLSTAND"."GRUNDINFO")

StartDateTime

Edm.DateTimeOffset

Database: "BEAS_APLATZ_STILLSTAND"."DATUM_VON"

EndDateTime

Edm.DateTimeOffset

Database: "BEAS_APLATZ_STILLSTAND"."DATUM_BIS"

StatusId

Edm.Int32

Database: "BEAS_APLATZ_STILLSTAND"."statusId"

Closed

Edm.Boolean

Database: case when coalesce("BEAS_APLATZ_STILLSTAND"."statusId",0)=0 then 0 else 1 end

DontStopTimeCounter

Edm.Boolean

Database: coalesce("BEAS_APLATZ_STILLSTAND"."DontStoppTimeCounter",1)

PersonnelId

Edm.String(20)

Database: coalesce("BEAS_APLATZ_STILLSTAND"."PERS_ID",'')

PersonnelName

Edm.String(100)

Database: coalesce("BEAS_APLATZ_STILLSTAND"."PERS_ID_Name",'')

StopByPersonnelId

Edm.String(20)

Database: coalesce("BEAS_APLATZ_STILLSTAND"."PERS_ID_END",'')

StopByPersonnelName

Edm.String(100)

Database: coalesce("BEAS_APLATZ_STILLSTAND"."PERS_ID_END_Name",'')

BaseType

Edm.String(20)

Database: coalesce("BEAS_APLATZ_STILLSTAND"."BaseType",'')

BaseDocEntry

Edm.Int32

Database: coalesce("BEAS_APLATZ_STILLSTAND"."BaseDocNum",0)

BaseLineNumber

Edm.Int32

Database: coalesce("BEAS_APLATZ_STILLSTAND"."BaseLine",0)

BaseLineNumber2

Edm.Int32

Database: coalesce("BEAS_APLATZ_STILLSTAND"."BASELINE2",0)

UDF1

Edm.String(100)

Database: "BEAS_APLATZ_STILLSTAND"."UDF1"

UDF2

Edm.String(100)

Database: "BEAS_APLATZ_STILLSTAND"."UDF2"

UDF3

Edm.String(100)

Database: "BEAS_APLATZ_STILLSTAND"."UDF3"

UDF4

Edm.String(100)

Database: "BEAS_APLATZ_STILLSTAND"."UDF4"

 

Relations

Join to Entiy Object

Relation

Resource

ResourceId

Tool

ToolId=ResourceId

InterruptionReason

ReasonId

 

hmtoggle_plus0Start/Create an interruption

With the following post command an interruption can be started or create a new one if the "InterruptionId" is set to 0.

This command is based on "ue_interruption".

 

 

post Interruption
 {

   "action":"start",

   "ResourceId":"1500",

   "ResourceType":"resource",

   "InterruptionId":0,

   "InterruptionReasonId":"cleaning",

   "ReasonInfo":"my text for the reason",

   "Udf1":"",

   "Udf2":"",

   "Udf3":"",

   "Udf4":"",

   "PersonnelId":"",

   "PersonnelId_end":"",

   "BaseType":"",

   "PlanId":"",        

   "DateTime_From":"",

   "DateTime_To":"",                                                

   "StatusId":"",

   "BaseDocNum":"",

   "BaseLine":"",

   "BaseLine2":"",

   "MaintenanceNr":"",

 }

 

Returnsyes

{

   "DocEntry": 123,

   "BaseType": "mtc",

   "BaseDocNum": 456

}

 

Example:

{

   "action":"start",

   "ResourceId":"1500",

   "ResourceType":"resource",

   "InterruptionReasonId":"typ1",

   "ReasonInfo":"my text for the reason",

   "PersonnelId":"3",

   "DateTime_From":"2019/05/27 10:00",

   "DateTime_To":""                                                

 

 }

 

Property for the POST command

Type

Description

action

Edm.String

Must be start

ResourceId

Edm.String

The resource ID

InterruptionId

Edm.Int32

The Interruption ID

- =0 will create a new one

- >0 will load the interruption ID for the resource and allow to modify the information

InterruptionReasonId

Edm.String

The interruption reason ID

ReasonInfo

Edm.String

The Reason Info, if it's empty we use the Reason text for the given Interruption Reason Id "InterruptionReasonId"

ResourceType

Edm.String

Type of resource: resource/tool

If it's empty we use "resource"

Udf1..4

Edm.String

User define fields from Udf1 to Udf4

PersonnelId

Edm.String

Set the personell number, which is starting the interruption

PersonnelId_end

Edm.String

Set the personell number, which is ending the interruption

BaseType

Edm.String

Linked to document

mtc = maintenance

PlanId

Edm.Int32

Set the plan id for the maintenance order (see maintenancenr)

DateTime_From

Edm.Date

Set the start date/time for the interruption

DateTime_To

Edm.Date

Set the stop date/time for the interruption

StatusId

Edm.Int32

Set the status for this interruption:
0 - Active

1 - Planned

2 - Completed

BaseDocNum

Edm.Int32

The linked docnum/docentry

BaseLine

Edm.Int32

Interruption

BaseLine2

Edm.Int32

MaintenanceNr

Edm.Int32

You set a maintenance nr and the flag "BEAS_STILLSTANDGRUND"."CreateMaintenance" in the reason-settings is active, then beas create a maintenance order

 

if nr is empty, beas get the correct nr and planid automatically

hmtoggle_plus0Stop an interruption

With the following post command a started interruption can be stopped.

This command is based on "ue_interruption".

 

post Interruption
 {"action":"stop",
  "ResourceId":"1500",
  "InterruptionId":123

}

 

Returns

 

{

   "DocEntry": 123

}

 

 

Property for the POST command

Type

Description

action

Edm.String

Must be stop

ResourceId

Edm.String

The resource ID

Interruption

Edm.Int32

The interruption ID