Table: dbo.Spreadsheet_Import_Bank_Routing_Number
Table to store the mapping data information of payment terms for spreadsheet import.
Columns
NameTypeConstraintsDescription
spreadsheet_import_bank_routing_number_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 NULLExternal description which is used to match to an existing bank routing number in the AccountingCS
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.
bank_KEYint (4)bank_KEY of Bank table to which the bank routing number description in the spreadsheet is mapped to,a null value indicates that it was mapped as Do not import.
Primary key
NameColumnsDescription
PK_Spreadsheet_Import_Bank_Routing_Numberspreadsheet_import_bank_routing_number_KEY
Unique constraints
NameColumnsDescription
UK_Spreadsheet_Import_Bank_Routing_Number$client_KEY$descriptionclient_KEY, description
Foreign keys
NameColumnsReferenced tableDescription
FK_Spreadsheet_Import_Bank_Routing_Number__Bank__bank_KEYbank_KEYBank (bank_KEY)
FK_Spreadsheet_Import_Bank_Routing_Number__Client__client_KEYclient_KEYClient (client_KEY)

Schema diagram