G XML Format Examples (All Parameters)

G.2 Outbound XML Request and Response Format (All Parameters)

This section provides example request and response code that illustrate the outbound XML Format with all of the parameters.

G.2.1 Request

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>

G.2.2 Response

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>