Oracle® Application Server Adapter for J.D. Edwards OneWorld User's Guide
10g Release 2 (10.1.2) B14059-02 |
|
Previous |
Next |
The Adapter for J.D. Edwards OneWorld supports the jdeRequest and jdeResponse XML structures for executing business functions within OneWorld. Using J.D. Edwards OneWorld XML, you can:
Aggregate business function calls into a single object.Use the J.D. Edwards OneWorld ThinNet API.Access both Z files and business functions.
The following topics provide examples of the jdeRequest and jdeResponse XML structures for executing business functions within OneWorld:
The following example, GetEffectiveAddress, is a single-function call to J.D. Edwards OneWorld, and the result of this request is a standard jdeResponse document. In a single-function request, only one callMethod within the XML object is specified.
Executing a Business Function with a Single-Function Call
The following is a sample GetEffectiveAddress jdeRequest.
<jdeRequest type="callmethod" user="JDE" pwd="JDE" environment="DV7333" session=""> <callMethod name="GetEffectiveAddress" app="BSE" runOnError="no"> <params> <param name="mnAddressNumber">1001</param> <param name="jdDateBeginningEffective"></param> <param name="cEffectiveDateExistence10"></param> <param name="szAddressLine1"></param> <param name="szAddressLine2"></param> <param name="szAddressLine3"></param> <param name="szAddressLine4"></param> <param name="szZipCodePostal"></param> <param name="szCity"></param> <param name="szCountyAddress"></param> <param name="szState"></param> <param name="szCountry"></param> <param name="szUserid"></param> <param name="szProgramid"></param> <param name="jdDateupdated"></param> <param name="szWorkstationid"></param> <param name="mnTimelastupdated"></param> <param name="szNamealpha"></param> </params> <onError abort="yes"></onError> </callMethod> </jdeRequest>
The following is a sample GetEffectiveAddress jdeResponse.
<?xml version="1.0"?> <!DOCTYPE jdeResponse> <jdeResponse environment="DV7333" pwd="JDE" session="516.1029417972.68" type="callmethod" user="JDE"> <callMethod app="BSE" name="GetEffectiveAddress" runOnError="no"> <returnCode code="0"/> <params> <param name="mnAddressNumber">1001</param> <param name="jdDateBeginningEffective"/> <param name="cEffectiveDateExistence10"/> <param name="szAddressLine1">8055 Tufts Avenue, Suite 1331 </param> <param name="szAddressLine2"> </param> <param name="szAddressLine3"> </param> <param name="szAddressLine4"> </param> <param name="szZipCodePostal">80237 </param> <param name="szCity">Denver </param> <param name="szCountyAddress"> </param> <param name="szState">CO</param> <param name="szCountry"/> <param name="szUserid"/> <param name="szProgramid"/> <param name="jdDateupdated"/> <param name="szWorkstationid"/> <param name="mnTimelastupdated">0</param> <param name="szNamealpha">J.D. Edwards & Company </param> </params> </callMethod> </jdeResponse>
The following example, GetEffectiveAddress, is a multiple-function call to J.D. Edwards OneWorld, and the result of this request is a standard jdeResponse document with multiple sections. In a multiple-function request, more than one callMethod within the XML object is specified.
Executing a Business Function with a Multiple-Function Call
The following is a sample Purchase Order in the jdeRequest format. The XML contains return parameter specifications as well as file cleanup logic.
<?xml version='1.0' encoding='utf-8' ?> <jdeRequest pwd='password' type='callmethod' user='user' session='' environment='DV7333' sessionidle=''> <callMethod app='XMLTest' name='GetLocalComputerId' runOnError='no'> <params> <param name='szMachineKey' id='machineKey'></param> </params> <onError abort='yes'> </onError> </callMethod> <callMethod app='XMLTest' name='F4311InitializeCaching' runOnError='no'> <params> <param name='cUseWorkFiles'>2</param> </params> </callMethod> <callMethod app='XMLTest' name='F4311FSBeginDoc' runOnError='no' returnNullData='yes'> <params> <param name='mnJobNumber' id='jobNumber'></param> <param name='szComputerID' idref='machineKey'></param> <param name='cHeaderActionCode'>A</param> <param name='cProcessEdits'>1</param> <param name='cUpdateOrWriteToWorkFile'>2</param> <param name='cRecordWrittenToWorkFile'>0</param> <param name='szOrderCOmpany' id='orderCompany'>00200</param> <param name='szOrderType'>OP</param> <param name='szOrderSuffix'>000</param> <param name='szBranchPlant'> M30</param> <param name='mnSupplierNumber' id='supplierNumber'>4343</param> <param name='mnShipToNumber'>0.0</param> <param name='jdOrderDate'>2000/03/02</param> <param name='cEvaluatedReceiptsFlag'>N</param> <param name='cCurrencyMode'>D</param> <param name='szTransactionCurrencyCode'>USD</param> <param name='mnCurrencyExchangeRate'>0.0</param> <param name='szOrderedPlacedBy'>SUBSTITUTE</param> <param name='szProgramID'>EP4310</param> <param name='szPurchaseOrderPrOptVersion' id='Version'>ZJDE0001</param> <param name='szUserID'>SUBSTITUTE</param> <param name='mnProcessID' id='processID'></param> <param name='mnTransactionID' id='transactionID'></param> </params> <onError abort='yes'> <callMethod app='XMLTest' name='F4311ClearWorkFiles' runOnError='yes' returnNullData='yes'> <params> <param name='szComputerID' idref='jobNumber'></param> <param name='mnJobNumber' idref='machineKey'></param> <param name='cClearHeaderFile'>1</param> <param name='cClearDetailFile'>1</param> <param name='mnLineNumber'>0</param> <param name='cUseWorkFiles'>2</param> <param name='mnProcessID' idref='processID'></param> <param name='mnTransactionID' idref='transactionID'></param> </params> </callMethod> </onError> </callMethod> <!-- This is the first EditLine entry --> <callMethod app='XMLTest' name='F4311EditLine' runOnError='yes' returnNullData='no'> <params> <param name='mnJobNumber' idref='jobNumber'></param> <param name='szComputerID' idref='machineKey'></param> <param name='cDetailActionCode'>A</param> <param name='cProcessEdits'>1</param> <param name='cUpdateOrWriteWorkFile'>2</param> <param name='cCurrencyProcessingFlag'>Y</param> <param name='szPurchaseOrderPrOptVersion' idref='version'></param> <param name='szOrderCompany' idref='orderCompany'></param> <param name='szOrderType'>OP</param> <param name='szOrderSuffix'>000</param> <param name='szBranchPlant'> M30</param> <param name='mnSupplierNumber' idref='supplierNumber'></param> <param name='mnShipToNumber'>0.0</param> <param name='jdRequestedDate'>2000/03/02</param> <param name='jdTransactionDate'>2000/03/02</param> <param name='jdPromisedDate'>2000/03/02</param> <param name='jdGLDate'>2000/03/02</param> <param name='szUnformattedItemNumber'>1001</param> <param name='mnQuantityOrdered'>1</param> <param name='szDetailLineBranchPlant'> M30</param> <param name='szLastStatus'>220</param> <param name='szNextStatus'>230</param> <param name='cEvaluatedReceipts'>N</param> <param name='szTransactionCurrencyCode'>USD</param> <param name='cSourceRequestingPOGeneration'>0</param> <param name='szProgramID'>XMLTest</param> <param name='szUserID'>SUBSTITUTE</param> <param name='szAgreementNumber'></param> <param name='mnAgreementSupplement'>0</param> <param name='jdEffectiveDate'></param> <param name='szPurchasingCostCenter'></param> <param name='szObjectAccount'></param> <param name='szSubsidiary'></param> <param name='mnProcessID' idref='processID'></param> <param name='mnTransactionID' idref='transactionID'></param> </params> </callMethod> <!-- This is the second EditLine entry --> <callMethod app='XMLTest' name='F4311EditLine' runOnError='yes' returnNullData='no'> <params> <param name='mnJobNumber' idref='jobNumber'></param> <param name='szComputerID' idref='machineKey'></param> <param name='cDetailActionCode'>A</param> <param name='cProcessEdits'>1</param> <param name='cUpdateOrWriteWorkFile'>2</param> <param name='cCurrencyProcessingFlag'>Y</param> <param name='szPurchaseOrderPrOptVersion' idref='version'></param> <param name='szOrderCompany' idref='orderCompany'></param> <param name='szOrderType'>OP</param> <param name='szOrderSuffix'>000</param> <param name='szBranchPlant'> M30</param> <param name='mnSupplierNumber' idref='supplierNumber'></param> <param name='mnShipToNumber'>0.0</param> <param name='jdRequestedDate'>2000/03/02</param> <param name='jdTransactionDate'>2000/03/02</param> <param name='jdPromisedDate'>2000/03/02</param> <param name='jdGLDate'>2000/03/02</param> <param name='szUnformattedItemNumber'>2001</param> <param name='mnQuantityOrdered'>3</param> <param name='szDetailLineBranchPlant'> M30</param> <param name='szLastStatus'>220</param> <param name='szNextStatus'>230</param> <param name='cEvaluatedReceipts'>N</param> <param name='szTransactionCurrencyCode'>USD</param> <param name='cSourceRequestingPOGeneration'>0</param> <param name='szProgramID'>XMLTest</param> <param name='szUserID'>SUBSTITUTE</param> <param name='szAgreementNumber'></param> <param name='mnAgreementSupplement'>0</param> <param name='jdEffectiveDate'></param> <param name='szPurchasingCostCenter'></param> <param name='szObjectAccount'></param> <param name='szSubsidiary'></param> <param name='mnProcessID' idref='processID'></param> <param name='mnTransactionID' idref='transactionID'></param> </params> </callMethod> <callMethod app='XMLTest' name='F4311EditDoc' runOnError='no' returnNullData='no'> <params> <param name='szOrderSuffix'>000</param> <param name='szComputerID' idref='machineKey'></param> <param name='mnJobnumber' idref='jobNumber'></param> <param name='mnAddressNumber' idref='supplierNumber'></param> <param name='szOrderType'>OP</param> <param name='szOrderCompany' idref='orderCompany'></param> <param name='szVersionProcOption' idref='version'></param> <param name='cActionCode'>A</param> <param name='mnProcessID' idref='processID'></param> <param name='mnTransactionID' idref='transactionID'></param> </params> </callMethod> <callMethod app='XMLTest' name='F4311EndDoc' runOnError='no' returnNullData='no'> <params> <param name='szComputerID' idref='machineKey'></param> <param name='mnJobNumber' idref='jobNumber'></param> <param name='szCallingApplicationName'>XMLTest</param> <param name='szVersion' idref='version'></param> <param name='szUserID'>SUBSTITUTE</param> <param name='mnOrderNumberAssigned' id='orderNumberAssigned'></param> <param name='cUseWorkFiles'>2</param> <param name='cConsolidateLines'>0</param> <param name='mnProcessID' idref='processID'></param> <param name='mnTransactionID' idref='transactionID'></param> </params> </callMethod> <returnParams runOnError='yes' returnNullData='no'> <param name='JobNumber' idref='machineKey'></param> <param name='ComputerID' idref='jobNumber'></param> <param name='OrderNumberAssigned' idref='orderNumberAssigned'></param> </returnParams> <!-- This is a default error catch for the entire document--> <onError abort='yes'> <callMethod app='XMLTest' name='F4311ClearWorkFiles' runOnError='yes' returnNullData='no'> <params> <param name='szComputerID' idref='jobNumber'></param> <param name='mnJobNumber' idref='machineKey'></param> <param name='cClearHeaderFile'>1</param> <param name='cClearDetailFile'>1</param> <param name='mnLineNumber'>0</param> <param name='cUseWorkFiles'>2</param> <param name='mnProcessID' idref='processID'></param> <param name='mnTransactionID' idref='transactionID'></param> </params> </callMethod> </onError> </jdeRequest>
The Purchase Order response document contains individual return codes for each callMethod executed. In addition, this method returns the order number assigned for the Purchase Order.
<?xml version="1.0" encoding="utf-8" ?> <jdeResponse environment="DV7333" user="JDE" type="callmethod" sessionidle="" session="2612.1026498135.5" pwd="JDE"> <callMethod name="GetLocalComputerId" runOnError="no" app="XMLTest"> <returnCode code="0"/> <params> <param name="szMachineKey" id="machineKey">XEENT</param> </params> </callMethod> <callMethod name="F4311InitializeCaching" runOnError="no" app="XMLTest"> <returnCode code="0"/> <params> <param name="cUseWorkFiles">2</param> </params> </callMethod> <callMethod name="F4311FSBeginDoc" returnNullData="yes" runOnError="no" app="XMLTest"> <returnCode code="0"/> <params> <param name="mnJobNumber" id="jobNumber">3</param> <param name="szComputerID" idref="machineKey">XEENT</param> <param name="cHeaderActionCode">1</param> <param name="cProcessEdits">1</param> <param name="cUpdateOrWriteToWorkFile">2</param> <param name="cRecordWrittenToWorkFile">1</param> <param name="cCurrencyProcessingFlag">Z</param> <param name="szOrderCOmpany" id="orderCompany">00200</param> <param name="mnOrderNumber">0</param> <param name="szOrderType">OP</param> <param name="szOrderSuffix">000</param> <param name="szBranchPlant"> M30</param> <param name="szOriginalOrderCompany"/> <param name="szOriginalOrderNumber"/> <param name="szOriginalOrderType"/> <param name="szRelatedOrderCompany"/> <param name="szRelatedOrderNumber"/> <param name="szRelatedOrderType"/> <param name="mnSupplierNumber" id="supplierNumber">17000</param> <param name="mnShipToNumber">6074</param> <param name="jdRequestedDate">2002/07/12</param> <param name="jdOrderDate">2000/03/02</param> <param name="jdPromisedDate">2002/07/12</param> <param name="jdCancelDate"/> <param name="szReference01"/> <param name="szReference02"/> <param name="szDeliveryInstructions01"> </param> <param name="szDeliveryInstructions02"> </param> <param name="szPrintMessage"/> <param name="szSupplierPriceGroup"/> <param name="szPaymentTerms"/> <param name="szTaxExplanationCode"/> <param name="szTaxRateArea"/> <param name="szTaxCertificate"> </param> <param name="cAssociatedText"/> <param name="szHoldCode"/> <param name="szFreightHandlingCode"/> <param name="mnBuyerNumber">0</param> <param name="mnCarrierNumber">0</param> <param name="cEvaluatedReceiptsFlag">N</param> <param name="cSendMethod"/> <param name="szLandedCostRule"> </param> <param name="szApprovalRouteCode"/> <param name="mnChangeOrderNumber">0</param> <param name="cCurrencyMode">D</param> <param name="szTransactionCurrencyCode">USD</param> <param name="mnCurrencyExchangeRate">0</param> <param name="szOrderedPlacedBy">SUBSTITUTE</param> <param name="szOrderTakenBy"/> <param name="szProgramID">EP4310</param> <param name="szApprovalRoutePO"/> <param name="szPurchaseOrderPrOptVersion" id="Version">ZJDE0001</param> <param name="szBaseCurrencyCode">USD</param> <param name="szUserID">SUBSTITUTE</param> <param name="cAddNewLineToExistingOrder"/> <param name="idInternalVariables">0</param> <param name="cSourceOfData"/> <param name="mnSODOrderNumber">0</param> <param name="szSODOrderType"/> <param name="szSODOrderCompany"/> <param name="szSODOrderSuffix"/> <param name="mnRetainage">0</param> <param name="szDescription"/> <param name="szRemark"/> <param name="jdEffectiveDate"/> <param name="jdPhysicalCompletionDate"/> <param name="mnTriangulationRateFromCurrenc">0</param> <param name="mnTriangulationRateToCurrency">0</param> <param name="cCurrencyConversionMethod"/> <param name="szPriceAdjustmentScheduleN"/> <param name="cAIADocument"/> <param name="mnProcessID" id="processID">2612</param> <param name="mnTransactionID" id="transactionID">4</param> </params> </callMethod> <callMethod name="F4311EditLine" returnNullData="no" runOnError="yes" app="XMLTest"> <returnCode code="0"/> <params> <param name="mnJobNumber" idref="jobNumber">3</param> <param name="szComputerID" idref="machineKey">XEENT</param> <param name="mnOrderLineNumber">1</param> <param name="cDetailActionCode">1</param> <param name="cProcessEdits">1</param> <param name="cUpdateOrWriteWorkFile">2</param> <param name="cRecordWrittenToWorkFile">1</param> <param name="cCurrencyProcessingFlag">Y</param> <param name="szPurchaseOrderPrOptVersion" idref="version">ZJDE0001</param> <param name="szOrderCompany" idref="orderCompany">00200</param> <param name="szOrderType">OP</param> <param name="szOrderSuffix">000</param> <param name="szBranchPlant"> M30</param> <param name="mnSupplierNumber" idref="supplierNumber">17000</param> <param name="mnShipToNumber">6074</param> <param name="jdRequestedDate">2000/03/02</param> <param name="jdTransactionDate">2000/03/02</param> <param name="jdPromisedDate">2000/03/02</param> <param name="jdGLDate">2000/03/02</param> <param name="szUnformattedItemNumber">1001 </param> <param name="mnQuantityOrdered">1</param> <param name="mnUnitPrice">32,1000</param> <param name="mnExtendedPrice">32,1</param> <param name="szLineType">S</param> <param name="szDescription1">Bike Rack - Trunk Mount</param> <param name="szDescription2"> </param> <param name="szDetailLineBranchPlant"> M30</param> <param name="szLocation"> . . </param> <param name="szLotNumber"> </param> <param name="szTransactionUoM">EA</param> <param name="szPurchasingUoM">EA</param> <param name="szLastStatus">220</param> <param name="szNextStatus">230</param> <param name="mnDiscountFactor">1</param> <param name="szInventoryPriceRule"> </param> <param name="szPrintMessage"> </param> <param name="cTaxable">Y</param> <param name="szGLClassCode">IN30</param> <param name="mnBuyerNumber">8444</param> <param name="szPurchasingCategoryCode1"> </param> <param name="szPurchasingCategoryCode2"> </param> <param name="szPurchasingCategoryCode3"> </param> <param name="szPurchasingCategoryCode4">240</param> <param name="szLandedCostRule"> </param> <param name="mnWeight">80</param> <param name="szWeightUoM">OZ</param> <param name="mnVolume">2,25</param> <param name="szVolumeUoM">FC</param> <param name="cEvaluatedReceipts">N</param> <param name="cInventoryInterface">Y</param> <param name="szTransactionCurrencyCode">USD</param> <param name="szBaseCurrencyCode">USD</param> <param name="cSourceRequestingPOGeneration">0</param> <param name="szProgramID">XMLTest</param> <param name="szUserID">SUBSTITUTE</param> <param name="szAgreementNumber"/> <param name="mnAgreementSupplement">0</param> <param name="jdEffectiveDate"/> <param name="szPurchasingCostCenter"/> <param name="szObjectAccount"/> <param name="szSubsidiary"/> <param name="cStockingType">P</param> <param name="mnProcessID" idref="processID">2612</param> <param name="mnTransactionID" idref="transactionID">4</param> <param name="mnIdentifierShortItem">60003</param> </params> </callMethod> <callMethod name="F4311EditLine" returnNullData="no" runOnError="yes" app="XMLTest"> <returnCode code="0"/> <params> <param name="mnJobNumber" idref="jobNumber">3</param> <param name="szComputerID" idref="machineKey">XEENT</param> <param name="mnOrderLineNumber">2</param> <param name="cDetailActionCode">1</param> <param name="cProcessEdits">1</param> <param name="cUpdateOrWriteWorkFile">2</param> <param name="cRecordWrittenToWorkFile">1</param> <param name="cCurrencyProcessingFlag">Y</param> <param name="szPurchaseOrderPrOptVersion" idref="version">ZJDE0001</param> <param name="szOrderCompany" idref="orderCompany">00200</param> <param name="szOrderType">OP</param> <param name="szOrderSuffix">000</param> <param name="szBranchPlant"> M30</param> <param name="mnSupplierNumber" idref="supplierNumber">17000</param> <param name="mnShipToNumber">6074</param> <param name="jdRequestedDate">2000/03/02</param> <param name="jdTransactionDate">2000/03/02</param> <param name="jdPromisedDate">2000/03/02</param> <param name="jdGLDate">2000/03/02</param> <param name="szUnformattedItemNumber">2001 </param> <param name="mnQuantityOrdered">3</param> <param name="mnUnitPrice">164,0817</param> <param name="mnExtendedPrice">492,2451</param> <param name="szLineType">S</param> <param name="szDescription1">Cro-Moly Frame, Red </param> <param name="szDescription2"> </param> <param name="szDetailLineBranchPlant"> M30</param> <param name="szLocation"> . . </param> <param name="szLotNumber"> </param> <param name="szTransactionUoM">EA</param> <param name="szPurchasingUoM">EA</param> <param name="szLastStatus">220</param> <param name="szNextStatus">230</param> <param name="mnDiscountFactor">1</param> <param name="szInventoryPriceRule"> </param> <param name="szPrintMessage"> </param> <param name="cTaxable">Y</param> <param name="szGLClassCode">IN30</param> <param name="szPurchasingCategoryCode1"> </param> <param name="szPurchasingCategoryCode2"> </param> <param name="szPurchasingCategoryCode3"> </param> <param name="szPurchasingCategoryCode4">200</param> <param name="szLandedCostRule"> </param> <param name="mnWeight">3</param> <param name="szWeightUoM">OZ</param> <param name="szVolumeUoM">FC</param> <param name="cEvaluatedReceipts">N</param> <param name="cInventoryInterface">Y</param> <param name="szTransactionCurrencyCode">USD</param> <param name="szBaseCurrencyCode">USD</param> <param name="cSourceRequestingPOGeneration">0</param> <param name="szProgramID">XMLTest</param> <param name="szUserID">SUBSTITUTE</param> <param name="szAgreementNumber"/> <param name="mnAgreementSupplement">0</param> <param name="jdEffectiveDate"/> <param name="szPurchasingCostCenter"/> <param name="szObjectAccount"/> <param name="szSubsidiary"/> <param name="cStockingType">M</param> <param name="mnProcessID" idref="processID">2612</param> <param name="mnTransactionID" idref="transactionID">4</param> <param name="mnIdentifierShortItem">60062</param> </params> </callMethod> <callMethod name="F4311EditDoc" returnNullData="no" runOnError="no" app="XMLTest"> <returnCode code="0"/> <params> <param name="szOrderSuffix">000</param> <param name="szComputerID" idref="machineKey">XEENT</param> <param name="mnJobnumber" idref="jobNumber">3</param> <param name="mnAddressNumber" idref="supplierNumber">17000</param> <param name="szOrderType">OP</param> <param name="szOrderCompany" idref="orderCompany">00200</param> <param name="szVersionProcOption" idref="version">ZJDE0001</param> <param name="cActionCode">A</param> <param name="mnProcessID" idref="processID">2612</param> <param name="mnTransactionID" idref="transactionID">4</param> </params> </callMethod> <callMethod name="F4311EndDoc" returnNullData="no" runOnError="no" app="XMLTest"> <returnCode code="0"/> <params> <param name="szComputerID" idref="machineKey">XEENT</param> <param name="mnJobNumber" idref="jobNumber">3</param> <param name="szCallingApplicationName">XMLTest</param> <param name="szVersion" idref="version">ZJDE0001</param> <param name="szUserID">SUBSTITUTE</param> <param name="mnOrderNumberAssigned" id="orderNumberAssigned">4884</param> <param name="cUseWorkFiles">2</param> <param name="cConsolidateLines">0</param> <param name="mnProcessID" idref="processID">2612</param> <param name="mnTransactionID" idref="transactionID">4</param> </params> </callMethod> <returnParams> <param name="JobNumber" idref="machineKey">XEENT</param> <param name="ComputerID" idref="jobNumber">3</param> <param name="OrderNumberAssigned" idref="orderNumberAssigned">4884</param> </returnParams> </jdeResponse>
The following is a sample Sales Order request.
Executing a Sales Order Request
The following is an example of a Sales Order request.
<?xml version='1.0' encoding='utf-8' ?> <jdeRequest type='callmethod' user='JDE' pwd='JDE' environment='DV7333'> <callMethod name='GetLocalComputerId' app='XMLInterop' runOnError='no'> <params> <param name='szMachineKey' id='2'></param> </params> <onError abort='yes'> </onError> </callMethod> <callMethod name='F4211FSBeginDoc' app='XMLInterop' runOnError='no'> <params> <param name='mnCMJobNumber' id='1'></param> <param name='cCMDocAction'>A</param> <param name='cCMProcessEdits'>1</param> <param name='szCMComputerID' idref='2'></param> <param name='cCMUpdateWriteToWF'>2</param> <param name='szCMProgramID'>XMLInterop</param> <param name='szCMVersion'>ZJDE0001</param> <param name='szOrderType'>SO</param> <param name='szBusinessUnit'> M30</param> <param name='mnAddressNumber'>4242</param> <param name='jdOrderDate'>2000/03/29</param> <param name='szReference'>10261</param> <param name='cApplyFreightYN'>Y</param> <param name='szCurrencyCode'></param> <param name='cWKSourceOfData'></param> <param name='cWKProcMode'></param> <param name='mnWKSuppressProcess'>0</param> </params> <onError abort='yes'> <callMethod name='F4211ClearWorkFile' app='XMLInterop' runOnError='yes'> <params> <param name='mnJobNo' idref='1'></param> <param name='szComputerID' idref='2'></param> <param name='mnFromLineNo'>0</param> <param name='mnThruLineNo'>0</param> <param name='cClearHeaderWF'>2</param> <param name='cClearDetailWF'>2</param> <param name='szProgramID'>XMLInterop</param> <param name='szCMVersion'>ZJDE0001</param> </params> </callMethod> </onError> </callMethod> <callMethod name='F4211FSEditLine' app='XMLInterop' runOnError='yes'> <params> <param name='mnCMJobNo' idref='1'></param> <param name='cCMLineAction'>A</param> <param name='cCMProcessEdits'>1</param> <param name='cCMWriteToWFFlag'>2</param> <param name='szCMComputerID' idref='2'></param> <!-- param name='mnLineNo'>10261</param --> <param name='szItemNo'>1001</param> <param name='mnQtyOrdered'>1</param> <param name='cSalesTaxableYN'>N</param> <param name='szTransactionUOM'>EA</param> <param name='szCMProgramID'>XMLInterop</param> <param name='szCMVersion'>ZJDE0001</param> <param name='cWKSourceOfData'></param> </params> <onError abort='no'> </onError> </callMethod> <callMethod name='F4211FSEditLine' app='XMLInterop' runOnError='yes'> <params> <param name='mnCMJobNo' idref='1'></param> <param name='cCMLineAction'>A</param> <param name='cCMProcessEdits'>1</param> <param name='cCMWriteToWFFlag'>2</param> <param name='szCMComputerID' idref='2'></param> <!-- param name='mnLineNo'>10262</param --> <param name='szItemNo'>1001</param> <param name='mnQtyOrdered'>10</param> <param name='cSalesTaxableYN'>N</param> <param name='szTransactionUOM'>EA</param> <param name='szCMProgramID'>XMLInterop</param> <param name='szCMVersion'>ZJDE0001</param> <param name='cWKSourceOfData'></param> </params> <onError abort='no'> </onError> </callMethod> <callMethod name='F4211FSEndDoc' app='XMLInterop' runOnError='no'> <params> <param name='mnCMJobNo' idref='1'></param> <param name='szCMComputerID' idref='2'></param> <param name='szCMProgramID'>XMLInterop</param> <param name='szCMVersion'>ZJDE0001</param> <param name='cCMUseWorkFiles'>2</param> </params> <onError abort='no'> <callMethod name='F4211ClearWorkFile' app='XMLInterop' runOnError='yes'> <params> <param name='mnJobNo' idref='1'></param> <param name='szComputerID' idref='2'></param> <param name='mnFromLineNo'>0</param> <param name='mnThruLineNo'>0</param> <param name='cClearHeaderWF'>2</param> <param name='cClearDetailWF'>2</param> <param name='szProgramID'>XMLInterop</param> <param name='szCMVersion'>ZJDE0001</param> </params> </callMethod> </onError> </callMethod> <returnParams failureDestination='ERROR.Q' successDestination='SUCCESS.Q' runOnError='yes'> </returnParams> <onError abort='yes'> <callMethod name='F4211ClearWorkFile' app='XMLInterop' runOnError='yes'> <params> <param name='mnJobNo' idref='1'></param> <param name='szComputerID' idref='2'></param> <param name='mnFromLineNo'>0</param> <param name='mnThruLineNo'>0</param> <param name='cClearHeaderWF'>2</param> <param name='cClearDetailWF'>2</param> <param name='szProgramID'>XMLInterop</param> <param name='szCMVersion'>ZJDE0001</param> </params> </callMethod> </onError> </jdeRequest>
This is the corresponding response document for the Sales Order request. There are error messages returned in the document. The error messages can be used within a workflow. For example:
<error code="2597">Warning: WARNING: Duplicate Customer Order Number </error> <error code="4136">Warning: Pick date is less than todays date</error>
Using the Sales Order Response
The following is the jdeResponse document.
<?xml version="1.0" encoding="utf-8" ?><jdeResponse environment="DV7333" user="JDE" type="callmethod" pwd="JDE"> <callMethod name="GetLocalComputerId" runOnError="no" app="XMLInterop"> <returnCode code="0"/> <params> <param name="szMachineKey" id="2">XEENT</param> </params> </callMethod><callMethod name="F4211FSBeginDoc" runOnError="no" app="XMLInterop"> <returnCode code="1"/> <params> <param name="mnCMJobNumber" id="1">3</param> <param name="cCMDocAction">A</param> <param name="cCMProcessEdits">1</param> <param name="szCMComputerID" idref="2">XEENT</param> <param name="cCMErrorConditions">1</param> <param name="cCMUpdateWriteToWF">2</param> <param name="szCMProgramID">XMLInterop</param> <param name="szCMVersion">ZJDE0001</param> <param name="szOrderCo">00200</param> <param name="szOrderType">SO</param> <param name="szBusinessUnit"> M30</param> <param name="mnAddressNumber">4242</param> <param name="mnShipToNo">4242</param> <param name="jdRequestedDate">2000/03/29</param> <param name="jdOrderDate">2000/03/29</param> <param name="jdPromisedDate">2000/03/29</param> <param name="szReference">10261</param> <param name="szDeliveryInstructions1"> </param> <param name="szDeliveryInstructions2"> </param> <param name="szPrintMesg"> </param> <param name="szPaymentTerm"> </param> <param name="cPaymentInstrument"> </param> <param name="mnTradeDiscount">,000</param> <param name="szTaxExplanationCode">S </param> <param name="szTaxArea">DEN </param> <param name="szCertificate"> </param> <param name="szHoldOrdersCode"> </param> <param name="cPricePickListYN">Y</param> <param name="szRouteCode"> </param> <param name="szStopCode"> </param> <param name="szZoneNumber"> </param> <param name="szFreightHandlingCode"> </param> <param name="cApplyFreightYN">Y</param> <param name="mnCommissionCode1">6001</param> <param name="mnCommissionRate1">5,000</param> <param name="mnCommissionRate2">,000</param> <param name="szWeightDisplayUOM"> </param> <param name="szVolumeDisplayUOM"> </param> <param name="cMode">D</param> <param name="szCurrencyCode">USD</param> <param name="jdDateUpdated">2002/07/12</param> <param name="szWKBaseCurrency">USD</param> <param name="cWKAdvancedPricingYN">N</param> <param name="szWKCreditMesg"> </param> <param name="szWKTempCreditMesg"> </param> <param name="cWKSourceOfData"/> <param name="cWKProcMode"/> <param name="mnWKSuppressProcess">0</param> <param name="szPricingGroup">PREFER </param> <param name="mnProcessID">2252</param> <param name="mnTransactionID">4</param> </params><errors><error code="2597">Warning: WARNING: Duplicate Customer Order Number</error><error code="4136">Warning: Pick date is less than todays date</error></errors> </callMethod><callMethod name="F4211FSEditLine" runOnError="yes" app="XMLInterop"> <returnCode code="1"/><params> <param name="mnCMJobNo" idref="1">3</param> <param name="cCMLineAction">A</param> <param name="cCMProcessEdits">1</param> <param name="cCMWriteToWFFlag">2</param> <param name="cCMRecdWrittenToWF">1</param> <param name="szCMComputerID" idref="2">XEENT</param> <param name="cCMErrorConditions">1</param> <param name="szOrderCo">00200</param> <param name="szOrderType">SO</param> <param name="szBusinessUnit"> M30</param> <param name="mnShipToNo">4242</param> <param name="jdRequestedDate">2000/03/29</param> <param name="jdPromisedDate">2000/03/29</param> <param name="jdPromisedDlvryDate">2000/03/29</param> <param name="szItemNo">1001 </param> <param name="szLocation"> . . </param> <param name="szDescription1">Bike Rack Trunk Mount </param> <param name="szDescription2"> </param> <param name="szLineType">S</param> <param name="szLastStatus">900</param> <param name="szNextStatus">540</param> <param name="mnQtyOrdered">1</param> <param name="mnQtyBackordered">1</param> <param name="mnUnitPrice">44,99</param> <param name="mnUnitCost">32,1000</param> <param name="szPrintMesg"> </param> <param name="cPaymentInstrument"> </param> <param name="cSalesTaxableYN">N</param> <param name="cAssociatedText"> </param> <param name="szTransactionUOM">EA</param> <param name="szPricingUOM">EA</param> <param name="mnItemWeight">80</param> <param name="szWeightUOM">OZ</param> <param name="mnForeignUnitPrice">44,99</param> <param name="mnForeignUnitCost">32,1000</param> <param name="mnDiscountFactor">1</param> <param name="mnCMLineNo">1</param> <param name="szCMProgramID">XMLInterop</param> <param name="szCMVersion">ZJDE0001</param> <param name="mnSupplierNo">4343</param> <param name="mnWKOrderTotal">44,99</param> <param name="mnWKForeignOrderTotal">44,99</param> <param name="mnWKTotalCost">32,1</param> <param name="mnWKForeignTotalCost">32,1</param> <param name="cWKSourceOfData"/> <param name="cWKCheckAvailability">1</param> <param name="mnLastLineNoAssigned">1</param> <param name="cStockingType">P</param> <param name="cParentItmMethdOfPriceCalcn">1</param> <param name="mnShortItemNo">60003</param> <param name="szSalesOrderFlags">0</param> <param name="jdPriceEffectiveDate">2000/03/29</param> <param name="jdPromisedShip">2000/03/29</param> <param name="mnQuantityAvailable">-34</param> <param name="mnItemVolume_ITVL">2,25</param> <param name="szVolumeUOM_VLUM">FC</param> <param name="szRevenueBusinessUnit"> M30</param> <param name="mnProcessID">2252</param> <param name="mnTransactionID">4</param> </params><errors><error code="030B">Warning: Order Quantity Exceeds what's Available</error></errors> </callMethod><callMethod name="F4211FSEditLine" runOnError="yes" app="XMLInterop"><returnCode code="1"/><params> <param name="mnCMJobNo" idref="1">3</param> <param name="cCMLineAction">A</param> <param name="cCMProcessEdits">1</param> <param name="cCMWriteToWFFlag">2</param> <param name="cCMRecdWrittenToWF">1</param> <param name="szCMComputerID" idref="2">XEENT</param> <param name="cCMErrorConditions">1</param> <param name="szOrderCo">00200</param> <param name="szOrderType">SO</param> <param name="szBusinessUnit"> M30</param> <param name="mnShipToNo">4242</param> <param name="jdRequestedDate">2000/03/29</param> <param name="jdPromisedDate">2000/03/29</param> <param name="jdPromisedDlvryDate">2000/03/29</param> <param name="szItemNo">1001 </param> <param name="szLocation"> . . </param> <param name="szDescription1">Bike Rack-Trunk Mount </param> <param name="szDescription2"> </param> <param name="szLineType">S</param> <param name="szLastStatus">900</param> <param name="szNextStatus">540</param> <param name="mnQtyOrdered">10</param> <param name="mnQtyBackordered">10</param> <param name="mnUnitPrice">44,99</param> <param name="mnUnitCost">32,1000</param> <param name="szPrintMesg"> </param> <param name="cPaymentInstrument"> </param> <param name="cSalesTaxableYN">N</param> <param name="cAssociatedText"> </param> <param name="szTransactionUOM">EA</param> <param name="szPricingUOM">EA</param> <param name="mnItemWeight">800</param> <param name="szWeightUOM">OZ</param> <param name="mnForeignUnitPrice">44,99</param> <param name="mnForeignUnitCost">32,1000</param> <param name="mnDiscountFactor">1</param> <param name="mnCMLineNo">2</param> <param name="szCMProgramID">XMLInterop</param> <param name="szCMVersion">ZJDE0001</param> <param name="mnSupplierNo">4343</param> <param name="mnWKOrderTotal">494,89</param> <param name="mnWKForeignOrderTotal">494,89</param> <param name="mnWKTotalCost">321</param> <param name="mnWKForeignTotalCost">321</param> <param name="cWKSourceOfData"/> <param name="cWKCheckAvailability">1</param> <param name="mnLastLineNoAssigned">2</param> <param name="cStockingType">P</param> <param name="cParentItmMethdOfPriceCalcn">1</param> <param name="mnShortItemNo">60003</param> <param name="szSalesOrderFlags"> 0 </param> <param name="jdPriceEffectiveDate">2000/03/29</param> <param name="jdPromisedShip">2000/03/29</param> <param name="mnQuantityAvailable">-44</param> <param name="mnItemVolume_ITVL">22,5</param> <param name="szVolumeUOM_VLUM">FC</param> <param name="szRevenueBusinessUnit"> M30</param> <param name="mnProcessID">2252</param> <param name="mnTransactionID">4</param> </params><errors><error code="030B">Warning: Order Quantity Exceeds what's Available</error></errors> </callMethod><callMethod name="F4211FSEndDoc" runOnError="no" app="XMLInterop"><returnCode code="0"/> <params> <param name="mnCMJobNo" idref="1">3</param> <param name="mnSalesOrderNo">2623</param> <param name="szCMComputerID" idref="2">XEENT</param> <param name="cCMErrorCondition">0</param> <param name="szOrderType">SO</param> <param name="szKeyCompany">00200</param> <param name="mnOrderTotal">494,89</param> <param name="szWorkstationID">XEENT</param> <param name="szCMProgramID">XMLInterop</param> <param name="szCMVersion">ZJDE0001</param> <param name="mnTimeOfDay">174220</param> <param name="cCMUseWorkFiles">2</param> <param name="cCMProcessEdits">1</param> <param name="mnProcessID">2252</param> <param name="mnTransactionID">4</param> </params> </callMethod><returnParams failureDestination="ERROR.Q" successDestination="SUCCESS.Q"> </returnParams></jdeResponse>