Table: dbo.Bank_Feeds_Retrieved_Transaction
This table provides transaction records from a bank feeds bank account or other financial account.
Columns
Name | Type | Constraints | Description
bank_feeds_retrieved_transaction_KEY | int (4) | NOT NULL | Primary Key for this table.
include_transaction | bit (1) | NOT NULL | this tells us if the user wants to include this transaction when importing and matching transactions from the bank feeds retrieve of transactions.
transaction_id | bigint (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_KEY | int (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.
amount | decimal (9, 2) | NOT NULL | the amount of the retrieved transaction.
description | nvarchar (240) | NOT NULL | the description of the retrieved transaction.
transaction_date | smalldatetime (4) | NOT NULL | the date of the transaction.
reference | nvarchar (32) | NOT NULL | the reference number of the transaction.
gl_period_KEY | int (4) |  | the gl period key of the transaction.
bank_feeds_transaction_import_status_KEY | tinyint (1) | NOT NULL | the import status of the transaction. this provides information on how to process the transaction.
vendor_KEY | int (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_KEY | int (4) | NOT NULL | The type of the transaction retrieved from bank feeds
user_session_guid | uniqueidentifier (16) |  | The unique identifier used to link imported records to a current user.
is_transaction_saved | bit (1) | NOT NULL | The 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_applied | bit (1) | NOT NULL | Bit 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_KEY | tinyint (1) | NOT NULL | Primary 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_KEY | int (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
Name | Columns | Description
PK_Bank_Feeds_Retrieved_Transaction | bank_feeds_retrieved_transaction_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Bank_Feeds_Retrieved_Transaction__Bank_Feeds_Transaction_Source_Type__bank_feeds_transaction_source_type_KEY | bank_feeds_transaction_source_type_KEY | Bank_Feeds_Transaction_Source_Type (bank_feeds_transaction_source_type_KEY) |
FK_Bank_Feeds_Retrieved_Transaction__Checkbook__checkbook_KEY | checkbook_KEY | Checkbook (checkbook_KEY) |
FK_Bank_Feeds_Retrieved_Transaction__Bank_Feeds_Retrieved_Financial_Account__bank_feeds_retrieved_financial_account_KEY | bank_feeds_retrieved_financial_account_KEY | Bank_Feeds_Retrieved_Financial_Account (bank_feeds_retrieved_financial_account_KEY) |
FK_Bank_Feeds_Retrieved_Transaction__GL_Period__gl_period_KEY | gl_period_KEY | GL_Period (gl_period_KEY) |
FK_Bank_Feeds_Retrieved_Transaction__Bank_Feeds_Transaction_Import_Status__bank_feeds_transaction_import_status_KEY | bank_feeds_transaction_import_status_KEY | Bank_Feeds_Transaction_Import_Status (bank_feeds_transaction_import_status_KEY) |
FK_Bank_Feeds_Retrieved_Transaction__Vendor__vendor_KEY | vendor_KEY | Vendor (vendor_KEY) |
FK_Bank_Feeds_Retrieved_Transaction__Bank_Transaction_Type__bank_transaction_type_KEY | bank_transaction_type_KEY | Bank_Transaction_Type (bank_transaction_type_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Bank_Feeds_Retrieved_Transaction_Distribution__Bank_Feeds_Retrieved_Transaction__bank_feeds_retrieved_transaction_KEY | bank_feeds_retrieved_transaction_KEY | Bank_Feeds_Retrieved_Transaction_Distribution |
FK_Bank_Feeds_Retrieved_Transaction_Rule_Applied__Bank_Feeds_Retrieved_Transaction__bank_feeds_retrieved_transaction_KEY | bank_feeds_retrieved_transaction_KEY | Bank_Feeds_Retrieved_Transaction_Rule_Applied |