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
NameTypeConstraintsDescription
bank_reconciliation_statement_imported_file_name_KEYint (4)NOT NULLPrimary key.
bank_reconciliation_statement_KEYint (4)NOT NULLLink to the reconciliation statement record.
file_namenvarchar (520)NOT NULLName and location of the statement file imported by the bank statement view.
import_timedatetime (8, 3)NOT NULLThis stores the system date and time the statement file was imported.
Primary key
NameColumnsDescription
PK_Bank_Reconciliation_Statement_Imported_File_Namebank_reconciliation_statement_imported_file_name_KEY
Unique constraints
NameColumnsDescription
UK_Bank_Reconciliation_Statement_Imported_File_Name$bank_reconciliation_statement_KEY$bank_reconciliation_statement_imported_filbank_reconciliation_statement_KEY, bank_reconciliation_statement_imported_file_name_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Bank_Reconciliation_Statement_Imported_File_Name__Bank_Reconciliation_Statement__bank_reconciliation_statement_KEYbank_reconciliation_statement_KEYBank_Reconciliation_Statement (bank_reconciliation_statement_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Bank_Reconciliation_Statement_Import__Bank_Reconciliation_Statement_Imported_File_Name__bank_reconciliation_statement_KEY__babank_reconciliation_statement_KEY, bank_reconciliation_statement_imported_file_name_KEYBank_Reconciliation_Statement_Import

Schema diagram