Introduction

Datasources and destinations

Fields listing for Stripe

Account Id
Id of an account.
Field IDaccount/id
TypeTEXT
Data Typedimension
Account name
Name of the account
Field IDaccount/name
TypeTEXT
Data Typedimension
Year
Year such as 2017.
Field ID_NORMALIZED_DATE_FIELD_YEAR
TypeYEAR
Data Typedimension
Year Quarter
Year and quarter.
Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER
TypeYEAR_QUARTER
Data Typedimension
Year month
Year and month.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH
TypeYEAR_MONTH
Data Typedimension
Year week
Year and week.
Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK
TypeYEAR_WEEK
Data Typedimension
Date
Year, month, and day.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
TypeYEAR_MONTH_DAY
Data Typedimension
Year month day hour
Year, month, day, and hour.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
TypeQUARTER
Data Typedimension
Month of the year
Month of the year
Field ID_NORMALIZED_DATE_FIELD_MONTH
TypeMONTH
Data Typedimension
Week of the year
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK
TypeWEEK
Data Typedimension
Month and day
Month and day
Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY
TypeMONTH_DAY
Data Typedimension
Day of the week
Week of the year
Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
TypeDAY_OF_WEEK
Data Typedimension
Day of the month
Day of the year
Field ID_NORMALIZED_DATE_FIELD_DAY
TypeDAY
Data Typedimension
Hour of the day
Hour of the day
Field ID_NORMALIZED_DATE_FIELD_HOUR
TypeHOUR
Data Typedimension
Customer ID
Id of a customer.
Field IDcustomer/id
TypeTEXT
Data Typedimension
Customer currency
Name of the customer
Field IDcustomer/currency
TypeTEXT
Data Typedimension
Customer Created On
Time at which the object was created. Measured in seconds since the Unix epoch.
Field IDcustomer/created
TypeYEAR_MONTH_DAY
Data Typedimension
Customer email
Email of the customer
Field IDcustomer/email
TypeTEXT
Data Typedimension
Customer Delinquent
Tracks the most recent state change on any invoice belonging to the customer.
Field IDcustomer/delinquent
TypeBOOLEAN
Data Typedimension
Customer City
City, district, suburb, town, or village.
Field IDcustomer/city
TypeTEXT
Data Typedimension
Customer Country
Two-letter country code (ISO 3166-1 alpha-2).
Field IDcustomer/country
TypeCOUNTRY_CODE
Data Typedimension
Customer Address Line 1
Address line 1 (e.g., street, PO Box, or company name).
Field IDcustomer/line1
TypeTEXT
Data Typedimension
Customer Address Line 2
Address line 2 (e.g., apartment, suite, unit, or building).
Field IDcustomer/line2
TypeTEXT
Data Typedimension
Customer Postal Code
ZIP or postal code.
Field IDcustomer/postal_code
TypeTEXT
Data Typedimension
Customer State
State, county, province, or region.
Field IDcustomer/state
TypeTEXT
Data Typedimension
Customer Name
The customer’s full name or business name.
Field IDcustomer/name
TypeTEXT
Data Typedimension
Customer Phone
The customer’s phone number.
Field IDcustomer/phone
TypeTEXT
Data Typedimension
Customer Shipping Name
The customer’s shipping name.
Field IDcustomer/shipping_name
TypeTEXT
Data Typedimension
Customer Shipping Phone
The customer’s shipping phone.
Field IDcustomer/shipping_phone
TypeTEXT
Data Typedimension
Customer Shipping City
The customer’s shipping city.
Field IDcustomer/shipping_address_city
TypeTEXT
Data Typedimension
Customer Shipping Country
Two-letter country code (ISO 3166-1 alpha-2).
Field IDcustomer/shipping_address_country
TypeCOUNTRY_CODE
Data Typedimension
Customer Shipping Address Line 1
Address line 1 (e.g., street, PO Box, or company name).
Field IDcustomer/shipping_address_line1
TypeTEXT
Data Typedimension
Customer Shipping Address Line 2
Address line 2 (e.g., apartment, suite, unit, or building).
Field IDcustomer/shipping_address_line2
TypeTEXT
Data Typedimension
Customer Shipping Postal Code
ZIP or postal code.
Field IDcustomer/shipping_address_postal_code
TypeTEXT
Data Typedimension
Customer Shipping State
State, county, province, or region.
Field IDcustomer/shipping_address_state
TypeTEXT
Data Typedimension
Customer Balance
The current balance, if any, that’s stored on the customer. If negative, the customer has credit to apply to their next invoice. If positive, the customer has an amount owed that’s added to their next invoice.
Field IDcustomer/balance
TypeNUMBER
Data Typedimension
Customer Discount
Describes the current discount active on the customer, if there is one.
Field IDcustomer/discount
TypeTEXT
Data Typedimension
Customer Invoice Prefix
Describes the current discount active on the customer, if there is one.
Field IDcustomer/invoice_prefix
TypeTEXT
Data Typedimension
Customer Next Invoice Sequence
The suffix of the customer’s next invoice number (for example, 0001).
Field IDcustomer/next_invoice_sequence
TypeTEXT
Data Typedimension
Customer Tax Exempt
Describes the customer’s tax exemption status, which is none, exempt, or reverse. When set to reverse, invoice and receipt PDFs include the following text: “Reverse charge”.
Field IDcustomer/tax_exempt
TypeTEXT
Data Typedimension
Customer Automatic Tax Status
Surfaces if automatic tax computation is possible given the current customer location information.
Field IDcustomer/tax_supported
TypeTEXT
Data Typedimension
Customer IP Tax Address
A recent IP address of the customer used for tax reporting and tax location inference.
Field IDcustomer/tax_ip_address
TypeTEXT
Data Typedimension
Customer Tax Location Country
The customer’s country as identified by Stripe Tax.
Field IDcustomer/tax_location_country
TypeTEXT
Data Typedimension
Customer Tax Location Source
The data source used to infer the customer’s location.
Field IDcustomer/tax_location_source
TypeTEXT
Data Typedimension
Customer Tax Location State
The customer’s state, county, province, or region as identified by Stripe Tax.
Field IDcustomer/tax_location_state
TypeTEXT
Data Typedimension
Balance Type
Should be available or pending
Field IDbalance/type
TypeTEXT
Data Typedimension
Balance Amount
Balance amount.
Field IDbalance/amount
TypeNUMBER
Data Typedimension
Balance Currency
Balance currency. Three-letter ISO currency code, in lowercase. Must be a supported currency.
Field IDbalance/currency
TypeTEXT
Data Typedimension
Balance Card Amount
Amount for card.
Field IDbalance/card
TypeNUMBER
Data Typedimension
Balance Bank Account Amount
Amount for bank account.
Field IDbalance/bank_account
TypeNUMBER
Data Typedimension
Balance FPX Amount
Amount for FPX.
Field IDbalance/fpx
TypeNUMBER
Data Typedimension
Charge ID
Unique identifier for the object.
Field IDcharge/id
TypeTEXT
Data Typedimension
Charge Amount
Amount intended to be collected by this payment. A positive integer representing how much to charge in the smallest currency unit (e.g., 100 cents to charge $1.00 or 100 to charge ¥100, a zero-decimal currency). The minimum amount is $0.50 US or equivalent in charge currency. The amount value supports up to eight digits (e.g., a value of 99999999 for a USD charge of $999,999.99).
Field IDcharge/amount
TypeNUMBER
Data Typedimension
Charge Billing Name
The charge’s billing name.
Field IDcharge/billing_name
TypeTEXT
Data Typedimension
Charge Billing Phone
The charge's billing phone.
Field IDcharge/billing_phone
TypeTEXT
Data Typedimension
Charge Billing Email
The charge's billing phone.
Field IDcharge/billing_email
TypeTEXT
Data Typedimension
Charge Billing City
The charge's billing city.
Field IDcharge/billing_address_city
TypeTEXT
Data Typedimension
Charge Billing Country
Two-letter country code (ISO 3166-1 alpha-2).
Field IDcharge/billing_address_country
TypeCOUNTRY_CODE
Data Typedimension
Charge Billing Address Line 1
Address line 1 (e.g., street, PO Box, or company name).
Field IDcharge/billing_address_line1
TypeTEXT
Data Typedimension
Charge Billing Address Line 2
Address line 2 (e.g., apartment, suite, unit, or building).
Field IDcharge/billing_address_line2
TypeTEXT
Data Typedimension
Charge Billing Postal Code
ZIP or postal code.
Field IDcharge/billing_address_postal_code
TypeTEXT
Data Typedimension
Charge Billing State
State, county, province, or region.
Field IDcharge/billing_address_state
TypeTEXT
Data Typedimension
Charge Currency
The charge's currency
Field IDcharge/currency
TypeTEXT
Data Typedimension
Charge Is Disputed
The charge's disputed state
Field IDcharge/disputed
TypeBOOLEAN
Data Typedimension
Charge Is Refunded
The charge's refunded state
Field IDcharge/refunded
TypeBOOLEAN
Data Typedimension
Charge Receipt Email
The charge's receipt email
Field IDcharge/receipt_email
TypeTEXT
Data Typedimension
Charge Shipping Name
The charge's shipping name.
Field IDcharge/shipping_name
TypeTEXT
Data Typedimension
Charge Shipping Carrier
The charge's shipping carrier.
Field IDcharge/shipping_carrier
TypeTEXT
Data Typedimension
Charge Shipping Tracking Number
The charge's shipping tracking number.
Field IDcharge/shipping_tracking_number
TypeTEXT
Data Typedimension
Charge Shipping Phone
The charge's shipping phone.
Field IDcharge/shipping_phone
TypeTEXT
Data Typedimension
Charge Shipping City
The charge's shipping city.
Field IDcharge/shipping_address_city
TypeTEXT
Data Typedimension
Charge Shipping Country
Two-letter country code (ISO 3166-1 alpha-2).
Field IDcharge/shipping_address_country
TypeCOUNTRY_CODE
Data Typedimension
Charge Shipping Address Line 1
Address line 1 (e.g., street, PO Box, or company name).
Field IDcharge/shipping_address_line1
TypeTEXT
Data Typedimension
Charge Shipping Address Line 2
Address line 2 (e.g., apartment, suite, unit, or building).
Field IDcharge/shipping_address_line2
TypeTEXT
Data Typedimension
Charge Shipping Postal Code
ZIP or postal code.
Field IDcharge/shipping_address_postal_code
TypeTEXT
Data Typedimension
Charge Shipping State
State, county, province, or region.
Field IDcharge/shipping_address_state
TypeTEXT
Data Typedimension
Charge Statement Descriptor
For card charges, use statement_descriptor_suffix instead. Otherwise, you can use this value as the complete description of a charge on your customers’ statements. Must contain at least one letter, maximum 22 characters.
Field IDcharge/statement_descriptor
TypeTEXT
Data Typedimension
Charge Statement Descriptor Suffix
Provides information about the charge that customers see on their statements. Concatenated with the prefix (shortened descriptor) or statement descriptor that’s set on the account to form the complete statement descriptor. Maximum 22 characters for the concatenated descriptor.
Field IDcharge/statement_descriptor_suffix
TypeTEXT
Data Typedimension
Charge Status
The status of the payment is either succeeded, pending, or failed.
Field IDcharge/status
TypeTEXT
Data Typedimension
Charge Amount Captured
Amount in cents captured (can be less than the amount attribute on the charge if a partial capture was made).
Field IDcharge/amount_captured
TypeNUMBER
Data Typedimension
Charge Amount Refunded
Amount in cents refunded (can be less than the amount attribute on the charge if a partial refund was issued).
Field IDcharge/amount_refunded
TypeNUMBER
Data Typedimension
Charge Calculated Statement Descriptor
The full statement descriptor that is passed to card networks, and that is displayed on your customers’ credit card and bank statements. Allows you to see what the statement descriptor looks like after the static and dynamic portions are combined.
Field IDcharge/calculated_statement_descriptor
TypeTEXT
Data Typedimension
Charge Is captured
If the charge was created without capturing, this Boolean represents whether it is still uncaptured or has since been captured.
Field IDcharge/captured
TypeBOOLEAN
Data Typedimension
Charge Created On
Time at which the object was created. Measured in seconds since the Unix epoch.
Field IDcharge/created
TypeYEAR_MONTH_DAY
Data Typedimension
Charge Failure Code
Error code explaining reason for charge failure if available (see the errors section for a list of codes).
Field IDcharge/failure_code
TypeTEXT
Data Typedimension
Charge Failure Message
Message to user further explaining reason for charge failure if available.
Field IDcharge/failure_message
TypeTEXT
Data Typedimension
Charge Is Paid
true if the charge succeeded, or was successfully authorized for later capture.
Field IDcharge/paid
TypeBOOLEAN
Data Typedimension
Charge Id of the payment method
ID of the payment method used in this charge.
Field IDcharge/payment_method
TypeTEXT
Data Typedimension
Charge Receipt Number
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 IDcharge/receipt_number
TypeTEXT
Data Typedimension
Charge Receipt URL
his is the URL to view the receipt for this charge. The receipt is kept up-to-date to the latest state of the charge, including any refunds. If the charge is for an Invoice, the receipt will be stylized as an Invoice receipt.
Field IDcharge/receipt_url
TypeTEXT
Data Typedimension
Invoice ID
The Invoice ID
Field IDinvoice/id
TypeTEXT
Data Typedimension
Invoice Auto Advance
The Invoice auto advance state
Field IDinvoice/auto_advance
TypeBOOLEAN
Data Typedimension
Invoice Collection Method
Either charge_automatically, or send_invoice. When charging automatically, Stripe will attempt to pay this invoice using the default source attached to the customer. When sending an invoice, Stripe will email this invoice to the customer with payment instructions.
Field IDinvoice/collection_method
TypeTEXT
Data Typedimension
Invoice Currency
Three-letter ISO currency code, in lowercase. Must be a supported currency.
Field IDinvoice/currency
TypeTEXT
Data Typedimension
Invoice Hosted URL
The invoice url
Field IDinvoice/hosted_invoice_url
TypeTEXT
Data Typedimension
Invoice Period End
End of the usage period during which invoice items were added to this invoice.
Field IDinvoice/period_end
TypeYEAR_MONTH_DAY
Data Typedimension
Invoice Due date
The date on which payment for this invoice is due. This value will be null for invoices where collection_method=charge_automatically.
Field IDinvoice/due_date
TypeYEAR_MONTH_DAY
Data Typedimension
Invoice Effective At
The date when this invoice is in effect. Same as finalized_at unless overwritten. When defined, this value replaces the system-generated ‘Date of issue’ printed on the invoice PDF and receipt.
Field IDinvoice/effective_at
TypeYEAR_MONTH_DAY
Data Typedimension
Invoice Period Start
Start of the usage period during which invoice items were added to this invoice.
Field IDinvoice/period_start
TypeYEAR_MONTH_DAY
Data Typedimension
Invoice Created At
Date fo the creation of the invoice.
Field IDinvoice/created
TypeYEAR_MONTH_DAY
Data Typedimension
Invoice Next Payment Attempt
The time at which payment will next be attempted. This value will be null for invoices where collection_method=send_invoice.
Field IDinvoice/next_payment_attempt
TypeYEAR_MONTH_DAY
Data Typedimension
Invoice Status
The status of the invoice, one of draft, open, paid, uncollectible, or void. Learn more
Field IDinvoice/status
TypeTEXT
Data Typedimension
Invoice Number
A unique, identifying string that appears on emails sent to the customer for this invoice. This starts with the customer’s unique invoice_prefix if it is specified.
Field IDinvoice/number
TypeTEXT
Data Typedimension
Invoice Total
Total after discounts and taxes.
Field IDinvoice/total
TypeNUMBER
Data Typedimension
Invoice Amount Due
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 IDinvoice/amount_due
TypeNUMBER
Data Typedimension
Invoice Ending Balance
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 IDinvoice/ending_balance
TypeNUMBER
Data Typedimension
Invoice Amount Paied
The amount, in cents, that was paid.
Field IDinvoice/amount_paid
TypeNUMBER
Data Typedimension
Invoice Amount Remaining
The difference between amount_due and amount_paid, in cents.
Field IDinvoice/amount_remaining
TypeNUMBER
Data Typedimension
Invoice Amount Shipping
This is the sum of all the shipping amounts.
Field IDinvoice/amount_shipping
TypeNUMBER
Data Typedimension
Invoice Attempt Count
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 IDinvoice/attempt_count
TypeNUMBER
Data Typedimension
Invoice Attempted
Whether an attempt has been made to pay the invoice. An invoice is not attempted until 1 hour after the invoice.created webhook, for example, so you might not want to display that invoice as unpaid to your users.
Field IDinvoice/attempted
TypeBOOLEAN
Data Typedimension
Invoice Billing Reason
Indicates the reason why the invoice was created.
Field IDinvoice/billing_reason
TypeTEXT
Data Typedimension
Invoice PDF
The link to download the PDF for the invoice. If the invoice has not been finalized yet, this will be null.
Field IDinvoice/invoice_pdf
TypeTEXT
Data Typedimension
Invoice Is Paid
Whether payment was successfully collected for this invoice. An invoice can be paid (most commonly) with a charge or with credit from the customer’s account balance.
Field IDinvoice/paid
TypeBOOLEAN
Data Typedimension
Invoice Is Paid Out Of Band
Returns true if the invoice was manually marked paid, returns false if the invoice hasn’t been paid yet or was paid on Stripe.
Field IDinvoice/paid_out_of_band
TypeBOOLEAN
Data Typedimension
Invoice Post Payment Credit Note Amount
Total amount of all post-payment credit notes issued for this invoice.
Field IDinvoice/post_payment_credit_notes_amount
TypeNUMBER
Data Typedimension
Invoice Pre Payment Credit Note Amount
Total amount of all pre-payment credit notes issued for this invoice.
Field IDinvoice/pre_payment_credit_notes_amount
TypeNUMBER
Data Typedimension
Invoice Receipt Number
This is the transaction number that appears on email receipts sent for this invoice.
Field IDinvoice/receipt_number
TypeTEXT
Data Typedimension
Invoice Starting Balance
Starting customer balance before the invoice is finalized. If the invoice has not been finalized yet, this will be the current customer balance. For revision invoices, this also includes any customer balance that was applied to the original invoice.
Field IDinvoice/starting_balance
TypeNUMBER
Data Typedimension
Invoice Statement Descriptor
Extra information about an invoice for the customer’s credit card statement.
Field IDinvoice/statement_descriptor
TypeTEXT
Data Typedimension
Invoice Subscription Proration Date
Only set for upcoming invoices that preview prorations. The time used to calculate prorations.
Field IDinvoice/subscription_proration_date
TypeNUMBER
Data Typedimension
Invoice Subtotal
Total of all subscriptions, invoice items, and prorations on the invoice before any invoice level discount or exclusive tax is applied. Item discounts are already incorporated.
Field IDinvoice/subtotal
TypeNUMBER
Data Typedimension
Invoice Subtotal Excluding Tax
The integer amount in cents representing the subtotal of the invoice before any invoice level discount or tax is applied. Item discounts are already incorporated
Field IDinvoice/subtotal_excluding_tax
TypeNUMBER
Data Typedimension
Invoice Tax
The amount of tax on this invoice. This is the sum of all the tax amounts on this invoice.
Field IDinvoice/tax
TypeNUMBER
Data Typedimension
Invoice Total Excluding Tax
The integer amount in cents representing the total amount of the invoice including all discounts but excluding all tax.
Field IDinvoice/total_excluding_tax
TypeNUMBER
Data Typedimension
Invoice Item ID
The Invoice Item Id
Field IDinvoice_item/id
TypeTEXT
Data Typedimension
Invoice Item Amount
The Invoice Item Amount
Field IDinvoice_item/amount
TypeNUMBER
Data Typedimension
Invoice Item Currency
The Invoice Item Currency
Field IDinvoice_item/currency
TypeTEXT
Data Typedimension
Invoice Item Period Start
The Invoice Item Period Start
Field IDinvoice_item/period_start
TypeYEAR_MONTH_DAY
Data Typedimension
Invoice Item Period End
The Invoice Item Period End
Field IDinvoice_item/period_end
TypeYEAR_MONTH_DAY
Data Typedimension
Invoice Item Proration
The Invoice Item Proration
Field IDinvoice_item/proration
TypeBOOLEAN
Data Typedimension
Invoice Item Created At
The Invoice Item Created At
Field IDinvoice_item/date
TypeYEAR_MONTH_DAY
Data Typedimension
Invoice Item IS Discountable
The Invoice Item Is Discountable
Field IDinvoice_item/discountable
TypeBOOLEAN
Data Typedimension
Invoice Item Quantity
Quantity of units for the invoice item. If the invoice item is a proration, the quantity of the subscription that the proration was computed for.
Field IDinvoice_item/quantity
TypeNUMBER
Data Typedimension
Invoice Item Unit Amount
Unit amount (in the currency specified) of the invoice item.
Field IDinvoice_item/unit_amount
TypeNUMBER
Data Typedimension
Invoice Item Subscription item
The subscription item that this invoice item has been created for, if any.
Field IDinvoice_item/subscription_item
TypeTEXT
Data Typedimension
Subscription ID
The Subscription Id
Field IDsubscription/id
TypeTEXT
Data Typedimension
Subscription Cancel At Period End
If the subscription has been canceled with the at_period_end flag set to true, cancel_at_period_end on the subscription will be true. You can use this attribute to determine whether a subscription that has a status of active is scheduled to be canceled at the end of the current period.
Field IDsubscription/cancel_at_period_end
TypeBOOLEAN
Data Typedimension
Subscription Currency
Three-letter ISO currency code, in lowercase. Must be a supported currency.
Field IDsubscription/currency
TypeTEXT
Data Typedimension
Subscription Current Period End
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 IDsubscription/current_period_end
TypeYEAR_MONTH_DAY
Data Typedimension
Subscription Current Period Start
Start of the current period that the subscription has been invoiced for.
Field IDsubscription/current_period_start
TypeYEAR_MONTH_DAY
Data Typedimension
Subscription Billing Cycle Anchor
Determines the date of the first full invoice, and, for plans with month or year intervals, the day of the month for subsequent invoices. The timestamp is in UTC format.
Field IDsubscription/billing_cycle_anchor
TypeYEAR_MONTH_DAY
Data Typedimension
Subscription Cancel At
A date in the future at which the subscription will automatically get canceled.
Field IDsubscription/cancel_at
TypeYEAR_MONTH_DAY
Data Typedimension
Subscription Canceled At
If the subscription has been canceled, the date of that cancellation. If the subscription was canceled with cancel_at_period_end, canceled_at will reflect the time of the most recent update request, not the end of the subscription period when the subscription is automatically moved to a canceled state.
Field IDsubscription/canceled_at
TypeYEAR_MONTH_DAY
Data Typedimension
Subscription Created At
Time at which the object was created. Measured in seconds since the Unix epoch.
Field IDsubscription/created
TypeYEAR_MONTH_DAY
Data Typedimension
Subscription Ended At
If the subscription has ended, the date the subscription ended.
Field IDsubscription/ended_at
TypeYEAR_MONTH_DAY
Data Typedimension
Subscription Start Date
Date when the subscription was first created. The date might differ from the created date due to backdating.
Field IDsubscription/start_date
TypeYEAR_MONTH_DAY
Data Typedimension
Subscription Trial End
If the subscription has a trial, the end of that trial.
Field IDsubscription/trial_end
TypeYEAR_MONTH_DAY
Data Typedimension
Subscription Trial Start
If the subscription has a trial, the beginning of that trial.
Field IDsubscription/trial_start
TypeYEAR_MONTH_DAY
Data Typedimension
Subscription Next Pending Invoice item Invoice
Specifies the approximate timestamp on which any pending invoice items will be billed according to the schedule provided at pending_invoice_item_interval.
Field IDsubscription/next_pending_invoice_item_invoice
TypeYEAR_MONTH_DAY
Data Typedimension
Subscription Pause Collection Behavior
The payment collection behavior for this subscription while paused. One of keep_as_draft, mark_uncollectible, or void.
Field IDsubscription/pause_collection_behavior
TypeTEXT
Data Typedimension
Subscription Pause Collection Resume At
The time after which the subscription will resume collecting payments.
Field IDsubscription/pause_collection_resumes_at
TypeYEAR_MONTH_DAY
Data Typedimension
Subscription Cancellation Details Comment
Additional comments about why the user canceled the subscription, if the subscription was canceled explicitly by the user.
Field IDsubscription/cancellation_details_comment
TypeTEXT
Data Typedimension
Subscription Cancellation Details Feedback
The customer submitted reason for why they canceled, if the subscription was canceled explicitly by the user.
Field IDsubscription/cancellation_details_feedback
TypeTEXT
Data Typedimension
Subscription Cancellation Details Reason
Why this subscription was canceled.
Field IDsubscription/cancellation_details_reason
TypeTEXT
Data Typedimension
Subscription Collection Method
Either charge_automatically, or send_invoice. When charging automatically, Stripe will attempt to pay this subscription at the end of the cycle using the default source attached to the customer. When sending an invoice, Stripe will email your customer an invoice with payment instructions and mark the subscription as active.
Field IDsubscription/collection_method
TypeTEXT
Data Typedimension
Subscription Status
Possible values are incomplete, incomplete_expired, trialing, active, past_due, canceled, or unpaid.
Field IDsubscription/status
TypeTEXT
Data Typedimension
Subscription Days Until Due
Number of days a customer has to pay invoices generated by this subscription. This value will be null for subscriptions where collection_method=charge_automatically.
Field IDsubscription/days_until_due
TypeNUMBER
Data Typedimension
Balance Transaction ID
Unique identifier for the object.
Field IDbalance_transaction/id
TypeTEXT
Data Typedimension
Balance Transaction Amount
Gross amount of this transaction (in cents). A positive value represents funds charged to another party, and a negative value represents funds sent to another party.
Field IDbalance_transaction/amount
TypeNUMBER
Data Typedimension
Balance Transaction Currency
Three-letter ISO currency code, in lowercase. Must be a supported currency.
Field IDbalance_transaction/currency
TypeTEXT
Data Typedimension
Balance Transaction Fee
Fees paid for this transaction. Represented as a positive integer when assessed.
Field IDbalance_transaction/fee
TypeNUMBER
Data Typedimension
Balance Transaction Net
Net impact to a Stripe balance (in cents). A positive value represents incrementing a Stripe balance, and a negative value decrementing a Stripe balance. You can calculate the net impact of a transaction on a balance by amount - fee
Field IDbalance_transaction/net
TypeNUMBER
Data Typedimension
Balance Transaction Status
The transaction’s net funds status in the Stripe balance, which are either available or pending.
Field IDbalance_transaction/status
TypeTEXT
Data Typedimension
Balance Transaction Type
The transaction type.
Field IDbalance_transaction/type
TypeTEXT
Data Typedimension
Balance Transaction Created On
Time at which the object was created. Measured in seconds since the Unix epoch.
Field IDbalance_transaction/created
TypeYEAR_MONTH_DAY
Data Typedimension
Balance Transaction Available On
The date that the transaction’s net funds become available in the Stripe balance.
Field IDbalance_transaction/available_on
TypeYEAR_MONTH_DAY
Data Typedimension
Balance Transaction Exchange Rate
If applicable, this transaction uses an exchange rate. If money converts from currency A to currency B, then the amount in currency A, multipled by the exchange_rate, equals the amount in currency B. For example, if you charge a customer 10.00 EUR, the PaymentIntent’s amount is 1000 and currency is eur. If this converts to 12.34 USD in your Stripe account, the BalanceTransaction’s amount is 1234, its currency is usd, and the exchange_rate is 1.234.
Field IDbalance_transaction/exchange_rate
TypeNUMBER
Data Typedimension
Balance Transaction Reporting Category
Learn more about how reporting categories can help you understand balance transactions from an accounting perspective.
Field IDbalance_transaction/reporting_category
TypeTEXT
Data Typedimension
Extracted Date
The date where the extraction take times.
Field ID_catchr_date_extract
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Platform Name
Return the platform name
Field ID_catchr_platform_name
TypeTEXT
Data Typedimension