Stripe Data Export

What is Stripe?

Stripe is an online payment processing for internet (e-commerce) businesses of all sizes. Stripe processes payments from credit cards, debit cards, mobile wallets (Google Pay, Apple Pay etc) and also accept payments from buy now, pay later services. Stripe is available to businesses in 35 plus countries in more than 130 currencies.

How to add Stripe Source in Electrik.AI?

Follow these steps to connect your Stripe to Electrik.AI

Step 1: Ensure you have following prerequisites to create a Stripe Connection in Electrik.AI

a. Stripe API Key.

b. Access to Stripe account.

Step 2: Sign-in into your Electrik.AI account .

Step 3: Select IO in Electrik.AI dashboard.

Select IO in Electrik.AI dashboard

Step 4: Select the Connections tab in the left most navigation bar & click on “Add” action button.

Select the Connections tab in the left most navigation bar & click on “Add” action button

Step 5: The Source default tab is selected just click on “Stripe” connection.

Step 6: Provide your Stripe account API key.

Step 7: Click on Save button on the top.

Congratulations, you have successfully created a Stripe Connection in Electrik.AI

What are the supported Data Destinations?

Electrik.AI supports the following destinations to export Stripe Data.

PostgreSQL Data Destination-Eletrik.AI
MySQL Data Destination-Electrik.AI
AzureSQL Data Destination-Eletrik.AI
Google Big Query Data Destination-Elecrik.AI
EletrikAI

How to export Stripe Data?

Electrik.AI creates a data flow (or ETL process) that exports Stripe data to a target database or data warehouse. This process runs daily at scheduled time and exports data for the previous day.

Follow these steps to create a Data Flow from Stripe to Database/Data Warehouse

Step 1:  Ensure you have the following prerequisites.
1. Access to Stripe Account.
2. Stripe Account User Id and Password.
3. Access to a Database/Warehouse/Electrik.AI of your choice (PostgreSQL, MySQL, Azure SQL, BigQuery.)
4. Database Connection Details such as Host, Port, DB Name, DB User, DB Password
Step 2: Sign-in into your Electrik.AI account.
Step 3: Select IO in Electrik.AI dashboard

Select IO in Electrik.AI dashboard

Step 4: Click on Add button to create a Stripe Flow

Click on Add button to create a Flow

Step 5: Select Stripe Connection present in the list of available sources.

Step 6: Select your existing Stripe connection in Electrik.AI.

To Configure a new connection, refer to this link.

Step 7: Click on available destinations, we are selecting BigQuery Warehouse.

Step 8: Select your existing BigQuery connection in Electrik.AI.
To Configure a new connection, refer to this link.

Step 9:
a. Electrik.AI supports 19 reports, you can choose all or any number of reports as per your requirement. In this example we are choosing Balance Transaction, Invoices and Payouts.

b. Review the Data Source, Data Destination, Database Schema, Provide Success Notification Email, Failure Notification Email. Click “Save and Proceed” to continue.
Success Notification Email: Enter a valid Email ID to receive the Flow Success Email Notification.
Failure Notification Email: Enter a valid Email ID to receive the Flow Failure Email Notification.
Note: By Default, Electrik.AI uses the signed-in user’s Email Id.

Flow Step 9b

Note: By Default, Electrik.AI chooses an existing Dataset to load your Stripe Report. You can create a new schema in your database by selecting the “Create New Dataset” radio button.

Congratulations, Flow is created. Please wait while you are redirected to Flow Details Screen.

You have now successfully setup Stripe to BigQuery Data Warehouse flow in Electrik.AI

Your Stripe will start loading after 24 hours in your Data Warehouse.

New-Your Stripe will start loading after 24 hours in your Data Warehouse

Stripe Data Schema

IndexCategoryElectrik.AI Column NameDescriptionSample Value
1MetricamountGross amount of the transaction.9900
2Dimensionavailable_onThe date the transaction’s net funds will become available in the Stripe balance.12/1/2021
3DimensioncreatedTime at which the object was created. Measured in seconds since the Unix epoch.11/29/2021
4DimensioncurrencyThree-letter ISO currency code, in lowercase. Must be a supported currency.usd
5Dimensiondatacontains an array of up to limit transactions, starting after transaction starting_after. Each entry in the array is a separate transaction history object. If no more transactions are available, the resulting array will be empty.{id=txn_3JtbvqKFb2PyqLAG0A59Qldw, object=balance_transaction, amount=9900, available_on= 1638316800, created=1638208132, currency=usd, description=Invoice CE2B17E8-0009, exchange_rate=null, fee=317, fee_details=[{amount=317, application=null,
currency=usd, description=Stripe processing fees, type=stripe_fee}], net=9583, reporting_category=charge, source= ch_3JtbvqKFb2PyqLAG0Sk1TFao, status=pending, type=charge}
6DimensiondescriptionAn arbitrary string attached to the object. Often useful for displaying to users.invoice ce2b17e8-0009
7Metricexchange_rateThe exchange rate used, if applicable, for this transaction. Specifically, if money was converted from one currency to other. For example, suppose you charged a customer 10.00 EUR. Then the PaymentIntent’s amount would be 1000 and currency
would be eur. Suppose this was converted into 12.34 USD in your Stripe account. Then the BalanceTransaction’s amount would be 1234, currency would be usd, and exchange_rate would be 1.234.
null
8MetricfeeFees paid for this transaction.317
9Dimensionfee_detailsDetailed breakdown of fees paid for this transaction.[{“amount”:317,”application”:null, “currency”:”usd”,”description”:”Stripe processing fees”,”type”:”stripe_fee”}]
10Metricfee_details_amountfee details amount317
11Dimensionfee_details_applicationfee details applicationnull
12Dimensionfee_details_currencyfee details currencyusd
13Dimensionfee_details_descriptionfee details descriptionstripe processing fees
14Dimensionfee_details_typefee details typestripe_fee
15DimensionidUnique identifier for the object.txn_3jtbvqkfb2pyqlag0a59qldw
16MetricnetNet amount of the transaction9583
17DimensionobjectStripe Object Typebalance_transaction
18Dimensionreporting_categoryLearn more about how reporting categories can help you understand balance transactions from an accounting perspective.charge
19DimensionsourceThe Stripe object to which this transaction is related.ch_3jtbvqkfb2pyqlag0sk1tfao
20DimensionstatusEither available or pending based on the transaction’s net funds available in the Stripe balance yet.pending
21DimensiontypeTransaction type: adjustment, advance, advance_funding, anticipation_repayment, application_fee, application_fee_refund, charge, connect_collection_transfer, contribution, issuing_authorization_hold, issuing_authorization_release, issuing_dispute,
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
charge
22Electrik.AIsha_idHashed Primary Key.4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
23Electrik.AIetl_orgOrganization IdORG000097
24Electrik.AIetl_projectProject IdPR000154
25Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC2021-06-13 12:45:42 UTC
26Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC2021-06-13 12:45:42 UTC
27Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC2021-06-13 12:45:42 UTC
28Electrik.AIetl_flow_nmEAI Flow CodeFL001282
29Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL00AD-20190910144445424196
IndexCategoryElectrik.AI Column NameDescriptionSample Value
1MetricamountAmount intended to be collected by this payment. A positive integer representing how much to charge in the smallest currency unit.9900
2Metricamount_capturedAmount in cents captured (can be less than the amount attribute on the charge if a partial capture was made).9900
3Metricamount_refundedAmount in cents refunded (can be less than the amount attribute on the charge if a partial refund was issued).0
4DimensionapplicationID of the Connect application that created the charge.
5Metricapplication_feeThe application fee (if any) for the charge.
6Metricapplication_fee_amountThe amount of the application fee (if any) requested for the charge.
7Dimensionbalance_transactionID of the balance transaction that describes the impact of this charge on your account balance (not including refunds or disputes).txn_3jtbvqkfb2pyqlag0a59qldw
8Dimensionbilling_detailsBilling information associated with the payment method at the time of the transaction.{“address”:{“city”:”New Brighton”,”country”: “US”,”line1″:”2155 Old Hwy 8 NW”,”line2″:null,”postal_code”:”55112″,”state”: “MN”},”email”:”developer@roofle.com”,”name”:”Brad Greenwald”,”phone”:null}
9Dimensionbilling_details_addressComplete Address{“city”:”New Brighton”,”country”:”US”,”line1″: “2155 Old Hwy 8 NW”,”line2″:null,”postal_code”:”55112″,”state”:”MN”}
10Dimensionbilling_details_ address_cityCity, district, suburb, town, or village.new brighton
11Dimensionbilling_details_ address_countryTwo-letter country codeus
12Dimensionbilling_details_ address_line1Address line 12155 old hwy 8 nw
13Dimensionbilling_details_ address_line2Address line 2
14Dimensionbilling_details_ address_postal_codeZIP or postal code.55112
15Dimensionbilling_details_ address_stateState, county, province, or region.mn
16Dimensionbilling_details_emailEmail address.developer@roofle.com
17Dimensionbilling_details_nameFull name.brad greenwald
18Dimensionbilling_details_phoneBilling phone number (including extension).
19Dimensioncalculated_statement_ descriptorThe 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.electrik.ai inc
20DimensioncapturedIf the charge was created without capturing, this Boolean represents whether it is still uncaptured or has since been captured.TRUE
21DimensioncreatedTime at which the object was created. Measured in seconds since the Unix epoch.11/29/2021
22DimensioncurrencyThree-letter ISO currency code, in lowercase. Must be a supported currency.usd
23DimensioncustomerID of the customer this charge is for if one exists.cus_iis3948rdp6qqj
24Dimensiondatacontains an array of up to limit transactions, starting after transaction starting_after. Each entry in the array is a separate transaction history object. If no more transactions are available, the resulting array will be empty.{id=ch_3JtbvqKFb2PyqLAG0Sk1TFao, object=charge, amount=9900, amount_captured=9900, amount_refunded=0, application=null, application_fee=null, application_fee_amount=null, balance_transaction=txn_3JtbvqKFb2PyqLAG0A59Qldw, billing_details={address={city=New
Brighton, country=US, line1=2155 Old Hwy 8 NW, line2=null, postal_code=55112, state=MN}, email=developer@roofle.com, name=Brad Greenwald, phone=null}, calculated_statement_descriptor=ELECTRIK.AI INC, captured=true, created=1638208132,
currency=usd, customer=cus_IiS3948rDP6qQJ, description=Invoice CE2B17E8-0009, destination=null, dispute=null, disputed=false, failure_code=null, failure_message=null, fraud_details={}, invoice=in_1Jtbv9KFb2PyqLAGKiVqAjvT, livemode=true,
metadata={}, on_behalf_of=null, order=null, outcome={network_status=approved_by_network, reason=null, risk_level=normal, seller_message=Payment complete., type=authorized}, paid=true, payment_intent=pi_3JtbvqKFb2PyqLAG0TiI7dVG, payment_method=pm_1JcbevKFb2PyqLAGsZjS0Y9p,
payment_method_details={card={brand=visa, checks={address_line1_check=pass, address_postal_code_check=pass, cvc_check=null}, country=US, exp_month=6, exp_year=2023, fingerprint=3EHTuLY2f0fy6Zke, funding=credit, installments=null, last4=0579,
network=visa, three_d_secure=null, wallet=null}, type=card}, receipt_email=developer@roofle.com, receipt_number=2947-9659, receipt_url=https://pay.stripe.com/receipts/ acct_1FEyUIKFb2PyqLAG/ch_3JtbvqKFb2PyqLAG0Sk1TFao/ rcpt_KgbA415KT0hCIzxUHa7j55xoZt9JQJx,
refunded=false, refunds={object=list, data=[], has_more=false, total_count=0, url=/v1/charges/ch_3JtbvqKFb2PyqLAG0Sk1TFao/ refunds}, review=null, shipping=null, source=null, source_transfer=null, statement_descriptor=null, statement_descriptor_suffix=null,
status=succeeded, transfer_data=null, transfer_group=null}
25DimensiondescriptionAn arbitrary string attached to the object. Often useful for displaying to users.invoice ce2b17e8-0009
26DimensiondestinationID of the bank account or card the payout was sent to.
27DimensiondisputeWhether the charge has been disputed.
28Dimensiondisputeddisputed statusFALSE
29Dimensionfailure_codeError code explaining reason for charge failure if availableData Migration Testing
30Dimensionfailure_messageMessage to user further explaining reason for charge failure if available.
31Dimensionfraud_detailsInformation on fraud assessments for the charge.{}
32DimensionidUnique identifier for the object.ch_3jtbvqkfb2pyqlag0sk1tfao
33DimensioninvoiceID of the invoice this charge is for if one exists.in_1jtbv9kfb2pyqlagkivqajvt
34DimensionlivemodeHas the value true if the object exists in live mode or the value false if the object exists in test mode.TRUE
35DimensionmetadataSet 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.{}
36DimensionobjectString representing the object’s type. Objects of the same type share the same value.charge
37Dimensionon_behalf_ofThe account (if any) the charge was made on behalf of without triggering an automatic transfer.
38DimensionorderID of the order this charge is for if one exists.USD
39DimensionoutcomeDetails about whether the payment was accepted, and why.{“network_status”:”approved_by_network”, “reason”:null,”risk_level”:”normal”, “seller_message”:”Payment complete.”, “type”:”authorized”}
40Dimensionoutcome_network_statusPossible 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.
approved_by_network
41Dimensionoutcome_reasonAn enumerated value providing a more detailed explanation of the outcome’s type.
42Dimensionoutcome_risk_levelStripe Radar’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. This field is only available with Radar.
normal
43Dimensionoutcome_risk_scoreStripe Radar’s evaluation of the riskiness of the payment. Possible values for evaluated payments are between 0 and 100. For non-card payments, card-based payments predating the public assignment of risk scores, or in the event of an error
during evaluation, this field will not be present. This field is only available with Radar for Fraud Teams.
44Dimensionoutcome_seller_messageA human-readable description of the outcome type and reason, designed for you (the recipient of the payment), not your customer.payment complete.
45Dimensionoutcome_typePossible values are authorized, manual_review, issuer_declined, blocked, and invalid.authorized
46Dimensionpaidtrue if the charge succeeded, or was successfully authorized for later capture.TRUE
47Dimensionpayment_intentID of the PaymentIntent associated with this charge, if one exists.pi_3jtbvqkfb2pyqlag0tii7dvg
48Dimensionpayment_methodID of the payment method used in this charge.pm_1jcbevkfb2pyqlagszjs0y9p
49Dimensionpayment_method_detailsDetails about the payment method at the time of the transaction.{“card”:{“brand”:”visa”,”checks”:{“address_line1_check”: “pass”,”address_postal_code_check”: “pass”,”cvc_check”:null},”country”: “US”,”exp_month”:6,”exp_year”:2023, “fingerprint”:”3EHTuLY2f0fy6Zke”,”funding”: “credit”,”installments”:null,”last4″:”0579″,”network”:
“visa”,”three_d_secure”:null,”wallet”:null},”type”:”card”}
50Dimensionpayment_method_ details_cardIf this is a card payment,the card details{“brand”:”visa”,”checks”:{“address_line1_check”:”pass”, “address_postal_code_check”: “pass”,”cvc_check”:null},”country”: “US”,”exp_month”:6,”exp_year”:2023, “fingerprint”:”3EHTuLY2f0fy6Zke”,”funding”: “credit”,”installments”:null,”last4″:”0579″,”network”:
“visa”,”three_d_secure”:null,”wallet”:null}
51Dimensionpayment_method_ details_card_brandCard brand. Can be amex, diners, discover, jcb, mastercard, unionpay, visa, or unknown.visa
52Dimensionpayment_method_ details_card_checksCheck results by Card networks on Card address and CVC at time of payment.{“address_line1_check”:”pass”, “address_postal_code_check”: “pass”,”cvc_check”:null}
53Dimensionpayment_method_ details_card_countryTwo-letter ISO code representing the country of the card.us
54Dimensionpayment_method_ details_card_exp_monthTwo-digit number representing the card’s expiration month.6
55Dimensionpayment_method_ details_card_exp_yearFour-digit number representing the card’s expiration year.2023
56Dimensionpayment_method_ details_card_fingerprintUniquely 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. For payment methods that tokenize card information (Apple Pay,
Google Pay), the tokenized number might be provided instead of the underlying card number.
3ehtuly2f0fy6zke
57Dimensionpayment_method_ details_card_fundingCard funding type. Can be credit, debit, prepaid, or unknown.credit
58Dimensionpayment_method_ details_card_installments“Installment details for this payment (Mexico only). For more information, see the installments integration guide.”
59Dimensionpayment_method_ details_card_last4The last four digits of the card.579
60Dimensionpayment_method_ details_card_networkIdentifies which network this charge was processed on. Can be amex, cartes_bancaires, diners, discover, interac, jcb, mastercard, unionpay, visa, or unknown.visa
61Dimensionpayment_method_details_ card_three_d_securePopulated if this transaction used 3D Secure authentication.1/0/1900 0:00
62Dimensionpayment_method_ details_card_walletIf this Card is part of a card wallet, this contains the details of the card wallet.
63Dimensionpayment_method_ details_typehe type of transaction-specific details of the payment method used in the payment, one of ach_credit_transfer, ach_debit, acss_debit, alipay, au_becs_debit, bancontact, card, card_present, eps, giropay, ideal, klarna, multibanco, p24, sepa_debit,
sofort, stripe_account, or wechat.
card
64Dimensionreceipt_emailThis is the email address that the receipt for this charge was sent to.developer@roofle.com
65Dimensionreceipt_numberThis is the transaction number that appears on email receipts sent for this charge. This attribute will be null until a receipt has been sent.2947-9659
66Dimensionreceipt_urlThis 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.https://pay.stripe.com/receipts/ acct_1feyuikfb2pyqlag/ch_ 3jtbvqkfb2pyqlag0sk1tfao/ rcpt_kgba415kt0hcizxuha7j55xozt9jqjx
67DimensionrefundedWhether the charge has been fully refunded. If the charge is only partially refunded, this attribute will still be false.FALSE
68DimensionrefundsA list of refunds that have been applied to the charge.{“object”:”list”,”data”:[],”has_more”:false, “total_count”:0,”url”:”/v1/charges/ ch_3JtbvqKFb2PyqLAG0Sk1TFao/refunds”}
69DimensionreviewID of the review associated with this charge if one exists.Bing and Yahoo! search – Top
70DimensionshippingShipping information for the charge.
71Dimensionsource
72Dimensionsource_transferThe transfer ID which created this charge. Only present if the charge came from another Stripe account.
73Dimensionstatement_descriptorcomplete description of a charge on your customers’ statements.PR000253
74Dimensionstatement_descriptor_ suffixProvides information about the charge that customers see on their statements. Concatenated with the prefix (shortened descriptor)
75DimensionstatusThe status of the payment is either succeeded, pending, or failed.succeeded
76Dimensiontransfer_dataAn optional dictionary including the account to automatically transfer to as part of a destination charge6/24/2020 16:02
77Dimensiontransfer_groupA string that identifies this transaction as part of a group.FL001309
78Electrik.AIsha_idHashed Primary Key4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
79Electrik.AIetl_orgOrganization IdORG000097
80Electrik.AIetl_projectProject IdPR000154
81Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC2021-06-13 12:45:42 UTC
82Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC2021-06-13 12:45:42 UTC
83Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC2021-06-13 12:45:42 UTC
84Electrik.AIetl_flow_nmEAI Flow CodeFL001282
85Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL00AD-20190910144445424196
IndexCategoryElectrik.AI Column NameDescriptionSample Value
1Metricaccount_balanceCurrent balance, if any, being 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 will be added to their 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.
0
2DimensionaddressThe customer’s address.
3MetricbalanceThe customer’s balance.0
4Dimensionbillingidbilling id6189712531f7706105baf97c
5DimensioncreatedTime at which the object was created. Measured in seconds since the Unix epoch.11/10/2021
6DimensioncurrencyThree-letter ISO currency code, in lowercase. Must be a supported currency.
7Dimensiondatacontains an array of up to limit transactions, starting after transaction starting_after. Each entry in the array is a separate transaction history object. If no more transactions are available, the resulting array will be empty.{id=cus_KZWQVQGAKPavHY, object=customer, account_balance=0, address=null, balance=0, created=1636576011, currency=null, default_source=null, delinquent=false, description= Customer for Organization ‘FinLocker LLC’, discount=null, email=bryan.garcia@finlocker.com,
invoice_prefix=462A0B86, invoice_settings ={custom_fields=null, default_payment_method =pm_1JuNP7KFb2PyqLAGve2lNaan, footer=null}, livemode=true, metadata= {organizationId=6189712331f7706105baf97b, billingId=6189712531f7706105baf97c},
name=FinLocker LLC, next_invoice_sequence=1, phone=3146160874, preferred_locales=[], shipping={address={city=WATERLOO, country=US, line1=2929 ESTATE DR, line2=, postal_code=62298, state=IL}, name= Bryan Garcia, phone=3146160874}, sources=
{object=list, data=[], has_more=false, total_count=0, url=/v1/customers/cus_KZWQVQGAKPavHY/sources}, subscriptions={object=list, data=[], has_more=false, total_count=0, url=/v1/customers/cus_KZWQVQGAKPavHY/ subscriptions}, tax_exempt=none,
tax_ids= {object=list, data=[], has_more=false, total_count=0, url=/v1/customers/cus_KZWQVQGAKPavHY/tax_ids}, tax_info=null, tax_info_verification=null}
8Dimensiondefault_sourceID of the default payment source for the customer.
9Dimensiondelinquent“When the customer’s latest invoice is billed by charging automatically, delinquent is true if the invoice’s latest charge failed. When the customer’s latest invoice is billed by sending an invoice, delinquent is true if the invoice isn’t
paid by its due date. If an invoice is marked uncollectible by dunning, delinquent doesn’t get reset to false.”
FALSE
10DimensiondescriptionAn arbitrary string attached to the object. Often useful for displaying to users.customer for organization ‘finlocker llc’
11MetricdiscountDescribes the current discount active on the customer, if there is one.
12DimensionemailThe customer’s email address.bryan.garcia@finlocker.com
13DimensionidUnique identifier for the object.cus_kzwqvqgakpavhy
14Dimensioninvoice_prefixThe prefix for the customer used to generate unique invoice numbers.462a0b86
15Dimensioninvoice_settingsThe customer’s default invoice settings.{“custom_fields”:null, “default_payment_method”: “pm_1JuNP7KFb2PyqLAGve2lNaan”, “footer”:null}
16Dimensioninvoice_settings_ custom_fieldsDefault custom fields to be displayed on invoices for this customer.
17Dimensioninvoice_settings_ default_payment_methodID of a payment method that’s attached to the customer, to be used as the customer’s default payment method for subscriptions and invoices.pm_1junp7kfb2pyqlagve2lnaan
18Dimensioninvoice_settings_footerDefault footer to be displayed on invoices for this customer.
19DimensionlivemodeHas the value true if the object exists in live mode or the value false if the object exists in test mode.TRUE
20DimensionnameThe customer’s full name or business name.finlocker llc
21Dimensionnext_invoice_sequenceThe suffix of the customer’s next invoice number, e.g., 0001.1
22DimensionobjectString representing the object’s type. Objects of the same type share the same value.customer
23Dimensionorganizationidorganization id6189712331f7706105baf97b
24DimensionphoneThe customer’s phone number.3146160874
25Dimensionpreferred_localespreferred locales[]
26DimensionshippingMailing and shipping address for the customer. Appears on invoices emailed to this customer.{“address”:{“city”:”WATERLOO”, “country”:”US”,”line1″:”2929 ESTATE DR”,”line2″: “”,”postal_code”: “62298”,”state”:”IL”},”name”: “Bryan Garcia”,”phone”:”3146160874″}
27Dimensionshipping_addressCustomer shipping address.{“city”:”WATERLOO”,”country”: “US”,”line1″:”2929 ESTATE DR”,”line2″: “”,”postal_code”:”62298″,”state”:”IL”}
28Dimensionshipping_nameCustomer name.bryan garcia
29Dimensionshipping_phoneCustomer phone (including extension).3146160874
30DimensionsourcesThe customer’s payment sources, if any.{“object”:”list”,”data”:[],”has_more”:false,”total_count” :0,”url”:”/v1/customers/cus_KZWQVQGAKPavHY/ sources”}
31DimensionsubscriptionsThe customer’s current subscriptions, if any.{“object”:”list”,”data”:[],”has_more”:false,”total_count”:0,”url”: “/v1/customers/cus_KZWQVQGAKPavHY/ subscriptions”}
32Dimensiontax_exemptDescribes the customer’s tax exemption status. One of none, exempt, or reverse. When set to reverse, invoice and receiptnone
33Dimensiontax_idsThe customer’s tax IDs.{“object”:”list”,”data”:[],”has_more”:false,”total_count” :0,”url”:”/v1/customers/cus_ KZWQVQGAKPavHY/tax_ids”}
34Dimensiontax_infoTax details about the customer.
35Dimensiontax_info_verificationtax info verification
36Electrik.AIsha_idHashed Primary Key4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
37Electrik.AIetl_orgOrganization IdORG000097
38Electrik.AIetl_projectProject IdPR000154
39Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC2021-06-13 12:45:42 UTC
40Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC2021-06-13 12:45:42 UTC
41Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC2021-06-13 12:45:42 UTC
42Electrik.AIetl_flow_nmEAI Flow CodeFL001282
43Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL00AD-20190910144445424196
IndexCategoryElectrik.AI Column NameDescriptionSample Value
1Metricapi_versionThe Stripe API version used to render data.8/14/2019
2DimensioncreatedTime at which the object was created. Measured in seconds since the Unix epoch.11/19/2021
3Metricdatacontains an array of up to limit transactions, starting after transaction starting_after. Each entry in the array is a separate transaction history object. If no more transactions are available, the resulting array will be empty.{“object”:{“id”:”in_1Jtbv9KFb2PyqLAGKiVqAjvT”, “object”:”invoice”,”account_country”:”US”, “account_name”:”Electrik.AI Inc”,”account_tax_ids”: null,”amount_due”:9900,”amount_paid”:0, “amount_remaining”:9900,”application_fee_amount”: null,”attempt_count”:3,”attempted”:true,”auto_advance”:
true,”automatic_tax”:{“enabled”:false,”status”:null}, “billing”:”charge_automatically”,”billing_reason”: “manual”,”charge”:”ch_3JtbvqKFb2PyqLAG0WIafDGl”, “collection_method”:”charge_automatically”, “created”:1636393575,”currency”:”usd”,”custom_fields”:null,
“customer”:”cus_IiS3948rDP6qQJ”,”customer_address” :{“city”:null,”country”:””,”line1″:””,”line2″:””, “postal_code”:null,”state”:””},”customer_email”: “developer@roofle.com”,”customer_name”: “Roofle Developer”,”customer_phone”:”6122558200″,
“customer_shipping”:{“address”:{“city”:”New Brighton”, “country”:”US”,”line1″:”2155 Old Hwy 8 NW”,”line2″:””, “postal_code”:”55112″,”state”:”MN”},”name”: “Roofle Developer”,”phone”:”6122558200″}, “customer_tax_exempt”:”none”,”customer_tax_ids”:[],
“default_payment_method”:null,”default_source”:null, “default_tax_rates”:[],”description”: “Billing Period: 10/01/2021 – 10/31/2021″,”discount”:null,”discounts”:[],”due_date”:1636998418,”ending_balance”:0, “footer”:null,”hosted_invoice_url”:
“https://invoice.stripe.com/i/acct_1FEyUIKFb2PyqLAG/live_ YWNjdF8xRkV5VUlLRmIyUHlxTEFHLF9LWWp ONXlRZXpZdUpNcHlJRWxYcTJTajVtNTI5QUp20100UWf6KDL4”, “invoice_pdf”:”https://pay.stripe.com/invoice/ acct_1FEyUIKFb2PyqLAG/live_YWNjdF8xRkV5VUlLRmIy
UHlxTEFHLF9LWWpONXlRZXpZdUpNcHlJRWxYc TJTajVtNTI5QUp20100UWf6KDL4/pdf”, “last_finalization_error”:null,”lines”: {“object”:”list”,”data”:[{“id”:”ii_1Jtbv9KFb2PyqLAG0BSPdBko”, “object”:”line_item”,”amount”:9900,”currency”: “usd”,”description”:”Google
Analytics to Google BigQuery (Service Account) – October 2021″,”discount_amounts”:[], “discountable”:true,”discounts”:[],”invoice_item”: “ii_1Jtbv9KFb2PyqLAG0BSPdBko”,”livemode” :true,”metadata”:{},”period”:{“end”:1636393575,”start”:1636393575},
“plan”:null,”price”:{“id”:”price_1Jtbv9KFb2PyqLAGzBmk97zO”, “object”:”price”,”active”:false,”billing_scheme”: “per_unit”,”created”:1636393575,”currency”: “usd”,”livemode”:true,”lookup_key”:null,”metadata”:{}, “nickname”:null,”product”:”prod_KYjNqBt76RJMXQ”,
“recurring”:null,”tax_behavior”:”unspecified”,”tiers_mode” :null,”transform_quantity”:null,”type”:”one_time”,”unit_amount”:9900 ,”unit_amount_decimal”:”9900″},”proration”:false,”quantity”: 1,”subscription”:null,”tax_amounts”:[],”tax_rates”:[],”type”:
“invoiceitem”,”unique_id”:”il_1Jtbv9KFb2PyqLAGGIqfoYpS”}], “has_more”:false,”total_count”:1,”url”:”/v1/invoices/ in_1Jtbv9KFb2PyqLAGKiVqAjvT/lines”},”livemode”: true,”metadata”:{},”next_payment_attempt”:1637754442, “number”:”CE2B17E8-0009″,”on_behalf_of”:null,”paid”:
false,”payment_intent”:”pi_3JtbvqKFb2PyqLAG0TiI7dVG”, “payment_settings”:{“payment_method_options”:null,”payment_method_types” :null},”period_end”:1636393575,”period_start”:1636393575, “post_payment_credit_notes_amount”:0, “pre_payment_credit_notes_amount”:0,”quote”:
null,”receipt_number”:null,”starting_balance”:0, “statement_descriptor”:null,”status”:”open”,”status_transitions”: {“finalized_at”:1636393617,”marked_uncollectible_at”: null,”paid_at”:null,”voided_at”:null},”subscription”:null, “subtotal”:9900,”tax”:null,”tax_percent”:null,”total”:9900,
“total_discount_amounts”:[],”total_tax_amounts”:[],”transfer_data”:null,”webhooks_delivered_at”: 1636393575},”previous_attributes”:{“next_payment_attempt”:1637300826}}
4Dimensionevent_idUnique identifier for the object.evt_1jxpxikfb2pyqlagtfk9aqol
5DimensionlivemodeHas the value true if the object exists in live mode or the value false if the object exists in test mode.TRUE
6DimensionobjectString representing the object’s type. Objects of the same type share the same value.event
7Dimensionpending_webhooksNumber of webhooks that have yet to be successfully delivered0
8DimensionrequestInformation on the API request that instigated the event.{“id”:null,”idempotency_key”:null}
9DimensiontypeDescription of the event (e.g., invoice.created or charge.refunded).invoice.updated
10Electrik.AIsha_idHashed Primary Key4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
11Electrik.AIetl_orgOrganization IdORG000097
12Electrik.AIetl_projectProject IdPR000154
13Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC2021-06-13 12:45:42 UTC
14Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC2021-06-13 12:45:42 UTC
15Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC2021-06-13 12:45:42 UTC
16Electrik.AIetl_flow_nmEAI Flow CodeFL001282
17Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL00AD-20190910144445424196
IndexCategoryElectrik.AI Column NameDescriptionSample Value
1MetricamountAmount (in the currency specified) of the invoice item. This should always be equal to unit_amount * quantity.19800
2DimensioncurrencyThree-letter ISO currency code, in lowercase. Must be a supported currency.usd
3MetriccustomerThe ID of the customer who will be billed when this invoice item is billed.cus_gigwzgjampvazx
4Dimensiondatacontains an array of up to limit transactions, starting after transaction starting_after. Each entry in the array is a separate transaction history object. If no more transactions are available, the resulting array will be empty.{id=ii_1JzUlqKFb2PyqLAGkTzlLC18, object=invoiceitem, amount=19800, currency=usd, customer=cus_GIGWZGJAmPVaZX, date=1637796058, description=GAHIT2BQ, discountable=true, discounts=[], invoice=in_1JzUlQKFb2PyqLAG7qaLb4BH, livemode=true, metadata={},
period={end=1637796058, start=1637796058}, plan=null, price={id=price_1JzUl0KFb2PyqLAGxixSnbP2, object=price, active=true, billing_scheme=per_unit, created=1637796006, currency=usd, livemode=true, lookup_key=null, metadata={}, nickname=null,
product=prod_KeoNlm0Djwpvn1, recurring=null, tax_behavior=unspecified, tiers_mode=null, transform_quantity=null, type=one_time, unit_amount=9900, unit_amount_decimal=9900}, proration=false, quantity=2, subscription=null, tax_rates=[],
unit_amount=9900, unit_amount_decimal=9900}
5DimensiondateTime at which the object was created.11/24/2021
6DimensiondescriptionAn arbitrary string attached to the object. Often useful for displaying to users.gahit2bq
7DimensiondiscountableIf true, discounts will apply to this invoice item. Always false for prorations.TRUE
8DimensiondiscountsThe discounts which apply to the invoice item. Item discounts are applied before invoice discounts. Use expand[]=discounts to expand each discount.[]
9DimensionidUnique identifier for the object.ii_1jzulqkfb2pyqlagktzllc18
10DimensioninvoiceThe ID of the invoice this invoice item belongs to.in_1jzulqkfb2pyqlag7qalb4bh
11DimensionlivemodeHas the value true if the object exists in live mode or the value false if the object exists in test mode.TRUE
12DimensionmetadataSet 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.{}
13DimensionobjectString representing the object’s type. Objects of the same type share the same value.invoiceitem
14Dimensionperiod_endEnd of the line item’s billing period11/24/2021
15Dimensionperiod_startStart of the line item’s billing period11/24/2021
16Dimensionplan
17Dimensionprice_activeWhether the price can be used for new purchases.TRUE
18Dimensionprice_billing_schemeDescribes how to compute the price per period. Either per_unit or tiered. per_unit indicates that the fixed amount (specified in unit_amount or unit_amount_decimal) will be charged per unit in quantity (for prices with usage_type=licensed),
or per unit of total usage (for prices with usage_type=metered). tiered indicates that the unit pricing will be computed using a tiering strategy as defined using the tiers and tiers_mode attributes.
per_unit
19Dimensionprice_createdTime at which the object was created. Measured in seconds since the Unix epoch.11/24/2021
20Dimensionprice_currencyThree-letter ISO currency code, in lowercase. Must be a supported currency.usd
21Dimensionprice_idUnique identifier for the object.price_1jzul0kfb2pyqlagxixsnbp2
22Dimensionprice_livemodeHas the value true if the object exists in live mode or the value false if the object exists in test mode.TRUE
23Dimensionprice_lookup_keyA lookup key used to retrieve prices dynamically from a static string. This may be up to 200 characters.
24Dimensionprice_metadataSet 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.{}
25Dimensionprice_nicknameA brief description of the price, hidden from customers.
26Dimensionprice_objectString representing the object’s type. Objects of the same type share the same value.price
27Dimensionprice_productThe ID of the product this price is associated with.prod_keonlm0djwpvn1
28Dimensionprice_recurringThe recurring components of a price such as interval and usage_type.
29Dimensionprice_tax_behaviorSpecifies whether the price is considered inclusive of taxes or exclusive of taxes. One of inclusive, exclusive, or unspecified. Once specified as either inclusive or exclusive, it cannot be changed.unspecified
30Dimensionprice_tiers_modeDefines if the tiering price should be graduated or volume based. In volume-based tiering, the maximum quantity within a period determines the per unit price. In graduated tiering, pricing can change as the quantity grows.
31Dimensionprice_transform_quantityApply a transformation to the reported usage or set quantity before computing the amount billed. Cannot be combined with tiers.
32Dimensionprice_typeOne of one_time or recurring depending on whether the price is for a one-time purchase or a recurring (subscription) purchase.one_time
33Metricprice_unit_amountThe unit amount in paise to be charged, represented as a whole integer if possible. Only set if billing_scheme=per_unit.9900
34Metricprice_unit_amount_decimalThe unit amount in paise to be charged, represented as a decimal string with at most 12 decimal places. Only set if billing_scheme=per_unit.9900
35DimensionprorationWhether the invoice item was created automatically as a proration adjustment when the customer switched plans.FALSE
36MetricquantityQuantity of units for the invoice item. If the invoice item is a proration, the quantity of the subscription that the proration was computed for.2
37DimensionsubscriptionThe subscription that this invoice item has been created for, if any.
38Dimensiontax_ratesThe tax rates which apply to the invoice item. When set, the default_tax_rates on the invoice do not apply to this invoice item.[]
39Metricunit_amountUnit amount (in the currency specified) of the invoice item.9900
40Metricunit_amount_decimalSame as unit_amount, but contains a decimal value with at most 12 decimal places.9900
41Electrik.AIsha_idHashed Primary Key4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
42Electrik.AIetl_orgOrganization IdORG000097
43Electrik.AIetl_projectProject IdPR000154
44Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC2021-06-13 12:45:42 UTC
45Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC2021-06-13 12:45:42 UTC
46Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC2021-06-13 12:45:42 UTC
47Electrik.AIetl_flow_nmEAI Flow CodeFL001282
48Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL00AD-20190910144445424196
IndexCategoryElectrik.AI Column NameDescriptionSample Value
1Dimensionaccount_countryThe country of the business associated with this invoice, most often the business creating the invoice.us
2Dimensionaccount_nameThe public name of the business associated with this invoice, most often the business creating the invoice.electrik.ai inc
3Dimensionaccount_tax_idsThe account tax IDs associated with the invoice. Only editable when the invoice is a draft.
4Metricamount_dueFinal 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.
0
5Metricamount_paidThe amount, in pence, that was paid.0
6Metricamount_remainingThe amount remaining, in pence, that is due.0
7Metricapplication_fee_amountThe fee in pence that will be applied to the invoice and transferred to the application owner’s Stripe account when the invoice is paid.
8Metricattempt_countNumber 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.
0
9DimensionattemptedWhether 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.FALSE
10Dimensionauto_advanceControls whether Stripe will perform automatic collection of the invoice. When false, the invoice’s state will not automatically advance without an explicit action.FALSE
11Dimensionautomatic_taxSettings and latest results for automatic tax lookup for this invoice.{“enabled”:false,”status”:null}
12Dimensionautomatic_tax_

enabled

Whether Stripe automatically computes tax on this invoice.FALSE
13Dimensionautomatic_tax_statusThe status of the most recent automated tax calculation for this invoice.
14Dimensionbillingbillingsend_invoice
15Dimensionbilling_reasonIndicates the reason why the invoice was created. subscription_cycle indicates an invoice created by a subscription advancing into a new period. subscription_create indicates an invoice created due to creating a subscription. subscription_update
indicates an invoice created due to updating a subscription. subscription is set for all old invoices to indicate either a change to a subscription or a period advancement. manual is set for all invoices unrelated to a subscription
manual
16DimensionchargeID of the latest charge generated for this invoice, if any.
17Dimensioncollection_methodEither 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.
send_invoice
18DimensioncreatedTime at which the object was created. Measured in seconds since the Unix epoch.11/24/2021
19DimensioncurrencyThree-letter ISO currency code, in lowercase. Must be a supported currency.usd
20Dimensioncustom_fieldsCustom fields displayed on the invoice.
21DimensioncustomerThe ID of the customer who will be billed.cus_k4erj1tetvoalx
22Dimensioncustomer_addressThe customer’s address. Until the invoice is finalized, this field will equal customer.address. Once the invoice is finalized, this field will no longer be updated.
23Dimensioncustomer_emailThe customer’s email. Until the invoice is finalized, this field will equal customer.email. Once the invoice is finalized, this field will no longer be updated.pranaliamde@gmail.com
24Dimensioncustomer_nameThe customer’s name. Until the invoice is finalized, this field will equal customer.name. Once the invoice is finalized, this field will no longer be updated.p test
25Dimensioncustomer_phoneThe customer’s phone number. Until the invoice is finalized, this field will equal customer.phone. Once the invoice is finalized, this field will no longer be updated.5454545656
26Dimensioncustomer_shippingThe customer’s shipping information. Until the invoice is finalized, this field will equal customer.shipping. Once the invoice is finalized, this field will no longer be updated.{“address”:{“city”:””,”country”:”US”,”line1″:””,”line2″:””, “postal_code”:””,”state”:””},”name”:”Pranali”, “phone”:”5454545656″}
27Dimensioncustomer_shipping

_ address

Customer shipping address.{“city”:””,”country”:”US”,”line1″:””,”line2″:””, “postal_code”:””,”state”:””}
28Dimensioncustomer_shipping

_ address_city

City, district, suburb, town, or village.
29Dimensioncustomer_shipping_ address_countryTwo-letter country codeus
30Dimensioncustomer_shipping

_ address_line1

Address line 1
31Dimensioncustomer_shipping

_ address_line2

Address line 2
32Dimensioncustomer_shipping_ address_postal_codeZIP or postal code.
33Dimensioncustomer_shipping_

address_state

State, county, province, or region.
34Dimensioncustomer_shipping_

name

Customer name.pranali
35Dimensioncustomer_shipping_

phone

Billing phone number (including extension).5454545656
36Dimensioncustomer_tax_exemptThe customer’s tax exempt status. Until the invoice is finalized, this field will equal customer.tax_exempt. Once the invoice is finalized, this field will no longer be updated.none
37Dimensioncustomer_tax_idsThe customer’s tax IDs. Until the invoice is finalized, this field will contain the same tax IDs as customer.tax_ids. Once the invoice is finalized, this field will no longer be updated.[]
38Dimensiondatacontains an array of up to limit transactions, starting after transaction starting_after. Each entry in the array is a separate transaction history object. If no more transactions are available, the resulting array will be empty.{id=in_1JzUqIKFb2PyqLAGGMMnbdkw, object=invoice, account_country=US, account_name= Electrik.AI Inc, account_tax_ids=null, amount_due=0, amount_paid=0, amount_remaining=0, application_fee_ amount=null, attempt_count=0, attempted=false, auto_
advance=false, automatic_tax={enabled=false, status=null}, billing=send_invoice, billing_reason=manual, charge=null, collection_method=send_invoice, created=1637796334, currency=usd, custom_fields=null, customer=cus_GIGWZGJAmPVaZX, customer_address=null,
customer_email=sumit.m@toranainc.com, customer_name=TORANA, customer_phone=2036139296, customer_shipping={address={city=Stamford, country=US, line1=60 Long Ridge Rd, line2=Ste 303, postal_code=06902, state=CT}, name=Sandesh Gawande, phone=2036139296},
customer_tax_exempt=none, customer_tax_ids=[], default_payment_method=null, default_source=null, default_tax_rates=[], description=null, discount=null, discounts=[], due_date=null, ending_balance=null, footer=null, hosted_invoice_url=null,
invoice_pdf=null, last_finalization_error=null, lines={object=list, data=[], has_more=false, total_count=0, url=/v1/invoices /in_1JzUqIKFb2PyqLAGGMMnbdkw/lines}, livemode=true, metadata={}, next_payment_attempt=null, number=74E81D3E-0002,
on_behalf_of=null, paid=false, payment_intent=null, payment_settings= {payment_method_options=null, payment_method_types=null}, period_end=1637796334, period_start=1637796334, post_payment_credit_notes_amount=0, pre_payment_credit_notes_amount=0,
quote=null, receipt_number=null, starting_balance=0, statement_descriptor=null, status=draft, status_transitions= {finalized_at=null, marked_uncollectible_at=null, paid_at=null, voided_at=null}, subscription=null, subtotal=0, tax=null,
tax_percent=null, total=0, total_discount_amounts=[], total_tax_amounts=[], transfer_data=null, webhooks_delivered_at =1637796334}
39Dimensiondefault_payment_

method

ID of the default payment method for the invoice. It must belong to the customer associated with the invoice. If not set, defaults to the subscription’s default payment method, if any, or to the default payment method in the customer’s invoice
settings.
40Dimensiondefault_sourceID of the default payment source for the invoice. It must belong to the customer associated with the invoice and be in a chargeable state. If not set, defaults to the subscription’s default source, if any, or to the customer’s default source.
41Metricdefault_tax_ratesThe tax rates applied to this invoice, if any.[]
42DimensiondescriptionAn arbitrary string attached to the object. Often useful for displaying to users. Referenced as ‘memo’ in the Dashboard.ORG000097
43MetricdiscountsDescribes the current discount applied to this invoice, if there is one. Not populated if there are multiple discounts.[]
44Dimensiondue_dateThe date on which payment for this invoice is due. This value will be null for invoices where collection_method=charge_automatically.2021-06-13 12:45:42 UTC
45Metricending_balanceEnding 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.
2021-06-13 12:45:42 UTC
46DimensionfooterFooter displayed on the invoice.
47Dimensionhosted_invoice_urlThe URL for the hosted invoice page, which allows customers to view and pay an invoice. If the invoice has not been finalized yet, this will be null.
48DimensionidUnique identifier for the object.in_1jzuhtkfb2pyqlagwu7wwphw
49Dimensioninvoice_pdfThe link to download the PDF for the invoice. If the invoice has not been finalized yet, this will be null.
50Dimensionlast_finalization_errorThe error encountered during the previous attempt to finalize the invoice. This field is cleared when the invoice is successfully finalized.
51DimensionlinesThe individual line items that make up the invoice. lines is sorted as follows: invoice items in reverse chronological order, followed by the subscription, if any.{“object”:”list”,”data”:[],”has_more”:false,”total_count”:

0,”url” :”/v1/invoices/in_1JzUhtKFb2Pyq

LAGWu7WwpHw/lines”}

52DimensionlivemodeHas the value true if the object exists in live mode or the value false if the object exists in test mode.TRUE
53DimensionmetadataSet 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.{}
54Dimensionnext_payment_attemptThe time at which payment will next be attempted. This value will be null for invoices where collection_method=send_invoice.
55DimensionnumberA 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.6076f4fd-0001
56DimensionobjectString representing the object’s type. Objects of the same type share the same value.invoice
57Dimensionon_behalf_ofThe account (if any) for which the funds of the invoice payment are intended. If set, the invoice will be presented with the branding and support information of the specified account.
58DimensionpaidWhether 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.FALSE
59Dimensionpayment_intentThe Payment Intent associated with this invoice. The PaymentIntent is generated when the invoice is finalized, and can then be used to pay the invoice. Note that voiding an invoice will cancel the PaymentIntent.
60Dimensionpayment_settingsConfiguration settings for the PaymentIntent that is generated when the invoice is finalized.{“payment_method_options”:null, “payment_method_types”:null}
61Dimensionperiod_endEnd of the usage period during which invoice items were added to this invoice.11/24/2021
62Dimensionperiod_startStart of the usage period during which invoice items were added to this invoice.11/24/2021
63Metricpost_payment_credit

_notes_amount

Total amount of all post-payment credit notes issued for this invoice.0
64Metricpre_payment_credit

_notes_amount

Total amount of all pre-payment credit notes issued for this invoice.0
65DimensionqouteThe quote this invoice was generated from.
66Dimensionreceipt_numberThis is the transaction number that appears on email receipts sent for this invoice.
67Dimensionstarting_balanceStarting customer balance before the invoice is finalized. If the invoice has not been finalized yet, this will be the current customer balance.0
68Dimensionstatement_descriptorExtra information about an invoice for the customer’s credit card statement.
69DimensionstatusThe status of the invoice, one of draft, open, paid, uncollectible, or void.draft
70Dimensionstatus_transitionsThe timestamps at which the invoice status was updated.{“finalized_at”:null,”marked

_uncollectible_at”: null,”paid_at”

:null,”voided_at”:null}

71Dimensionstatus_transitions_ finalized_atThe time that the invoice draft was finalized.
72Dimensionstatus_transitions_ marked_uncollectible_atThe time that the invoice was marked uncollectible.
73Dimensionstatus_transitions_paid_ atThe time that the invoice was paid.
74Dimensionstatus_transitions_voided_ atThe time that the invoice was voided.
75DimensionsubscriptionThe subscription that this invoice was prepared for, if any.
76MetricsubtotalTotal of all subscriptions, invoice items, and prorations on the invoice before any invoice level discount or tax is applied. Item discounts are already incorporated0
77MetrictaxThe amount of tax on this invoice. This is the sum of all the tax amounts on this invoice.
78Metrictax_percenttax percent
79MetrictotalTotal after discounts and taxes.0
80Metrictotal_discount_amountstotal discount amounts[]
81Metrictotal_tax_amountstotal tax amounts[]
82Metrictransfer_dataThe account (if any) the payment will be attributed to for tax reporting, and where funds from the payment will be transferred to for the invoice.
83Dimensionwebhooks_delivered

_ at

Invoices are automatically paid or sent 1 hour after webhooks are delivered, or until all webhook delivery attempts have been exhausted. This field tracks the time when webhooks for this invoice were successfully delivered. If the invoice
had no webhooks to deliver, this will be set while the invoice is being created.
1637795813
84Electrik.AIsha_idHashed Primary Key4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
85Electrik.AIetl_orgOrganization IdORG000097
86Electrik.AIetl_projectProject IdPR000154
87Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC2021-06-13 12:45:42 UTC
88Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC2021-06-13 12:45:42 UTC
89Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC2021-06-13 12:45:42 UTC
90Electrik.AIetl_flow_nmEAI Flow CodeFL001282
91Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL00AD-20190910144445424196
IndexCategoryElectrik.AI Column NameDescriptionSample Value
1MetricamountAmount (in pence) to be transferred to your bank account or debit card.9583
2Dimensionarrival_dateDate the payout is expected to arrive in the bank. This factors in delays like weekends or bank holidays.12/1/2021
3DimensionautomaticReturns true if the payout was created by an automated payout schedule, and false if it was requested manually.TRUE
4Dimensionbalance_transactionID of the balance transaction that describes the impact of this payout on your account balance.txn_1k1nnqkfb2pyqlagtqnvv8th
5DimensioncreatedTime at which the object was created. Measured in seconds since the Unix epoch.11/30/2021
6DimensioncurrencyThree-letter ISO currency code, in lowercase. Must be a supported currency.usd
7Dimensiondatacontains an array of up to limit transactions, starting after transaction starting_after. Each entry in the array is a separate transaction history object. If no more transactions are available, the resulting array will be empty.{id=po_1K1NNqKFb2PyqLAGUQmT7dYi, object=payout, amount=9583, arrival_date =1638316800, automatic=true, balance_transaction=txn_1K1NNqKFb2Pyq LAGtqNVv8tH , created=1638244318, currency=usd, description=STRIPE PAYOUT, destination=ba_1FgdQ8KFb2PyqLAGjLv
BpokN, failure_balance_transaction=null, failure_code=null, failure_message=null, livemode=true, metadata={}, method=standard, original_payout=null, reversed_by=null, source_type=card, statement_descriptor=null, status=in_transit, type=bank_account}
8DimensiondescriptionAn arbitrary string attached to the object. Often useful for displaying to users.stripe payout
9DimensiondestinationID of the bank account or card the payout was sent to.ba_1fgdq8kfb2pyqlagjlvbpokn
10Dimensionfailure_balance_ transactionIf the payout failed or was canceled, this will be the ID of the balance transaction that reversed the initial balance transaction, and puts the funds from the failed payout back in your balance.
11Dimensionfailure_codeError code explaining reason for payout failure if available. See Types of payout failures for a list of failure codes.
12Dimensionfailure_messageMessage to user further explaining reason for payout failure if available.
13DimensionidUnique identifier for the object.po_1k1nnqkfb2pyqlaguqmt7dyi
14DimensionlivemodeHas the value true if the object exists in live mode or the value false if the object exists in test mode.TRUE
15DimensionmetadataSet 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.{}
16DimensionmethodThe method used to send this payout, which can be standard or instant. instant is only supported for payouts to debit cards.standard
17DimensionobjectString representing the object’s type. Objects of the same type share the same value.payout
18Dimensionoriginal_payoutIf the payout reverses another, this is the ID of the original payout.
19Dimensionreversed_byIf the payout was reversed, this is the ID of the payout that reverses this payout.
20Dimensionsource_typeThe source balance this payout came from. One of card, fpx, or bank_account.card
21Dimensionstatement_descriptorstatement descriptor2021-06-13 12:45:42 UTC
22DimensionstatusOnly return payouts that have the given status: pending, paid, failed, or canceled.in_transit
23DimensiontypeCan be bank_account or card.bank_account
24Electrik.AIsha_idHashed Primary Key4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
25Electrik.AIetl_orgOrganization IdORG000097
26Electrik.AIetl_projectProject IdPR000154
27Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC2021-06-13 12:45:42 UTC
28Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC2021-06-13 12:45:42 UTC
29Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC2021-06-13 12:45:42 UTC
30Electrik.AIetl_flow_nmEAI Flow CodeFL001282
31Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL00AD-20190910144445424196
IndexCategoryElectrik.AI Column NameDescriptionSample Value
1DimensionactiveWhether the product is currently available for purchase.TRUE
2DimensioncreatedTime at which the object was created. Measured in seconds since the Unix epoch.11/24/2021
3Dimensiondatacontains an array of up to limit transactions, starting after transaction starting_after. Each entry in the array is a separate transaction history object. If no more transactions are available, the resulting array will be empty.{id=prod_KeoNlm0Djwpvn1, object=product, active=true, attributes=[], created=1637796006, description=Google Analytics Hit Level Data to BigQuery, images=[], livemode=true, metadata={}, name=GAHIT2BQ, package_dimensions=null, shippable=null,
statement_descriptor=null, tax_code=null, type=service, unit_label=null, updated=1637796006, url=null}
4DimensiondescriptionThe product’s description, meant to be displayable to the customer. Use this field to optionally store a long form explanation of the product being sold for your own rendering purposes.google analytics hit level data to bigquery
5DimensionidUnique identifier for the object.prod_keonlm0djwpvn1
6DimensionimagesA list of up to 8 URLs of images for this product, meant to be displayable to the customer.[]
7DimensionlivemodeHas the value true if the object exists in live mode or the value false if the object exists in test mode.TRUE
8DimensionmetadataSet 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.{}
9Dimensionnamehe product’s name, meant to be displayable to the customer. Whenever this product is sold via a subscription, name will show up on associated invoice line item descriptions.gahit2bq
10DimensionobjectString representing the object’s type. Objects of the same type share the same value.product
11Dimensionpackage_dimensionsThe dimensions of this product for shipping purposes.
12DimensionshippableWhether this product is shipped (i.e., physical goods).
13Dimensionstatement_descriptorExtra information about a product which will appear on your customer’s credit card statement. In the case that multiple products are billed at once, the first statement descriptor will be used.
14Dimensiontax_codeA tax code ID.
15Dimensionunit_labelA label that represents units of this product in Stripe and on customers’ receipts and invoices. When set, this will be included in associated invoice line item descriptions.
16DimensionupdatedTime at which the object was last updated. Measured in seconds since the Unix epoch.11/24/2021
17DimensionurlA URL of a publicly-accessible webpage for this product.
18Electrik.AIsha_idHashed Primary Key4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
19Electrik.AIetl_orgOrganization IdORG000097
20Electrik.AIetl_projectProject IdPR000154
21Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC2021-06-13 12:45:42 UTC
22Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC2021-06-13 12:45:42 UTC
23Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC2021-06-13 12:45:42 UTC
24Electrik.AIetl_flow_nmEAI Flow CodeFL001282
25Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL00AD-20190910144445424196