GET

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