TransactionReport

Method

TransactionReport(TransactionReportRequest)

This report displays data for all transactions that meet the criteria in the request. Data will be retrieved as a data set.

Parameters

TYPE	NAME	DESCRIPTION
TransactionReportRequest	request

Returns

TYPE	DESCRIPTION
TransactionReportResponse

Example Request

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:pv="https://ssl.selectpayment.com/PV">
	<soapenv:Header/>
	<soapenv:Body>
		<pv:TransactionReport>
			<pv:storeId>123456</pv:storeId>
			<pv:storeKey>3z9em9oxqwX3acsaqc6H0ck8D3Yj </pv:storeKey>
			<pv:entityId>12345</pv:entityId>
			<pv:wsdisplayFields>
				<pv:WSDisplayFields>Transaction_DateTime</pv:WSDisplayFields>
				<pv:WSDisplayFields>Total_Amount</pv:WSDisplayFields>
				<pv:WSDisplayFields>Name_On_Account</pv:WSDisplayFields>
				<pv:WSDisplayFields>Customer_Number</pv:WSDisplayFields>
				<pv:WSDisplayFields>Payment_Type_Name</pv:WSDisplayFields>
				<pv:WSDisplayFields>Transaction_Number</pv:WSDisplayFields>
			</pv:wsdisplayFields>
			<pv:locationIds>
				<pv:int>102030</pv:int>
			</pv:locationIds>
			<pv:wstransStatus>
				<pv:WSTransactionStatus>Approved</pv:WSTransactionStatus>
				<pv:WSTransactionStatus>Processed</pv:WSTransactionStatus>
			</pv:wstransStatus>
			<pv:wssettlementType>
				<pv:WSSettlementType>ACH</pv:WSSettlementType>
			</pv:wssettlementType>
			<pv:wspaymentType>Checking</pv:wspaymentType>
			<pv:wspaymentOrigin>
				<pv:WSPaymentOrigin>Internet</pv:WSPaymentOrigin>
			</pv:wspaymentOrigin>
			<pv:wssettlementStatus>
				<pv:WSSettlementStatus>To_Be_Originated</pv:WSSettlementStatus>
				<pv:WSSettlementStatus>Settled</pv:WSSettlementStatus>
			</pv:wssettlementStatus>
			<pv:wsauthResponseCode>Success</pv:wsauthResponseCode>
			<pv:wsopType>Sale</pv:wsopType>
			<pv:beginTransDate>2011-02-01</pv:beginTransDate>
			<pv:endTransDate>2011-02-17</pv:endTransDate>
			<pv:wsdateType>__NONE</pv:wsdateType>
			<pv:fromAmount></pv:fromAmount>
			<pv:toAmount></pv:toAmount>
		</pv:TransactionReport>
	</soapenv:Body>
</soapenv:Envelope>

Example Response

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
	<soap:Body>
		<TransactionReportResponse xmlns="https://ssl.selectpayment.com/PV">
			<TransactionReportResult>
				<xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema"
				xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
					<xs:element name="NewDataSet" msdata:IsDataSet="true">
						<xs:complexType>
							<xs:choice maxOccurs="unbounded">
								<xs:element name="Table">
									<xs:complexType>
										<xs:sequence>
											<xs:element name="TransactionDateTime" type="xs:dateTime" minOccurs="0"/>
											<xs:element name="TotalAmount" type="xs:decimal" minOccurs="0"/>
											<xs:element name="NameOnAccount" type="xs:string" minOccurs="0"/>
											<xs:element name="CustomerNumber" type="xs:string" minOccurs="0"/>
											<xs:element name="PaymentTypeName" type="xs:string" minOccurs="0"/>
											<xs:element name="TransactionNumber" type="xs:string" minOccurs="0"/>
										</xs:sequence>
									</xs:complexType>
								</xs:element>
							</xs:choice>
						</xs:complexType>
					</xs:element>
				</xs:schema>
				<diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"
				xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">
					<NewDataSet xmlns="">
						<Table diffgr:id="Table1" msdata:rowOrder="0">
							<TransactionDateTime>2011-01-24T14:53:14.2000000-06:00</TransactionDateTime>
							<TotalAmount>97.8600</TotalAmount>
							<NameOnAccount>Jane Doe</NameOnAccount>
							<CustomerNumber>112235</CustomerNumber>
							<PaymentTypeName>Checking</PaymentTypeName>
							<TransactionNumber>1739</TransactionNumber>
						</Table>
						<Table diffgr:id="Table2" msdata:rowOrder="1">
							<TransactionDateTime>2011-01-24T14:53:36.1370000-06:00</TransactionDateTime>
							<TotalAmount>97.8600</TotalAmount>
							<NameOnAccount>Jane Doe</NameOnAccount>
							<CustomerNumber>112235</CustomerNumber>
							<PaymentTypeName>Checking</PaymentTypeName>
							<TransactionNumber>1740</TransactionNumber>
						</Table>
						<Table diffgr:id="Table3" msdata:rowOrder="2">
							<TransactionDateTime>2011-01-24T14:53:57.7000000-06:00</TransactionDateTime>
							<TotalAmount>97.8600</TotalAmount>
							<NameOnAccount>Jane DOe</NameOnAccount>
							<CustomerNumber>112235</CustomerNumber>
							<PaymentTypeName>Checking</PaymentTypeName>
							<TransactionNumber>1741</TransactionNumber>
						</Table>
						<Table diffgr:id="Table4" msdata:rowOrder="3">
							<TransactionDateTime>2011-01-24T15:35:59.1530000-06:00</TransactionDateTime>
							<TotalAmount>65.3700</TotalAmount>
							<NameOnAccount>Jane Doe</NameOnAccount>
							<CustomerNumber>112235</CustomerNumber>
							<PaymentTypeName>Checking</PaymentTypeName>
							<TransactionNumber>1726</TransactionNumber>
						</Table>
						<Table diffgr:id="Table5" msdata:rowOrder="4">
							<TransactionDateTime>2011-01-24T15:53:16.9000000-06:00</TransactionDateTime>
							<TotalAmount>113.2800</TotalAmount>
							<NameOnAccount>Jane Doe</NameOnAccount>
							<CustomerNumber>112235</CustomerNumber>
							<PaymentTypeName>Checking</PaymentTypeName>
							<TransactionNumber>1727</TransactionNumber>
						</Table>
						<Table diffgr:id="Table6" msdata:rowOrder="5">
							<TransactionDateTime>2011-01-31T13:55:07.9570000-06:00</TransactionDateTime>
							<TotalAmount>563.1100</TotalAmount>
							<NameOnAccount>Jerry Hall</NameOnAccount>
							<CustomerNumber>112236</CustomerNumber>
							<PaymentTypeName>Checking</PaymentTypeName>
							<TransactionNumber>11430</TransactionNumber>
						</Table>
						<Table diffgr:id="Table7" msdata:rowOrder="6">
							<TransactionDateTime>2011-01-31T14:01:05.1000000-06:00</TransactionDateTime>
							<TotalAmount>563.1100</TotalAmount>
							<NameOnAccount>Jerry Hall</NameOnAccount>
							<CustomerNumber>112236</CustomerNumber>
							<PaymentTypeName>Checking</PaymentTypeName>
							<TransactionNumber>11431</TransactionNumber>
						</Table>
						<Table diffgr:id="Table8" msdata:rowOrder="7">
							<TransactionDateTime>2011-02-04T07:54:30.7970000-06:00</TransactionDateTime>
							<TotalAmount>122.3500</TotalAmount>
							<NameOnAccount>Jack Henry</NameOnAccount>
							<PaymentTypeName>Checking</PaymentTypeName>
							<TransactionNumber>1021</TransactionNumber>
						</Table>
					</NewDataSet>
				</diffgr:diffgram>
			</TransactionReportResult>
		</TransactionReportResponse>
	</soap:Body>
</soap:Envelope>