Name
|
Type
|
Description
|
DocEntry
|
Edm.Int32
|
Entity Relation: Workorder -> DocEntry
Database: "BEAS_FTAPL"."BELNR_ID"
|
|
LineNumber
|
Edm.Int32
|
Database: "BEAS_FTAPL"."BELPOS_ID"
|
|
LineNumber2
|
Edm.Int32
|
Database: "BEAS_FTAPL"."POS_ID"
|
|
ResourceId
|
Edm.String(20)
|
Entity Relation: Resource -> ResourceId
Entity Relation: Resource -> ResourceId
Database: rtrim("BEAS_FTAPL"."APLATZ_ID")
|
|
CatalogId
|
Edm.String(20)
|
Database: rtrim("BEAS_FTAPL"."AG_ID")
|
|
OperationTypeId
|
Edm.String(20)
|
Entity Relation: OperationType -> OperationTypeId
Database: rtrim("BEAS_FTAPL"."AGTYP")
|
|
SortId
|
Edm.Int32
|
Database: coalesce("BEAS_FTAPL"."SortId","BEAS_FTAPL"."POS_ID")
|
|
Position
|
Edm.String(20)
|
Database: "BEAS_FTAPL"."POS_TEXT"
|
|
ClockMandatory
|
Edm.Boolean
|
Database: case when coalesce("BEAS_FTAPL"."BDE",'J')='J' then 1 else 0 end
|
|
Barcode
|
Edm.String(20)
|
Database: cast("BEAS_FTAPL"."NUMMER" as varchar(20))
|
|
Closed
|
Edm.Boolean
|
Database: CASE WHEN coalesce("BEAS_FTHAUPT"."ABGKZ",'') = 'J' or coalesce("BEAS_FTPOS"."ABGKZ",'')='J' or coalesce("BEAS_FTAPL"."ABGKZ",'')='J' THEN 1 ELSE 0 END
|
|
RoutingColor
|
Edm.Int32
|
Database: "BEAS_FTAPL"."COLORID"
|
|
RoutingBitmap
|
Edm.String(50)
|
Database: "BEAS_FTAPL"."BITMAPNAME"
|
|
Description
|
Edm.String(255)
|
Database: "BEAS_FTAPL"."BEZ"
|
|
FirstLine
|
Edm.Boolean
|
return 1, if this the first routing position, with Clock Mandatory=true
Database: case when "BEAS_FTAPL"."SortId" = (select min(ftl."SortId") from "BEAS_FTAPL" as ftl where ftl."BELNR_ID"="BEAS_FTAPL"."BELNR_ID" and ftl."BELPOS_ID"="BEAS_FTAPL"."BELPOS_ID" and coalesce(ftl."BDE",'J')='J') then 1 else 0 end
|
|
LastLine
|
Edm.Boolean
|
return 1, if this the last routing position, with Clock Mandatory=true
Database: case when "BEAS_FTAPL"."SortId" = (select max(ftl."SortId") from "BEAS_FTAPL" as ftl where ftl."BELNR_ID"="BEAS_FTAPL"."BELNR_ID" and ftl."BELPOS_ID"="BEAS_FTAPL"."BELPOS_ID" and coalesce(ftl."BDE",'J')='J') then 1 else 0 end
|
|
CurrentRunningCurrentPersonnel
|
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"."BELPOS_ID" and "BEAS_FTSTMP"."POS_ID"="BEAS_FTAPL"."POS_ID" and "BEAS_FTSTMP"."WKZPOS_ID"=0 an
|
|
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"."BELPOS_ID" and "BEAS_FTSTMP"."POS_ID"="BEAS_FTAPL"."POS_ID" and "BEAS_FTSTMP"."WKZPOS_ID"=0) >
|
|
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"."APLATZ_ID" and year("BEAS_APLATZ_STILLSTAND"."DATUM_BIS")=2050)
|
|
RUoMFactor
|
Edm.Decimal
|
Determines the factor between Production Unit of the Assembly and Confirm Unit in Time receipt message
Example:
Production Unit = kg
Confirm unit = Liter, Factor = 1.2
If you create a time receipt with 1 Liter, you confirm 1,2 kg in production unit
Database: coalesce("BEAS_FTAPL"."RM_FAKTOR",1)
|
|
RUoM
|
Edm.String(20)
|
Determines the Confirm Unit in Time receipt message
Example:
Production Unit = kg
Confirm unit = Liter, Factor = 1.2
If you create a time receipt with 1 Liter, you confirm 1,2 kg in production unit
Database: case when rtrim(coalesce("BEAS_FTAPL"."RM_ME_ID",''))='' then "BEAS_FTPOS"."ME_VERBRAUCH" else "BEAS_FTAPL"."RM_ME_ID" end
|
|
Instructions
|
Edm.String(16000)
|
Database: "BEAS_FTAPL"."ANWEISUNGEN"
|
|
Picture1
|
Edm.String(100)
|
Database: "BEAS_FTAPL"."BILD1"
|
|
Picture2
|
Edm.String(100)
|
Database: "BEAS_FTAPL"."BILD2"
|
|
Picture3
|
Edm.String(100)
|
Database: "BEAS_FTAPL"."BILD3"
|
|
TotalStartTime
|
Edm.String
|
Database: "BEAS_FTAPL"."ANFZEIT"
|
|
TransferStartTime
|
Edm.String
|
Database: "BEAS_FTAPL"."UEBERGABE_ANFZEIT"
|
|
TransferEndTime
|
Edm.String
|
Database: "BEAS_FTAPL"."UEBERGABE_ENDZEIT"
|
|
ProcessingStartTime
|
Edm.String
|
Database: "BEAS_FTAPL"."ANFZEIT"
|
|
ProcessingEndTime
|
Edm.String
|
Database: "BEAS_FTAPL"."ENDZEIT"
|
|
IdleStartTime
|
Edm.String
|
Database: "BEAS_FTAPL"."LIEGEZEIT_ANFZEIT"
|
|
IdleEndTime
|
Edm.String
|
Database: "BEAS_FTAPL"."LIEGEZEIT_ENDZEIT"
|
|
TotalEndTime
|
Edm.String
|
Database: "BEAS_FTAPL"."ENDZEIT"
|
|
QuantityProduced
|
Edm.Decimal
|
Database: (select coalesce(sum("MENGE_GUT"),0)+coalesce(sum("MENGE_SCHLECHT"),0) FROM "BEAS_ARBZEIT" WHERE "BELNR_ID"="BEAS_FTAPL"."BELNR_ID" and "BELPOS_ID"="BEAS_FTAPL"."BELPOS_ID" and "POS_ID"="BEAS_FTAPL"."POS_ID" and "RESOURCENPOS_ID"=0 and coalesce(cancel,0)=
|
|
ForPersonnelId
|
Edm.String(20)
|
Database: case when ='' or (select count(*) from "BEAS_PERS" p where p."PERS_ID"= and coalesce(p."ALLESANMELDBAR",0)=0)=0 then else case when coalesce((SELECT min("BEAS_FTPOOL"."POOL_ID") FROM "BEAS_FTPOOL" WHERE
|
|
UDF1
|
Edm.String(50)
|
Database: "BEAS_FTAPL"."UDF1"
|
|
UDF2
|
Edm.String(50)
|
Database: "BEAS_FTAPL"."UDF2"
|
|
UDF3
|
Edm.String(50)
|
Database: "BEAS_FTAPL"."UDF3"
|
|
UDF4
|
Edm.String(50)
|
Database: "BEAS_FTAPL"."UDF4"
|
|