Table: dbo.Trial_Balance_Grid_Column_Amount_Period_Basis
This table stores type definition to Trial_Balance_Grid_Amount_Period_Base. User has flexibilty to define an amount column by specifiying an offset from a period Base. it could be Current Period, Current YTD or The Begining of the Year
Columns
NameTypeConstraintsDescription
trial_balance_grid_column_amount_period_basis_KEYint (4)NOT NULLPrimary key.
descriptionnvarchar (60)NOT NULLA description for the Trial_Balance_Grid_Column_Amount_Period_Type.
Primary key
NameColumnsDescription
PK_Trial_Balance_Grid_Column_Amount_Period_Basistrial_balance_grid_column_amount_period_basis_KEY
Unique constraints
NameColumnsDescription
UK_Trial_Balance_Grid_Column_Amount_Period_Basis$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
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_KEYCustom_Excel_Template_Amount_Data
FK_Trial_Balance_Grid_Column_Tickmark_Option__Trial_Balance_Grid_Column_Amount_Period_Basis__trial_balance_grid_column_amount_petrial_balance_grid_column_amount_period_basis_KEYTrial_Balance_Grid_Column_Tickmark_Option
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_Option
FK_Trial_Balance_Grid_Column_Workpaper_Reference_Option__Trial_Balance_Grid_Column_Amount_Period_Basis__trial_balance_grid_columtrial_balance_grid_column_amount_period_basis_KEYTrial_Balance_Grid_Column_Workpaper_Reference_Option

Schema diagram