Table: dbo.Spreadsheet_Import_Bank_Routing_Number
Table to store the mapping data information of payment terms for spreadsheet import.
Columns
Name | Type | Constraints | Description
spreadsheet_import_bank_routing_number_KEY | int (4) | NOT NULL | Key which uniquely identify each row of the table.
client_KEY | int (4) | NOT NULL | Client key for which we are importing the spreadsheet data.
description | nvarchar (318) | NOT NULL | External description which is used to match to an existing bank routing number in the AccountingCS
is_interim_data | bit (1) | NOT NULL | When 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_KEY | int (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
Name | Columns | Description
PK_Spreadsheet_Import_Bank_Routing_Number | spreadsheet_import_bank_routing_number_KEY |
Unique constraints
Name | Columns | Description
UK_Spreadsheet_Import_Bank_Routing_Number$client_KEY$description | client_KEY, description |

Foreign keys
Name | Columns | Referenced table | Description
FK_Spreadsheet_Import_Bank_Routing_Number__Bank__bank_KEY | bank_KEY | Bank (bank_KEY) |
FK_Spreadsheet_Import_Bank_Routing_Number__Client__client_KEY | client_KEY | Client (client_KEY) |