Entity Relation: Workorder -> DocEntry

Database: "BEAS_FTAPL"."BELNR_ID"

Database: "BEAS_FTAPL"."BELPOS_ID"

Database: "BEAS_FTAPL"."POS_ID"

Entity Relation: Resource -> ResourceId

Entity Relation: Resource -> ResourceId

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

Database: rtrim("BEAS_FTAPL"."AG_ID")

Entity Relation: OperationType -> OperationTypeId

Database: rtrim("BEAS_FTAPL"."AGTYP")

Database: coalesce("BEAS_FTAPL"."SortId","BEAS_FTAPL"."POS_ID")

Database: "BEAS_FTAPL"."POS_TEXT"

Database: case when coalesce("BEAS_FTAPL"."BDE",'J')='J' then 1 else 0 end

Database: cast("BEAS_FTAPL"."NUMMER" as varchar(20))

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

Database: "BEAS_FTAPL"."COLORID"

Database: "BEAS_FTAPL"."BITMAPNAME"

Database: "BEAS_FTAPL"."BEZ"

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

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

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

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) >

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)

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)

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

Database: "BEAS_FTAPL"."ANWEISUNGEN"

Database: "BEAS_FTAPL"."BILD1"

Database: "BEAS_FTAPL"."BILD2"

Database: "BEAS_FTAPL"."BILD3"

Database: "BEAS_FTAPL"."ANFZEIT"

Database: "BEAS_FTAPL"."UEBERGABE_ANFZEIT"

Database: "BEAS_FTAPL"."UEBERGABE_ENDZEIT"

Database: "BEAS_FTAPL"."ANFZEIT"

Database: "BEAS_FTAPL"."ENDZEIT"

Database: "BEAS_FTAPL"."LIEGEZEIT_ANFZEIT"

Database: "BEAS_FTAPL"."LIEGEZEIT_ENDZEIT"

Database: "BEAS_FTAPL"."ENDZEIT"

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)=

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

Database: "BEAS_FTAPL"."UDF1"

Database: "BEAS_FTAPL"."UDF2"

Database: "BEAS_FTAPL"."UDF3"

Database: "BEAS_FTAPL"."UDF4"