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
Show child attributes
Show child attributes
See PagingInput
Show child attributes
Show child attributes
See GuidFilterInput
Show child attributes
Show child attributes
See GuidFilterInput
Show child attributes
Show child attributes
See GuidFilterInput
Return type
PaymentTransactionCollection
Show child attributes
Show child attributes
The date Tesouro recognized the payment request based upon the acceptor cutoff.
Components of the requested amount that may or may not have been provided by the presenter on the payment transaction request.See AmountDetails
The billing descriptor name that appears on the customer’s statement.
The business application identifier (BAI) is a value provided by Visa to identify the type of transfer that is being performed.See BusinessApplicationId
Aggregate information for assessed feesSee FeeDetails
A unique identifier assigned by Tesouro for every transaction request received.
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.
See Organization
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.
Refers to the various options available for customers to make payments when purchasing a product or service.See PaymentMethod
The payment network that the transaction was sent across, which may be unaffiliated with the card brand.See Network
A response code provided by Tesouro identifying the specific approval or decline reason.See ProcessorResponseCode
A human readable description of the authorization response code. e.g., Insufficient funds.
A unique transaction identifier created by the entity holding the direct relationship with the Acceptor. Tesouro uses this identifier to manage idempotency.
The result of the authorization request, e.g., Approved or Declined.See ResponseType
Short description of the payment transaction result. Examples include Approved, Insufficient funds. Intended for display purposes only.
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.
The date and time that Tesouro received the transaction, in UTC. Formatted as 2024-03-27T02:40:00Z
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?
⌘I