Interruption

Contents

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)

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

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

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