GET

PoolReport

 

Property

Description

Table

BEAS_TEMPREPORT

Primary key

PoolReportId/i

$transaction

no

$branch

no

$mask

no

 

Fields

Name

Type

Description

PoolReportId

Edm.Int32

Database: "BEAS_TEMPREPORT"."ID"

LineId

Edm.Int32

Database: "BEAS_TEMPREPORT"."NR"

DocEntry

Edm.Int32

Entity Relation: Workorder -> DocEntry

Database: "BEAS_TEMPREPORT"."BELNR_ID"

LineNumber

Edm.Int32

Database: "BEAS_TEMPREPORT"."BELPOS_ID"

LineNumber2

Edm.Int32

Database: "BEAS_TEMPREPORT"."POS_ID"

LineNumber3

Edm.Int32

Database: "BEAS_TEMPREPORT"."POS2_ID"

ResourceId

Edm.String(20)

Entity Relation: Resource -> ResourceId

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

ItemCode

Edm.String(50)

Database: "BEAS_TEMPREPORT"."ItemCode"

Duration

Edm.Int32

Database: "BEAS_TEMPREPORT"."DECIMALPARM1"

SortDate

Edm.DateTimeOffset

Database: pool."VON"

RunningSince

Edm.DateTimeOffset

Database: (select min("AB") from "BEAS_FTSTMP" f where f."BELNR_ID"="BEAS_TEMPREPORT"."BELNR_ID" and f."BELPOS_ID"="BEAS_TEMPREPORT"."BELPOS_ID" and f."POS_ID"="BEAS_TEMPREPORT"."POS_ID" and f."WKZPOS_ID"="BEAS_TEMPREPORT"."POS2_ID" and f."PERS_ID"=

CurrentRunningCurrentPersonnel

Edm.Boolean

Database: case when (select count(*) from "BEAS_FTSTMP" WITH (NOLOCK) where "BEAS_FTSTMP"."BELNR_ID"="BEAS_TEMPREPORT"."BELNR_ID" and "BEAS_FTSTMP"."BELPOS_ID"="BEAS_TEMPREPORT"."BELPOS_ID" and "BEAS_FTSTMP"."POS_ID"="BEAS_TEMPREPORT"."POS_ID" and "BEAS_FTSTMP"."

CurrentRunning

Edm.Boolean

Database: case when (select count(*) from "BEAS_FTSTMP" WITH (NOLOCK) where "BEAS_FTSTMP"."BELNR_ID"="BEAS_TEMPREPORT"."BELNR_ID" and "BEAS_FTSTMP"."BELPOS_ID"="BEAS_TEMPREPORT"."BELPOS_ID" and "BEAS_FTSTMP"."POS_ID"="BEAS_TEMPREPORT"."POS_ID" and "BEAS_FTSTMP"."

ProcessingStartTime

Edm.String

Database: "BEAS_TEMPREPORT"."DATETIMEPARM1"

ProcessingEndTime

Edm.String

Database: "BEAS_TEMPREPORT"."DATETIMEPARM2"

MaterialInsufficient

Edm.String(255)

Database: "BEAS_TEMPREPORT"."STRINGPARM1"

 

Relations

Join to Entiy Object

Relation

Workorder

DocEntry

WorkorderPos

DocEntry,LineNumber

Resource

ResourceId

WorkorderRouting

DocEntry,LineNumber,LineNumber2,LineNumber3

WorkorderRoutingParallel

DocEntry,LineNumber,LineNumber2,LineNumber3

 

Functions

Function

Parameter

Description

Calculate

Personnel/c,StationId/c,MaterialCheck/b

Delete

Id/i

ResourceList

Id/i