Available Columns by Report Type

Reconciliation Report

• Account_Id
• Account_Name
• Card_Brand
• Card_Type
• Funding_Type
• Gateway_Transaction_Amount
• Gateway_Transaction_Currency
• Gateway_Transaction_ID
• Gateway_Transaction_Timestamp
• Gateway_Transaction_Type
• Installment_Number
• Is_Full_Captured
• Legal_Business_Name
• Number_of_Installments
• Order_Number
• Plan_Amount
• Plan_Number
• Shopper_Email
• Shopper_Name
• Terminal_Name

Plan Details Report

• Account_Id
• Account_Name
• Agent_Name
• Card_Brand
• Card_Type
• Credit_Refund_Amount
• Created_Date
• Currency
• Delayed_Installments
• First_Installment_Amount
• First_Installment_Date
• Funding_Type
• Legal_Business_Name
• Non_Credit_Refund_Amount
• Number_of_Installments
• Order_Number
• Outstanding_Amount
• Outstanding_Installments
• Paid_Installments
• Plan_Created_By
• Plan_End_Date
• Plan_Number
• Plan_On_Hold
• Plan_Status
• Shopper_Email
• Shopper_Name
• Terminal_Name
• Total_Plan_Amount

Notification of Fraud Report

• Account_Id
• Account_Name
• Card_Brand
• Card_Type
• Currency
• Fraud_Amount
• Installment_Amount
• Installment_Number
• Legal_Business_Name
• NOF_Reason_Code
• NOF_Reason_Description
• Notification_Date
• Number_Of_Installments
• Order_Number
• Plan_Number
• Plan_Original_Amount
• Plan_Status
• Shopper_Email
• Shopper_Name

Shopper Outstanding Report

• Account_Id
• Account_Name
• Amount_For_Next_0To30_Days
• Amount_For_Next_31To60_Days
• Amount_For_Next_61To90_Days
• Amount_for_Next_91PlusDays
• Currency
• Installment_Plan_Number
• Last_Collection_Date
• Legal_Business_Name
• Number_of_Installments
• Order_Number
• Outstanding_Amount
• Outstanding_Installments
• Paid_Amount
• Paid_Installments
• Plan_Activation_Date
• Plan_Status
• Report_Date
• Total_Plan_Amount

Pending CC Report

• Account_Id
• Account_Name
• Card_Brand
• Card_Type
• Created_Date
• Currency
• Delayed_Installments
• Funding_Type
• Legal_Business_Name
• Number_Of_Installments
• Order_Number
• Original_Amount
• Outstanding_Amount
• Outstanding_Installments
• Paid_Installments
• Plan_Number
• Plan_On_Hold
• Shopper_Email
• Shopper_Name

Refund Report

• Account_Id
• Account_Name
• Amount
• Credit_Refund_Amount
• Currency
• Legal_Business_Name
• Number_Of_Installments
• Plan_Number
• Refund_Plan_Reductions
• Refund_Date
• Refund_Id

Chargeback Report

• Account_Id
• Account_Name
• Card_Brand
• Case_Number
• Chargeback_Amount
• Chargeback_Created_Date
• Chargeback_Due_Date
• Chargeback_Installment_Number
• Chargeback_Status
• Chargeback_Type
• Currency_Code
• External_Chargeback_Id
• Installment_Amount
• Is_Pre_Arbitration
• Legal_Business_Name
• Number_Of_Installments
• Order_Number
• Plan_Amount
• Plan_Created_Date
• Plan_Number
• Plan_Status
• Reason_Code
• Reason_Description

Settlement Report (Summary)

• Account_Id
• Gross_Settlement_Amount
• Invoice_ID
• Legal_Business_Name
• Net_Settlement_Amount
• Reserve
• Settlement_Date
• Tax
• Total_Fees
• Total_Line_Items

Settlement Report (Details)

• Account_ID
• Account_Name
• Activity_Date
• Card_Brand
• Card_Type
• Exchange_Rate
• Exchange_Rate_Date
• Fixed_Fee
• Gross_Settlement_Amount
• Installment_Number
• Invoice_Id
• Legal_Business_Name
• Net_Settlement_Amount
• Number_Of_Installments
• Order_Number
• Plan_Created_Date
• Plan_Currency
• Plan_Number
• Ref_Transaction_ID
• Settlement_Currency
• Settlement_Date
• Shopper_Email
• Shopper_Name
• Tag_1
• Tag_2
• Terminal_API_Key
• Terminal_Name
• Transaction_Amount
• Transaction_Type
• Variable_Fee

Settlement Report (Gross Debit)

• Account_Id
• Account_Name
• Activity_Date
• Business_Unit
• Business_Unit_ID
• Card_Brand
• Card_Type
• Exchange_Rate
• Exchange_Rate_Date
• Fixed_Fee
• Gross_Settlement_Amount
• Installment_Number
• Invoice_ID
• Legal_Business_Name
• Net_Settlement_Amount
• Number_Of_Installments
• Order_Number
• Original_Plan_Amount
• Plan_Created_Date
• Plan_Currency
• Plan_Number
• Ref_Transaction_Id
• Settlement_Currency
• Settlement_Date
• Shopper_Email
• Shopper_Name
• Transaction_Amount
• Transaction_Type
• Variable_Fee

Standard Merchant Fee Report

• Plan_Number
• Number_Of_Installments
• Activity_Date
• Payment_Type
• Ref_Transaction_ID
• Installment_Number
• Plan_Currency
• Transaction_Amount
• Exchange_Rate
• Settlement_Currency
• Converted_Transaction_Amount
• Variable_Fee
• Fixed_Fee
• Total_Fees
• Invoice_Date
• Invoice_ID
• Order_Number
• Plan_Created_Date
• Original_Plan_Amount
• Exchange_Rate_Date
• Account_Id
• Account_Name
• Legal_Business_Name

Standard Merchant Fee Report (Summary)

• Invoice_Date
• Total_Line_Items
• Converted_Transaction_Amount
• Total_Fees
• Tax
• Net_Settlement_Amount
• Invoice_ID
• Account_ID
• Legal_Business_Name