Stripe data warehouse table groups

  • Updated on Oct 6, 2025
  • Published on Aug 5, 2025
Prev Next

Table: TRANSACTION

account_id
Display name Account ID
Description Unique ID of the account
Field type dimension
Data type string.text.value
account_name
Display name Account name
Description Display name of the account
Field type dimension
Data type string.text.value
app_id
Display name Application ID
Description Unique identifier for the object
Field type dimension
Data type string.text.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
source_id
Display name Source ID
Description Unique identifier for the object
Field type dimension
Data type string.text.value
transaction_amount
Display name Transaction amount
Description Gross amount of the transaction, in cents
Field type metric
Data type float.currency.value
transaction_available_date
Display name Transaction available date
Description The date the transaction's net funds will become available in the Stripe balance
Field type dimension
Data type string.time.date
transaction_charge_amount
Display name Charge amount
Description Amount of the fee, in cents
Field type metric
Data type float.currency.value
transaction_charge_fee
Display name Charge fee
Description Fees (in cents) paid for this transaction
Field type metric
Data type float.currency.value
transaction_charge_net
Display name Charge net
Description Net amount of the transaction, in cents
Field type metric
Data type float.currency.value
transaction_currency
Display name Transaction currency
Description Three-letter ISO currency code, in lowercase
Field type dimension
Data type string.currency.code
transaction_description
Display name Transaction description
Description An arbitrary string attached to the object. Often useful for displaying to users
Field type dimension
Data type string.text.value
transaction_fee
Display name Transaction fee
Description Fees (in cents) paid for this transaction
Field type metric
Data type float.currency.value
transaction_fee_description
Display name First fee description
Description An arbitrary string attached to the object. Often useful for displaying to users
Field type dimension
Data type string.text.value
transaction_fee_type
Display name First fee type
Description Type of the fee, one of: application_fee, stripe_fee or tax
Field type dimension
Data type string.text.value
transaction_id
Display name Transaction ID
Description Unique identifier for the object
Field type dimension
Data type string.text.value
transaction_net
Display name Transaction net
Description Net amount of the transaction, in cents
Field type metric
Data type float.currency.value
transaction_status
Display name Transaction status
Description If the transaction's net funds are available in the Stripe balance yet. Either available or pending
Field type dimension
Data type string.text.value
transaction_type
Display name Transaction type
Description Transaction type: adjustment, advance, advance_funding, application_fee, application_fee_refund, charge, connect_collection_transfer, issuing_authorization_hold, issuing_authorization_release, issuing_transaction, payment, payment_failure_refund, payment_refund, payout, payout_cancel, payout_failure, refund, refund_failure, reserve_transaction, reserved_funds, stripe_fee, stripe_fx_fee, tax_fee, topup, topup_reversal, transfer, transfer_cancel, transfer_failure, or transfer_refund
Field type dimension
Data type string.text.value

Table: CHARGE

account_id
Display name Account ID
Description Unique ID of the account
Field type dimension
Data type string.text.value
account_name
Display name Account name
Description Display name of the account
Field type dimension
Data type string.text.value
app_id
Display name Application ID
Description Unique identifier for the object
Field type dimension
Data type string.text.value
charge_amount
Display name Charge amount
Description A positive integer in the smallest currency unit (e.g., 100 cents to charge $1.00 or 100 to charge ¥100, a zero-decimal currency) representing how much to charge. The minimum amount is $0.50 US or equivalent in charge currency
Field type metric
Data type float.currency.value
charge_amount_refunded
Display name Charge refunded amount
Description Amount in cents refunded (can be less than the amount attribute on the charge if a partial refund was issued)
Field type metric
Data type float.currency.value
charge_app_fee
Display name Charge application fee
Description The application fee (if any) for the charge
Field type metric
Data type float.currency.value
charge_captured
Display name Charge is captured
Description If the charge was created without capturing, this Boolean represents whether it is still uncaptured or has since been captured
Field type dimension
Data type bool
charge_currency
Display name Charge currency
Description The status of the payment is either succeeded, pending, or failed
Field type dimension
Data type string.currency.code
charge_description
Display name Charge description
Description An arbitrary string attached to the object. Often useful for displaying to users
Field type dimension
Data type string.text.value
charge_failure_code
Display name Charge failure code
Description Error code explaining reason for charge failure if available
Field type dimension
Data type string.text.value
charge_failure_message
Display name Charge failure message
Description Message to user further explaining reason for charge failure if available
Field type dimension
Data type string.text.value
charge_fraud_details
Display name Fraud user details
Description Information on fraud assessments for the charge
Field type dimension
Data type string.text.json
charge_fraud_user_report
Display name Fraud user report
Description Assessments reported by you. If set, possible values of are safe and fraudulent
Field type dimension
Data type string.text.value
charge_id
Display name Charge ID
Description Unique identifier for the object
Field type dimension
Data type string.text.value
charge_metadata
Display name Charge metadata
Description Set of key-value pairs that you can attach to an object. This can be useful for storing additional information about the object in a structured format
Field type dimension
Data type string.text.json
charge_on_behalf_of
Display name Charge on behalf of
Description The account (if any) the charge was made on behalf of without triggering an automatic transfer
Field type dimension
Data type string.text.value
charge_outcome_network_status
Display name Outcome network status
Description Possible values are approved_by_network, declined_by_network, not_sent_to_network, and reversed_after_approval. The value reversed_after_approval indicates the payment was blocked by Stripe after bank authorization, and may temporarily appear as "pending" on a cardholder's statement
Field type dimension
Data type string.text.value
charge_outcome_reason
Display name Outcome reason
Description An enumerated value providing a more detailed explanation of the outcome's type. Charges blocked by Radar's default block rule have the value highest_risk_level. Charges placed in review by Radar's default review rule have the value elevated_risk_level. Charges authorized, blocked, or placed in review by custom rules have the value rule
Field type dimension
Data type string.text.value
charge_outcome_risk_level
Display name Outcome risk level
Description Stripe's evaluation of the riskiness of the payment. Possible values for evaluated payments are normal, elevated, highest. For non-card payments, and card-based payments predating the public assignment of risk levels, this field will have the value not_assessed. In the event of an error in the evaluation, this field will have the value unknown
Field type dimension
Data type string.text.value
charge_outcome_seller_message
Display name Outcome seller message
Description A human-readable description of the outcome type and reason, designed for you (the recipient of the payment), not your customer
Field type dimension
Data type string.text.value
charge_outcome_type
Display name Outcome type
Description Possible values are authorized, manual_review, issuer_declined, blocked, and invalid
Field type dimension
Data type string.text.value
charge_paid
Display name Charge is paid
Description true if the charge succeeded, or was successfully authorized for later capture
Field type dimension
Data type bool
charge_receipt_email
Display name Charge receipt email
Description This is the email address that the receipt for this charge was sent to
Field type dimension
Data type string.text.json
charge_receipt_number
Display name Charge receipt number
Description This is the transaction number that appears on email receipts sent for this charge. This attribute will be null until a receipt has been sent
Field type dimension
Data type string.text.value
charge_refunded
Display name Charge is refunded
Description Whether the charge has been fully refunded. If the charge is only partially refunded, this attribute will still be false
Field type dimension
Data type bool
charge_statement
Display name Charge statement descriptor
Description Extra information about a charge. This will appear on your customer's credit card statement. It must contain at least one letter
Field type dimension
Data type string.text.value
charge_status
Display name Charge status
Description The status of the payment is either succeeded, pending, or failed
Field type dimension
Data type string.text.value
charge_transfer_group
Display name Charge transfer group
Description A string that identifies this transaction as part of a group. See the Connect documentation for details
Field type dimension
Data type string.text.value
charge_type
Display name Charge type
Description String representing the object's type. Objects of the same type share the same value
Field type dimension
Data type string.text.value
customer_account_balance
Display name Customer Balance
Description An integer amount that represents the account balance for your customer. Account balances only affect invoices. A negative amount represents a credit that decreases the amount due on an invoice; a positive amount increases the amount due on an invoice
Field type metric
Data type float.currency.value
customer_currency
Display name Customer currency
Description Three-letter ISO code for the currency the customer can be charged in for recurring billing purposes
Field type dimension
Data type string.currency.code
customer_delinquent
Display name Customer is delinquent
Description When the customer's latest invoice is billed by charging automatically, delinquent is true if the invoice's latest charge is failed. When the customer's latest invoice is billed by sending an invoice, delinquent is true if the invoice is not paid by its due date
Field type dimension
Data type bool
customer_email
Display name Customer email
Description The customer's email address
Field type dimension
Data type string.text.email
customer_id
Display name Customer ID
Description Unique identifier for the object
Field type dimension
Data type string.text.value
customer_vat_id
Display name Customer VAT ID
Description Unique identifier for the object
Field type dimension
Data type string.text.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
destination_id
Display name Destination ID
Description Unique identifier for the object
Field type dimension
Data type string.text.value
dispute_id
Display name Dispute ID
Description Unique identifier for the object
Field type dimension
Data type string.text.value
invoice_id
Display name Invoice ID
Description The ID of the invoice this invoice item belongs to
Field type dimension
Data type string.text.value
review_id
Display name Review ID
Description Unique identifier for the object
Field type dimension
Data type string.text.value
shipping_address_city
Display name Shipping city
Description City/District/Suburb/Town/Village
Field type dimension
Data type string.geo.city
shipping_address_country
Display name Shipping country
Description Billing address country, if provided when creating card
Field type dimension
Data type string.geo.country.twolettercode
shipping_address_zip
Display name Shipping zip code
Description ZIP or postal code
Field type dimension
Data type string.geo.zip
shipping_carrier
Display name Shipping carrier
Description The delivery service that shipped a physical product, such as Fedex, UPS, USPS, etc. If multiple carriers were used for this purchase, please separate them with commas
Field type dimension
Data type string.text.value
shipping_line_1
Display name Shipping address line 1
Description Address line 1 (Street address/PO Box/Company name)
Field type dimension
Data type string.geo.street
shipping_line_2
Display name Shipping address line 2
Description Address line 2 (Apartment/Suite/Unit/Building)
Field type dimension
Data type string.geo.street
shipping_recipient_name
Display name Shipping recipient name
Description The name of the customer
Field type dimension
Data type string.text.value
shipping_recipient_phone
Display name Shipping recipient phone
Description The recipient's phone number
Field type dimension
Data type string.text.phone
shipping_state
Display name Shipping state
Description State/County/Province/Region
Field type dimension
Data type string.geo.region
shipping_tracking_number
Display name Shipping tracking number
Description The tracking number for a physical product, obtained from the delivery service. If multiple tracking numbers were generated for this purchase, please separate them with commas
Field type dimension
Data type string.text.value
source_address_city
Display name Source address city
Description City/District/Suburb/Town/Village
Field type dimension
Data type string.geo.city
source_address_country
Display name Source address country
Description Billing address country, if provided when creating card
Field type dimension
Data type string.geo.country
source_address_line_1
Display name Source address line 1
Description Address line 1 (Street address/PO Box/Company name)
Field type dimension
Data type string.geo.street
source_address_line_2
Display name Source address line 2
Description Address line 2 (Apartment/Suite/Unit/Building)
Field type dimension
Data type string.geo.street
source_address_state
Display name Source address state
Description State/County/Province/Region
Field type dimension
Data type string.geo.region
source_address_zip
Display name Source address zip code
Description ZIP or postal code
Field type dimension
Data type string.geo.zip
source_address_zip_check
Display name Source address zip code check
Description If address_zip was provided, results of the check: pass, fail, unavailable, or unchecked
Field type dimension
Data type string.text.value
source_card_brand
Display name Card brand
Description Card brand. Can be American Express, Diners Club, Discover, JCB, MasterCard, UnionPay, Visa, or Unknown
Field type dimension
Data type string.text.value
source_card_country
Display name Card country code
Description Two-letter ISO code representing the country of the card. You could use this attribute to get a sense of the international breakdown of cards you've collected
Field type dimension
Data type string.geo.country.twolettercode
source_card_cvc_check
Display name Card CVC check
Description If a CVC was provided, results of the check: pass, fail, unavailable, or unchecked
Field type dimension
Data type string.text.value
source_card_exp_month
Display name Card expiration month
Description Two digit number representing the card's expiration month
Field type dimension
Data type int.number.value
source_card_exp_year
Display name Card expiration year
Description Four digit number representing the card's expiration year
Field type dimension
Data type int.number.value
source_card_fingerprint
Display name Card fingerprint
Description Uniquely identifies this particular card number. You can use this attribute to check whether two customers who've signed up with you are using the same card number, for example
Field type dimension
Data type string.text.value
source_card_funding
Display name Card funding type
Description Card funding type. Can be credit, debit, prepaid, or unknown
Field type dimension
Data type string.text.value
source_card_last4
Display name Card last 4 digits
Description The last four digits of the card
Field type dimension
Data type string.text.value
source_card_last4_dynamic
Display name Card last 4 digits (dynamic)
Description (For tokenized numbers only.) The last four digits of the device account number
Field type dimension
Data type string.text.value
source_card_name
Display name Card holder name
Description Cardholder name
Field type dimension
Data type string.text.value
source_card_tokenization
Display name Card tokenization method
Description If the card number is tokenized, this is the method that was used. Can be apple_pay or google_pay
Field type dimension
Data type string.text.value
source_id
Display name Source ID
Description Unique identifier for the object
Field type dimension
Data type string.text.value
source_metadata
Display name Source metadata
Description Set of key-value pairs that you can attach to an object. This can be useful for storing additional information about the object in a structured format
Field type dimension
Data type string.text.json
source_type
Display name Source type
Description The type of the source. The type is a payment method
Field type dimension
Data type string.text.value
transaction_id
Display name Transaction ID
Description Unique identifier for the object
Field type dimension
Data type string.text.value
transfer_id
Display name Transfer ID
Description Unique identifier for the object
Field type dimension
Data type string.text.value

Table: BALANCE

account_id
Display name Account ID
Description Unique ID of the account
Field type dimension
Data type string.text.value
account_name
Display name Account name
Description Display name of the account
Field type dimension
Data type string.text.value
balance_amount
Display name Balance amount
Description Gross amount of the transaction, in cents
Field type metric
Data type float.currency.value
balance_currency
Display name Balance currency
Description Three-letter ISO currency code, in lowercase
Field type dimension
Data type string.currency.code
balance_source_bank
Display name Bank account balance
Description Current balance, if any, being stored on the customer's account. If negative, the customer has credit to apply to the next invoice. If positive, the customer has an amount owed that will be added to the next invoice. The balance does not refer to any unpaid invoices; it solely takes into account amounts that have yet to be successfully applied to any invoice. This balance is only taken into account as invoices are finalized. Note that the balance does not include unpaid invoices
Field type metric
Data type float.currency.value
balance_source_bitcoin
Display name Bitcoin receiver balance
Description Current balance, if any, being stored on the account in bitcoin
Field type metric
Data type float.currency.value
balance_source_card
Display name Card balance
Description Current balance, if any, being stored on the account's card
Field type metric
Data type float.currency.value
balance_type
Display name Balance type
Description String representing the object's type. Objects of the same type share the same value
Field type dimension
Data type string.text.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
today
Display name Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date

Table: APP_FEE

account_id
Display name Account ID
Description Unique ID of the account
Field type dimension
Data type string.text.value
account_name
Display name Account name
Description Display name of the account
Field type dimension
Data type string.text.value
app_fee_amount
Display name Fee amount
Description Amount earned, in cents
Field type metric
Data type float.currency.value
app_fee_amount_refunded
Display name Fee refunded amount
Description Amount, in cents
Field type metric
Data type float.currency.value
app_fee_currency
Display name Fee currency
Description Three-letter ISO currency code, in lowercase
Field type dimension
Data type string.currency.code
app_fee_id
Display name Application fee ID
Description Unique identifier for the object
Field type dimension
Data type string.text.value
app_fee_orig_transaction
Display name Originating transaction ID
Description ID of the corresponding charge on the platform account, if this fee was the result of a charge using the destinationparameter
Field type dimension
Data type string.text.value
app_fee_refunded
Display name Fee is refunded
Description Whether the fee has been fully refunded. If the fee is only partially refunded, this attribute will still be false
Field type dimension
Data type bool
app_id
Display name Application ID
Description Unique identifier for the object
Field type dimension
Data type string.text.value
charge_id
Display name Charge ID
Description Unique identifier for the object
Field type dimension
Data type string.text.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
transaction_id
Display name Transaction ID
Description Unique identifier for the object
Field type dimension
Data type string.text.value

Table: COUPON

account_id
Display name Account ID
Description Unique ID of the account
Field type dimension
Data type string.text.value
account_name
Display name Account name
Description Display name of the account
Field type dimension
Data type string.text.value
coupon_amount_off
Display name Amount off
Description Amount (in the currency specified) that will be taken off the subtotal of any invoices for this customer
Field type metric
Data type float.currency.value
coupon_duration
Display name Coupon duration
Description One of forever, once, and repeating. Describes how long a customer who applies this coupon will get the discount
Field type dimension
Data type string.text.value
coupon_duration_in_months
Display name Duration in months
Description If duration is repeating, the number of months the coupon applies. Null if coupon duration is forever or once
Field type metric
Data type int.number.value
coupon_id
Display name Coupon ID
Description Unique identifier for the object
Field type dimension
Data type string.text.value
coupon_max_redeems
Display name Max redeems
Description Maximum number of times this coupon can be redeemed, in total, across all customers, before it is no longer valid
Field type metric
Data type int.number.value
coupon_metadata
Display name Coupon metadata
Description A set of key-value pairs that you can attach to a coupon object. It can be useful for storing additional information about the coupon in a structured format
Field type dimension
Data type string.text.json
coupon_percent_off
Display name Coupon percent off
Description Percent that will be taken off the subtotal of any invoices for this customer for the duration of the coupon. For example, a coupon with percent_off of 50 will make a $100 invoice $50 instead
Field type dimension
Data type int.number.percentage
coupon_redeem_by
Display name Coupon redeem by date
Description Date after which the coupon can no longer be redeemed
Field type dimension
Data type string.time.date
coupon_times_redeemed
Display name Times redeemed
Description Number of times this coupon has been applied to a customer
Field type metric
Data type int.number.value
coupon_valid
Display name Coupon is valid
Description Taking account of the above properties, whether this coupon can still be applied to a customer
Field type dimension
Data type bool
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date

Table: DISPUTE

account_id
Display name Account ID
Description Unique ID of the account
Field type dimension
Data type string.text.value
account_name
Display name Account name
Description Display name of the account
Field type dimension
Data type string.text.value
charge_id
Display name Charge ID
Description Unique identifier for the object
Field type dimension
Data type string.text.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
dispute_amount
Display name Dispute amount
Description Disputed amount. Usually the amount of the disputed_transaction, but can differ (usually because of currency fluctuation or because only part of the order is disputed)
Field type metric
Data type float.currency.value
dispute_charge_refundable
Display name Dispute charge is refundable
Description If true, it is still possible to refund the disputed payment. Once the payment has been fully refunded, no further funds will be withdrawn from your Stripe account as a result of this dispute
Field type dimension
Data type bool
dispute_currency
Display name Dispute currency
Description Three-letter ISO currency code, in lowercase
Field type dimension
Data type string.currency.code
dispute_evidence_due_by
Display name Evidence due by date
Description Date by which evidence must be submitted in order to successfully challenge dispute. Will be null if the customer's bank or credit card company doesn't allow a response for this particular dispute
Field type dimension
Data type string.time.date
dispute_evidence_past_due
Display name Evidence is past due
Description Whether the last evidence submission was submitted past the due date. Defaults to false if no evidence submissions have occurred. If true, then delivery of the latest evidence is not guaranteed
Field type dimension
Data type bool
dispute_evidence_submissions
Display name Evidence submissions
Description Evidence related to the dispute. This hash will contain exactly one non-null value, containing an evidence object that matches its reason
Field type metric
Data type int.number.value
dispute_has_evidence
Display name Has evidence
Description Whether evidence has been staged for this dispute
Field type dimension
Data type bool
dispute_id
Display name Dispute ID
Description Unique identifier for the object
Field type dimension
Data type string.text.value
dispute_metadata
Display name Dispute metadata
Description Set of key-value pairs that you can attach to an object. This can be useful for storing additional information about the object in a structured format
Field type dimension
Data type string.text.json
dispute_reason
Display name Dispute reason
Description Reason given by cardholder for dispute. Possible values are duplicate, fraudulent, subscription_canceled, product_unacceptable, product_not_received, unrecognized, credit_not_processed, general, incorrect_account_details, insufficient_funds, bank_cannot_process, debit_not_authorized, or customer_initiated
Field type dimension
Data type string.text.value
dispute_status
Display name Dispute status
Description Current status of dispute. Possible values are warning_needs_response, warning_under_review, warning_closed, needs_response, under_review, charge_refunded, won, or lost
Field type dimension
Data type string.text.value
transaction_id
Display name Transaction ID
Description Unique identifier for the object
Field type dimension
Data type string.text.value

Table: INVOICE

account_id
Display name Account ID
Description Unique ID of the account
Field type dimension
Data type string.text.value
account_name
Display name Account name
Description Display name of the account
Field type dimension
Data type string.text.value
charge_id
Display name Charge ID
Description Unique identifier for the object
Field type dimension
Data type string.text.value
coupon_amount_off
Display name Amount off
Description Amount (in the currency specified) that will be taken off the subtotal of any invoices for this customer
Field type metric
Data type float.currency.value
coupon_duration
Display name Coupon duration
Description One of forever, once, and repeating. Describes how long a customer who applies this coupon will get the discount
Field type dimension
Data type string.text.value
coupon_duration_in_months
Display name Duration in months
Description If duration is repeating, the number of months the coupon applies. Null if coupon duration is forever or once
Field type metric
Data type int.number.value
coupon_id
Display name Coupon ID
Description Unique identifier for the object
Field type dimension
Data type string.text.value
coupon_max_redeems
Display name Max redeems
Description Maximum number of times this coupon can be redeemed, in total, across all customers, before it is no longer valid
Field type metric
Data type int.number.value
coupon_metadata
Display name Coupon metadata
Description A set of key-value pairs that you can attach to a coupon object. It can be useful for storing additional information about the coupon in a structured format
Field type dimension
Data type string.text.json
coupon_percent_off
Display name Coupon percent off
Description Percent that will be taken off the subtotal of any invoices for this customer for the duration of the coupon. For example, a coupon with percent_off of 50 will make a $100 invoice $50 instead
Field type dimension
Data type int.number.percentage
coupon_redeem_by
Display name Coupon redeem by date
Description Date after which the coupon can no longer be redeemed
Field type dimension
Data type string.time.date
coupon_times_redeemed
Display name Times redeemed
Description Number of times this coupon has been applied to a customer
Field type metric
Data type int.number.value
coupon_valid
Display name Coupon is valid
Description Taking account of the above properties, whether this coupon can still be applied to a customer
Field type dimension
Data type bool
customer_account_balance
Display name Customer Balance
Description An integer amount that represents the account balance for your customer. Account balances only affect invoices. A negative amount represents a credit that decreases the amount due on an invoice; a positive amount increases the amount due on an invoice
Field type metric
Data type float.currency.value
customer_currency
Display name Customer currency
Description Three-letter ISO code for the currency the customer can be charged in for recurring billing purposes
Field type dimension
Data type string.currency.code
customer_delinquent
Display name Customer is delinquent
Description When the customer's latest invoice is billed by charging automatically, delinquent is true if the invoice's latest charge is failed. When the customer's latest invoice is billed by sending an invoice, delinquent is true if the invoice is not paid by its due date
Field type dimension
Data type bool
customer_email
Display name Customer email
Description The customer's email address
Field type dimension
Data type string.text.email
customer_id
Display name Customer ID
Description Unique identifier for the object
Field type dimension
Data type string.text.value
customer_vat_id
Display name Customer VAT ID
Description Unique identifier for the object
Field type dimension
Data type string.text.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
invoice_amount_due
Display name Invoice due amount
Description Final amount due at this time for this invoice. If the invoice's total is smaller than the minimum charge amount, for example, or if there is account credit that can be applied to the invoice, the amount_due may be 0. If there is a positive starting_balance for the invoice (the customer owes money), the amount_due will also take that into account. The charge that gets generated for the invoice will be for the amount specified in amount_due
Field type metric
Data type float.currency.value
invoice_amount_ending_balance
Display name Ending customer balance
Description Ending customer balance after the invoice is finalized. Invoices are finalized approximately an hour after successful webhook delivery or when payment collection is attempted for the invoice. If the invoice has not been finalized yet, this will be null
Field type metric
Data type float.currency.value
invoice_amount_starting_balance
Display name Starting customer balance
Description Starting customer balance before the invoice is finalized. If the invoice has not been finalized yet, this will be the current customer balance
Field type metric
Data type float.currency.value
invoice_app_fee
Display name Invoice application fee
Description The fee in cents that will be applied to the invoice and transferred to the application owner's Stripe account when the invoice is paid
Field type metric
Data type float.currency.value
invoice_closed
Display name Invoice is closed
Description Please note that this field will be removed on 2021-08-12. Please note that this field will be removed on 2021-08-12
Field type dimension
Data type bool
invoice_currency
Display name Invoice currency
Description Three-letter ISO currency code, in lowercase
Field type dimension
Data type string.currency.code
invoice_description
Display name Invoice description
Description An arbitrary string attached to the object. Often useful for displaying to users. Referenced as 'memo' in the Dashboard
Field type dimension
Data type string.text.value
invoice_forgiven
Display name Invoice is forgiven
Description Please note that this field will be removed on 2021-08-12. Please note that this field will be removed on 2021-08-12
Field type dimension
Data type bool
invoice_id
Display name Invoice ID
Description The ID of the invoice this invoice item belongs to
Field type dimension
Data type string.text.value
invoice_metadata
Display name Invoice metadata
Description Set of key-value pairs that you can attach to an object. This can be useful for storing additional information about the object in a structured format
Field type dimension
Data type string.text.json
invoice_next_payment_attempt
Display name Invoice next payment attempt
Description The time at which payment will next be attempted. This value will be null for invoices where billing=send_invoice
Field type dimension
Data type string.time.datetime
invoice_paid
Display name Invoice is paid
Description Please note that this field will be removed on 2021-08-12. Please note that this field will be removed on 2021-08-12
Field type dimension
Data type bool
invoice_payment_attempts
Display name Invoice payment attempts
Description Number of payment attempts made for this invoice, from the perspective of the payment retry schedule. Any payment attempt counts as the first attempt, and subsequently only automatic retries increment the attempt count. In other words, manual payment attempts after the first attempt do not affect the retry schedule
Field type metric
Data type int.number.value
invoice_period_end
Display name Invoice period end time
Description End of the usage period during which invoice items were added to this invoice
Field type dimension
Data type string.time.datetime
invoice_period_start
Display name Invoice period start time
Description Start of the usage period during which invoice items were added to this invoice
Field type dimension
Data type string.time.datetime
invoice_receipt_number
Display name Invoice receipt number
Description This is the transaction number that appears on email receipts sent for this charge. This attribute will be null until a receipt has been sent
Field type dimension
Data type string.text.value
invoice_statement
Display name Invoice statement descriptor
Description Extra information about a charge. This will appear on your customer's credit card statement. It must contain at least one letter
Field type dimension
Data type string.text.value
invoice_subtotal
Display name Invoice subtotal
Description Total of all subscriptions, invoice items, and prorations on the invoice before any discount is applied
Field type metric
Data type float.currency.value
invoice_tax
Display name Invoice tax
Description The amount of tax included in the total, calculated from tax_percent and the subtotal. If no tax_percent is defined, this value will be null
Field type metric
Data type float.currency.value
invoice_total
Display name Invoice total
Description Total after discount
Field type metric
Data type float.currency.value
subscription_id
Display name Subscription ID
Description Unique identifier for the object
Field type dimension
Data type string.text.value

Table: REFUND

account_id
Display name Account ID
Description Unique ID of the account
Field type dimension
Data type string.text.value
account_name
Display name Account name
Description Display name of the account
Field type dimension
Data type string.text.value
charge_id
Display name Charge ID
Description Unique identifier for the object
Field type dimension
Data type string.text.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
refund_amount
Display name Refund amount
Description Amount, in cents
Field type metric
Data type float.currency.value
refund_currency
Display name Refund currency
Description Three-letter ISO currency code, in lowercase
Field type dimension
Data type string.currency.code
refund_id
Display name Refund ID
Description Unique identifier for the object
Field type dimension
Data type string.text.value
refund_metadata
Display name Refund metadata
Description Set of key-value pairs that you can attach to an object. This can be useful for storing additional information about the object in a structured format
Field type dimension
Data type string.text.json
refund_reason
Display name Refund reason
Description Reason for the refund. If set, possible values are duplicate, fraudulent, and requested_by_customer
Field type dimension
Data type string.text.value
refund_receipt_number
Display name Refund receipt number
Description This is the transaction number that appears on email receipts sent for this refund
Field type dimension
Data type string.text.value
refund_status
Display name Refund status
Description Status of the refund. For credit card refunds, this can be succeeded or failed. For other types of refunds, it can be pending, succeeded, failed, or canceled
Field type dimension
Data type string.text.value
transaction_id
Display name Transaction ID
Description Unique identifier for the object
Field type dimension
Data type string.text.value

Table: SUBSCRIPTION

account_id
Display name Account ID
Description Unique ID of the account
Field type dimension
Data type string.text.value
account_name
Display name Account name
Description Display name of the account
Field type dimension
Data type string.text.value
customer_currency
Display name Customer currency
Description Three-letter ISO code for the currency the customer can be charged in for recurring billing purposes
Field type dimension
Data type string.currency.code
customer_delinquent
Display name Customer is delinquent
Description When the customer's latest invoice is billed by charging automatically, delinquent is true if the invoice's latest charge is failed. When the customer's latest invoice is billed by sending an invoice, delinquent is true if the invoice is not paid by its due date
Field type dimension
Data type bool
customer_email
Display name Customer email
Description The customer's email address
Field type dimension
Data type string.text.email
customer_id
Display name Customer ID
Description Unique identifier for the object
Field type dimension
Data type string.text.value
customer_vat_id
Display name Customer VAT ID
Description Unique identifier for the object
Field type dimension
Data type string.text.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
subscription_appfee_percent
Display name Application fee (%)
Description A non-negative decimal between 0 and 100, with at most two decimal places. This represents the percentage of the subscription invoice subtotal that will be transferred to the application owner's Stripe account
Field type metric
Data type float.number.percentage
subscription_cancel_period_end
Display name Cancel at period end
Description Boolean indicating whether this subscription should cancel at the end of the current period
Field type dimension
Data type bool
subscription_cancel_time
Display name Subscription cancel time
Description If the subscription has been canceled, the date of that cancellation. If the subscription was canceled with cancel_at_period_end, canceled_atwill still reflect the date of the initial cancellation request, not the end of the subscription period when the subscription is automatically moved to a canceled state
Field type dimension
Data type string.time.datetime
subscription_end_time
Display name Subscription end time
Description If the subscription has ended, the date the subscription ended
Field type dimension
Data type string.time.datetime
subscription_id
Display name Subscription ID
Description Unique identifier for the object
Field type dimension
Data type string.text.value
subscription_metadata
Display name Subscription metadata
Description A set of key-value pairs that you can attach to a Subscription object. It can be useful for storing additional information about the subscription in a structured format
Field type dimension
Data type string.text.json
subscription_period_end
Display name Subscription period end time
Description End of the current period that the subscription has been invoiced for. At the end of this period, a new invoice will be created
Field type dimension
Data type string.time.datetime
subscription_period_start
Display name Subscription period start time
Description Start of the current period that the subscription has been invoiced for
Field type dimension
Data type string.time.datetime
subscription_plan_amount
Display name Plan amount
Description A positive integer in cents (or 0 for a free plan) representing how much to charge on a recurring basis
Field type metric
Data type float.currency.value
subscription_plan_id
Display name Plan id
Description Unique identifier for the object
Field type dimension
Data type string.text.value
subscription_plan_interval
Display name Plan interval
Description One of day, week, month or year. The frequency with which a subscription should be billed
Field type dimension
Data type string.text.value
subscription_plan_intervals
Display name Plan interval count
Description The number of intervals between subscription billings. For example, interval=month and interval_count=3 bills every 3 months
Field type metric
Data type int.number.value
subscription_plan_metadata
Display name Plan metadata
Description Set of key-value pairs that you can attach to an object. This can be useful for storing additional information about the object in a structured format
Field type dimension
Data type string.text.json
subscription_plan_name
Display name Plan name
Description A brief description of the plan, hidden from customers
Field type dimension
Data type string.text.value
subscription_plan_statement
Display name Plan statement descriptor
Description For a non-card charge, text that appears on the customer's statement as the statement descriptor
Field type dimension
Data type string.text.value
subscription_plan_trial_days
Display name Plan trial days
Description Default number of trial days when subscribing a customer to this plan using trial_from_plan=true
Field type metric
Data type int.number.value
subscription_quantity
Display name Subscription quantity
Description The quantity of the plan to which the customer is subscribed. For example, if your plan is $10/user/month, and your customer has 5 users, you could pass 5 as the quantity to have the customer charged $50 (5 x $10) monthly
Field type metric
Data type int.number.value
subscription_start_time
Display name Subscription start time
Description Date of the last substantial change to this subscription. For example, a change to the items array, or a change of status, will reset this timestamp
Field type dimension
Data type string.time.date
subscription_status
Display name Subscription status
Description Possible values are trialing, active, past_due, canceled, or unpaid. A subscription still in its trial period is trialing and moves to active when the trial period is over. If subscription billing=charge_automatically it becomes past_due when payment to renew it fails and canceled or unpaid (depending on your subscriptions settings) when Stripe has exhausted all payment retry attempts. If subscription billing=send_invoice it becomes past_due when its invoice is not paid by the due date, and canceled or unpaid if it is still not paid by an additional deadline after that. Note that when a subscription has a status of unpaid, no subsequent invoices will be attempted (invoices will be created, but then immediately automatically closed.)
Field type dimension
Data type string.text.value
subscription_tax_percent
Display name Subscription tax (%)
Description A non-negative decimal (with at most four decimal places) between 0 and 100. This represents the percentage of the subscription invoice subtotal that will be calculated and added as tax to the final amount in each billing period. For example, a plan which charges $10/month with a tax_percent of 20.0 will charge $12 per invoice. To unset a previously-set value, pass an empty string
Field type metric
Data type int.number.percentage
subscription_trial_end
Display name Subscription trial end time
Description Unix timestamp representing the end of the trial period the customer will get before being charged for the first time. This will always overwrite any trials that might apply via a subscribed plan
Field type dimension
Data type string.time.datetime
subscription_trial_start
Display name Subscription trial start time
Description If the subscription has a trial, the beginning of that trial
Field type dimension
Data type string.time.datetime

Table: TRANSFER

account_id
Display name Account ID
Description Unique ID of the account
Field type dimension
Data type string.text.value
account_name
Display name Account name
Description Display name of the account
Field type dimension
Data type string.text.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
destination_id
Display name Destination ID
Description Unique identifier for the object
Field type dimension
Data type string.text.value
transaction_id
Display name Transaction ID
Description Unique identifier for the object
Field type dimension
Data type string.text.value
transfer_amount
Display name Transfer amount
Description Amount in cents to be transferred
Field type metric
Data type float.currency.value
transfer_amount_reversed
Display name Transfer reversed amount
Description Amount in cents reversed (can be less than the amount attribute on the transfer if a partial reversal was issued)
Field type metric
Data type float.currency.value
transfer_currency
Display name Transfers currency
Description Three-letter ISO currency code, in lowercase
Field type dimension
Data type string.currency.code
transfer_description
Display name Transfers description
Description An arbitrary string attached to the object. Often useful for displaying to users
Field type dimension
Data type string.text.value
transfer_destination_payment_id
Display name Transfers destination payment ID
Description Unique identifier for the object
Field type dimension
Data type string.text.value
transfer_group_id
Display name Transfer group ID
Description Unique identifier for the object
Field type dimension
Data type string.text.value
transfer_id
Display name Transfer ID
Description Unique identifier for the object
Field type dimension
Data type string.text.value
transfer_metadata
Display name Transfer metadata
Description A set of key-value pairs that you can attach to a transfer object. It can be useful for storing additional information about the transfer in a structured format
Field type dimension
Data type string.text.json
transfer_reversed
Display name Transfer is reversed
Description Whether the transfer has been fully reversed. If the transfer is only partially reversed, this attribute will still be false
Field type dimension
Data type bool
transfer_source_transaction_id
Display name Transfer source transaction ID
Description Unique identifier for the object
Field type dimension
Data type string.text.value
transfer_source_type
Display name Transfer source type
Description The source balance this transfer came from. One of card, financing, bank_account, or alipay_account
Field type dimension
Data type string.text.value