Table: dbo.Spreadsheet_Import_Bank_Account
Table to store the mapping data information of bank accounts for spreadsheet import
Columns
NameTypeConstraintsDescription
spreadsheet_import_bank_account_KEYint (4)NOT NULLKey which uniquely identify each row of the table.
client_KEYint (4)NOT NULLClient key for which we are importing the spreadsheet data.
descriptionnvarchar (318)NOT NULLDescription for the bank account from spread sheet.
mark_transactions_as_clearedbit (1)NOT NULLThis column is set to true and provided to user on subsequent imports, if the user checks the cleared option while mapping bank accounts.All the transactions referred by such bank accounts are cleared for reconciliation while importing.
is_interim_databit (1)NOT NULLWhen the user cancels the import process,the data mapped till that point has to be saved and presented to the user when he starts the import next time.For such mapping data we set the value of this column to true.
checkbook_KEYint (4)NOT NULLBank account key for which the bank account in the spreadsheet is mapped.
Primary key
NameColumnsDescription
PK_Spreadsheet_Import_Bank_Accountspreadsheet_import_bank_account_KEY
Unique constraints
NameColumnsDescription
UK_Spreadsheet_Import_Bank_Account$client_KEY$descriptionclient_KEY, description
Foreign keys
NameColumnsReferenced tableDescription
FK_Spreadsheet_Import_Bank_Account__Checkbook__checkbook_KEYcheckbook_KEYCheckbook (checkbook_KEY)
FK_Spreadsheet_Import_Bank_Account__Client__client_KEYclient_KEYClient (client_KEY)

Schema diagram