query PaymentTransactions($input: PaymentTransactionsInput!) {
paymentTransactions(input: $input) {
items {
acceptor {
businessName
id
name
paymentTransactions
reference
}
activityDate
amountDetails {
cashBack
convenienceFee
discount
duty
gratuity
serviceFee
shipping
subTotal
surcharge
}
billingDescriptor
businessApplicationId
fees {
}
id
lineItems {
commodityCode
description
discountAmount
lineItemAmount
productCode
productSku
unitOfMeasure
unitPrice
unitQuantity
}
location {
id
}
merchantCategory
organization {
businessName
capabilities
id
legalName
name
paymentTransactions
phoneNumber
}
paymentId
paymentMethod {
acquirerToken
brand
type
}
processingNetwork
processorResponseCode
processorResponseMessage
reference
responseType
resultLabel
taxes {
localAmount
nationalAmount
totalAmount
}
taxIdentificationNumber
transactionDateTime
transactionType
}
pageInfo {
hasNextPage
hasPreviousPage
}
}
}
{
"input": {
"paging": {
"skip": 0,
"take": 0
},
"where": {
"acceptorId": "f47ac10b-58cc-4372-a567-0e02b2c3d479",
"acquirerReferenceNumber": "example",
"conveyedStatus": "example"
}
}
}
curl --request POST \
--url https://api.sandbox.com/graphql \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer <YOUR_ACCESS_TOKEN>' \
--data '{
"query": "query PaymentTransactions($input: PaymentTransactionsInput!) {\n paymentTransactions(input: $input) {\n items {\n acceptor {\n businessName\n id\n name\n paymentTransactions\n reference\n }\n activityDate\n amountDetails {\n cashBack\n convenienceFee\n discount\n duty\n gratuity\n serviceFee\n shipping\n subTotal\n surcharge\n }\n billingDescriptor\n businessApplicationId\n fees {\n\n }\n id\n lineItems {\n commodityCode\n description\n discountAmount\n lineItemAmount\n productCode\n productSku\n unitOfMeasure\n unitPrice\n unitQuantity\n }\n location {\n id\n }\n merchantCategory\n organization {\n businessName\n capabilities\n id\n legalName\n name\n paymentTransactions\n phoneNumber\n }\n paymentId\n paymentMethod {\n acquirerToken\n brand\n type\n }\n processingNetwork\n processorResponseCode\n processorResponseMessage\n reference\n responseType\n resultLabel\n taxes {\n localAmount\n nationalAmount\n totalAmount\n }\n taxIdentificationNumber\n transactionDateTime\n transactionType\n }\n pageInfo {\n hasNextPage\n hasPreviousPage\n }\n }\n}",
"variables": {
"input": {
"paging": {
"skip": 0,
"take": 0
},
"where": {
"acceptorId": "f47ac10b-58cc-4372-a567-0e02b2c3d479",
"acquirerReferenceNumber": "example",
"conveyedStatus": "example"
}
}
}
}'
{
"data": {
"paymentTransactions": {
"items": [
{
"acceptor": {
"allocations": "example",
"authorizationSummaries": "example",
"billingDescriptor": "CLACKSWORTH KEYBOARDS",
"businessName": "Clacksworth Keyboards",
"fees": "example",
"feeSummaries": "example",
"fundingAchReturns": "example",
"fundingDisputeEvents": "example",
"fundingSummaries": "example",
"fundingTransactions": "example",
"id": "a1b2c3d4-e5f6-7890-abcd-ef1234567890",
"name": "Ben Torres",
"paymentTransactions": "example",
"paymentTransactionSummaries": "example",
"reference": "example"
},
"activityDate": "2026-01-15",
"amountDetails": {
"cashBack": 0,
"convenienceFee": 0,
"discount": 0,
"duty": 0,
"gratuity": 0,
"serviceFee": 0,
"shipping": 0,
"subTotal": 0,
"surcharge": 0
},
"billingDescriptor": "CLACKSWORTH KEYBOARDS",
"businessApplicationId": "CB",
"fees": {
"items": [
"example"
],
"summary": "example"
},
"id": "f47ac10b-58cc-4372-a567-0e02b2c3d479",
"lineItems": [
{
"commodityCode": "example",
"description": "example",
"discountAmount": 0,
"lineItemAmount": 0,
"productCode": "example",
"productSku": "example",
"taxDetails": "example",
"unitOfMeasure": "example",
"unitPrice": 0,
"unitQuantity": 0
}
],
"location": {
"id": "c9a1e2d3-4b5f-6789-0abc-def123456789",
"outlet": "example"
},
"merchantCategory": "example",
"organization": {
"acceptorApplicationCounts": [
"example"
],
"acceptors": "example",
"achNotificationsOfChange": "example",
"achReturns": "example",
"allocations": "example",
"allowedMerchantCategories": [
"example"
],
"authorizationSummaries": "example",
"businessAddress": "example",
"businessName": "Clacksworth Keyboards",
"capabilities": [
"ACQUIRING"
],
"fees": "example",
"feeSummaries": "example",
"fundingAchReturns": "example",
"fundingDisbursementReturns": "example",
"fundingDisputeEvents": "example",
"fundingSummaries": "example",
"fundingTransactions": "example",
"id": "d8b2f3e4-5c6a-7890-1bcd-ef2345678901",
"legalName": "example",
"name": "Ben Torres",
"paymentTransactions": "example",
"paymentTransactionSummaries": "example",
"phoneNumber": "example",
"reportAvailability": [
"example"
],
"settings": "example"
},
"paymentId": "e7c3a4b5-6d7e-8901-2cde-f34567890123",
"paymentMethod": {
"acquirerToken": "example",
"brand": "VISA",
"type": "CARD"
},
"processingNetwork": "VISA",
"processorResponseCode": "A0000",
"processorResponseMessage": "example",
"reference": "example",
"responseType": "APPROVAL",
"resultLabel": "example",
"taxes": {
"localAmount": 0,
"nationalAmount": 0,
"totalAmount": 0
},
"taxIdentificationNumber": "example",
"transactionDateTime": "2026-01-15T14:30:00Z",
"transactionType": "AUTHORIZATION"
}
],
"pageInfo": {
"hasNextPage": true,
"hasPreviousPage": true
}
}
}
}
Reporting
paymentTransactions
A list of payment transaction requests (including conveyed) submitted on the pertinent transaction activity dates. Use this report as an operational tool to reconcile against your internal record of submitted transactions.
query PaymentTransactions($input: PaymentTransactionsInput!) {
paymentTransactions(input: $input) {
items {
acceptor {
businessName
id
name
paymentTransactions
reference
}
activityDate
amountDetails {
cashBack
convenienceFee
discount
duty
gratuity
serviceFee
shipping
subTotal
surcharge
}
billingDescriptor
businessApplicationId
fees {
}
id
lineItems {
commodityCode
description
discountAmount
lineItemAmount
productCode
productSku
unitOfMeasure
unitPrice
unitQuantity
}
location {
id
}
merchantCategory
organization {
businessName
capabilities
id
legalName
name
paymentTransactions
phoneNumber
}
paymentId
paymentMethod {
acquirerToken
brand
type
}
processingNetwork
processorResponseCode
processorResponseMessage
reference
responseType
resultLabel
taxes {
localAmount
nationalAmount
totalAmount
}
taxIdentificationNumber
transactionDateTime
transactionType
}
pageInfo {
hasNextPage
hasPreviousPage
}
}
}
{
"input": {
"paging": {
"skip": 0,
"take": 0
},
"where": {
"acceptorId": "f47ac10b-58cc-4372-a567-0e02b2c3d479",
"acquirerReferenceNumber": "example",
"conveyedStatus": "example"
}
}
}
curl --request POST \
--url https://api.sandbox.com/graphql \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer <YOUR_ACCESS_TOKEN>' \
--data '{
"query": "query PaymentTransactions($input: PaymentTransactionsInput!) {\n paymentTransactions(input: $input) {\n items {\n acceptor {\n businessName\n id\n name\n paymentTransactions\n reference\n }\n activityDate\n amountDetails {\n cashBack\n convenienceFee\n discount\n duty\n gratuity\n serviceFee\n shipping\n subTotal\n surcharge\n }\n billingDescriptor\n businessApplicationId\n fees {\n\n }\n id\n lineItems {\n commodityCode\n description\n discountAmount\n lineItemAmount\n productCode\n productSku\n unitOfMeasure\n unitPrice\n unitQuantity\n }\n location {\n id\n }\n merchantCategory\n organization {\n businessName\n capabilities\n id\n legalName\n name\n paymentTransactions\n phoneNumber\n }\n paymentId\n paymentMethod {\n acquirerToken\n brand\n type\n }\n processingNetwork\n processorResponseCode\n processorResponseMessage\n reference\n responseType\n resultLabel\n taxes {\n localAmount\n nationalAmount\n totalAmount\n }\n taxIdentificationNumber\n transactionDateTime\n transactionType\n }\n pageInfo {\n hasNextPage\n hasPreviousPage\n }\n }\n}",
"variables": {
"input": {
"paging": {
"skip": 0,
"take": 0
},
"where": {
"acceptorId": "f47ac10b-58cc-4372-a567-0e02b2c3d479",
"acquirerReferenceNumber": "example",
"conveyedStatus": "example"
}
}
}
}'
{
"data": {
"paymentTransactions": {
"items": [
{
"acceptor": {
"allocations": "example",
"authorizationSummaries": "example",
"billingDescriptor": "CLACKSWORTH KEYBOARDS",
"businessName": "Clacksworth Keyboards",
"fees": "example",
"feeSummaries": "example",
"fundingAchReturns": "example",
"fundingDisputeEvents": "example",
"fundingSummaries": "example",
"fundingTransactions": "example",
"id": "a1b2c3d4-e5f6-7890-abcd-ef1234567890",
"name": "Ben Torres",
"paymentTransactions": "example",
"paymentTransactionSummaries": "example",
"reference": "example"
},
"activityDate": "2026-01-15",
"amountDetails": {
"cashBack": 0,
"convenienceFee": 0,
"discount": 0,
"duty": 0,
"gratuity": 0,
"serviceFee": 0,
"shipping": 0,
"subTotal": 0,
"surcharge": 0
},
"billingDescriptor": "CLACKSWORTH KEYBOARDS",
"businessApplicationId": "CB",
"fees": {
"items": [
"example"
],
"summary": "example"
},
"id": "f47ac10b-58cc-4372-a567-0e02b2c3d479",
"lineItems": [
{
"commodityCode": "example",
"description": "example",
"discountAmount": 0,
"lineItemAmount": 0,
"productCode": "example",
"productSku": "example",
"taxDetails": "example",
"unitOfMeasure": "example",
"unitPrice": 0,
"unitQuantity": 0
}
],
"location": {
"id": "c9a1e2d3-4b5f-6789-0abc-def123456789",
"outlet": "example"
},
"merchantCategory": "example",
"organization": {
"acceptorApplicationCounts": [
"example"
],
"acceptors": "example",
"achNotificationsOfChange": "example",
"achReturns": "example",
"allocations": "example",
"allowedMerchantCategories": [
"example"
],
"authorizationSummaries": "example",
"businessAddress": "example",
"businessName": "Clacksworth Keyboards",
"capabilities": [
"ACQUIRING"
],
"fees": "example",
"feeSummaries": "example",
"fundingAchReturns": "example",
"fundingDisbursementReturns": "example",
"fundingDisputeEvents": "example",
"fundingSummaries": "example",
"fundingTransactions": "example",
"id": "d8b2f3e4-5c6a-7890-1bcd-ef2345678901",
"legalName": "example",
"name": "Ben Torres",
"paymentTransactions": "example",
"paymentTransactionSummaries": "example",
"phoneNumber": "example",
"reportAvailability": [
"example"
],
"settings": "example"
},
"paymentId": "e7c3a4b5-6d7e-8901-2cde-f34567890123",
"paymentMethod": {
"acquirerToken": "example",
"brand": "VISA",
"type": "CARD"
},
"processingNetwork": "VISA",
"processorResponseCode": "A0000",
"processorResponseMessage": "example",
"reference": "example",
"responseType": "APPROVAL",
"resultLabel": "example",
"taxes": {
"localAmount": 0,
"nationalAmount": 0,
"totalAmount": 0
},
"taxIdentificationNumber": "example",
"transactionDateTime": "2026-01-15T14:30:00Z",
"transactionType": "AUTHORIZATION"
}
],
"pageInfo": {
"hasNextPage": true,
"hasPreviousPage": true
}
}
}
}
Query
Arguments
PaymentTransactionsInput!
required
Show child attributes
Show child attributes
PagingInput!
required
See PagingInput
PaymentTransactionFilterInput!
required
Show child attributes
Show child attributes
GuidFilterInput
See GuidFilterInput
StringFilterInput
EnumFilterInputOfConveyedStatusInput
EnumFilterInputOfPaymentBrandInput
EnumFilterInputOfPaymentChannelInput
EnumFilterInputOfFundingSourceInput
Show child attributes
Show child attributes
GuidFilterInput
See GuidFilterInput
EnumFilterInputOfProcessorResponseCodeInput
Show child attributes
Show child attributes
ProcessorResponseCode
[ProcessorResponseCode!]
[ProcessorResponseCode!]
DateRangeFilterInput
StringFilterInput
GuidFilterInput
See GuidFilterInput
StringFilterInput
EnumFilterInputOfPaymentTransactionTypeInput
Return type
PaymentTransactionCollection
[PaymentTransaction!]!
required
Show child attributes
Show child attributes
Date
The date Tesouro recognized the payment request based upon the acceptor cutoff.
AmountDetails
Components of the requested amount that may or may not have been provided by the presenter on the payment transaction request.See AmountDetails
String
The billing descriptor name that appears on the customer’s statement.
BusinessApplicationId
The business application identifier (BAI) is a value provided by Visa to identify the type of transfer that is being performed.See BusinessApplicationId
FeeDetails
Aggregate information for assessed feesSee FeeDetails
UUID!
required
A unique identifier assigned by Tesouro for every transaction request received.
String
Unique ISO four digit values used to classify merchants and their transactions into specific categories based on the type of business, trade or services supplied.
Organization!
required
See Organization
UUID!
required
A unique 36 character identifier created by Tesouro and assigned to a group of transactions in the same payment request cohort. e.g., An authorization request, incremental authorization request, and the final capture would have the same paymentID.
PaymentMethod!
required
Refers to the various options available for customers to make payments when purchasing a product or service.See PaymentMethod
Network!
required
The payment network that the transaction was sent across, which may be unaffiliated with the card brand.See Network
ProcessorResponseCode!
required
A response code provided by Tesouro identifying the specific approval or decline reason.See ProcessorResponseCode
String!
required
A human readable description of the authorization response code. e.g., Insufficient funds.
String
A unique transaction identifier created by the entity holding the direct relationship with the Acceptor. Tesouro uses this identifier to manage idempotency.
ResponseType
The result of the authorization request, e.g., Approved or Declined.See ResponseType
String!
required
Short description of the payment transaction result. Examples include Approved, Insufficient funds. Intended for display purposes only.
String
The last 4 digits of the tax identification number (TIN), which is a unique identifier created by the national government and associated with the acceptor at the time the transaction was submitted.
DateTime!
required
The date and time that Tesouro received the transaction, in UTC. Formatted as 2024-03-27T02:40:00Z
PaymentTransactionType!
required
The type of payment transaction, e.g., Authorization, Capture, Sale, Refund, Reversal, etc.See PaymentTransactionType
query PaymentTransactions($input: PaymentTransactionsInput!) {
paymentTransactions(input: $input) {
items {
acceptor {
businessName
id
name
paymentTransactions
reference
}
activityDate
amountDetails {
cashBack
convenienceFee
discount
duty
gratuity
serviceFee
shipping
subTotal
surcharge
}
billingDescriptor
businessApplicationId
fees {
}
id
lineItems {
commodityCode
description
discountAmount
lineItemAmount
productCode
productSku
unitOfMeasure
unitPrice
unitQuantity
}
location {
id
}
merchantCategory
organization {
businessName
capabilities
id
legalName
name
paymentTransactions
phoneNumber
}
paymentId
paymentMethod {
acquirerToken
brand
type
}
processingNetwork
processorResponseCode
processorResponseMessage
reference
responseType
resultLabel
taxes {
localAmount
nationalAmount
totalAmount
}
taxIdentificationNumber
transactionDateTime
transactionType
}
pageInfo {
hasNextPage
hasPreviousPage
}
}
}
{
"input": {
"paging": {
"skip": 0,
"take": 0
},
"where": {
"acceptorId": "f47ac10b-58cc-4372-a567-0e02b2c3d479",
"acquirerReferenceNumber": "example",
"conveyedStatus": "example"
}
}
}
curl --request POST \
--url https://api.sandbox.com/graphql \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer <YOUR_ACCESS_TOKEN>' \
--data '{
"query": "query PaymentTransactions($input: PaymentTransactionsInput!) {\n paymentTransactions(input: $input) {\n items {\n acceptor {\n businessName\n id\n name\n paymentTransactions\n reference\n }\n activityDate\n amountDetails {\n cashBack\n convenienceFee\n discount\n duty\n gratuity\n serviceFee\n shipping\n subTotal\n surcharge\n }\n billingDescriptor\n businessApplicationId\n fees {\n\n }\n id\n lineItems {\n commodityCode\n description\n discountAmount\n lineItemAmount\n productCode\n productSku\n unitOfMeasure\n unitPrice\n unitQuantity\n }\n location {\n id\n }\n merchantCategory\n organization {\n businessName\n capabilities\n id\n legalName\n name\n paymentTransactions\n phoneNumber\n }\n paymentId\n paymentMethod {\n acquirerToken\n brand\n type\n }\n processingNetwork\n processorResponseCode\n processorResponseMessage\n reference\n responseType\n resultLabel\n taxes {\n localAmount\n nationalAmount\n totalAmount\n }\n taxIdentificationNumber\n transactionDateTime\n transactionType\n }\n pageInfo {\n hasNextPage\n hasPreviousPage\n }\n }\n}",
"variables": {
"input": {
"paging": {
"skip": 0,
"take": 0
},
"where": {
"acceptorId": "f47ac10b-58cc-4372-a567-0e02b2c3d479",
"acquirerReferenceNumber": "example",
"conveyedStatus": "example"
}
}
}
}'
{
"data": {
"paymentTransactions": {
"items": [
{
"acceptor": {
"allocations": "example",
"authorizationSummaries": "example",
"billingDescriptor": "CLACKSWORTH KEYBOARDS",
"businessName": "Clacksworth Keyboards",
"fees": "example",
"feeSummaries": "example",
"fundingAchReturns": "example",
"fundingDisputeEvents": "example",
"fundingSummaries": "example",
"fundingTransactions": "example",
"id": "a1b2c3d4-e5f6-7890-abcd-ef1234567890",
"name": "Ben Torres",
"paymentTransactions": "example",
"paymentTransactionSummaries": "example",
"reference": "example"
},
"activityDate": "2026-01-15",
"amountDetails": {
"cashBack": 0,
"convenienceFee": 0,
"discount": 0,
"duty": 0,
"gratuity": 0,
"serviceFee": 0,
"shipping": 0,
"subTotal": 0,
"surcharge": 0
},
"billingDescriptor": "CLACKSWORTH KEYBOARDS",
"businessApplicationId": "CB",
"fees": {
"items": [
"example"
],
"summary": "example"
},
"id": "f47ac10b-58cc-4372-a567-0e02b2c3d479",
"lineItems": [
{
"commodityCode": "example",
"description": "example",
"discountAmount": 0,
"lineItemAmount": 0,
"productCode": "example",
"productSku": "example",
"taxDetails": "example",
"unitOfMeasure": "example",
"unitPrice": 0,
"unitQuantity": 0
}
],
"location": {
"id": "c9a1e2d3-4b5f-6789-0abc-def123456789",
"outlet": "example"
},
"merchantCategory": "example",
"organization": {
"acceptorApplicationCounts": [
"example"
],
"acceptors": "example",
"achNotificationsOfChange": "example",
"achReturns": "example",
"allocations": "example",
"allowedMerchantCategories": [
"example"
],
"authorizationSummaries": "example",
"businessAddress": "example",
"businessName": "Clacksworth Keyboards",
"capabilities": [
"ACQUIRING"
],
"fees": "example",
"feeSummaries": "example",
"fundingAchReturns": "example",
"fundingDisbursementReturns": "example",
"fundingDisputeEvents": "example",
"fundingSummaries": "example",
"fundingTransactions": "example",
"id": "d8b2f3e4-5c6a-7890-1bcd-ef2345678901",
"legalName": "example",
"name": "Ben Torres",
"paymentTransactions": "example",
"paymentTransactionSummaries": "example",
"phoneNumber": "example",
"reportAvailability": [
"example"
],
"settings": "example"
},
"paymentId": "e7c3a4b5-6d7e-8901-2cde-f34567890123",
"paymentMethod": {
"acquirerToken": "example",
"brand": "VISA",
"type": "CARD"
},
"processingNetwork": "VISA",
"processorResponseCode": "A0000",
"processorResponseMessage": "example",
"reference": "example",
"responseType": "APPROVAL",
"resultLabel": "example",
"taxes": {
"localAmount": 0,
"nationalAmount": 0,
"totalAmount": 0
},
"taxIdentificationNumber": "example",
"transactionDateTime": "2026-01-15T14:30:00Z",
"transactionType": "AUTHORIZATION"
}
],
"pageInfo": {
"hasNextPage": true,
"hasPreviousPage": true
}
}
}
}
Was this page helpful?