> For the complete documentation index, see [llms.txt](https://apidocs.juicefin.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://apidocs.juicefin.com/apis/cardholder-management/repfullrawdata.md).

# 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

```json
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

```json
<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>
```