Table: dbo.Import_Template_Column_GL_Account_Data
This table stores info for chart of accounts excel import grid headers
Columns
Name | Type | Constraints | Description
import_template_column_gl_account_data_KEY | int (4) | NOT NULL | Primary key.
import_template_column_KEY | int (4) | NOT NULL | The foreign key to Import_Template_Column
gl_account_grouping_KEY | int (4) |  | The foreign key to GL_Account_Grouping
code_subcode_type_KEY | int (4) |  | The foreign key to Code_Subcode
gl_period_KEY | int (4) |  | The foreign key to GL_Period
gl_balance_effect_KEY | int (4) |  | The foreign key to GL_Balance_Effect
spreadsheet_import_tax_info_type_KEY | int (4) |  | Foreign key to Spreadsheet_Import_Tax_Info_Type table.

Primary key
Name | Columns | Description
PK_Import_Template_Column_GL_Account_Data | import_template_column_gl_account_data_KEY |
Unique constraints
Name | Columns | Description
UK_Import_Template_Column_GL_Account_Data$import_template_column_KEY | import_template_column_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Import_Template_Column_GL_Account_Data__Code_Subcode_Type__code_subcode_type_KEY | code_subcode_type_KEY | Code_Subcode_Type (code_subcode_type_KEY) |
FK_Import_Template_Column_GL_Account_Data__GL_Account_Grouping__gl_account_grouping_KEY | gl_account_grouping_KEY | GL_Account_Grouping (gl_account_grouping_KEY) |
FK_Import_Template_Column_GL_Account_Data__GL_Balance_Effect__gl_balance_effect_KEY | gl_balance_effect_KEY | GL_Balance_Effect (gl_balance_effect_KEY) |
FK_Import_Template_Column_GL_Account_Data__GL_Period__gl_period_KEY | gl_period_KEY | GL_Period (gl_period_KEY) |
FK_Import_Template_Column_GL_Account_Data__Import_Template_Column__import_template_column_KEY | import_template_column_KEY | Import_Template_Column (import_template_column_KEY) |
FK_Import_Template_Column_GL_Account_Data__Spreadsheet_Import_Tax_Info_Type__spreadsheet_import_tax_info_type_KEY | spreadsheet_import_tax_info_type_KEY | Spreadsheet_Import_Tax_Info_Type (spreadsheet_import_tax_info_type_KEY) |