Table: dbo.Custom_Excel_Template_Data
A row in this table corresponds to a mapped column in the Custom Excel Template
Columns
NameTypeConstraintsDescription
custom_excel_template_data_KEYint (4)NOT NULLPrimary key
custom_excel_template_KEYint (4)NOT NULLIndicates with which custom excel template this data row is associated.
sequence_numberint (4)NOT NULLThe sequence number of the custom excel column.
trial_balance_grid_column_type_KEYint (4)NOT NULLThe type of the custom excel column.
heading_onenvarchar (60)NOT NULLHeading one of the column.
heading_twonvarchar (60)NOT NULLHeading two of the column.
Primary key
NameColumnsDescription
PK_Custom_Excel_Template_Datacustom_excel_template_data_KEY
Unique constraints
NameColumnsDescription
UK_Custom_Excel_Template_Data$custom_excel_template_KEY$sequence_numbercustom_excel_template_KEY, sequence_number
Foreign keys
NameColumnsReferenced tableDescription
FK_Custom_Excel_Template_Data__Custom_Excel_Template__custom_excel_template_KEYcustom_excel_template_KEYCustom_Excel_Template (custom_excel_template_KEY)
FK_Custom_Excel_Template_Data__Trial_Balance_Grid_Column_Type__trial_balance_grid_column_type_KEYtrial_balance_grid_column_type_KEYTrial_Balance_Grid_Column_Type (trial_balance_grid_column_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Custom_Excel_Template_Amount_Data__Custom_Excel_Template_Data__custom_excel_template_data_KEYcustom_excel_template_data_KEYCustom_Excel_Template_Amount_Data

Schema diagram