Table: dbo.Bank_Feeds_Transaction_Option
Table for options for the Bank Feeds Retrieved Transactions
Columns
Name | Type | Constraints | Description
client_KEY | int (4) | NOT NULL | The client key for which the options are set - Primary Key column
bank_feeds_transaction_description_type_KEY | tinyint (1) | NOT NULL | Key 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_matching | tinyint (1) | NOT NULL | Number of days offset to be used for determining a possible match of a transaction retrieved from Yodlee with existing ACS transactions
journal_KEY | int (4) | NOT NULL | Journal key to be associated with Bank Feeds Retrieved Transaction.

Primary key
Name | Columns | Description
PK_Bank_Feeds_Transaction_Option$client_KEY | client_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Bank_Feeds_Transaction_Option__Client__client_KEY | client_KEY | Client (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_KEY | bank_feeds_transaction_description_type_KEY | Bank_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_KEY | journal_KEY | Journal (journal_KEY) |