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) |