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
Name | Type | Constraints | Description
trial_balance_grid_column_amount_period_basis_KEY | int (4) | NOT NULL | Primary key.
description | nvarchar (60) | NOT NULL | A description for the Trial_Balance_Grid_Column_Amount_Period_Type.

Primary key
Name | Columns | Description
PK_Trial_Balance_Grid_Column_Amount_Period_Basis | trial_balance_grid_column_amount_period_basis_KEY |
Unique constraints
Name | Columns | Description
UK_Trial_Balance_Grid_Column_Amount_Period_Basis$description | description |

Incoming foreign keys
Name | Columns | Referencing table | Description
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 | Custom_Excel_Template_Amount_Data |
FK_Trial_Balance_Grid_Column_Tickmark_Option__Trial_Balance_Grid_Column_Amount_Period_Basis__trial_balance_grid_column_amount_pe | trial_balance_grid_column_amount_period_basis_KEY | Trial_Balance_Grid_Column_Tickmark_Option |
FK_Trial_Balance_Grid_Column_Amount_Option__Trial_Balance_Grid_Column_Amount_Period_Basis__trial_balance_grid_column_amount_peri | trial_balance_grid_column_amount_period_basis_KEY | Trial_Balance_Grid_Column_Amount_Option |
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_Workpaper_Reference_Option |