Table: dbo.Custom_Excel_Template_Data | |||
A row in this table corresponds to a mapped column in the Custom Excel Template | |||
Columns | |||
Name | Type | Constraints | Description |
custom_excel_template_data_KEY | int (4) | NOT NULL | Primary key |
custom_excel_template_KEY | int (4) | NOT NULL | Indicates with which custom excel template this data row is associated. |
sequence_number | int (4) | NOT NULL | The sequence number of the custom excel column. |
trial_balance_grid_column_type_KEY | int (4) | NOT NULL | The type of the custom excel column. |
heading_one | nvarchar (60) | NOT NULL | Heading one of the column. |
heading_two | nvarchar (60) | NOT NULL | Heading two of the column. |
Primary key | |||
Name | Columns | Description | |
PK_Custom_Excel_Template_Data | custom_excel_template_data_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Custom_Excel_Template_Data$custom_excel_template_KEY$sequence_number | custom_excel_template_KEY, sequence_number |
Incoming foreign keys | |||
Name | Columns | Referencing table | Description |
FK_Custom_Excel_Template_Amount_Data__Custom_Excel_Template_Data__custom_excel_template_data_KEY | custom_excel_template_data_KEY | Custom_Excel_Template_Amount_Data |