# Klarna schema ERD

Table and field reference for the Fivetran Klarna connector.

## 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 |  |

## Relationships

- transaction(payment_reference) → payout(payment_reference)
- payout_report(payment_reference) → payout(payment_reference)