Table: dbo.Bank_Feeds_Retrieved_Transaction
This table provides transaction records from a bank feeds bank account or other financial account.
Columns
NameTypeConstraintsDescription
bank_feeds_retrieved_transaction_KEYint (4)NOT NULLPrimary Key for this table.
include_transactionbit (1)NOT NULLthis tells us if the user wants to include this transaction when importing and matching transactions from the bank feeds retrieve of transactions.
transaction_idbigint (8)A bank feeds transaction id, supplied from bank feeds. This column will only have a value when bank_feeds_transaction_source_type_KEY is Yodlee.
bank_feeds_retrieved_financial_account_KEYint (4)This is the key of the bank feeds account associated with this retrieved transaction. This column will only have a value when bank_feeds_transaction_source_type_KEY is Yodlee.
amountdecimal (9, 2)NOT NULLthe amount of the retrieved transaction.
descriptionnvarchar (240)NOT NULLthe description of the retrieved transaction.
transaction_datesmalldatetime (4)NOT NULLthe date of the transaction.
referencenvarchar (32)NOT NULLthe reference number of the transaction.
gl_period_KEYint (4)the gl period key of the transaction.
bank_feeds_transaction_import_status_KEYtinyint (1)NOT NULLthe import status of the transaction. this provides information on how to process the transaction.
vendor_KEYint (4)the vendor key for the vendor associated with the transaction. This is an optional field, the user does not have to supply a vendor key. Not every bank transaction will have a vendor key assigned to it.
bank_transaction_type_KEYint (4)NOT NULLThe type of the transaction retrieved from bank feeds
user_session_guiduniqueidentifier (16)The unique identifier used to link imported records to a current user.
is_transaction_savedbit (1)NOT NULLThe flag used to indicate whether or not the data of the current user should persist. Only when this column has a value of true should the record persist.
is_rule_appliedbit (1)NOT NULLBit field that determines if a rule has already been applied to a bank feeds transaction. If it is true,["BR"] no further rules will be applied to the transaction.
bank_feeds_transaction_source_type_KEYtinyint (1)NOT NULLPrimary key of the Bank Feeds Retrieved Transaction Source Type associated with Bank Feeds Retrieved Transaction. This column will only have a value of Yodlee and Digital File.
checkbook_KEYint (4)Primary key of the Checkbook associated with Bank Feeds Retrieved Transaction. This column will only have a value when bank_feeds_transaction_source_type_KEY is Digital File.
Primary key
NameColumnsDescription
PK_Bank_Feeds_Retrieved_Transactionbank_feeds_retrieved_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Bank_Feeds_Retrieved_Transaction__Bank_Feeds_Transaction_Source_Type__bank_feeds_transaction_source_type_KEYbank_feeds_transaction_source_type_KEYBank_Feeds_Transaction_Source_Type (bank_feeds_transaction_source_type_KEY)
FK_Bank_Feeds_Retrieved_Transaction__Checkbook__checkbook_KEYcheckbook_KEYCheckbook (checkbook_KEY)
FK_Bank_Feeds_Retrieved_Transaction__Bank_Feeds_Retrieved_Financial_Account__bank_feeds_retrieved_financial_account_KEYbank_feeds_retrieved_financial_account_KEYBank_Feeds_Retrieved_Financial_Account (bank_feeds_retrieved_financial_account_KEY)
FK_Bank_Feeds_Retrieved_Transaction__GL_Period__gl_period_KEYgl_period_KEYGL_Period (gl_period_KEY)
FK_Bank_Feeds_Retrieved_Transaction__Bank_Feeds_Transaction_Import_Status__bank_feeds_transaction_import_status_KEYbank_feeds_transaction_import_status_KEYBank_Feeds_Transaction_Import_Status (bank_feeds_transaction_import_status_KEY)
FK_Bank_Feeds_Retrieved_Transaction__Vendor__vendor_KEYvendor_KEYVendor (vendor_KEY)
FK_Bank_Feeds_Retrieved_Transaction__Bank_Transaction_Type__bank_transaction_type_KEYbank_transaction_type_KEYBank_Transaction_Type (bank_transaction_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Bank_Feeds_Retrieved_Transaction_Distribution__Bank_Feeds_Retrieved_Transaction__bank_feeds_retrieved_transaction_KEYbank_feeds_retrieved_transaction_KEYBank_Feeds_Retrieved_Transaction_Distribution
FK_Bank_Feeds_Retrieved_Transaction_Rule_Applied__Bank_Feeds_Retrieved_Transaction__bank_feeds_retrieved_transaction_KEYbank_feeds_retrieved_transaction_KEYBank_Feeds_Retrieved_Transaction_Rule_Applied

Schema diagram