WorkorderRouting

Contents

WorkorderRouting

Property	Description
Table	BEAS_FTAPL
Primary key	DocEntry/i,LineNumber/i,LineNumber2/i
$transaction	yes
$branch	no
$mask	no

Fields

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

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

CatalogId

Edm.String(20)

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

RoutingType

Edm.String(20)

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

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"

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"

Relations

Join to Entiy Object	Relation
Workorder	DocEntry
WorkorderPos	DocEntry,LineNumber
Resource	ResourceId
WorkorderRoutingParallel	DocEntry,LineNumber,LineNumber2
TimeReceipt	DocEntry,LineNumber,LineNumber2
UoMConsumption	UoMCode=RUoM

All Work order Routing Position from Workorder 1308 / 10 with parallel resource


WorkorderRouting?$select=*,WorkorderRoutingParallel&$filter=DocEntry eq 1308 and LineNumber eq 10&$expand=WorkorderRoutingParallel

{
    
    "value": [
         {
        "DocEntry": 1308,
        "LineNumber": 10,
        "LineNumber2": 10,
        "ResourceId": "i1004",
        "CatalogId": "3",
        "RoutingType": "Assembly",
        "SortId": 1,
        "Position": "10",
        "ClockMandatory": true,
        "Barcode": "3002992",
        "Closed": true,
        "RoutingColor": null,
        "RoutingBitmap": null,
        "Description": "Assembling ",
        "FirstLine": true,
        "LastLine": false,
        "CurrentRunningCurrentPersonnel": false,
        "CurrentRunning": false,
        "InterruptionId": null,
        "RUoMFactor": 1,
        "RUoM": "Pcs",
        "Instructions": null,
        "TotalStartTime": "2019-09-24T05:03Z",
        "TransferStartTime": "2019-09-24T05:03Z",
        "TransferEndTime": "2019-09-24T05:03Z",
        "ProcessingStartTime": "2019-09-24T05:03Z",
        "ProcessingEndTime": "2019-09-24T05:03Z",
        "IdleStartTime": "2019-09-24T05:03Z",
        "IdleEndTime": "2019-09-24T05:03Z",
        "TotalEndTime": "2019-09-24T05:03Z",
        "QuantityProduced": 3,
        "ForPersonnelId": "",
        "UDF1": null,
        "UDF2": null,
        "UDF3": null,
        "UDF4": null,
        "WorkorderRoutingParallel": [
         {
        "DocEntry": 1308,
        "LineNumber": 10,
        "LineNumber2": 10,
        "LineNumber3": 46,
        "Position": 10,
        "Typ": "Parallel",
        "Active": true,
        "Alternativ": false,
        "ResourceId": "i1004",
        "ParallelInformation": null,
        "Barcode": "3002992046",
        "CurrentRunningCurrentPersonnel": false,
        "CurrentRunning": false,
        "InterruptionId": null,
        "RUoMFactor": 1,
        "RUoM": "Pcs"
        }
    ]

        },
         {
        "DocEntry": 1308,
        "LineNumber": 10,
        "LineNumber2": 20,
        "ResourceId": "1800",
        "CatalogId": "i1005",
        "RoutingType": "Assembly",
        "SortId": 3,
        "Position": "20",
        "ClockMandatory": true,
        "Barcode": "3002993",
        "Closed": true,
        "RoutingColor": null,
        "RoutingBitmap": null,
        "Description": " ",
        "FirstLine": false,
        "LastLine": true,
        "CurrentRunningCurrentPersonnel": false,
        "CurrentRunning": false,
        "InterruptionId": null,
        "RUoMFactor": 1,
        "RUoM": "l",
        "Instructions": null,
        "TotalStartTime": "2019-09-25T16:50Z",
        "TransferStartTime": "2019-09-24T16:50Z",
        "TransferEndTime": "2019-09-25T16:50Z",
        "ProcessingStartTime": "2019-09-25T16:50Z",
        "ProcessingEndTime": "2019-09-25T16:50Z",
        "IdleStartTime": "2019-09-25T16:50Z",
        "IdleEndTime": "2019-09-25T16:50Z",
        "TotalEndTime": "2019-09-25T16:50Z",
        "QuantityProduced": 0,
        "ForPersonnelId": "",
        "UDF1": null,
        "UDF2": null,
        "UDF3": null,
        "UDF4": null,
        "WorkorderRoutingParallel": [
    ]

        },
         {
        "DocEntry": 1308,
        "LineNumber": 10,
        "LineNumber2": 30,
        "ResourceId": "7110",
        "CatalogId": "2",
        "RoutingType": "Assembly",
        "SortId": 2,
        "Position": "15",
        "ClockMandatory": false,
        "Barcode": "3002994",
        "Closed": true,
        "RoutingColor": null,
        "RoutingBitmap": null,
        "Description": "Molding",
        "FirstLine": false,
        "LastLine": false,
        "CurrentRunningCurrentPersonnel": false,
        "CurrentRunning": false,
        "InterruptionId": null,
        "RUoMFactor": 1,
        "RUoM": "Pcs",
        "Instructions": "{\\rtf1\\ansi\\ansicpg1252\\uc1\\deff0{\\fonttbl\r\n{\\f0\\fswiss\\fcharset0\\fprq2 Arial;}\r\n{\\f1\\fswiss\\fcharset0\\fprq2 Tahoma;}\r\n{\\f2\\froman\\fcharset2\\fprq2 Symbol;}}\r\n{\\colortbl;\\red0\\green0\\blue0;\\red255\\green255\\blue255;\\red255\\green0\\blue0;}\r\n{\\stylesheet{\\s0\\itap0\\nowidctlpar\\f0\\fs24 [Normal];}{\\*\\cs10\\additive Default Paragraph Font;}}\r\n{\\*\\generator TX_RTF32 13.0.501.502;}\r\n\\deftab1134\\paperw11905\\paperh16838\\margl0\\margt0\\margr0\\margb0\\widowctrl\r\n{\\*\\background{\\shp{\\*\\shpinst\\shpleft0\\shptop0\\shpright0\\shpbottom0\\shpfhdr0\\shpbxmargin\\shpbxignore\\shpbymargin\\shpbyignore\\shpwr0\\shpwrk0\\shpfblwtxt1\\shplid1025{\\sp{\\sn shapeType}{\\sv 1}}{\\sp{\\sn fFlipH}{\\sv 0}}{\\sp{\\sn fFlipV}{\\sv 0}}{\\sp{\\sn fillColor}{\\sv 16777215}}{\\sp{\\sn fFilled}{\\sv 1}}{\\sp{\\sn lineWidth}{\\sv 0}}{\\sp{\\sn fLine}{\\sv 0}}{\\sp{\\sn fBackground}{\\sv 1}}{\\sp{\\sn fLayoutInCell}{\\sv 1}}}}}\\pard\\itap0\\nowidctlpar\\plain\\f1\\fs20 my \\plain\\f1\\fs20\\cf3 description\\par}",
        "TotalStartTime": "2019-09-24T13:50Z",
        "TransferStartTime": "2019-09-24T13:50Z",
        "TransferEndTime": "2019-09-24T13:50Z",
        "ProcessingStartTime": "2019-09-24T13:50Z",
        "ProcessingEndTime": "2019-09-25T08:09Z",
        "IdleStartTime": "2019-09-25T08:09Z",
        "IdleEndTime": "2019-09-25T11:08Z",
        "TotalEndTime": "2019-09-25T08:09Z",
        "QuantityProduced": 3,
        "ForPersonnelId": "",
        "UDF1": null,
        "UDF2": null,
        "UDF3": null,
        "UDF4": null,
        "WorkorderRoutingParallel": [
         {
        "DocEntry": 1308,
        "LineNumber": 10,
        "LineNumber2": 30,
        "LineNumber3": 113,
        "Position": 10,
        "Typ": "Parallel",
        "Active": true,
        "Alternativ": false,
        "ResourceId": "i1004",
        "ParallelInformation": null,
        "Barcode": "3002994113",
        "CurrentRunningCurrentPersonnel": false,
        "CurrentRunning": false,
        "InterruptionId": null,
        "RUoMFactor": 1,
        "RUoM": "Pcs"
        }
    ]

        }
    ]

}