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
Name | Type | Constraints | Description
custom_excel_template_data_KEY | int (4) | NOT NULL | Primary key and Foreign key
trial_balance_grid_column_amount_amount_type_KEY | int (4) | NOT NULL | tells 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_KEY | int (4) | NOT NULL | tells 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_KEY | int (4) | NOT NULL | tells 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_basis | tinyint (1) | NOT NULL | tells 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_year | tinyint (1) | NOT NULL | tells 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
Name | Columns | Description
PK_Custom_Excel_Template_Amount_Data$custom_excel_template_data_KEY | custom_excel_template_data_KEY |

Foreign keys
Name | Columns | Referenced 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_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_type | trial_balance_grid_column_amount_amount_type_KEY | Trial_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_ty | trial_balance_grid_column_amount_balance_type_KEY | Trial_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_bas | trial_balance_grid_column_amount_period_basis_KEY | Trial_Balance_Grid_Column_Amount_Period_Basis (trial_balance_grid_column_amount_period_basis_KEY) |