Table: dbo.Spreadsheet_Import_Tax_Info_Type
Table to identify the tax informatio type(tax codes,tax codes unit or m3 tax codes) used when importing data from spreadsheet.
Columns
NameTypeConstraintsDescription
spreadsheet_import_tax_info_type_KEYint (4)NOT NULLKey which uniquely identify each row of the table.
descriptionnvarchar (60)NOT NULLTax code type description
sequence_numberint (4)NOT NULLSequence order to display items in the column mapping combo.
Primary key
NameColumnsDescription
PK_Spreadsheet_Import_Tax_Info_Typespreadsheet_import_tax_info_type_KEY
Unique constraints
NameColumnsDescription
UK_Spreadsheet_Import_Tax_Info_Type$descriptiondescription
UK_Spreadsheet_Import_Tax_Info_Type$sequence_numbersequence_number
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Import_Template_Column_GL_Account_Data__Spreadsheet_Import_Tax_Info_Type__spreadsheet_import_tax_info_type_KEYspreadsheet_import_tax_info_type_KEYImport_Template_Column_GL_Account_Data

Schema diagram