This table provides transaction records from a bank feeds bank account or other financial account. |
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. |