Table: dbo.Import_Template_Column_GL_Account_Data
This table stores info for chart of accounts excel import grid headers
Columns
NameTypeConstraintsDescription
import_template_column_gl_account_data_KEYint (4)NOT NULLPrimary key.
import_template_column_KEYint (4)NOT NULLThe foreign key to Import_Template_Column
gl_account_grouping_KEYint (4)The foreign key to GL_Account_Grouping
code_subcode_type_KEYint (4)The foreign key to Code_Subcode
gl_period_KEYint (4)The foreign key to GL_Period
gl_balance_effect_KEYint (4)The foreign key to GL_Balance_Effect
spreadsheet_import_tax_info_type_KEYint (4)Foreign key to Spreadsheet_Import_Tax_Info_Type table.
Primary key
NameColumnsDescription
PK_Import_Template_Column_GL_Account_Dataimport_template_column_gl_account_data_KEY
Unique constraints
NameColumnsDescription
UK_Import_Template_Column_GL_Account_Data$import_template_column_KEYimport_template_column_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Import_Template_Column_GL_Account_Data__Code_Subcode_Type__code_subcode_type_KEYcode_subcode_type_KEYCode_Subcode_Type (code_subcode_type_KEY)
FK_Import_Template_Column_GL_Account_Data__GL_Account_Grouping__gl_account_grouping_KEYgl_account_grouping_KEYGL_Account_Grouping (gl_account_grouping_KEY)
FK_Import_Template_Column_GL_Account_Data__GL_Balance_Effect__gl_balance_effect_KEYgl_balance_effect_KEYGL_Balance_Effect (gl_balance_effect_KEY)
FK_Import_Template_Column_GL_Account_Data__GL_Period__gl_period_KEYgl_period_KEYGL_Period (gl_period_KEY)
FK_Import_Template_Column_GL_Account_Data__Import_Template_Column__import_template_column_KEYimport_template_column_KEYImport_Template_Column (import_template_column_KEY)
FK_Import_Template_Column_GL_Account_Data__Spreadsheet_Import_Tax_Info_Type__spreadsheet_import_tax_info_type_KEYspreadsheet_import_tax_info_type_KEYSpreadsheet_Import_Tax_Info_Type (spreadsheet_import_tax_info_type_KEY)

Schema diagram