| 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 | ||