WorkorderRouting
Property |
Description |
Table |
BEAS_FTAPL |
Primary key |
DocEntry/i,LineNumber/i,LineNumber2/i |
$transaction |
yes |
$branch |
no |
$mask |
no |
Name |
Type |
Description |
|
DocEntry |
Edm.Int32 |
|
|
LineNumber |
Edm.Int32 |
|
|
LineNumber2 |
Edm.Int32 |
|
|
ResourceId |
Edm.String(20) |
|
|
CatalogId |
Edm.String(20) |
|
|
OperationTypeId |
Edm.String(20) |
|
|
SortId |
Edm.Int32 |
|
|
Position |
Edm.String(20) |
|
|
ClockMandatory |
Edm.Boolean |
|
|
Barcode |
Edm.String(20) |
|
|
Closed |
Edm.Boolean |
|
|
RoutingColor |
Edm.Int32 |
|
|
RoutingBitmap |
Edm.String(50) |
|
|
Description |
Edm.String(255) |
|
|
FirstLine |
Edm.Boolean |
|
|
LastLine |
Edm.Boolean |
|
|
CurrentRunningCurrentPersonnel |
Edm.Boolean |
|
|
CurrentRunning |
Edm.Boolean |
|
|
InterruptionId |
Edm.String(20) |
|
|
RUoMFactor |
Edm.Decimal |
|
|
RUoM |
Edm.String(20) |
|
|
Instructions |
Edm.String(16000) |
|
|
Picture1 |
Edm.String(100) |
|
|
Picture2 |
Edm.String(100) |
|
|
Picture3 |
Edm.String(100) |
|
|
TotalStartTime |
Edm.String |
|
|
TransferStartTime |
Edm.String |
|
|
TransferEndTime |
Edm.String |
|
|
ProcessingStartTime |
Edm.String |
|
|
ProcessingEndTime |
Edm.String |
|
|
IdleStartTime |
Edm.String |
|
|
IdleEndTime |
Edm.String |
|
|
TotalEndTime |
Edm.String |
|
|
QuantityProduced |
Edm.Decimal |
|
|
ForPersonnelId |
Edm.String(20) |
|
|
UDF1 |
Edm.String(50) |
|
|
UDF2 |
Edm.String(50) |
|
|
UDF3 |
Edm.String(50) |
|
|
UDF4 |
Edm.String(50) |
|
Join to Entiy Object |
Relation |
Workorder |
DocEntry |
WorkorderPos |
DocEntry,LineNumber |
Resource |
ResourceId |
WorkorderRoutingParallel |
DocEntry,LineNumber,LineNumber2 |
TimeReceipt |
DocEntry,LineNumber,LineNumber2 |
UoMConsumption |
UoMCode=RUoM |
OperationType |
OperationTypeId |
Resource |
ResourceId |
TimeReceiptRunning |
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",
"OperationTypeId": "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,
"Picture1": null,
"Picture2": null,
"Picture3": 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",
"OperationTypeId": "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": 39,
"RUoMFactor": 1,
"RUoM": "l",
"Instructions": null,
"Picture1": null,
"Picture2": null,
"Picture3": 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",
"OperationTypeId": "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}",
"Picture1": null,
"Picture2": null,
"Picture3": null,
"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"
}
]
}
]
}
Geben Sie hier den Text ein.