Table: dbo.GL_Account_Grouping_Code_Type
Extension of the GL_Account_Grouping_Code table to hold the Type for the standard classification codes and the default codes for each Type
Columns
Name | Type | Constraints | Description
gl_account_grouping_code_KEY | int (4) | NOT NULL | Primary key for this table.
gl_account_type_KEY | int (4) | NOT NULL | GL_Account_Type key.
default__gl_account_type_KEY | int (4) |  | GL_Account_Type key If this code is the default code for this type, NULL otherwise.

Primary key
Name | Columns | Description
PK_GL_Account_Grouping_Code_Type$gl_account_grouping_code_KEY | gl_account_grouping_code_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_GL_Account_Grouping_Code_Type__GL_Account_Grouping_Code__gl_account_grouping_code_KEY | gl_account_grouping_code_KEY | GL_Account_Grouping_Code (gl_account_grouping_code_KEY) |
FK_GL_Account_Grouping_Code_Type__GL_Account_Type__default__gl_account_type_KEY | default__gl_account_type_KEY | GL_Account_Type (gl_account_type_KEY) |
FK_GL_Account_Grouping_Code_Type__GL_Account_Type__gl_account_type_KEY | gl_account_type_KEY | GL_Account_Type (gl_account_type_KEY) |