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 |

Foreign keys
Name | Columns | Referenced table | Description
FK_Custom_Excel_Template_Data__Custom_Excel_Template__custom_excel_template_KEY | custom_excel_template_KEY | Custom_Excel_Template (custom_excel_template_KEY) |
FK_Custom_Excel_Template_Data__Trial_Balance_Grid_Column_Type__trial_balance_grid_column_type_KEY | trial_balance_grid_column_type_KEY | Trial_Balance_Grid_Column_Type (trial_balance_grid_column_type_KEY) |

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 |