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