Table: dbo.Trial_Balance_Grid_Column_Workpaper_Reference_Option
This table stores more column defintion information for trial balance data entry grid columns. For workpaper reference columns they need more specifical information
Columns
Name | Type | Constraints | Description
trial_balance_grid_column_KEY | int (4) | NOT NULL | Primary key. it is also a foreign key to Trial_Balance_Grid_Column table
trial_balance_grid_column_amount_period_basis_KEY | int (4) | NOT NULL | A foreign key to Trial_Balance_Grid_Column_Amount_Period_Basis table
period_offset_from_period_basis | smallint (2) | NOT NULL | A 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_year | smallint (2) | NOT NULL | A small int which tells the offset from current fiscal year

Primary key
Name | Columns | Description
PK_Trial_Balance_Grid_Column_Workpaper_Reference_Option$trial_balance_grid_column_KEY | trial_balance_grid_column_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Trial_Balance_Grid_Column_Workpaper_Reference_Option__Trial_Balance_Grid_Column__trial_balance_grid_column_KEY | trial_balance_grid_column_KEY | Trial_Balance_Grid_Column (trial_balance_grid_column_KEY) |
FK_Trial_Balance_Grid_Column_Workpaper_Reference_Option__Trial_Balance_Grid_Column_Amount_Period_Basis__trial_balance_grid_colum | trial_balance_grid_column_amount_period_basis_KEY | Trial_Balance_Grid_Column_Amount_Period_Basis (trial_balance_grid_column_amount_period_basis_KEY) |