repFullRawData

📘 Transaction Report API (repFullRawData)

This API retrieves card transaction report data based on a specified date range and optional filter criteria.

This API retrieves card transaction report data based on a specified date range and optional filter criteria.

---

🔹 Overview

• Generates a detailed transaction report

• Supports multiple filter parameters to refine results

• Returns data in IXML format

• Each response includes transaction-level records

---

🔑 Required Parameters

Parameter	Description
fromDate	Start date for transaction search (format: YYYY-MM-DD)
toDate	End date for transaction search (format: YYYY-MM-DD)

⚠️ These fields are mandatory. The API will not return data without a valid date range.

---

⚙️ Optional Filter Parameters

All other <Param> fields are optional and can be used to refine the results.

🧑 Card / User Filters

• keyType, keyValue (e.g., filter by RPID, card number)

• firstName, lastName

• account_id, primaryRpid, secondaryRpid

💳 Transaction Filters

• activity (transaction type/code)

• dateType, trxTimeLine

• orderByName

📊 Card / Account Status

• cardStatus, chState

• replacementStatus, reasonCodeGroup

• verificationStatus

🏢 Product / Organization

• productType, bankOrgName

• onlineOrgName, repInternalUserOrgId

🔎 Additional Filters

• sourceIP, issuerUser, portalUserName

• address, PhoneNumber

• SubscriptionType, feeLess

💡 If no optional filters are provided, the API returns all transactions within the given date range.

---

📤 Response

• Format: IXML

• Includes:

  • Report headers (field definitions)

  • Transaction entries (rows)

• Each row represents a single transaction

---

🧾 Key Features

• Flexible filtering using multiple parameters

• Supports sorting via OrderByName

• Pagination support:

  • FromPos

  • RowsPerPage

• Consistent schema (empty fields are still returned)

---

✅ Summary

Type	Fields
Required	fromDate, toDate
Optional	All other parameters (filters)
Output	Transaction report in XML format

XML Samples

Input XML

destServer=debitAppServer2&data=<?xml version="1.0" ?>
		 <PraxellMessage>
		  <ServiceRequest> 
		   <UserName>test_pm</UserName>
		   <UserPassword>test_pm@816</UserPassword>
		   <ServiceName>Report</ServiceName>
		   <UniqueRequestId>945f58fe-83df-658c-494f-c2bc6630b461</UniqueRequestId>
		   <OriginType>app.juice.trxreport</OriginType>
		   <ReportName>repFullRawData</ReportName>
		   <SourceName>Default</SourceName>
		   <WhereName>DayActivity</WhereName>
		   <GroupByName>Default</GroupByName>
		   <OrderByName>LOG_DATETIME desc</OrderByName>
		   <FormatName>IXML</FormatName>
		   <OutputName>Standard</OutputName>
		   <RowsPerPage></RowsPerPage>
		   <FromPos>1</FromPos>
		   <NumberOfRows></NumberOfRows>        
			<Param Name="repInternalUserOrgId" Value="" Operator=""/>
			<Param Name="trxTimeLine" Value="Y" Operator=""/>
			<Param Name="orderByName" Value="" Operator="LOG_DATETIME"/>
			<Param Name="fromDate" Value="2026-01-01" Operator=""/>
			<Param Name="toDate" Value="2026-04-20" Operator=""/>
			<Param Name="onlineOrgName" Value="" Operator=""/>
			<Param Name="activity" Value="XP0BDS" Operator=""/>
			<Param Name="childName" Value="" Operator=""/>
			<Param Name="keyType" Value="rpid" Operator=""/>
			<Param Name="keyValue" Value="123456545" Operator=""/>
			<Param Name="firstName" Value="" Operator=""/>
			<Param Name="lastName" Value="" Operator=""/>
			<Param Name="repInternalOrgRole" Value="" Operator=""/>
			<Param Name="govtIssuedId" Value="" Operator=""/>
			<Param Name="cardStatus" Value="" Operator=""/>
			<Param Name="reasonCodeGroup" Value="" Operator=""/>
			<Param Name="productType" Value="" Operator=""/>
			<Param Name="bankOrgName" Value="" Operator=""/>
			<Param Name="replacementStatus" Value="" Operator=""/>
			<Param Name="sourceIP" Value="" Operator=""/>
			<Param Name="dateType" Value="" Operator=""/>
			<Param Name="feeLess" Value="" Operator=""/>
			<Param Name="chState" Value="" Operator=""/>
			<Param Name="issuerUser" Value="" Operator=""/>
			<Param Name="portalUserName" Value="" Operator=""/>
			<Param Name="address" Value="" Operator=""/>
			<Param Name="verificationStatus" Value="" Operator=""/>
			<Param Name="primaryRpid" Value="" Operator=""/>
			<Param Name="secondaryRpid" Value="" Operator=""/>
			<Param Name="SubscriptionType" Value="" Operator=""/>
			<Param Name="PhoneNumber" Value="" Operator=""/>
			<Param Name="account_id" Value="" Operator=""/>
		  </ServiceRequest>
		 </PraxellMessage>

Output XML

<PraxellMessage>
  <ServiceResponse>
    <ServiceCode>Report</ServiceCode>
    <ServiceStatusId>0</ServiceStatusId>
    <ServiceStatusName>0</ServiceStatusName>
    <UpdateDate>2026-04-15T13:50:45</UpdateDate>
    <SessionId>f8da9e45-4ef7-473e-b578-f3ec3d0198be</SessionId>
    <ServiceId>f8da9e45-4ef7-473e-b578-f3ec3d0198be</ServiceId>

    <ReportOutPut>
      <![CDATA[
<report-data>

  <report-headers>

    <header name="CURRENT_CARD_STATUS"></header>
    <header name="SPND_VALID_REASON"></header>
    <header name="ORIGIN_TRAN_DESC"></header>
    <header name="TXN_AMOUNT_DOLLAR"></header>
    <header name="REVERSE_MAIL_MAX_AMOUNT"></header>
    <header name="TERM_LOGICAL_NET"></header>
    <header name="REVERSE_FEE_LINK_ID"></header>
    <header name="TXN_ID"></header>
    <header name="ACTIONS"></header>
    <header name="LOG_DATETIME"></header>
    <header name="CARD_NUMBER"></header>
    <header name="RPID"></header>
    <header name="PRAXELL_CODE"></header>
    <header name="TRAN_DESC"></header>
    <header name="TERM_OWNER"></header>
    <header name="CARD_STATUS"></header>
    <header name="TXN_AMOUNT"></header>
    <header name="HOLD_BALANCE"></header>
    <header name="CARD_BALANCE"></header>
    <header name="PRODUCT_TYPE"></header>
    <header name="DDA"></header>
    <header name="FBE_DDA"></header>
    <header name="MCC"></header>
    <header name="MCC_DESC"></header>
    <header name="PRAXELL_CODE_DESCRIPTION"></header>
    <header name="TRANS_CODE"></header>
    <header name="PROC_TRANS_DESC"></header>
    <header name="RESPONSE_CODE"></header>
    <header name="TERM_ID"></header>
    <header name="TERM_NAME_LOCATION"></header>
    <header name="TERM_ADDRESS"></header>
    <header name="TERM_CITY"></header>
    <header name="TERM_STATE"></header>
    <header name="TERM_COUNTRY"></header>
    <header name="TERM_ZIP"></header>
    <header name="ISSUER_NAME"></header>
    <header name="BANK_NAME"></header>
    <header name="ACH_POST_DATE"></header>
    <header name="ISSUE_DATE"></header>
    <header name="CALC_FEE_AMOUNT"></header>
    <header name="SERVICE_CODE"></header>
    <header name="SERVICE_ID"></header>
    <header name="UNIQUE_REQUEST_ID"></header>
    <header name="CLIENT_SOURCE_IP"></header>
    <header name="ORIGINAL_ERROR_CODE"></header>
    <header name="FULL_BUFFER_ID"></header>
    <header name="REVERSE_FEE"></header>
    <header name="DESCRIPTION"></header>
    <header name="CAMPAIGN_CODE"></header>
    <header name="WAIVE_FEE"></header>
    <header name="USER_DEFINED_1"></header>
    <header name="REPLACEMENT_AMOUNT_SETTLEMENT"></header>
    <header name="REPLACEMENT_AMOUNT_CH_BILLING"></header>
    <header name="ADDITIONAL_DATA_CODE"></header>
    <header name="ADDITIONAL_DATA_CODE_DESC"></header>
    <header name="ADDITIONAL_FEE_OPERATION"></header>
    <header name="ADDITIONAL_FEE"></header>
    <header name="BP_ID"></header>
    <header name="TRANSACTION_ID"></header>
    <header name="RELATED_RPID"></header>
    <header name="ISO_ACCOUNT_ID"></header>
    <header name="PROCESSOR_DATE_TIME"></header>
    <header name="TRANS_DATETIME"></header>
    <header name="DISPLAY_NAME"></header>
    <header name="DISPLAY_NAME_2"></header>
    <header name="DISPLAY_NAME_3"></header>

  </report-headers>

  <report-entries>

    <row>

      <entry name="CURRENT_CARD_STATUS">ACT</entry>
      <entry name="SPND_VALID_REASON"></entry>
      <entry name="ORIGIN_TRAN_DESC">Business - Card to Card Transfer - Out</entry>
      <entry name="TXN_AMOUNT_DOLLAR">0.04</entry>
      <entry name="REVERSE_MAIL_MAX_AMOUNT">26</entry>
      <entry name="TERM_LOGICAL_NET">I</entry>
      <entry name="REVERSE_FEE_LINK_ID"></entry>
      <entry name="TXN_ID">26000000000134525415</entry>
      <entry name="ACTIONS"></entry>
      <entry name="LOG_DATETIME">02-06-2026 05:31:19</entry>
      <entry name="CARD_NUMBER">1111</entry>
      <entry name="RPID">123456545</entry>
      <entry name="PRAXELL_CODE">XP0BDS</entry>
      <entry name="TRAN_DESC">Business - Card to Card Transfer - Out</entry>
      <entry name="TERM_OWNER">Praxell Int</entry>
      <entry name="CARD_STATUS">ACT</entry>
      <entry name="TXN_AMOUNT">0.04</entry>
      <entry name="HOLD_BALANCE">0</entry>
      <entry name="CARD_BALANCE">10.66</entry>
      <entry name="PRODUCT_TYPE">Juice virtual FBO</entry>
      <entry name="DDA">11110001111111</entry>
      <entry name="FBE_DDA"></entry>
      <entry name="MCC"></entry>
      <entry name="MCC_DESC"></entry>
      <entry name="PRAXELL_CODE_DESCRIPTION">Business - Card to Card Transfer - Out</entry>
      <entry name="TRANS_CODE"></entry>
      <entry name="PROC_TRANS_DESC"></entry>
      <entry name="RESPONSE_CODE"></entry>
      <entry name="TERM_ID">CSRTest</entry>
      <entry name="TERM_NAME_LOCATION"></entry>
      <entry name="TERM_ADDRESS"></entry>
      <entry name="TERM_CITY">New York</entry>
      <entry name="TERM_STATE">NY</entry>
      <entry name="TERM_COUNTRY">US</entry>
      <entry name="TERM_ZIP"></entry>
      <entry name="ISSUER_NAME">Juice AA</entry>
      <entry name="BANK_NAME">First Century Bank NC</entry>
      <entry name="SERVICE_CODE">CardToCardTransfer</entry>
      <entry name="SERVICE_ID">026f5787-ac28-49ac-872d-04faf164827c</entry>
      <entry name="UNIQUE_REQUEST_ID">1770373877791-p2ewwit</entry>
      <entry name="CLIENT_SOURCE_IP">0.0.0.0</entry>
      <entry name="ORIGINAL_ERROR_CODE"></entry>
      <entry name="FULL_BUFFER_ID"></entry>
      <entry name="REVERSE_FEE"></entry>
      <entry name="DESCRIPTION"></entry>
      <entry name="CAMPAIGN_CODE"></entry>
      <entry name="WAIVE_FEE"></entry>
      <entry name="USER_DEFINED_1"></entry>
      <entry name="REPLACEMENT_AMOUNT_SETTLEMENT"></entry>
      <entry name="REPLACEMENT_AMOUNT_CH_BILLING"></entry>
      <entry name="ADDITIONAL_DATA_CODE"></entry>
      <entry name="ADDITIONAL_DATA_CODE_DESC"></entry>
      <entry name="ADDITIONAL_FEE_OPERATION"></entry>
      <entry name="ADDITIONAL_FEE"></entry>
      <entry name="BP_ID"></entry>
      <entry name="TRANSACTION_ID">11861770707</entry>
      <entry name="RELATED_RPID"></entry>
      <entry name="ISO_ACCOUNT_ID"></entry>
      <entry name="PROCESSOR_DATE_TIME"></entry>
      <entry name="TRANS_DATETIME">2026-02-06 05:31:19.0</entry>
      <entry name="DISPLAY_NAME"></entry>
      <entry name="DISPLAY_NAME_2"></entry>
      <entry name="DISPLAY_NAME_3"></entry>

    </row>

  </report-entries>

</report-data>
      ]]>
    </ReportOutPut>

    <NumberOfRows>1</NumberOfRows>

  </ServiceResponse>
</PraxellMessage>