| 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 | |