Average settlement amount per transaction
SQL query for Klarna
Calculate the average settlement amount for each transaction in the settlement_transactions table.
SELECT transaction_id, AVG(settlement_amount) AS average_settlement_amount FROM settlement_transactions GROUP BY transaction_id
Klarna data model
Settlement Payouts
View 19 columns
Merchant_idString
Payout_dateString
TransactionsString
Currency_codeString
Payment_referenceString
Totals_fee_amountInteger
Totals_tax_amountInteger
Totals_sale_amountInteger
Totals_repay_amountInteger
Totals_charge_amountInteger
Totals_credit_amountInteger
Totals_return_amountInteger
Totals_release_amountInteger
Totals_holdback_amountInteger
Totals_reversal_amountInteger
Merchant_settlement_typeString
Totals_commission_amountInteger
Totals_settlement_amountInteger
Totals_fee_correction_amountInteger
Settlement Transactions
View 24 columns
TypeString
AmountInteger
PayoutString
Order_idString
Refund_idString
Sale_dateString
Capture_idString
Vat_amountInteger
Merchant_idString
Capture_dateString
Currency_codeString
Detailed_typeString
Short_order_idString
Purchase_countryString
Payment_referenceString
Merchant_reference1String
Merchant_reference2String
Consumer_vat_0_tax_rateInteger
Consumer_vat_1_tax_rateInteger
Shipping_address_countryString
Consumer_vat_0_tax_amountNumber
Consumer_vat_1_tax_amountNumber
Initial_payment_method_typeString
Initial_payment_method_monthly_downpaymentsInteger
Ready to get instant access to all your company data ?
Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.
- 14-day free trial
- No credit card needed