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
NameTypeConstraintsDescription
spreadsheet_import_finance_charge_definition_KEYint (4)NOT NULLKey which uniquely identify each row of the table.
client_KEYint (4)NOT NULLKey of the client for which we are importing the spreadsheet data.
idnvarchar (318)NOT NULLAn 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_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.
finance_charge_definition_KEYint (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
NameColumnsDescription
PK_Spreadsheet_Import_Finance_Charge_Definitionspreadsheet_import_finance_charge_definition_KEY
Unique constraints
NameColumnsDescription
UK_Spreadsheet_Import_Finance_Charge_Definition$client_KEY$idclient_KEY, id
Foreign keys
NameColumnsReferenced tableDescription
FK_Spreadsheet_Import_Finance_Charge_Definition__Client__client_KEYclient_KEYClient (client_KEY)
FK_Spreadsheet_Import_Finance_Charge_Definition__Finance_Charge_Definition__finance_charge_definition_KEYfinance_charge_definition_KEYFinance_Charge_Definition (finance_charge_definition_KEY)

Schema diagram