Processes a series of commands formed as a XML request, this allows to replace and/or update the routes for an item using a single XML document
Property |
Columnname in Table |
Description |
parentitemcode |
itemcode |
Item Code |
position |
pos_id |
position id |
operation |
ag_id |
link to beas_ag |
workcenter |
aplatz_id |
link to beas_aplatz |
description |
bez |
|
description2 |
anweisung |
|
kstst_id |
kstst_id |
|
activ |
aktivformel |
activ formular |
zeitaufnkz |
zeitaufndkz |
|
zeitaufndat |
zeitaufndat |
|
setupforcalculator |
traplatz |
|
setupforsched |
tr2aplatz |
|
maschinetime |
thaplatz |
|
labortime |
tnaplatz |
|
maschinelabortime |
teaplatz |
|
use |
nutzen |
|
number |
anzahl |
|
idletime |
tl |
|
wagegroup |
lohngruppe |
|
shareableresource |
mehrmasch_bed |
|
timesper |
menge_je |
|
timesin |
menge_zeitje |
1 (minute) or 60 (hours) |
clockmandantory |
bde |
y/n |
maschinegrouping |
mehrmaschinenbelegung |
y/n |
picture1 ... 3 |
bild1 ...3 |
3 Pictures |
inspectionplanqc |
qs_id |
|
cardcode |
cardcode |
declare=bom=ue_api_routing
setvar=xmlbuffer=<routegroup>& <command>replace</command>& <item>& <parentitemcode>_CEDRENEA</parentitemcode>& <route>& <position>10</position>& <operation>CORTE</operation>& <workcenter>Soldar</workcenter>& <routingdescription>CORTE</routingdescription>& <activ></activ>& <setupforcalculator>0.000000</setupforcalculator>& <setupforsched>0.000000</setupforsched>& <maschinetime>0.000000</maschinetime>& <labortime>0.000000</labortime>& <maschinelabortime>30.000000</maschinelabortime>& <use>1</use>& </route>& <route>& <position>20</position>& <operation>DECA</operation>& <workcenter>Soldar</workcenter>& <routingdescription>DECA</routingdescription>& <activ></activ>& <setupforcalculator>0.000000</setupforcalculator>& <setupforsched>0.000000</setupforsched>& <maschinetime>0.000000</maschinetime>& <labortime>0.000000</labortime>& <maschinelabortime>30.000000</maschinelabortime>& <use>1</use>& </route>& <route>& <position>30</position>& <operation>Soldar</operation>& <workcenter>Soldar</workcenter>& <routingdescription>Soldadura</routingdescription>& <activ></activ>& <setupforcalculator>0.000000</setupforcalculator>& <setupforsched>0.000000</setupforsched>& <maschinetime>0.000000</maschinetime>& <labortime>0.000000</labortime>& <maschinelabortime>30.000000</maschinelabortime>& <use>1</use>& </route>& <commit>true</commit>& </item>& </routegroup>
bom=processxmlrequest=<xmlbuffer> |
Example 2 for: processxmlrequest update route entries, each <route> entry acts as an UPSERT, if the entry exists it updates it, if it does not exists it creates it |
declare=bom=ue_api_routing
setvar=xmlbuffer=<routegroup>& <command>update</command>& <item>& <parentitemcode>_CEDRENEA</parentitemcode>& <route>& <position>10</position>& <operation>CORTE</operation>& <workcenter>Soldar</workcenter>& <routingdescription>CORTE</routingdescription>& <activ></activ>& <setupforcalculator>0.000000</setupforcalculator>& <setupforsched>0.000000</setupforsched>& <maschinetime>0.000000</maschinetime>& <labortime>0.000000</labortime>& <maschinelabortime>30.000000</maschinelabortime>& <use>1</use>& <commit>true</commit>& </route>& <route>& <position>25</position>& <operation>DECA</operation>& <workcenter>Soldar</workcenter>& <routingdescription>DECA</routingdescription>& <activ></activ>& <setupforcalculator>0.000000</setupforcalculator>& <setupforsched>0.000000</setupforsched>& <maschinetime>0.000000</maschinetime>& <labortime>0.000000</labortime>& <maschinelabortime>30.000000</maschinelabortime>& <use>1</use>& <commit>true</commit>& </route>& <route>& <position>30</position>& <operation>BURN-IN</operation>& <workcenter>BURN-IN</workcenter>& <routingdescription>BURN-INNN000101</routingdescription>& <activ></activ>& <setupforcalculator>0.000000</setupforcalculator>& <setupforsched>0.000000</setupforsched>& <maschinetime>0.000000</maschinetime>& <labortime>0.000000</labortime>& <maschinelabortime>30.000000</maschinelabortime>& <use>1</use>& <commit>true</commit>& </route>& </item>& </routegroup>
bom=processxmlrequest=<xmlbuffer> |