Stripe
## Columns
| Type | Name | Description |
| -------- | ----------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| STRING | balance\_transaction\_id | Unique identifier for the transaction. |
| DATETIME | balance\_transaction\_created\_at | When the transaction took place |
| DATETIME | balance\_transaction\_available\_on | The date the transaction’s net funds will become available in the Stripe balance. |
| STRING | balance\_transaction\_currency | Three-letter ISO currency code, in lowercase. |
| INTEGER | balance\_transaction\_amount | Gross amount of the transaction, in cents. |
| INTEGER | balance\_transaction\_fee | Fees (in cents) paid for this transaction. |
| INTEGER | balance\_transaction\_net | Net amount of the transaction, in cents. Gross amount minus fees, refunds, and disputes |
| STRING | balance\_transaction\_source\_id | The Stripe object to which this transaction is related. |
| STRING | balance\_transaction\_description | An arbitrary string attached to the object. Often useful for displaying to users. |
| STRING | balance\_transaction\_type | The type of transaction. Possible values are adjustment, advance, advance\_funding, application\_fee, application\_fee\_refund, charge, connect\_collection\_transfer, 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. |
| STRING | balance\_transaction\_reporting\_category | Groupings of transactions types based on how they show in Stripe's reporting |
| INTEGER | customer\_facing\_amount | The transaction amount that the customer sees. |
| STRING | customer\_facing\_currency | Three-letter ISO currency code that the customer sees. |
| DATETIME | effective\_at | calendar day after available\_at |
| STRING | automatic\_payout\_id | (Applies only to accounts on automatic payouts.) The unique ID for the associated payout. |
| STRING | payout\_id | ID for the payout associated with this balance transaction |
| DATETIME | payout\_created\_at | Time at which the payout record was created. |
| STRING | payout\_currency | Three-letter ISO currency code of the payout, in lowercase. |
| BOOLEAN | payout\_is\_automatic | True if the payout was created by an automated payout schedule, and false if it was requested manually. |
| DATETIME | payout\_arrival\_date\_at | Date the payout is expected to arrive in the bank. This factors in delays like weekends or bank holidays. |
| DATETIME | automatic\_payout\_effective\_at | The date we expect this automatic payout to arrive in your bank account, in UTC. This is also when the paid-out funds are deducted from your Stripe balance. |
| STRING | payout\_type | Whether the payout was to a bank\_account or card. |
| STRING | payout\_status | Current status of the payout. Can be paid, pending, in\_transit, canceled or failed. |
| STRING | payout\_description | An arbitrary string attached to the payout. Often useful for displaying to users. |
| STRING | destination\_bank\_account\_id | ID of the bank account the payout was sent to. |
| STRING | destination\_card\_id | ID of the card the payout was sent to. |
| STRING | customer\_id | The customer associated with the balance transaction (based on charge or refund details) |
| STRING | receipt\_email | The email the receipt was emailed to for this transaction. |
| STRING | customer\_email | The customer’s email address. |
| STRING | customer\_name | Customer name. |
| STRING | customer\_description | The description field associated with the customer |
| STRING | customer\_shipping\_address\_line\_1 | Attribute of the customer's shipping address. |
| STRING | customer\_shipping\_address\_line\_2 | Attribute of the customer's shipping address. |
| STRING | customer\_shipping\_address\_city | Attribute of the customer's shipping address. |
| STRING | customer\_shipping\_address\_state | Attribute of the customer's shipping address. |
| STRING | customer\_shipping\_address\_postal\_code | Attribute of the customer's shipping address. |
| STRING | customer\_shipping\_address\_country | Attribute of the customer's shipping address. |
| STRING | customer\_address\_line\_1 | Address line 1 (e.g., street, PO Box, or company name). |
| STRING | customer\_address\_line\_2 | Address line 2 (e.g., apartment, suite, unit, or building). |
| STRING | customer\_address\_city | City, district, suburb, town, or village. |
| STRING | customer\_address\_state | State, county, province, or region. |
| STRING | customer\_address\_postal\_code | ZIP or postal code. |
| STRING | customer\_address\_country | Two-letter country code (ISO 3166-1 alpha-2). |
| STRING | charge\_shipping\_address\_line\_1 | Address line 1 (e.g., street, PO Box, or company name) belonging to the charge. |
| STRING | charge\_shipping\_address\_line\_2 | Address line 2 (e.g., apartment, suite, unit, or building) belonging to the charge. |
| STRING | charge\_shipping\_address\_city | City, district, suburb, town, or village belonging to the charge. |
| STRING | charge\_shipping\_address\_state | State, county, province, or region belonging to the charge. |
| STRING | charge\_shipping\_address\_postal\_code | ZIP or postal code belonging to the charge. |
| STRING | charge\_shipping\_address\_country | Two-letter country code (ISO 3166-1 alpha-2) belonging to the charge. |
| STRING | card\_address\_line\_1 | Address line 1 (e.g., street, PO Box, or company name). |
| STRING | card\_address\_line\_2 | Address line 2 (e.g., apartment, suite, unit, or building). |
| STRING | card\_address\_city | City, district, suburb, town, or village. |
| STRING | card\_address\_state | State, county, province, or region. |
| STRING | card\_address\_postal\_code | ZIP or postal code. |
| STRING | card\_address\_country | Two-letter country code (ISO 3166-1 alpha-2). |
| STRING | charge\_id | The id of the charge associated with the balance transaction |
| DATETIME | charge\_created\_at | Timestamp of the charge object associated with the balance transaction |
| STRING | payment\_intent\_id | The id of the payment intent associated with the balance transaction |
| STRING | invoice\_id | The ID of the invoice this record is a part of. |
| STRING | invoice\_number | The number of the invoice associated with this record. |
| STRING | subscription\_id | The ID of the subscription is associated with this record. |
| STRING | payment\_method\_type | The id of the payment method type associated with the balance transaction |
| STRING | payment\_method\_brand | Card brand used for the payment method. Can be American Express, Diners Club, Discover, JCB, MasterCard, UnionPay, Visa, or Unknown. |
| STRING | payment\_method\_funding | Card funding type for the payment method. Can be credit, debit, prepaid, or unknown. |
| STRING | card\_brand | The brand of the card associated with the balance transaction |
| STRING | card\_funding | Card funding type. Can be credit, debit, prepaid, or unknown. |
| STRING | card\_country | The country the card was issued in. |
| STRING | charge\_statement\_descriptor | Extra information about a source. This will appear on your customer’s statement every time you charge the source. |
| STRING | dispute\_id | Unique identifier for the object. |
| STRING | dispute\_reason | Reason given by cardholder for dispute. Possible values are bank\_cannot\_process, check\_returned, credit\_not\_processed, customer\_initiated, debit\_not\_authorized, duplicate, fraudulent, general, incorrect\_account\_details, insufficient\_funds, product\_not\_received, product\_unacceptable, subscription\_canceled, or unrecognized. |
| STRING | refund\_id | ID of the refund associated with this record. |
| STRING | refund\_reason | Reason for the refund, either user-provided (duplicate, fraudulent, or requested\_by\_customer) or generated by Stripe internally (expired\_uncaptured\_charge). |
| STRING | transfer\_id | ID of the transfer associated with this record. |
| STRING | connected\_account\_id | The ID of the account connected to the transaction. |
| STRING | connected\_account\_country | The country of the account connected to the transaction. |
| STRING | connected\_account\_direct\_charge\_id | (Beta) For Stripe Connect activity related to a connected account, charge id of the direct charge that happened on connected account. |
| STRING | source\_relation | The source where this data was pulled from. If you are making use of the `union_schemas` variable, this will be the source schema. If you are making use of the `union_databases` variable, this will be the source database. If you are not unioning together multiple sources, this will be an empty string. |
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/stripe-balance-transactions.md?ask=