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 |