Table: dbo.Spreadsheet_Import_Finance_Charge_Definition
The purpose of this table is to map finance charge definitions imported via the spreadsheet import process to finance charge definitions already existing in the database.
Columns
Name | Type | Constraints | Description
spreadsheet_import_finance_charge_definition_KEY | int (4) | NOT NULL | Key which uniquely identify each row of the table.
client_KEY | int (4) | NOT NULL | Key of the client for which we are importing the spreadsheet data.
id | nvarchar (318) | NOT NULL | An external id which uniquely identifies a finance charge in the data source being imported. This id will be compared first to the finance charge definition ID and then to the description when trying to find a match with an existing finance charge definition in the database.
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.
finance_charge_definition_KEY | int (4) |  | finance_charge_definition_KEY of ACS Finance_Charge_Definition table to which the spreadsheet finance charge is mapped. Null value indicates that the spreadsheet value mapped to Do not import.

Primary key
Name | Columns | Description
PK_Spreadsheet_Import_Finance_Charge_Definition | spreadsheet_import_finance_charge_definition_KEY |
Unique constraints
Name | Columns | Description
UK_Spreadsheet_Import_Finance_Charge_Definition$client_KEY$id | client_KEY, id |

Foreign keys
Name | Columns | Referenced table | Description
FK_Spreadsheet_Import_Finance_Charge_Definition__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Spreadsheet_Import_Finance_Charge_Definition__Finance_Charge_Definition__finance_charge_definition_KEY | finance_charge_definition_KEY | Finance_Charge_Definition (finance_charge_definition_KEY) |