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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://apidocs.juicefin.com/apis/cardholder-management/repfullrawdata.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.