Accounts and Balances
An account within a users linked institution.
These can be checking, savings, credit cards, loans, mortgages, etc. Some institutions allow the user to select which accounts to share with us when connecting to plaid.
Each account has an account_id that is generated by plaid at connection time.
During plaid connection, the user selects one "main account". This main account is recorded in the item record. The main account should be a checking account only, and it should be the account that the user gets their paycheck deposited into. It should be the same account as the debit card that the user links, but unfortunately we don’t have any way to verify this. It will also be the account that we will attempt to collect the users subscription from.
Any other accounts that are within the item are retrieved every time we call plaid to get the latest account information. This is usually any other checking, savings or credit cards that the user has with that institution.
Accounts are updated every time we receive a webhook from plaid. The txn-miner calls plaid to get the newest transactions, and the most up to date version of the accounts within the item.
Storage
Table: prod-txn-transactions
Location: us-east-2
Attributes
-
type - ACCOUNT
-
user_id
-
acct_id
-
acct_mask - The last 4 digits of the account number
-
acct_name
-
acct_official_name
-
acct_subtype - checking, savings, etc
-
acct_type
-
acct_verification_status
-
institution_id
-
acct_balances - json of balances object
-
bal_available - in cents
-
bal_available_string
-
bal_current - in cents
-
bal_current_string
-
bal_limit - in cents
-
bal_limit_string
-
bal_iso_cc
-
bal_unofficial_cc
-
updated_date
-