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