Table: dbo.GL_Account_Type
Columns
NameTypeConstraintsDescription
gl_account_type_KEYint (4)NOT NULLPrimary key for this table.
gl_account_typenvarchar (2)NOT NULLSingle character abbreviation of the type.
descriptionnvarchar (100)NOT NULLDescription of the type.
Primary key
NameColumnsDescription
PK_GL_Account_Typegl_account_type_KEY
Unique constraints
NameColumnsDescription
UK_GL_Account_Type$descriptiondescription
UK_GL_Account_Type$gl_account_typegl_account_type
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Ultra_Tax_Tax_Code__GL_Account_Type__gl_account_type_KEYgl_account_type_KEYUltra_Tax_Tax_Code
FK_Ultra_Tax_Staged_Tax_Code__GL_Account_Type__gl_account_type_KEYgl_account_type_KEYUltra_Tax_Staged_Tax_Code
FK_GL_Account_Grouping_Code_Type__GL_Account_Type__default__gl_account_type_KEYdefault__gl_account_type_KEYGL_Account_Grouping_Code_Type
FK_GL_Account_Grouping_Code_Type__GL_Account_Type__gl_account_type_KEYgl_account_type_KEYGL_Account_Grouping_Code_Type
FK_Quick_Books_Account_GL_Account__GL_Account_Type__gl_account_type_KEYgl_account_type_KEYQuick_Books_Account_GL_Account

Schema diagram