Table: dbo.Trial_Balance_Grid_Column_Amount_Option
This table stores more column defintion information for trial balance data entry grid columns. For Amount columns they need more specifical informaiton
Columns
NameTypeConstraintsDescription
trial_balance_grid_column_KEYint (4)NOT NULLPrimary key. it is also a foreign key to Trial_Balance_Grid_Column table
trial_balance_grid_column_amount_amount_type_KEYint (4)NOT NULLA foreign key to Trial_Balance_Grid_Column_Amount_Amount_Type table
trial_balance_grid_column_amount_period_basis_KEYint (4)NOT NULLA foreign key to Trial_Balance_Grid_Column_Amount_Period_Basis table
period_offset_from_period_basissmallint (2)NOT NULLA samll int which represents an offset from a period base. It is used to calculate the gl_period_KEY for a specific amount column
year_offset_from_current_fiscal_yearsmallint (2)NOT NULLA small int which tells the offset from current fiscal year
trial_balance_grid_column_amount_balance_type_KEYint (4)NOT NULLTrial Balance Grid Column Amount Balance Type Key.
Primary key
NameColumnsDescription
PK_Trial_Balance_Grid_Column_Amount_Option$trial_balance_grid_column_KEYtrial_balance_grid_column_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Trial_Balance_Grid_Column_Amount_Option__Trial_Balance_Grid_Column__trial_balance_grid_column_KEYtrial_balance_grid_column_KEYTrial_Balance_Grid_Column (trial_balance_grid_column_KEY)
FK_Trial_Balance_Grid_Column_Amount_Option__Trial_Balance_Grid_Column_Amount_Amount_Type__trial_balance_grid_column_amount_amountrial_balance_grid_column_amount_amount_type_KEYTrial_Balance_Grid_Column_Amount_Amount_Type (trial_balance_grid_column_amount_amount_type_KEY)
FK_Trial_Balance_Grid_Column_Amount_Option__Trial_Balance_Grid_Column_Amount_Balance_Type__trial_balance_grid_column_amount_balatrial_balance_grid_column_amount_balance_type_KEYTrial_Balance_Grid_Column_Amount_Balance_Type (trial_balance_grid_column_amount_balance_type_KEY)
FK_Trial_Balance_Grid_Column_Amount_Option__Trial_Balance_Grid_Column_Amount_Period_Basis__trial_balance_grid_column_amount_peritrial_balance_grid_column_amount_period_basis_KEYTrial_Balance_Grid_Column_Amount_Period_Basis (trial_balance_grid_column_amount_period_basis_KEY)

Schema diagram