Table: dbo.Custom_Excel_Template_Amount_Data
This table provides additional data about entries in table Custom_Excel_Template_Data which shall exist EXACTLY when the trial_balance_grid_column_type_KEY column of that table is 3 (Amount)
Columns
NameTypeConstraintsDescription
custom_excel_template_data_KEYint (4)NOT NULLPrimary key and Foreign key
trial_balance_grid_column_amount_amount_type_KEYint (4)NOT NULLtells the type of the amount column by key, such as the key corresponding to "beginning balance", "Unadjusted" and so on.
trial_balance_grid_column_amount_balance_type_KEYint (4)NOT NULLtells the type of the balance column by key, such as the key corresponding to Credit as "CR" and Debit as "DR" and so on.
trial_balance_grid_column_amount_period_basis_KEYint (4)NOT NULLtells the type of the period basis column by key, such as the key corresponding to "Current YTD", "Current Year Total" and so on.
period_offset_from_period_basistinyint (1)NOT NULLtells The GL period frequency of this amount column.Note this is of type TINYINT while Table Trial_Balance_Grid_Column_Amount_Option has a similar column of type SMALLINT
year_offset_from_current_fiscal_yeartinyint (1)NOT NULLtells current fiscal year offset value.Note this is of type TINYINT while Table Trial_Balance_Grid_Column_Amount_Option has a similar column of type SMALLINT
Primary key
NameColumnsDescription
PK_Custom_Excel_Template_Amount_Data$custom_excel_template_data_KEYcustom_excel_template_data_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Custom_Excel_Template_Amount_Data__Custom_Excel_Template_Data__custom_excel_template_data_KEYcustom_excel_template_data_KEYCustom_Excel_Template_Data (custom_excel_template_data_KEY)
FK_Custom_Excel_Template_Amount_Data__Trial_Balance_Grid_Column_Amount_Amount_Type__trial_balance_grid_column_amount_amount_typetrial_balance_grid_column_amount_amount_type_KEYTrial_Balance_Grid_Column_Amount_Amount_Type (trial_balance_grid_column_amount_amount_type_KEY)
FK_Custom_Excel_Template_Amount_Data__Trial_Balance_Grid_Column_Amount_Balance_Type__trial_balance_grid_column_amount_balance_tytrial_balance_grid_column_amount_balance_type_KEYTrial_Balance_Grid_Column_Amount_Balance_Type (trial_balance_grid_column_amount_balance_type_KEY)
FK_Custom_Excel_Template_Amount_Data__Trial_Balance_Grid_Column_Amount_Period_Basis__trial_balance_grid_column_amount_period_bastrial_balance_grid_column_amount_period_basis_KEYTrial_Balance_Grid_Column_Amount_Period_Basis (trial_balance_grid_column_amount_period_basis_KEY)

Schema diagram