Table: dbo.Bank_Feeds_Transaction_Option
Table for options for the Bank Feeds Retrieved Transactions
Columns
NameTypeConstraintsDescription
client_KEYint (4)NOT NULLThe client key for which the options are set - Primary Key column
bank_feeds_transaction_description_type_KEYtinyint (1)NOT NULLKey for the default bank feeds transaction description type. If 1, it indicates that the description value["BR"] of a transaction retrieved from Yodlee needs to be based on the source transaction description and if 2, then["BR"] it should be based on the name of the vendor assigned to the transaction
days_offset_for_matchingtinyint (1)NOT NULLNumber of days offset to be used for determining a possible match of a transaction retrieved from Yodlee with existing ACS transactions
journal_KEYint (4)NOT NULLJournal key to be associated with Bank Feeds Retrieved Transaction.
Primary key
NameColumnsDescription
PK_Bank_Feeds_Transaction_Option$client_KEYclient_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Bank_Feeds_Transaction_Option__Client__client_KEYclient_KEYClient (client_KEY)The client key corresponding to which the bank feeds transaction options are set. It is forign-keyed to the Client
FK_Bank_Feeds_Transaction_Option__Bank_Feeds_Transaction_Description_Type__bank_feeds_transaction_description_type_KEYbank_feeds_transaction_description_type_KEYBank_Feeds_Transaction_Description_Type (bank_feeds_transaction_description_type_KEY)The bank feeds transaction description type selected for the client. It is foreign-keyed to the Bank_Feeds_Transaction_Description_Type
FK_Bank_Feeds_Transaction_Option__Journal__journal_KEYjournal_KEYJournal (journal_KEY)

Schema diagram