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 |