Reports

Home/ MerchantWare 4 / Reports / DetailedTransactionByTransactionId

DetailedTransactionByTransactionId

The DetailedTransactionTransactionId web method can look up detailed information about a specific transaction based on the merchantTransactionID supplied in the original transaction.

Arguments

Name Type Size Description
merchantName string 1-160 The name of the merchant's business.
merchantSiteId string 8-160 The site identifier of the business or store location.
merchantKey string 1-160 The software key or password for accessing the Merchantware account.
merchantTransactionId string 1-50 The identifier that the merchant gave the transaction.
ReportingInvoice Object - An optional field that specifies various data that the merchant included for level three processing-rates.

Return Values

A DetailedTransactionReference4 along with a SupportedActions is returned.

For an EMV transaction an Emv is returned.

If there are Health Care Amounts in the transaction data a HealthCareAmountDetails is returned.

Notes

The token is usually a number, but may have other forms depending on the card and transaction type. Avoid making the assumption that it is always a number.

Merchantware masks all digits except the last four for the following response parameters:

  • Card number
  • Transit number
  • Account number
  • Phone number
  • Date of birth
  • Social security number
  • Driver license number
  • Courtesy card number

SOAP Information

SOAPAction
http://schemas.merchantwarehouse.com/merchantware/40/Reports/TransactionsByTransactionId
Card Sample Request Packet (raw)
<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xmlns:xsd="http://www.w3.org/2001/XMLSchema"
 xmlns:soap="https://www.w3.org/2003/05/soap-envelope/">
  <soap:Body>
    <DetailedTransactionByTransactionId
     xmlns="http://schemas.merchantwarehouse.com/merchantware/40/Reports/">
      <merchantName>Zero Inc.</merchantName>
      <merchantSiteId>00000000</merchantSiteId>
      <merchantKey>00000-00000-00000-00000-00000</merchantKey>
      <merchantTransactionId>448254125</merchantTransactionId>
    </DetailedTransactionByTransactionId>
  </soap:Body>
</soap:Envelope>
Card Sample Return Packet (raw)
<soap:Envelope xmlns:soap="https://www.w3.org/2003/05/soap-envelope/"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <soap:Body>
    <DetailedTransactionByTransactionIdResponse
     xmlns="http://schemas.merchantwarehouse.com/merchantware/40/Reports/">
      <DetailedTransactionByTransactionIdResult>
        <ApprovalCode></ApprovalCode>
        <ApprovalStatus>DECLINED</ApprovalStatus>
        <AuthorizationAmount>5.00</AuthorizationAmount>
        <AvsResponse></AvsResponse>
        <BatchNumber></BatchNumber>
        <Cardholder>John Doe</Cardholder>
        <CashBackAmount>1.00</CashBackAmount>
        <CardNumber>************1117</CardNumber>
        <CardType>2</CardType>
        <ConvenienceAmount>1.00</ConvenienceAmount>
        <CustomerId></CustomerId>
        <CvvResponse></CvvResponse>
        <DiscountAmount></DiscountAmount>
        <ErrorMessage></ErrorMessage>
        <ExpirationDate>1215</ExpirationDate>
        <HostReference>14087</HostReference>
        <InvoiceNumber>9980</InvoiceNumber>
        <IsCardNumberKeyed>true</IsCardNumberKeyed>
        <IsTransactionAdjusted>false</IsTransactionAdjusted>
        <IsTransactionCaptured>false</IsTransactionCaptured>
        <IsTransactionVoided>false</IsTransactionVoided>
        <IsTransactionSettled>false</IsTransactionSettled>
        <MerchantTransactionId>DEV101</MerchantTransactionId>
        <OriginalToken></OriginalToken>
        <PostalCode>02110</PostalCode>
        <PurchaseOrderNumber>101750</PurchaseOrderNumber>
        <RegisterNumber>15</RegisterNumber>
        <StreetAddress>123 Main Street</StreetAddress>
        <SupportedActions>
          <AdjustmentToken></AdjustmentToken>
          <CaptureToken></CaptureToken>
          <EmailReceiptToken>375814</EmailReceiptToken>
          <RefundMaxAmount>5.00</RefundMaxAmount>
          <RefundToken></RefundToken>
          <RepeatSaleToken>375814</RepeatSaleToken>
          <VoidToken></VoidToken>
        </SupportedActions>
        <SurchargeAmount></SurchargeAmount>
        <TaxAmount>0.25</TaxAmount>
        <TipAmount>1.00</TipAmount>
        <Token>375814</Token>
        <TotalAmount>6.00</TotalAmount>
        <TransactionDate>2008-04-22 20:11:28.217</TransactionDate>
        <TransactionType>1</TransactionType>
        <UserName>GWAPITEST</UserName>
        <FsaCard>false</FsaCard>
        <HealthCareAmountDetails>
            <CopayAmount>2.00</CopayAmount>
            <ClinicalAmount>3.00</ClinicalAmount>
            <DentalAmount>1.00</DentalAmount>
            <HealthCareTotalAmount>15.00</HealthCareTotalAmount>
            <PrescriptionAmount>4.00</PrescriptionAmount>
            <VisionAmount>5.00</VisionAmount>
        </HealthCareAmountDetails>
        <Emv>
            <ApplicationInformation>
                <Aid>A0000000031010</Aid>
                <ApplicationLabel>VISA CREDIT</ApplicationLabel>
                <ApplicationExpiryDate>12/31/2022</ApplicationExpiryDate>
                <ApplicationEffectiveDate>01/01/2014</ApplicationEffectiveDate>
                <ApplicationInterchangeProfile>5C00</ApplicationInterchangeProfile>
                <ApplicationVersionNumber>008C</ApplicationVersionNumber>
                <ApplicationTransactionCounter>1680</ApplicationTransactionCounter>
                <ApplicationUsageControl>FF80</ApplicationUsageControl>
                <ApplicationPreferredName>VISA CREDIT 3</ApplicationPreferredName>
                <ApplicationDisplayName>VISA CREDIT 3</ApplicationDisplayName>
            </ApplicationInformation>
            <CardInformation>
                <MaskedPan>XXXXXXXXXXXXXXXX</MaskedPan>
                <PanSequenceNumber>XX</PanSequenceNumber>
                <CardExpiryDate>1222</CardExpiryDate>
            </CardInformation>
            <ApplicationCryptogram>
                <CryptogramType>TC</CryptogramType>               
                <Cryptogram>D4EF490CC3CA74D5</Cryptogram>
            </ApplicationCryptogram>
            <CVMResults>410302</CVMResults>
            <IssuerApplicationData>06020103A40000</IssuerApplicationData>
            <TerminalVerificationResults>0200008000</TerminalVerificationResults>
            <UnpredictableNumber>4B119B92</UnpredictableNumber>
            <Amount>
                <AmountAuthorized>6.00</AmountAuthorized>               
                <AmountOther>0.00</AmountOther>
            </Amount>
            <PosEntryMode>05</PosEntryMode>
            <TerminalInformation>
                <TerminalType>22</TerminalType>
                <IfdSerialNumber>87654321</IfdSerialNumber>
                <TerminalCountryCode>0840</TerminalCountryCode>
                <TerminalID>12345678</TerminalID>
                <TerminalActionCodeDefault>DC4000A800</TerminalActionCodeDefault>
                <TerminalActionCodeDenial>0010000000</TerminalActionCodeDenial>
                <TerminalActionCodeOnline>DC4004F800</TerminalActionCodeOnline>
            </TerminalInformation>
            <TerminalInformation>
                <TransactionType>00</TransactionType>
                <TransactionCurrencyCode>0840</TransactionCurrencyCode>
                <TransactionStatusInformation>E800</TransactionStatusInformation>
            </TerminalInformation>
            <CryptogramInformationData>40</CryptogramInformationData>
            <PinStatement>PIN VERIFIED</PinStatement>
            <CvmMethod>000000000000000045035E03</CvmMethod>
            <IssuerActionCodeDefault>FC50ECA800</IssuerActionCodeDefault>
            <IssuerActionCodeDenial>0000000000</IssuerActionCodeDenial>
            <IssuerActionCodeOnline>FC50ECA800</IssuerActionCodeOnline>
            <AuthorizationResponseCode>3030</AuthorizationResponseCode>
            <EntryMode>Contact</EntryMode>
        </Emv>
      <Invoice>
        <TaxIndicator>Provided</TaxIndicator>
            <ProductDescription>Misc Goods</ProductDescription>
            <DiscountAmount>1.01</DiscountAmount>
            <ShippingAmount>1.02</ShippingAmount>
            <DutyAmount>1.03</DutyAmount>
            <DestinationPostalCode>06033</DestinationPostalCode>
            <DestinationCountryCode>840</DestinationCountryCode>
            <ShipFromPostalCode>01887</ShipFromPostalCode>
            <LineItems>
               <LineItem>
                  <CommodityCode>030</CommodityCode>
                  <Description>Misc Good</Description>
                  <Upc>012345678901</Upc>
                  <Quantity>5.1</Quantity>
                  <UnitOfMeasure>lbs</UnitOfMeasure>
                  <UnitCost>0.60</UnitCost>
                  <DiscountAmount>0.61</DiscountAmount>
                  <TotalAmount>0.62</TotalAmount>
                  <TaxAmount>0.63</TaxAmount>
                  <ExtendedAmount>0.64</ExtendedAmount>
                  <DebitOrCreditIndicator>Credit</DebitOrCreditIndicator>
                  <NetOrGrossIndicator>Gross</NetOrGrossIndicator>
               </LineItem>
               <LineItem>
                  <CommodityCode>031</CommodityCode>
                  <Description>Misc Good 2</Description>
                  <Upc>012345678901</Upc>
                  <Quantity>5.1</Quantity>
                  <UnitOfMeasure>lbs</UnitOfMeasure>
                  <UnitCost>0.60</UnitCost>
                  <DiscountAmount>0.61</DiscountAmount>
                  <TotalAmount>0.62</TotalAmount>
                  <TaxAmount>0.63</TaxAmount>
                  <ExtendedAmount>0.64</ExtendedAmount>
                  <DebitOrCreditIndicator>Credit</DebitOrCreditIndicator>
                  <NetOrGrossIndicator>Gross</NetOrGrossIndicator>
               </LineItem>
            </LineItems>
         </Invoice>
      </DetailedTransactionByTransactionIdResult>
    </DetailedTransactionByTransactionIdResponse>
  </soap:Body>
</soap:Envelope>

Check Sample Request Packet (raw)
<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xmlns:xsd="http://www.w3.org/2001/XMLSchema"
 xmlns:soap="https://www.w3.org/2003/05/soap-envelope/">
  <soap:Body>
    <DetailedTransactionByTransactionId
     xmlns="http://schemas.merchantwarehouse.com/merchantware/40/Reports/">
      <merchantName>Zero Inc.</merchantName>
      <merchantSiteId>00000000</merchantSiteId>
      <merchantKey>00000-00000-00000-00000-00000</merchantKey>
      <merchantTransactionId>448254125</merchantTransactionId>
    </DetailedTransactionByTransactionId>
  </soap:Body>
</soap:Envelope>
Check Sample Return Packet (raw)
<soap:Envelope xmlns:soap="https://www.w3.org/2003/05/soap-envelope/"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <soap:Body>
    <DetailedTransactionByTransactionIdResponse
     xmlns="http://schemas.merchantwarehouse.com/merchantware/40/Reports/">
      <DetailedTransactionByTransactionIdResult>
        <ApprovalCode>AUTH NUM 272-172</ApprovalCode>
        <ApprovalStatus>APPROVED</ApprovalStatus>
        <AuthorizationAmount>0</AuthorizationAmount>
        <AvsResponse/>
        <BatchNumber/>
        <Cardholder/>
        <CashBackAmount>0</CashBackAmount>
        <CardNumber>****5678</CardNumber>
        <CardType>0</CardType>
        <ConvenienceAmount>0</ConvenienceAmount>
        <CustomerId/>
        <CvvResponse/>
        <DiscountAmount>0</DiscountAmount>
        <ErrorMessage/>
        <ExpirationDate/>
        <HostReference/>
        <InvoiceNumber/>
        <IsCardNumberKeyed>false</IsCardNumberKeyed>
        <IsTransactionAdjusted>false</IsTransactionAdjusted>
        <IsTransactionCaptured>false</IsTransactionCaptured>
        <IsTransactionVoided>false</IsTransactionVoided>
        <IsTransactionSettled>true</IsTransactionSettled>
        <MerchantTransactionId>TransId1</MerchantTransactionId>
        <OriginalToken/>
        <PostalCode>12345</PostalCode>
        <PurchaseOrderNumber/>
        <RegisterNumber/>
        <StreetAddress>123 Main Street</StreetAddress>
        <SupportedActions>
          <AdjustmentToken/>
          <CaptureToken/>
          <EmailReceiptToken>600000001</EmailReceiptToken>
          <RefundMaxAmount>0</RefundMaxAmount>
          <RefundToken/>
          <RepeatSaleToken/>
          <VoidToken>600000001</VoidToken>
        </SupportedActions>
        <SurchargeAmount>0</SurchargeAmount>
        <TaxAmount>0</TaxAmount>
        <TipAmount>0</TipAmount>
        <Token>600000001</Token>
        <TotalAmount>1.5000</TotalAmount>
        <TransactionDate>4/23/2019 1:23:51 PM</TransactionDate>
        <TransactionType>1</TransactionType>
        <UserName>GWAPITEST</UserName>
        <EntryMode>Scanned</EntryMode>
        <VaultToken>600000001-VT</VaultToken>
        <MerchantVaultTokenReference>600000001-Mvtr</MerchantVaultTokenReference>
        <CheckData>
          <Check>
            <AccountType>CHECKING</AccountType>
            <CheckType>PERSONAL</CheckType>
            <NameOnCheck>Jeff</NameOnCheck>
            <Amount>1.5000</Amount>
            <TransitNumber>*****0018</TransitNumber>
            <AccountNumber>*****5678</AccountNumber>
            <CheckNumber>123</CheckNumber>
            <MICR>true</MICR>
          </Check>
          <PersonalData>
            <PhoneNumber>******7890</PhoneNumber>
            <DateOfBirth>****1990</DateOfBirth>
            <SocialSecurityNumber>true</SocialSecurityNumber>
          </PersonalData>
          <HomeAddress>
            <StreetAddress1>Malone Road</StreetAddress1>
            <StreetAddress2>FAKE St</StreetAddress2>
            <City>Belfast</City>
            <State>FL</State>
            <PostalCode>12345</PostalCode>
          </HomeAddress>
          <DriverLicense>
            <Number>******1541</Number>
            <State>FL</State>
            <CourtesyCardNumber>****0154</CourtesyCardNumber>
          </DriverLicense>
        </CheckData>
        <CheckImages>
          <Front>true</Front>
          <Back>true</Back>
        </CheckImages>
        <RecurringCheck>true</RecurringCheck>
        <CheckStatus>Debit Sent</CheckStatus>
        <FundingStatus>Credit Sent</FundingStatus>
        <DepositDate>4/23/2019 2:39:54 PM</DepositDate>
        <AchChangeLog>
          <Change>
            <ChangeDate>4/23/2019 1:23:52 PM</ChangeDate>
            <ChangeType>CheckStatus</ChangeType>
            <CurrentValue>APPROVED</CurrentValue>
            <PreviousValue/>
          </Change>
          <Change>
            <ChangeDate>4/23/2019 1:23:52 PM</ChangeDate>
            <ChangeType>FundingStatus</ChangeType>
            <CurrentValue>IN PROGRESS</CurrentValue>
            <PreviousValue/>
          </Change>
        </AchChangeLog>
      </DetailedTransactionByTransactionIdResult>
    </DetailedTransactionByTransactionIdResponse>
  </soap:Body>
</soap:Envelope>