Skip Headers
Oracle® Application Server Adapter for J.D. Edwards OneWorld User's Guide
10g Release 2 (10.1.2)
B14059-03
  Go To Documentation Library
Home		Go To Product List
Solution Area		Go To Table Of Contents
Contents		 Go To Index
Index
Previous
Previous 		 Next
Next		  

B Sample Files

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:

The following topics provide examples of the jdeRequest and jdeResponse XML structures for executing business functions within OneWorld:

Issuing a Single-Function Request

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>

Issuing a Multiple-Function Request

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>

Sample Sales Order Request

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>

Sample Sales Order Response

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&apos;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&apos;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>
  Previous
Previous 		 Next
Next
  Go To Documentation Library
Home		Go To Product List
Solution Area		Go To Table Of Contents
Contents		 Go To Index
Index