BatchStatistics
Query BatchStatistics for an Authorize.net merchant account.
View-Specific Information
The BatchId is the only available supported column in the WHERE clause and it is required to retrieve results from BatchStatistics. BatchId can be used with (=) or IN operator.
SELECT * FROM BatchStatistics WHERE BatchId = '236274'
SELECT * FROM BatchStatistics WHERE BatchId IN ('236274', '237832')
Columns
| Name | Type | Statistic | Description |
| BatchId [KEY] | String | The unique batch Id. | |
| AccountType [KEY] | String | The card type for this transaction (including eCheck). Valid values are Visa, MasterCard, AmericanExpress, Discover, JCB, DinersClub, and eCheck. Note a batch will contain either credit card or eCheck statistics, because eCheck transactions go in their own batch.
The allowed values are Visa, MasterCard, AmericanExpress, Discover, JCB, DinersClub, eCheck. | |
| SettlementTime | Datetime | Date and time the batch was settled. | |
| SettlementState | String | The status of the batch. Valid values are settledSuccessfully or error.
The allowed values are settledSuccessfully, error. | |
| PaymentMethod | String | The payment method associated with the batch. Valid values are creditCard or eCheck.
The allowed values are creditCard, eCheck. | |
| MarketType | String | The market type associated with the batch. Valid values are 0 (eCommerce), 1 (MOTO), or 2 (Retail). | |
| Product | String | The product associated with the batch. Valid values are Card Not Present or Card Present.
The allowed values are Card Not Present, Card Present. | |
| ReturnedItemAmount | Decimal | The total amount of all returned items. Only applicable for eCheck transactions. | |
| ReturnedItemCount | Integer | The total count of all returned items. Only applicable for eCheck transactions. | |
| ChargeBackAmount | Decimal | The total amount of all charge backs. Only applicable for credit card transactions. | |
| ChargeBackCount | Integer | The total count of all charge backs. Only applicable for credit card transactions. | |
| CorrectionNoticeCount | Integer | The total count of all correction notices. Only applicable for credit card transactions. | |
| ChargeChargeBackAmount | Decimal | Only applicable for credit card transactions. | |
| ChargeChargeBackCount | Integer | Only applicable for credit card transactions. | |
| BatchStatisticsAmount | Decimal | The total amount of all transactions as returned in the response of a getBatchStatistics call. Only applicable for credit card transactions. | |
| BatchStatisticsCount | Integer | The total count of all transactions as returned in the response of a getBatchStatistics call. Only applicable for credit card transactions. | |
| ChargeReturnedItemsAmount | Decimal | The total amount of returned items purchased using credit cards. | |
| ChargeReturnedItemsCount | Integer | The total count of returned items purchased using credit cards. | |
| RefundReturnedItemsAmount | Decimal | The total amount of returned items that have been refunded. | |
| RefundReturnedItemsCount | Integer | The total count of returned items that have been refunded. | |
| ChargeAmount | Decimal | The total amount of all charge (i.e., Sale) transactions. | |
| ChargeCount | Integer | The total count of all charge transactions. | |
| RefundAmount | Decimal | The total amount of all refund transactions. | |
| RefundCount | Integer | The total count of all refund transactions. | |
| VoidCount | Integer | The total count of all voided transactions. | |
| DeclineCount | Integer | The total count of all declined transactions. | |
| ErrorCount | Integer | The total count of all transactions that resulted in an error. |