Table: dbo.Spreadsheet_Import_Account
Table to store the mapping data information of chart of accounts for spreadsheet import.
Columns
NameTypeConstraintsDescription
spreadsheet_import_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.
account_numbernvarchar (120)NOT NULLAccount number provided in the spread sheet.
descriptionnvarchar (318)NOT NULLDescription for the account number.
sequence_numberint (4)NOT NULLaccount sort order for the accont number.
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.
gl_account_KEYint (4)gl_account_key of GL_Account table to which the account number in the spreadsheet is mapped to,a null value indicates that it was mapped as Do not import.
import_template_type_KEYint (4)NOT NULLSS Import type key for which we are importing the spreadsheet data
Primary key
NameColumnsDescription
PK_Spreadsheet_Import_Accountspreadsheet_import_account_KEY
Unique constraints
NameColumnsDescription
UK_Spreadsheet_Import_Account$client_KEY$account_number$import_template_type_KEYclient_KEY, account_number, import_template_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Spreadsheet_Import_Account__Client__client_KEYclient_KEYClient (client_KEY)
FK_Spreadsheet_Import_Account__GL_Account__gl_account_KEYgl_account_KEYGL_Account (gl_account_KEY)
FK_Spreadsheet_Import_Account__Import_Template_Type__import_template_type_KEYimport_template_type_KEYImport_Template_Type (import_template_type_KEY)

Schema diagram