Table: dbo.Bank_Feeds_Retrieved_Financial_Account
This table provides records from a bank feeds bank account or other financial account.
Columns
NameTypeConstraintsDescription
bank_feeds_retrieved_financial_account_KEYint (4)NOT NULLPrimary Key for this table.
bank_feed_account_namenvarchar (240)NOT NULLthe bank feeds financial account name.
bank_feed_account_numbernvarchar (80)NOT NULLthe bank feeds financial account number.
bank_feed_current_balancedecimal (9, 2)NOT NULLthe bank feeds financial account current balance amount. Yodlee says that this may not include transactions yet to be posted to the account.
checkbook_guiduniqueidentifier (16)NOT NULLThe checkbook guid that links Account CS checkbooks to a corresponding Bluemoon Yodlee checkbook.
Primary key
NameColumnsDescription
PK_Bank_Feeds_Retrieved_Financial_Accountbank_feeds_retrieved_financial_account_KEY
Unique constraints
NameColumnsDescription
UK_Bank_Feeds_Retrieved_Financial_Account$checkbook_guidcheckbook_guid
Foreign keys
NameColumnsReferenced tableDescription
FK_Bank_Feeds_Retrieved_Financial_Account__Checkbook__checkbook_guidcheckbook_guidCheckbook (checkbook_guid)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Bank_Feeds_Retrieved_Transaction__Bank_Feeds_Retrieved_Financial_Account__bank_feeds_retrieved_financial_account_KEYbank_feeds_retrieved_financial_account_KEYBank_Feeds_Retrieved_Transaction
FK_Bank_Feeds_Refused_Transaction__Bank_Feeds_Retrieved_Financial_Account__bank_feeds_retrieved_financial_account_KEYbank_feeds_retrieved_financial_account_KEYBank_Feeds_Refused_Transaction

Schema diagram