Table: dbo.Bank_Reconciliation_Statement_Imported_File_Name
This table will hold the list of locations and names of bank statement files imported from the bank.
Columns
Name | Type | Constraints | Description
bank_reconciliation_statement_imported_file_name_KEY | int (4) | NOT NULL | Primary key.
bank_reconciliation_statement_KEY | int (4) | NOT NULL | Link to the reconciliation statement record.
file_name | nvarchar (520) | NOT NULL | Name and location of the statement file imported by the bank statement view.
import_time | datetime (8, 3) | NOT NULL | This stores the system date and time the statement file was imported.

Primary key
Name | Columns | Description
PK_Bank_Reconciliation_Statement_Imported_File_Name | bank_reconciliation_statement_imported_file_name_KEY |
Unique constraints
Name | Columns | Description
UK_Bank_Reconciliation_Statement_Imported_File_Name$bank_reconciliation_statement_KEY$bank_reconciliation_statement_imported_fil | bank_reconciliation_statement_KEY, bank_reconciliation_statement_imported_file_name_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Bank_Reconciliation_Statement_Imported_File_Name__Bank_Reconciliation_Statement__bank_reconciliation_statement_KEY | bank_reconciliation_statement_KEY | Bank_Reconciliation_Statement (bank_reconciliation_statement_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Bank_Reconciliation_Statement_Import__Bank_Reconciliation_Statement_Imported_File_Name__bank_reconciliation_statement_KEY__ba | bank_reconciliation_statement_KEY, bank_reconciliation_statement_imported_file_name_KEY | Bank_Reconciliation_Statement_Import |