Klarna
Explore the interactive ERD
Table & Field Reference
transaction
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
payment_reference | Unknown | FK |
amount | Unknown | |
capture_date | Unknown | |
capture_id | Unknown | |
currency_code | Unknown | |
currency_code_of_registration_country | Unknown | |
detailed_type | Unknown | |
initial_number_of_installments | Unknown | |
initial_payment_method_monthly_down_payment | Unknown | |
initial_payment_method_number_of_installment | Unknown | |
initial_payment_method_type | Unknown | |
klarna_comment | Unknown | |
merchant_capture_reference | Unknown | |
merchant_id | Unknown | |
merchant_reference_1 | Unknown | |
merchant_reference_2 | Unknown | |
merchant_refund_reference | Unknown | |
order_id | Unknown | |
payout | Unknown | |
purchase_country | Unknown | |
refund_id | Unknown | |
sale_date | Unknown | |
shipping_address_country | Unknown | |
short_order_id | Unknown | |
tax_in_currency_of_registration_country | Unknown | |
type | Unknown | |
vat_amount | Unknown | |
vat_rate | Unknown |
payout_report
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
payment_reference | Unknown | FK |
amount | Unknown | |
capture_date | Unknown | |
capture_id | Unknown | |
detailed_type | Unknown | |
initial_payment_method_monthly_down_payment | Unknown | |
initial_payment_method_number_of_installment | Unknown | |
initial_payment_method_type | Unknown | |
klarna_comment | Unknown | |
merchant_capture_reference | Unknown | |
merchant_reference_1 | Unknown | |
merchant_reference_2 | Unknown | |
merchant_refund_reference | Unknown | |
merchant_settlement_type | Unknown | |
order_id | Unknown | |
payout_date | Unknown | |
posting_currency | Unknown | |
purchase_country | Unknown | |
refund_id | Unknown | |
sale_date | Unknown | |
settlement_merchant_id | Unknown | |
shipping_address_country | Unknown | |
short_order_id | Unknown | |
sub_merchant_id | Unknown | |
tax_amount | Unknown | |
tax_rate | Unknown | |
type | Unknown |
payout
| Column | Type | Keys |
|---|---|---|
payment_reference | Unknown | PK |
currency_code | Unknown | |
currency_code_of_registration_country | Unknown | |
merchant_id | Unknown | |
merchant_settlement_type | Unknown | |
payout_date | Unknown | |
total_charge_amount | Unknown | |
total_closing_debt_balance_amount | Unknown | |
total_commission_amount | Unknown | |
total_credit_amount | Unknown | |
total_deposit_amount | Unknown | |
total_fee_amount | Unknown | |
total_fee_correction_amount | Unknown | |
total_fee_refund_amount | Unknown | |
total_holdback_amount | Unknown | |
total_opening_debt_balance_amount | Unknown | |
total_release_amount | Unknown | |
total_repay_amount | Unknown | |
total_return_amount | Unknown | |
total_reversal_amount | Unknown | |
total_sale_amount | Unknown | |
total_settlement_amount | Unknown | |
total_tax_amount | Unknown | |
total_tax_refund_amount | Unknown | |
transaction | Unknown |