This appendix contains the following topics:
Section B.1, "Inbound Sales Order XML Format (All Parameters)"
Section B.2, "Inbound XML Transaction Request and Response Format"
Section B.3, "Outbound XML Request and Response Format (All Parameters)"
This section provides example code for an inbound sales order. This sample code shows the XML format with all of the parameters.
"<?xml version='1.0'?>
<jdeRequest type='callmethod' user='userid' pwd='password'
environment='environment' role='*ALL'>
<callMethod name='GetLocalComputerId' app='NetCommerce' runOnError='no'>
<params>
<param name='szMachineKey'id='2'></param>
<params>
<callMethod>
<callMethod name='F4211FSBeginDoc' app='NetCommerce' runOnError='no'>
<params>
<param name='mnCMJobNumber' id='j1'></param>
<param name='cCMDocAction'>A</param>
<param name='cCMProcessEdits'>1</param> ( 1 = Full)
<param name='szCMComputerID' idref='c2'></param>
<param name='cCMErrorConditions'>value</param> (1=Warnings, 2=Errors)
<param name='cCMUpdateWriteToWF'>value</param> (1=wf,2=cache)
<param name='szCMProgramID'>value</param>
<param name='szCMVersion'>value</param>
<param name='szOrderCo'<value</param>
<param name='mnOrderNo'>value</param>
<param name='szOrderType'>value</param> (If blank def Proc Opt)
<param name='szBusinessUnit'>value</param> (If blank def Proc Opt)
<param name='szOriginalOrderCo'>value</param> (used copy/blanket function)
<param name='szOriginalOrderNo'>value</param> (used copy/blanket function)
<param name='szOriginalOrderType'>value</param> (used copy/blanket function)
<param name='mnAddressNumber'>value</param> (Required if ship to = 0)
<param name='mnShipToNo'>value</param> (Required if sold to = 0)
<param name='jdRequestedDate'>value</param>
<param name='jdOrderDate'>value</param>
<param name='jdPromisedDate'>value</param>
<param name='jdCancelDate'>value</param>
<param name='szReference'>value</param>
<param name='szDeliveryInstructions1'>value</param>
<param name='szDeliveryInstructions2'>value</param>
<param name='szPrintMesg'>value</param>
<param name='szPaymentTerm'>value</param>
<param name='cPaymentInstrument'>value</param>
<param name='szAdjustmentSchedule'>value</param>
<param name='mnTradeDiscount'>value</param>
<param name='szTaxExplanationCode'>value</param>
<param name='szTaxArea'>value</param>
<param name='szCertificate'>value</param>
<param name='cAssociatedText'>value</param>
<param name='szHoldOrdersCode'>value</param>
<param name='cPricePickListYN'>value</param>
<param name='mnInvoiceCopies'>value</param>
<param name='mnBuyerNumber'>value</param>
<param name='mnCarrier'>value</param>
<param name='szRouteCode'>value</param>
<param name='szStopCode'>value</param>
<param name='szZoneNumber'>value</param>
<param name='szFreightHandlingCode'>value</param>
<param name='cApplyFreightYN'>value</param>
<param name='mnCommissionCode1'>value</param>
<param name='mnCommissionRate1'>value</param>
<param name='mnCommissionCode2'>value</param>
<param name='mnCommissionRate2'>value</param>
<param name='szWeightDisplayUOM'>value</param>
<param name='szVolumeDisplayUOM'>value</param>
<param name='szAuthorizationNo'>value</param>
<param name='szCreditBankAcctNo'>value</param>
<param name='jdCreditBankExpiredDate'>value</param>
<param name='cMode'>value</param>
<param name='szCurrencyCode'>value</param>
<param name='mnExchangeRate'>value</param>
<param name='szOrderedBy'>value</param>
<param name='szOrderTakenBy'>value</param>
<param name='szUserReservedCode'>value</param>
<param name='jdUserReservedDate'>value</param>
<param name='mnUserReservedAmnt'>value</param>
<param name='mnUserReservedNo'>value</param>
<param name='szUserReservedRef'>value</param>
<param name='jdDateUpdated'>value</param>
<param name='szUserID'>value</param>
<param name='szWKBaseCurrency'>value</param>
<param name='cWKAdvancedPricingYN'>value</param>
<param name='szWKCreditMesg'>value</param>
<param name='szWKTempCreditMesg'>value</param>
<param name='cWKInvalidSalesOrderNo'>value</param>
<param name='cWKSourceOfData'>blank</param> (Required, blank = parms )
<param name='cWKProcMode'>blank</param> (blank = reg order)
<param name='mnWKSuppressProcess'>0</param> (0 = def, 2=P/O)
<param name='mnSODDocNo'>value</param>
<param name='szSODDocType'>value</param>
<param name='szSODOrderCo'>value</param>
<param name='mnTriangulationRateFrom'>value</param>
<param name='mnTriangulationRateTo'>value</param>
<param name='cCurrencyConversionMethod'>value</param>
<param name='cRetrieveOrderNo'>value</param>
<param name='szPricingGroup'>value</param>
<param name='cCommitInvInED'>value</param>
<param name='cSpotRateAllowed'>value</param>
<param name='cGenericChar2_EV02'>value</param>
<param name='szGenericString1_DL01'>value</param>
<param name='szGenericString2_DL02'>value</param>
<param name='mnGenericMathNumeric1_MATH01'>value</param>
<param name='mnGenericMathNumeric2_MATH02'>value</param>
<param name='szLongAddressNumberShipto'>value</param>
<param name='szLongAddressNumber'>value</param>
<param name='mnProcessID'>value</param>
<param name='mnTransactionID'>value</param>
</params>
<onError abort='yes'>\
<callMethod name='F4211ClearWorkFile' app='NetCommerce' runOnError='yes'>
<params>
<param name='mnJobNo' idref='j1'></param>
<param name='szComputerID' idref='c2'></param>
<param name='mnFromLineNo'>value</param>
<param name='mnThruLineNo'>value</param>
<param name='cClearHeaderWF'>value</param>
<param name='cClearDetailWF'>value</param>
<param name='szProgramID'>value</param>
<param name='mnWKRelatedOrderProcess'>value</param>
<param name='szCMVersion'>value</param>
<param name='cGenericChar1_EV01'>value</param>
<param name='szGenericString1_DL01'>value</param>
<param name='mnSODRelatedJobNumber'>value</param>
<param name='mnProcessID' >value</param>
<param name='mnTransactionID'>value</param>
</params>
</callMethod>
</onError>
</callMethod>
<callMethod name='F4211FSEditLine'app='NetCommerce' runOnError='yes'> (each line)
<params>
<param name='mnCMJobNo' idref='j1'></param>
<param name='cCMLineAction'>value</param>
<param name='cCMProcessEdits'>value</param>
<param name='cCMWriteToWFFlag'>value</param>
<param name='cCMRecdWrittenToWF'>value</param>
<param name='szCMComputerID' idref='c2'></param>
<param name='cCMErrorConditions'>value</param>
<param name='szOrderCo'>value</param>
<param name='mnOrderNo'>value</param>
<param name='szOrderType'>value</param>
<param name='mnLineNo'>value</param>
<param name='szBusinessUnit'>value</param>
<param name='mnShipToNo'>value</param>
<param name='jdRequestedDate'>value</param>
<param name='jdPromisedDate'>value</param>
<param name='jdCancelDate'>value</param>
<param name='jdPromisedDlvryDate'>value</param>
<param name='szItemNo'>value</param>
<param name='szLocation'>value</param>
<param name='szLotNo'>value</param>
<param name='szDescription1'>value</param>
<param name='szDescription2'>value</param>
<param name='szLineType'>value</param>
<param name='szLastStatus'>value</param>
<param name='szNextStatus'>value</param>
<param name='mnQtyOrdered'>value</param>
<param name='mnQtyShipped'>value</param>
<param name='mnQtyBackordered'>value</param>
<param name='mnQtyCanceled'>value</param>
<param name='mnExtendedPrice'>value</param>
<param name='mnExtendedCost'>value</param>
<param name='szPrintMesg'>value</param>
<param name='cPaymentInstrument'>value</param>
<param name='szAdjustmentSchedule'>value</param>
<param name='cSalesTaxableYN'>value</param>
<param name='cAssociatedText'>value</param>
<param name='szTransactionUOM'>value</param>
<param name='szPricingUOM'>value</param>
<param name='mnItemWeight'>value</param>
<param name='szWeightUOM'>value</param>
<param name='mnForeignUnitPrice'>value</param>
<param name='mnForeignExtPrice'>value</param>
<param name='mnForeignUnitCost'>value</param>
<param name='mnForeignExtCost'>value</param>
<param name='szPricingCategoryLevel'>value</param>
<param name='mnDiscountFactor'>value</param>
<param name='mnCMLineNo'>value</param>
<param name='szCMProgramID'>value</param>
<param name='szCMVersion'>value</param>
<param name='mnSupplierNo'>value</param>
<param name='szRelatedKitItemNo'>value</param>
<param name='mnKitMasterLineNo'>value</param>
<param name='mnComponentLineNo'>value</param>
<param name='mnRelatedKitComponent'>value</param>
<param name='mnNoOfCpntPerParent'>value</param>
<param name='cOverridePrice'>value</param>
<param name='cOverrideCost'>value</param>
<param name='szUserID'>value</param>
<param name='jdDateUpdated'>value</param>
<param name='mnWKOrderTotal'>value</param>
<param name='mnWKForeignOrderTotal'>value</param>
<param name='mnWKTotalCost'>value</param>
<param name='mnWKForeignTotalCost'>value</param>
<param name='cWKProcessingType'>value</param>
<param name='cWKSourceOfData'>value</param>
<param name='cWKCheckAvailability'>value</param>
<param name='mnLastLineNoAssigned'>value</param>
<param name='cStockingType'>value</param>
<param name='szOriginalOrderKeyCo'>value</param>
<param name='szOriginalOrderNo'>value</param>
<param name='szOriginalOrderType'>value</param>
<param name='mnOriginalOrderLineNo'>value</param>
<param name='cParentItmMethdOfPriceCalcn'>value</param>
<param name='szLandedCost'>value</param>
<param name='mnWKSuppressProcess'>value</param>
<param name='mnShortItemNo'>value</param>
<param name='mnWKRelatedOrderProcess'>value</param>
<param name='mnSODLineNo'>value</param>
<param name='mnPriceAdjRevLevel'>value</param>
<param name='szSalesOrderFlags'>value</param>
<param name='mnSODDocNo'>value</param>
<param name='szSODDocType'>value</param>
<param name='szSODOrderCo'>value</param>
<param name='szTransferOrderToBranch'>value</param>
<param name='mnDomesticDetachedAdj'>value</param>
<param name='mnForeignDetachedAdj'>value</param>
<param name='mnSODWFLineNo'>value</param>
<param name='szGeneric2CharString'>value</param>
<param name='mnTOEPOExchangeRate'>value</param>
<param name='szTOEPOCurrencyCode'>value</param>
<param name='mnDRPKeyId'>value</param>
<param name='mnSoldToCust'>value</param>
<param name='szF4201BranchPlant'>value</param>
<param name='szSoldToCurrencyCode'>value</param>
<param name='cConsolidationFlag'>value</param>
<param name='jdPriceEffectiveDate'>value</param>
<param name='mnWOWFLineNo'>value</param>
<param name='mnLineNoIncrement'>value</param>
<param name='mnParentWFLineNo'>value</param>
<param name='cStatusInWarehouse'>value</param>
<param name='cBypassCommitments'>value</param>
<param name='szProductSource'>value</param>
<param name='szProductSourceType'>value</param>
<param name='mnSequenceNumber'>value</param>
<param name='szAgreementNumber'>value</param>
<param name='mnAgreementSupplement'>value</param>
<param name='mnAgreementsFound'>value</param>
<param name='szModeOfTransport'>value</param>
<param name='szDutyStatus'>value</param>
<param name='szLineofBusiness'>value</param>
<param name='jdPromisedShip'>value</param>
<param name='szEndUse'>value</param>
<param name='mnTOEPOExchangeRate'>value</param>
<param name='szPriceCode1'>value</param>
<param name='szPriceCode2'>value</param>
<param name='szPriceCode3'>value</param>
<param name='szItemFlashMessage'>value</param>
<param name='szCompanyKeyRelated'>value</param>
<param name='szRelatedPoSoNumber'>value</param>
<param name='szRelatedOrderType'>value</param>
<param name='mnRelatedPoSoLineNo'>value</param>
<param name='cGenericChar3'>value</param>
<param name='mnProfitMargin'>value</param>
<param name='mnQuantityAvailable'>value</param>
<param name='cRequestScheduleFlag'>value</param>
<param name='cOrderProcessType'>value</param>
<param name='cGenericChar2'>value</param>
<param name='mnSODRelatedJobNumber'>value</param>
<param name='szGenericString'>value</param>
<param name='mnCarrier'>value</param>
<param name='szGenericString2_DL02'>value</param>
<param name='mnGenericMathNumeric1_MATH01'>value</param>
<param name='mnGenericMathNumeric2_MATH02'>value</param>
<param name='mnItemVolume_ITVL'>value</param>
<param name='szVolumeUOM_VLUM'>value</param>
<param name='szRevenueBusinessUnit'>value</param>
<param name='szCustomerPO_VR01'>value</param>
<param name='szReference2Vendor_VR02'>value</param>
<param name='mnProcessID'>value</param>
<param name='mnTransactionID'>value</param>
</params>
<onError abort='no'>\
</onError>
</callMethod>
<callMethod name='F4211FSEndDoc' app='NetCommerce' runOnError='no'>
<params>
<param name='mnCMJobNo' idref='j1'></param>
<param name='mnSalesOrderNo'>value</param>
<param name='szCMComputerID' idref='2'></param>
<param name='cCMErrorCondition'>value</param>
<param name='szOrderType'>value</param>
<param name='szKeyCompany'>value</param>
<param name='mnOrderTotal'>value</param>
<param name='mnForeignOrderTotal'>value</param>
<param name='szBaseCurrencyCode'>value</param>
<param name='szProgramID'>value</param>
<param name='szWorkstationID'>value</param>
<param name='szCMProgramID'>value</param>
<param name='szCMVersion'>value</param>
<param name='mnTimeOfDay'>value</param>
<param name='mnTotalCost'>value</param>
<param name='mnForeignTotalCost'>value</param>
<param name='cSuppressRlvBlnktFlag'>value</param>
<param name='cWKSkipProcOptions'>value</param> (Skip Proc Opt, 1="Yes")
<param name='mnWKRelatedOrderProcess'>value</param>
<param name='cCMUseWorkFiles'>value</param>(Req,Work File="1", Cache ="2")
<param name='mnEDIDocNo'>value</param>
<param name='szEDIKeyCo'>value</param>
<param name='szEDIDocType'>value</param>
<param name='cCMProcessEdits'>value</param>
<param name='cGenericChar2'>value</param>
<param name='mnSODRelatedJobNumber'>value</param>
<param name='cGenericChar1_EV01'>value</param>
<param name='mnGenericMathNumeric2_MATH02'>value</param>
<param name='szGenericString1_DL01'>value</param>
<param name='szGenericString2_DL02'>value</param>
<param name='mnProcessID'>value</param>
<param name='mnTransactionID'>value</param>
<params/>
<onError abort='no'>\
<callMethod name='F4211ClearWorkFile' app='NetCommerce' runOnError='yes'>
<params>
<param name='mnJobNo' idref='j1'></param>
<param name='szComputerID' idref='2'></param>
<param name='mnFromLineNo'>value</param>
<param name='mnThruLineNo'>value</param>
<param name='cClearHeaderWF'>value</param>
<param name='cClearDetailWF'>value</param>
<param name='szProgramID'>value</param>
<param name='mnWKRelatedOrderProcess'>value</param>
<param name='szCMVersion'>value</param>
<param name='cGenericChar1_EV01'>value</param>
<param name='szGenericString1_DL01'>value</param>
<param name='mnSODRelatedJobNumber'>value</param>
<param name='mnProcessID'>value</param>
<param name='mnTransactionID'>value</param>
</params>
</callMethod>
</onError>
</callMethod>
<returnParams version='value' messagetype='messsage name'
failureDestination='queuename' successDestination='queuename>
<param name='long description' idref='value'/param>
</returnParams>
<onError>
<callMethod name='F4211ClearWorkFile' app='NetCommerce' runOnError='yes'>
<params>
<param name='mnJobNo' idref='j1'></param>
<param name='szComputerID' idref='2'></param>
<param name='mnFromLineNo'>value</param>
<param name='mnThruLineNo'>value</param>
<param name='cClearHeaderWF'>value</param>
<param name='cClearDetailWF'>value</param>
<param name='szProgramID'>value</param>
<param name='mnWKRelatedOrderProcess'>value</param>
<param name='szCMVersion'>value</param>
<param name='cGenericChar1_EV01'>value</param>
<param name='szGenericString1_DL01'>value</param>
<param name='mnProcessID'>value</param>
<param name='mnTransactionID'>value</param>
</params>
</callMethod>
</onError>
</jdeRequest>
This section provides example request and response code that illustrate the inbound XML format with all of the parameters.
This format shows an XML Transaction update request for an inbound purchase order:
<?xml version="1.0" encoding="utf-8" ?> - <!-- This an Inbound Purchase Order. --> - <jdeRequest pwd="password" role="*ALL" type="trans" user="user" environment="environment"> - <transaction type="JDEPOIN" action="inbound"> - <key> <column name="EdiUserId">TEST</column> <column name="EdiTransactNumber">1995598</column> <column name="EdiBatchNumber">11004</column> <column name="EdiLineNumber">1.000</column> </key> - <!-- table name attribute value is optional, cross reference is used --> - <table name="F4301Z1" type="header"> <column name="EdiDocumentType" /> <column name="TypeTransaction">JDEPOIN</column> <column name="EdiTranslationFormat" /> <column name="EdiTransmissionDate" /> <column name="DirectionIndicator">1</column> <column name="EdiDetailLinesProcess">0</column> <column name="EdiSuccessfullyProcess">N</column> <column name="TradingPartnerId" /> <column name="TransactionAction">A</column> <column name="CompanyKeyOrderNo">00200</column> <column name="DocumentOrderInvoiceE">203</column> <column name="OrderType">OP</column> <column name="OrderSuffix">000</column> <column name="CostCenter">27</column> <column name="CompanyKeyOriginal" /> <column name="OriginalPoSoNumber" /> <column name="OriginalOrderType" /> <column name="CompanyKeyRelated" /> <column name="RelatedPoSoNumber" /> <column name="RelatedOrderType" /> <column name="AddressNumber">1620</column> <column name="AddressNumberShipTo">27</column> <column name="DateRequestedJulian">11/10/99</column> <column name="DateTransactionJulian">11/10/99</column> <column name="DateOriginalPromisde">11/10/99</column> <column name="ActualShipDate" /> <column name="CancelDate" /> <column name="DatePriceEffectiveDate" /> <column name="DatePromisedShipJu" /> <column name="DatePromisedShipJu" /> <column name="Reference1" /> <column name="Reference2Vendor" /> <column name="DeliveryInstructLine1" /> <column name="DeliveryInstructLine2" /> <column name="NameRemark" /> <column name="Description" /> <column name="PrintMessage1" /> <column name="PriceAdjustmentScheduleN" /> <column name="PricingGroup" /> <column name="PaymentTermsCode01" /> <column name="TaxExplanationCode1" /> <column name="TaxArea1" /> <column name="CertificateTaxExempt" /> <column name="HoldOrdersCode" /> <column name="AssociatedText" /> <column name="InvoiceCopies">0</column> <column name="NatureOfTransaction" /> <column name="ContainerID" /> <column name="FreightHandlingCode" /> <column name="ZoneNumber" /> <column name="BuyerNumber">0</column> <column name="CarrierNumber">0</column> <column name="ModeOfTransport" /> <column name="ConditionsOfTransport" /> <column name="ReasonCode" /> <column name="FreightCalculatedYN" /> <column name="ApplyFreight">Y</column> <column name="PostQuantities">1</column> <column name="AmountOrderGross">32.10</column> <column name="PercentRetainage1">0</column> <column name="RetainageRule" /> <column name="UnitOfMeasureWhtDisp" /> <column name="UnitOfMeasureVolDisp" /> <column name="PurgeCode1" /> <column name="LogicControl" /> <column name="ProcessingMode" /> <column name="TypeMatch" /> <column name="StatusPurchaseOrder" /> <column name="CodeAutomaticVoucher">N</column> <column name="PrepaymentYN" /> <column name="CorrespondenceMethod" /> <column name="PurchasingReportCode5" /> <column name="RoutingApproval">DEMO</column> <column name="NumberChangeOrder">0</column> <column name="CurrencyMode">D</column> <column name="CurrencyCodeFrom">USD</column> <column name="CurrencyConverRateOv">0</column> <column name="LanguagePreference" /> <column name="AmountForeignOpen">0</column> <column name="OrderedBy">LH5813131</column> <column name="OrderTakenBy" /> <column name="UserReservedCode" /> <column name="UserReservedDate" /> <column name="UserReservedAmount">0</column> <column name="UserReservedNumber">0</column> <column name="UserReservedReference" /> <column name="TransactionOriginator" /> <column name="UserId">LH5813131</column> <column name="ProgramId">EP4310</column> <column name="WorkStationId">HUANGL1</column> <column name="DateUpdated">11/10/99</column> <column name="TimeOfDay">100707</column> <column name="ReferenceUCISNo" /> <column name="RequestedshipTime" /> <column name="AddressNumberMarkfor" /> <column name="RequestedDeliveryTime" /> <column name="DocumentOrderInvoi" /> <column name="DoctType" /> <column name="AddressNumberBillTp" /> <column name="CurrencyCodeBase" /> </table> - <table name="F4311Z1" type="detail"> <column name="EdiDocumentType" /> <column name="TypeTransaction">JDEPOIN</column> <column name="EdiTranslationFormat" /> <column name="EdiTransmissionDate" /> <column name="DirectionIndicator">1</column> <column name="EdiDetailLinesProcess">0</column> <column name="EdiSuccessfullyProcess">N</column> <column name="TradingPartnerId" /> <column name="TransactionAction">A</column> <column name="DocumentOrderInvoiceE">203</column> <column name="CompanyKeyOrderNo">00200</column> <column name="OrderType">OP</column> <column name="OrderSuffix">000</column> - <!-- default line number is 1 --> - <!-- have to specify line number if multiple records exist --> <column name="LineNumber">1.000</column> <column name="CostCenter">30</column> <column name="Company">00001</column> <column name="CompanyKeyOriginal" /> <column name="OriginalPoSoNumber" /> <column name="OriginalOrderType" /> <column name="OriginalLineNumber">0</column> <column name="CompanyKeyRelated" /> <column name="RelatedPoSoNumber" /> <column name="RelatedOrderType" /> <column name="RelatedPoSoLineNo">0</column> <column name="ContractNumberDistributi" /> <column name="ContractSupplementDistri">0</column> <column name="ContractBalancesUpdatedY" /> <column name="AddressNumber">1620</column> <column name="AddressNumberShipTo">1620</column> <column name="DateRequestedJulian">11/10/99</column> <column name="DateTransactionJulian">11/10/99</column> <column name="DateOriginalPromisde">11/10/99</column> <column name="ActualShipDate">11/10/99</column> <column name="CancelDate" /> <column name="DatePriceEffectiveDate" /> <column name="DatePromisedShipJu" /> <column name="DatePromisedShipJu" /> <column name="DateServiceCurrency" /> <column name="DtForGLAndVouch1">11/10/99</column> <column name="PeriodNoGeneralLedge">0</column> <column name="Reference1" /> <column name="Reference2Vendor" /> <column name="IdentifierShortItem">60003</column> <column name="Identifier2ndItem">1001</column> <column name="Identifier3rdItem">1001</column> <column name="Location" /> <column name="Lot" /> <column name="FromGrade" /> <column name="ThruGrade" /> <column name="FromPotency">0</column> <column name="ThruPotency">0</column> <column name="DescriptionLine1">Bike Rack - Trunk Mount</column> <column name="DescriptionLine2" /> <column name="LineType">S</column> <column name="StatusCodeNext">280</column> <column name="StatusCodeLast">230</column> <column name="ItemNumberRelatedKit" /> <column name="ReportingCode1Sales" /> <column name="ReportingCode2Sales" /> <column name="ReportingCode3Sales" /> <column name="ReportingCode4Sales">444</column> <column name="ReportingCode5Sales">158</column> <column name="ReportCode1Purchasing" /> <column name="ReportCode2Purchasing" /> <column name="ReportCode3Purchasing" /> <column name="ReportCode4Purchasing">240</column> <column name="ReportCode5Purchasing" /> <column name="UnitOfMeasureAsInput">EA</column> <column name="UnitsTransactionQty">1</column> <column name="UnitsChangeOrderQty">0</column> <column name="UnitsOpenQuantity">1</column> <column name="UnitsLineItemQtyRe">0</column> <column name="CumulativeReceived">0</column> <column name="UnitsRelieved">0</column> <column name="OtherQuantity12" /> <column name="PurchasingUnitPrice">32.1000</column> <column name="AmountExtendedPrice">32.10</column> <column name="AmountChange">0</column> <column name="AmountOpen1">32.10</column> <column name="AmountReceived">0</column> <column name="AmountRelieved">0</column> <column name="TaxCommitment">0</column> <column name="TaxAmountRelieved">0</column> <column name="PriceOverrideCode" /> <column name="UnitCostPurchasing">32.1000</column> <column name="AmountExtendedCost">32.10</column> <column name="CostOverrideCode" /> <column name="CostMethodPurchasing" /> <column name="PrintMessage1" /> <column name="PriceAdjustmentScheduleN" /> <column name="PricingCategory" /> <column name="PricingCategoryLevel1" /> <column name="CatalogName" /> <column name="DiscountFactor">1.0000</column> <column name="PaymentTermsCode01" /> <column name="TaxableYN1">N</column> <column name="TaxExplanationCode1" /> <column name="TaxArea1" /> <column name="AssociatedText" /> <column name="ContainerID" /> <column name="CommodityCode" /> <column name="NatureOfTransaction" /> <column name="FreightHandlingCode" /> <column name="FreightCalculatedYN">N</column> <column name="ZoneNumber" /> <column name="RateCodeFrieghtMisc" /> <column name="RateTypeFreightMisc" /> <column name="BuyerNumber">0</column> <column name="CarrierNumber">0</column> <column name="ModeOfTransport" /> <column name="ConditionsOfTransport" /> <column name="ShippingCommodityClass" /> <column name="ShippingConditionsCode" /> <column name="UnitOfMeasurePrimary">EA</column> <column name="UnitsPrimaryQtyOrder">1</column> <column name="UnitOfMeasureSecondary">EA</column> <column name="UnitsSecondaryQtyOr">1</column> <column name="UnitOfMeasurePurchas">EA</column> <column name="AmountUnitWeight">80.0000</column> <column name="WeightUnitOfMeasure">OZ</column> <column name="AmountUnitVolume">2.2500</column> <column name="VolumeUnitOfMeasure">FC</column> <column name="GlClass">IN30</column> <column name="Century">0</column> <column name="FiscalYear1">0</column> <column name="LineStatus" /> <column name="ReasonCode" /> <column name="ApplyFreight" /> <column name="PostQuantities" /> <column name="GrossWeight">0</column> <column name="UnitOfMeasureGrossWt" /> <column name="LedgerType" /> <column name="AcctNoInputMode" /> <column name="AccountId" /> <column name="PurchasingCostCenter" /> <column name="ObjectAccount" /> <column name="Subsidiary" /> <column name="SubledgerType" /> <column name="Subledger" /> <column name="SerialTagNumber" /> <column name="CostComponentNumber">0</column> <column name="TagReference" /> <column name="CategoriesWorkOrder001" /> <column name="Plan" /> <column name="Elevation" /> <column name="CategoryCodeGl001" /> <column name="RetainageRule" /> <column name="CodeLocationTaxStat" /> <column name="PurgeCode1" /> <column name="ProcessingMode" /> <column name="FinalPayment" /> <column name="CodeAutomaticVoucher">N</column> <column name="PrepaymentYN" /> <column name="WoOrderFreezeCode">N</column> <column name="TypeMatch" /> <column name="RoutingProcessYN" /> <column name="ReceiptCode" /> <column name="PurchaseOrderStatus01" /> <column name="PurchaseOrderStatus02" /> <column name="PurchaseOrderStatus03" /> <column name="PurchaseOrderStatus04" /> <column name="PurchaseOrderStatus05" /> <column name="PurchaseOrderStatus06" /> <column name="PurchaseOrderStatus07" /> <column name="PurchaseOrderStatus08" /> <column name="PurchaseOrderStatus09" /> <column name="PurchaseOrderStatus10" /> <column name="CorrespondenceMethod" /> <column name="RoutingApproval">DEMO</column> <column name="NumberChangeOrder">0</column> <column name="ChangeOrderType" /> <column name="DocumentChangeOrder">0</column> <column name="ChangeOrderLineNumber">0</column> <column name="CurrencyCodeFrom">USD</column> <column name="CurrencyConverRateOv">0</column> <column name="ForeignPurchasingCost">0</column> <column name="AmountForeignExtPrice">0</column> <column name="AmountForeignUnitCost">0</column> <column name="AmountForeignExtCost">0</column> <column name="ForeignChangedAmount">0</column> <column name="AmountForeignOpen">0</column> <column name="AmountReceivedForeign">0</column> <column name="UserReservedCode" /> <column name="UserReservedDate" /> <column name="UserReservedAmount">0</column> <column name="UserReservedNumber">0</column> <column name="UserReservedReference" /> <column name="TransactionOriginator">LH5813131</column> <column name="UserId">LH5813131</column> <column name="ProgramId" /> <column name="WorkStationId">HUANGL1</column> <column name="DateUpdated">11/10/99</column> <column name="TimeOfDay">100712</column> </table> - <inboundUBE> <UBEName>R4311Z1I</UBEName> <UBEVersion>XJDE0002</UBEVersion> </inboundUBE> - <callbackFunction> <functionName /> <functionLibrary /> </callbackFunction> </transaction> </jdeRequest>
This format shows the XML Transaction update response for an inbound purchase order:
<?xml version="1.0" encoding="UTF-8" ?> - <jdeResponse role="*ALL" type="trans" user="user" xmlns="urn:Schemas-jdedwards-com:trans.response.JDEPOIN" environment="environment"> - <transaction type="JDEPOIN" action="inbound"> <returnCode code="0">XML Request OK</returnCode> - <key> <column name="EdiUserId">TEST</column> <column name="EdiTransactNumber">2995598</column> <column name="EdiBatchNumber">11004</column> <column name="EdiLineNumber">1.000</column> </key> <writeSubsystemRecord>SUCCESS</writeSubsystemRecord> </transaction> </jdeResponse>
This section provides example request and response code that illustrate the outbound XML Format with all of the parameters.
This format returns all columns for the F0101Z2 table:
<?xml version='1.0' ?>
<jdeRequest type='trans' user='user' pwd='password' environment='environment'
role='*ALL' session='' sessionidle='300'>
<transaction action='transactionInfo' type='JDEAB'>
<key>
<column name='EdiUserId'>value</column>
<column name='EdiBatchNumber'>value</column>
<column name='EdiTransactNumber'>value</column>
</key>
</transaction>
</jdeRequest>
This sample code shows the response for the request:
<?xml version='1.0' encoding='utf-8' ?>
<jdeResponse type='trans' user='user' session='session' environment='env'>
<transaction type='JDEAB' action='transactionInfo'>
<returnCode code='0'>XML Request OK</returnCode>
<key>
<column name='EdiUserId'></column>
<column name='EdiBatchNumber'></column>
</key>
<table name='F0101Z2' type='detail'>
<column name='EdiUserId'></column>
<column name='EdiBatchNumber'></column>
<column name='EdiTransactNumber'></column>
<column name='EdiLineNumber'></column>
<column name='EdiDocumentType'></column>
<column name='TypeTransaction'></column>
<column name='EdiTranslationFormat'></column>
<column name='EdiTransmissionDate'></column>
<column name='DirectionIndicator'></column>
<column name='EdiDetailLinesProcess'></column>
<column name='EdiSuccessfullyProcess'></column>
<column name='TradingPartnerId'></column>
<column name='TransactionAction'></column>
<column name='AddressNumber'></column>
<column name='AlternateAddressKey'></column>
<column name='TaxId'></column>
<column name='NameAlpha'></column>
<column name='DescripCompressed'></column>
<column name='CostCenter'></column>
<column name='StandardIndustryCode'></column>
<column name='LanguagePreference'>< /column>
<column name='AddressType1'></column>
<column name='CreditMessage'></column>
<column name='PersonCorporationCode'></column>
<column name='AddressType2'></column>
<column name='AddressType3'></column>
<column name='AddressType4'></column>
<column name='AddressTypeReceivables'></column>
<column name='AddressType5'></column>
<column name='AddressTypePayables'></column>
<column name='AddTypeCode4Purch'></column>
<column name='MiscCode3'></column>
<column name='AddressTypeEmployee'></column>
<column name='SubledgerInactiveCode'></column>
<column name='DateBeginningEffective'></column>
<column name='AddressNumber1st'></column>
<column name='AddressNumber2nd'></column>
<column name='AddressNumber3rd'></column>
<column name='AddressNumber4th'></column>
<column name='AddressNumber6th'></column>
<column name='AddressNumber5th'></column>
<column name='ReportCodeAddBook001'></column>
<column name='ReportCodeAddBook002'></column>
<column name='ReportCodeAddBook003'></column>
<column name='ReportCodeAddBook004'></column>
<column name='ReportCodeAddBook005'></column>
<column name='ReportCodeAddBook006'></column>
<column name='ReportCodeAddBook007'></column>
<column name='ReportCodeAddBook008'></column>
<column name='ReportCodeAddBook009'></column>
<column name='ReportCodeAddBook010'></column>
<column name='ReportCodeAddBook011'></column>
<column name='ReportCodeAddBook012'></column>
<column name='ReportCodeAddBook013'></column>
<column name='ReportCodeAddBook014'></column>
<column name='ReportCodeAddBook015'></column>
<column name='ReportCodeAddBook016'></column>
<column name='ReportCodeAddBook017'></column>
<column name='ReportCodeAddBook018'></column>
<column name='ReportCodeAddBook019'></column>
<column name='ReportCodeAddBook020'></column>
<column name='CategoryCodeAddressBook2'></column>
<column name='CategoryCodeAddressBk22'></column>
<column name='CategoryCodeAddressBk23'></column>
<column name='CategoryCodeAddressBk24'></column>
<column name='CategoryCodeAddressBk25'></column>
<column name='CategoryCodeAddressBk26'></column>
<column name='CategoryCodeAddressBk27'></column>
<column name='CategoryCodeAddressBk28'></column>
<column name='CategoryCodeAddressBk29'></column>
<column name='CategoryCodeAddressBk30'></column>
<column name='GlBankAccount'></column>
<column name='TimeScheduledIn'></column>
<column name='DateScheduledIn'></column>
<column name='ActionMessageControl'></column>
<column name='NameRemark'></column>
<column name='CertificateTaxExempt'></column>
<column name='TaxId2'></column>
<column name='Kanjialpha'></column>
<column name='UserReservedCode'></column>
<column name='UserReservedDate'></column>
<column name='UserReservedAmount'></column>
<column name='UserReservedNumber'></column>
<column name='UserReservedReference'></column>
<column name='NameMailing'></column>
<column name='SecondaryMailingName'></column>
<column name='AddressLine1'></column>
<column name='AddressLine2'></column>
<column name='AddressLine3'></column>
<column name='AddressLine4'></column>
<column name='ZipCodePostal'></column>
<column name='City'></column>
<column name='Country'></column>
<column name='State'></column>
<column name='CountyAddress'></column>
<column name='PhoneAreaCode1'></column>
<column name='PhoneNumber'></column>
<column name='PhoneNumberTyp1'></column>
<column name='PhoneAreaCode2'></column>
<column name='PhoneNumber1'></column>
<column name='PhoneNumberTyp2'></column>
<column name='TransactionOriginator'></column>
<column name='UserId'></column>
<column name='ProgramId'></column>
<column name='WorkStationId'></column>
<column name='DateUpdated'></column>
<column name='TimeOfDay'></column>
<column name='TimeLastUpdated'></column>
</table>
</transaction>
</jdeResponse>