Table: dbo.Bank_Feeds_Import
this table will store off the start date and the end date of the last retrieve. Also there will be data for the date and time of the last successful retrieve.["BR"]
Columns
NameTypeConstraintsDescription
checkbook_KEYint (4)NOT NULLThe primary key of this table is same as ACS checkbook key, because these dates would pertain to an acs bank account for which we are retrieving bank feeds data
last_import_start_time_utcdatetime (8, 3)NOT NULLThe date and time of the last import start date when the transactions were retrieved
last_import_end_time_utcdatetime (8, 3)NOT NULLThe date and time of the last import end date when the transactions were retrieved
last_update_time_utcdatetime (8, 3)NOT NULLThe date and time of the last update when the transactions were retrieved
additional_informationnvarchar (160)NOT NULLA field in table to save information whether email was sent to the client to link an account.
Primary key
NameColumnsDescription
PK_Bank_Feeds_Import$checkbook_KEYcheckbook_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Bank_Feeds_Import__Checkbook__checkbook_KEYcheckbook_KEYCheckbook (checkbook_KEY)

Schema diagram