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"] |
checkbook_KEY | int (4) | NOT NULL | The 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_utc | datetime (8, 3) | NOT NULL | The date and time of the last import start date when the transactions were retrieved |
last_import_end_time_utc | datetime (8, 3) | NOT NULL | The date and time of the last import end date when the transactions were retrieved |
last_update_time_utc | datetime (8, 3) | NOT NULL | The date and time of the last update when the transactions were retrieved |
additional_information | nvarchar (160) | NOT NULL | A field in table to save information whether email was sent to the client to link an account. |