Upgraded Report Fields

The new Recurring Billing introduces a report that contains information pertinent to the new features and functions. This table compares fields in the legacy Subscription Detail Reports to corresponding fields in the new Recurring Billing Detail Report. Both the legacy report and the new report are accessed through the
Business Center
UI.
Comparison of Recurring Billing Report Fields
Fields in the Legacy Subscription Detail Reports
Fields in the New Recurring Billing Detail Report
Comment
CustomerAccountID
RecurringPaymentEventAmount
RecurringPaymentAmount
SubscriptionPaymentAmount
SubscriptionTitle
SubscriptionName
SubscriptionStatus
SubscriptionStatus
SubscriptionPaymentMethod
RecurringStartDate
SubscriptionStartDate
RecurringNumberOfPayments
BillingCycles
RecurringFrequency
BillingPeriodUnit , BillingPeriodLength
RecurringApprovalRequired
RecurringPaymentEventApprovedBy
RecurringAutomaticRenew
SetupFee
SetupFee
SetupFeeCurrency
SubscriptionType
LastSubscriptionStatus
NextScheduledDate
SubscriptionNextPaymentDate
EventRetryCount
SubscriptionRetryCount
PaymentsSuccess
PaymentSuccessAmount
InstallmentSequence
InstallmentTotalCount
RequestID
RequestID
SubscriptionID
TMSCustomerID
TransactionDate
RequestDate
MerchantRefNo
TransRefNo
TransactionReferenceNumber
EcommerceIndicator
ApplicationName
BillToFirstName
BillTo_FirstName
BillToLastName
BillTo_LastName
BillToAddress1
BillTo_Address1
BillToAddress2
BillTo_Address2
BillToCity
BillTo_City
BillToState
BillTo_State
BillToZip
BillTo_Zip
BillToCountry
BillTo_Country
BillToCompanyName
BillToEmail
BillTo_Email
ConsumerPhone
BillTo_Phone
IPAddress
ShipToFirstName
ShipToLastName
ShipToAddress1
ShipToAddress2
ShipToCity
ShipToState
ShipToZip
ShipToCountry
ShipToCompanyName
CardType
CardType
CustomerCCExpiryMonth
ExpirationMonth
CustomerCCExpiryYear
ExpirationYear
CustomerCCStartMonth
CustomerCCStartYear
CustomerCCIssueNo
CustomerCCAccountSuffix
CustomerCCSubTypeDescription
CustomerCCRoutingNumber
Applications
PaymentProcessor
CurrencyCode
CurrencyCode
ReasonCode
AuthRCode
AuthCode
AuthorizationCode
AuthType
AuthAVSResults
AuthResponseCode
AuthCardVerificationResult
RCode
RFlag
RMsg
RequestToken
MerchantDefinedData1
MerchantDefinedData2
MerchantDefinedData3
MerchantDefinedData4
TaxAmount
Comments
MerchantSecureData1
MerchantSecureData2
MerchantSecureData3
MerchantSecureData4
MerchantID
MerchantID
PlanCurrency
New field
PlanCode
New field
PlanName
New field
SurchargeAmount
New field
SurchargeDescription
New field
TMSPaymentInstrumentID
New field
TMSShippingID
New field
SubscriptionID
New report information
SubscriptionCode
New report information
AccountSuffix
New report information