Name
|
Type
|
Description
|
DocEntry
|
Edm.Int32
|
Entity Relation: Workorder -> DocEntry
Database: "BEAS_FTAPL_WKZ"."BELNR_ID"
|
|
LineNumber
|
Edm.Int32
|
Database: "BEAS_FTAPL_WKZ"."BELPOS_ID"
|
|
LineNumber2
|
Edm.Int32
|
Database: "BEAS_FTAPL_WKZ"."POS_ID"
|
|
LineNumber3
|
Edm.Int32
|
Database: "BEAS_FTAPL_WKZ"."WKZPOS_ID"
|
|
Position
|
Edm.Int32
|
Database: "BEAS_FTAPL_WKZ"."POS2_ID"
|
|
Typ
|
Edm.String(20)
|
Database: case "BEAS_FTAPL_WKZ"."RESOURCENTYP" when 'A' then 'Parallel' when 'R' then 'Alternative' else 'Tool' end
|
|
Active
|
Edm.Boolean
|
Database: coalesce("BEAS_FTAPL_WKZ"."AKTIV",1)
|
|
Alternativ
|
Edm.Boolean
|
Database: coalesce("BEAS_FTAPL_WKZ"."ALTERNATIV",0)
|
|
ResourceId
|
Edm.String(20)
|
Entity Relation: Resource -> ResourceId
Database: rtrim("BEAS_FTAPL_WKZ"."WKZ_ID")
|
|
ParallelInformation
|
Edm.String(255)
|
Database: "BEAS_FTAPL_WKZ"."ZUSATZINFO"
|
|
Barcode
|
Edm.String(20)
|
Database: cast("BEAS_FTAPL"."NUMMER" as varchar(10)) +right('000'+cast("BEAS_FTAPL_WKZ"."WKZPOS_ID" as varchar(6)),3)
|
|
CurrentRunningCurrentPersonnel
|
Edm.Boolean
|
Database: case when (select count(*) from "BEAS_FTSTMP" WITH (NOLOCK) where "BEAS_FTSTMP"."BELNR_ID"="BEAS_FTAPL_WKZ"."BELNR_ID" and "BEAS_FTSTMP"."BELPOS_ID"="BEAS_FTAPL_WKZ"."BELPOS_ID" and "BEAS_FTSTMP"."POS_ID"="BEAS_FTAPL"."POS_ID" and "BEAS_FTSTMP"."WKZPOS_
|
|
CurrentRunning
|
Edm.Boolean
|
Database: case when (select count(*) from "BEAS_FTSTMP" WITH (NOLOCK) where "BEAS_FTSTMP"."BELNR_ID"="BEAS_FTAPL"."BELNR_ID" and "BEAS_FTSTMP"."BELPOS_ID"="BEAS_FTAPL_WKZ"."BELPOS_ID" and "BEAS_FTSTMP"."POS_ID"="BEAS_FTAPL"."POS_ID" and "BEAS_FTSTMP"."WKZPOS_ID"=
|
|
InterruptionId
|
Edm.String(20)
|
Database: (select min("BEAS_APLATZ_STILLSTAND"."INTNR") from "BEAS_APLATZ_STILLSTAND" WITH (NOLOCK) where "BEAS_APLATZ_STILLSTAND"."APLATZ_ID"="BEAS_FTAPL_WKZ"."WKZ_ID" and year("BEAS_APLATZ_STILLSTAND"."DATUM_BIS")=2050)
|
|
RUoMFactor
|
Edm.Decimal
|
Database: coalesce("BEAS_FTAPL"."RM_FAKTOR",1)
|
|
RUoM
|
Edm.String(20)
|
Database: coalesce("BEAS_FTAPL"."RM_ME_ID","BEAS_FTPOS"."ME_VERBRAUCH")
|
|
