Introduction
Datasources and destinations
- Find all the data sources available at www.catchr.io/connectors
- Find all the destinations available at www.catchr.io/destinations
Account Id Id of an account. |
| ||||||
Account name Name of the account |
| ||||||
Year Year such as 2017. |
| ||||||
Year Quarter Year and quarter. |
| ||||||
Year month Year and month. |
| ||||||
Year week Year and week. |
| ||||||
Date Year, month, and day. |
| ||||||
Year month day hour Year, month, day, and hour. |
| ||||||
Quarter of the year Quarter of the year |
| ||||||
Month of the year Month of the year |
| ||||||
Week of the year Week of the year |
| ||||||
Month and day Month and day |
| ||||||
Day of the week Week of the year |
| ||||||
Day of the month Day of the year |
| ||||||
Hour of the day Hour of the day |
| ||||||
Customer ID Id of a customer. |
| ||||||
Customer currency Name of the customer |
| ||||||
Customer Created On Time at which the object was created. Measured in seconds since the Unix epoch. |
| ||||||
Customer email Email of the customer |
| ||||||
Customer Delinquent Tracks the most recent state change on any invoice belonging to the customer. |
| ||||||
Customer City City, district, suburb, town, or village. |
| ||||||
Customer Country Two-letter country code (ISO 3166-1 alpha-2). |
| ||||||
Customer Address Line 1 Address line 1 (e.g., street, PO Box, or company name). |
| ||||||
Customer Address Line 2 Address line 2 (e.g., apartment, suite, unit, or building). |
| ||||||
Customer Postal Code ZIP or postal code. |
| ||||||
Customer State State, county, province, or region. |
| ||||||
Customer Name The customer’s full name or business name. |
| ||||||
Customer Phone The customer’s phone number. |
| ||||||
Customer Shipping Name The customer’s shipping name. |
| ||||||
Customer Shipping Phone The customer’s shipping phone. |
| ||||||
Customer Shipping City The customer’s shipping city. |
| ||||||
Customer Shipping Country Two-letter country code (ISO 3166-1 alpha-2). |
| ||||||
Customer Shipping Address Line 1 Address line 1 (e.g., street, PO Box, or company name). |
| ||||||
Customer Shipping Address Line 2 Address line 2 (e.g., apartment, suite, unit, or building). |
| ||||||
Customer Shipping Postal Code ZIP or postal code. |
| ||||||
Customer Shipping State State, county, province, or region. |
| ||||||
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. |
| ||||||
Customer Discount Describes the current discount active on the customer, if there is one. |
| ||||||
Customer Invoice Prefix Describes the current discount active on the customer, if there is one. |
| ||||||
Customer Next Invoice Sequence The suffix of the customer’s next invoice number (for example, 0001). |
| ||||||
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”. |
| ||||||
Customer Automatic Tax Status Surfaces if automatic tax computation is possible given the current customer location information. |
| ||||||
Customer IP Tax Address A recent IP address of the customer used for tax reporting and tax location inference. |
| ||||||
Customer Tax Location Country The customer’s country as identified by Stripe Tax. |
| ||||||
Customer Tax Location Source The data source used to infer the customer’s location. |
| ||||||
Customer Tax Location State The customer’s state, county, province, or region as identified by Stripe Tax. |
| ||||||
Balance Type Should be available or pending |
| ||||||
Balance Amount Balance amount. |
| ||||||
Balance Currency Balance currency. Three-letter ISO currency code, in lowercase. Must be a supported currency. |
| ||||||
Balance Card Amount Amount for card. |
| ||||||
Balance Bank Account Amount Amount for bank account. |
| ||||||
Balance FPX Amount Amount for FPX. |
| ||||||
Charge ID Unique identifier for the object. |
| ||||||
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). |
| ||||||
Charge Billing Name The charge’s billing name. |
| ||||||
Charge Billing Phone The charge's billing phone. |
| ||||||
Charge Billing Email The charge's billing phone. |
| ||||||
Charge Billing City The charge's billing city. |
| ||||||
Charge Billing Country Two-letter country code (ISO 3166-1 alpha-2). |
| ||||||
Charge Billing Address Line 1 Address line 1 (e.g., street, PO Box, or company name). |
| ||||||
Charge Billing Address Line 2 Address line 2 (e.g., apartment, suite, unit, or building). |
| ||||||
Charge Billing Postal Code ZIP or postal code. |
| ||||||
Charge Billing State State, county, province, or region. |
| ||||||
Charge Currency The charge's currency |
| ||||||
Charge Is Disputed The charge's disputed state |
| ||||||
Charge Is Refunded The charge's refunded state |
| ||||||
Charge Receipt Email The charge's receipt email |
| ||||||
Charge Shipping Name The charge's shipping name. |
| ||||||
Charge Shipping Carrier The charge's shipping carrier. |
| ||||||
Charge Shipping Tracking Number The charge's shipping tracking number. |
| ||||||
Charge Shipping Phone The charge's shipping phone. |
| ||||||
Charge Shipping City The charge's shipping city. |
| ||||||
Charge Shipping Country Two-letter country code (ISO 3166-1 alpha-2). |
| ||||||
Charge Shipping Address Line 1 Address line 1 (e.g., street, PO Box, or company name). |
| ||||||
Charge Shipping Address Line 2 Address line 2 (e.g., apartment, suite, unit, or building). |
| ||||||
Charge Shipping Postal Code ZIP or postal code. |
| ||||||
Charge Shipping State State, county, province, or region. |
| ||||||
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. |
| ||||||
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. |
| ||||||
Charge Status The status of the payment is either succeeded, pending, or failed. |
| ||||||
Charge Amount Captured Amount in cents captured (can be less than the amount attribute on the charge if a partial capture was made). |
| ||||||
Charge Amount Refunded Amount in cents refunded (can be less than the amount attribute on the charge if a partial refund was issued). |
| ||||||
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. |
| ||||||
Charge Is captured If the charge was created without capturing, this Boolean represents whether it is still uncaptured or has since been captured. |
| ||||||
Charge Created On Time at which the object was created. Measured in seconds since the Unix epoch. |
| ||||||
Charge Failure Code Error code explaining reason for charge failure if available (see the errors section for a list of codes). |
| ||||||
Charge Failure Message Message to user further explaining reason for charge failure if available. |
| ||||||
Charge Is Paid true if the charge succeeded, or was successfully authorized for later capture. |
| ||||||
Charge Id of the payment method ID of the payment method used in this charge. |
| ||||||
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. |
| ||||||
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. |
| ||||||
Invoice ID The Invoice ID |
| ||||||
Invoice Auto Advance The Invoice auto advance state |
| ||||||
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. |
| ||||||
Invoice Currency Three-letter ISO currency code, in lowercase. Must be a supported currency. |
| ||||||
Invoice Hosted URL The invoice url |
| ||||||
Invoice Period End End of the usage period during which invoice items were added to this invoice. |
| ||||||
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. |
| ||||||
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. |
| ||||||
Invoice Period Start Start of the usage period during which invoice items were added to this invoice. |
| ||||||
Invoice Created At Date fo the creation of the invoice. |
| ||||||
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. |
| ||||||
Invoice Status The status of the invoice, one of draft, open, paid, uncollectible, or void. Learn more |
| ||||||
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. |
| ||||||
Invoice Total Total after discounts and taxes. |
| ||||||
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. |
| ||||||
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. |
| ||||||
Invoice Amount Paied The amount, in cents, that was paid. |
| ||||||
Invoice Amount Remaining The difference between amount_due and amount_paid, in cents. |
| ||||||
Invoice Amount Shipping This is the sum of all the shipping amounts. |
| ||||||
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. |
| ||||||
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. |
| ||||||
Invoice Billing Reason Indicates the reason why the invoice was created. |
| ||||||
Invoice PDF The link to download the PDF for the invoice. If the invoice has not been finalized yet, this will be null. |
| ||||||
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. |
| ||||||
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. |
| ||||||
Invoice Post Payment Credit Note Amount Total amount of all post-payment credit notes issued for this invoice. |
| ||||||
Invoice Pre Payment Credit Note Amount Total amount of all pre-payment credit notes issued for this invoice. |
| ||||||
Invoice Receipt Number This is the transaction number that appears on email receipts sent for this invoice. |
| ||||||
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. |
| ||||||
Invoice Statement Descriptor Extra information about an invoice for the customer’s credit card statement. |
| ||||||
Invoice Subscription Proration Date Only set for upcoming invoices that preview prorations. The time used to calculate prorations. |
| ||||||
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. |
| ||||||
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 |
| ||||||
Invoice Tax The amount of tax on this invoice. This is the sum of all the tax amounts on this invoice. |
| ||||||
Invoice Total Excluding Tax The integer amount in cents representing the total amount of the invoice including all discounts but excluding all tax. |
| ||||||
Invoice Item ID The Invoice Item Id |
| ||||||
Invoice Item Amount The Invoice Item Amount |
| ||||||
Invoice Item Currency The Invoice Item Currency |
| ||||||
Invoice Item Period Start The Invoice Item Period Start |
| ||||||
Invoice Item Period End The Invoice Item Period End |
| ||||||
Invoice Item Proration The Invoice Item Proration |
| ||||||
Invoice Item Created At The Invoice Item Created At |
| ||||||
Invoice Item IS Discountable The Invoice Item Is Discountable |
| ||||||
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. |
| ||||||
Invoice Item Unit Amount Unit amount (in the currency specified) of the invoice item. |
| ||||||
Invoice Item Subscription item The subscription item that this invoice item has been created for, if any. |
| ||||||
Subscription ID The Subscription Id |
| ||||||
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. |
| ||||||
Subscription Currency Three-letter ISO currency code, in lowercase. Must be a supported currency. |
| ||||||
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. |
| ||||||
Subscription Current Period Start Start of the current period that the subscription has been invoiced for. |
| ||||||
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. |
| ||||||
Subscription Cancel At A date in the future at which the subscription will automatically get canceled. |
| ||||||
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. |
| ||||||
Subscription Created At Time at which the object was created. Measured in seconds since the Unix epoch. |
| ||||||
Subscription Ended At If the subscription has ended, the date the subscription ended. |
| ||||||
Subscription Start Date Date when the subscription was first created. The date might differ from the created date due to backdating. |
| ||||||
Subscription Trial End If the subscription has a trial, the end of that trial. |
| ||||||
Subscription Trial Start If the subscription has a trial, the beginning of that trial. |
| ||||||
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. |
| ||||||
Subscription Pause Collection Behavior The payment collection behavior for this subscription while paused. One of keep_as_draft, mark_uncollectible, or void. |
| ||||||
Subscription Pause Collection Resume At The time after which the subscription will resume collecting payments. |
| ||||||
Subscription Cancellation Details Comment Additional comments about why the user canceled the subscription, if the subscription was canceled explicitly by the user. |
| ||||||
Subscription Cancellation Details Feedback The customer submitted reason for why they canceled, if the subscription was canceled explicitly by the user. |
| ||||||
Subscription Cancellation Details Reason Why this subscription was canceled. |
| ||||||
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. |
| ||||||
Subscription Status Possible values are incomplete, incomplete_expired, trialing, active, past_due, canceled, or unpaid. |
| ||||||
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. |
| ||||||
Balance Transaction ID Unique identifier for the object. |
| ||||||
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. |
| ||||||
Balance Transaction Currency Three-letter ISO currency code, in lowercase. Must be a supported currency. |
| ||||||
Balance Transaction Fee Fees paid for this transaction. Represented as a positive integer when assessed. |
| ||||||
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 |
| ||||||
Balance Transaction Status The transaction’s net funds status in the Stripe balance, which are either available or pending. |
| ||||||
Balance Transaction Type The transaction type. |
| ||||||
Balance Transaction Created On Time at which the object was created. Measured in seconds since the Unix epoch. |
| ||||||
Balance Transaction Available On The date that the transaction’s net funds become available in the Stripe balance. |
| ||||||
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. |
| ||||||
Balance Transaction Reporting Category Learn more about how reporting categories can help you understand balance transactions from an accounting perspective. |
| ||||||
Extracted Date The date where the extraction take times. |
| ||||||
Platform Name Return the platform name |
|
.svg){kind=logo}