Table: dbo.GL_Account_Segment_Code
Columns
NameTypeConstraintsDescription
gl_account_segment_code_KEYint (4)NOT NULLPrimary key for this table.
is_activebit (1)NOT NULLFlag for indicating if the segment code is active.
codenvarchar (120)NOT NULLThe code for the field.
descriptionnvarchar (100)NOT NULLThe description of the code.
gl_account_segment_KEYint (4)NOT NULLKey of segment that owns the code.
do_not_export_to_quick_booksbit (1)NOT NULLOption to not export a gl account segment code to quickbooks. The user can specify that they do not want a gl account segment code exported.
Primary key
NameColumnsDescription
PK_GL_Account_Segment_Codegl_account_segment_code_KEY
Unique constraints
NameColumnsDescription
UK_GL_Account_Segment_Code$code$gl_account_segment_KEYcode, gl_account_segment_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_GL_Account_Segment_Code__GL_Account_Segment__gl_account_segment_KEYgl_account_segment_KEYGL_Account_Segment (gl_account_segment_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Quick_Books_Class__GL_Account_Segment_Code__gl_account_segment_code_KEYgl_account_segment_code_KEYQuick_Books_Class
FK_GL_Account_Segment_Code_N_Quick_Books_Class__GL_Account_Segment_Code__gl_account_segment_code_KEYgl_account_segment_code_KEYGL_Account_Segment_Code_N_Quick_Books_Class
FK_GL_Account_Segment_Code_Rounding_Account__GL_Account_Segment_Code__gl_account_segment_code_KEYgl_account_segment_code_KEYGL_Account_Segment_Code_Rounding_Account
FK_GL_Account_N_GL_Account_Segment_Code__GL_Account_Segment_Code__gl_account_segment_code_KEYgl_account_segment_code_KEYGL_Account_N_GL_Account_Segment_Code
FK_Year_End_Close_Net_Income_Distribution__GL_Account_Segment_Code__gl_account_segment_code_KEYgl_account_segment_code_KEYYear_End_Close_Net_Income_Distribution
FK_Year_End_Close_Balance_Sheet_Account_Distribution__GL_Account_Segment_Code__gl_account_segment_code_KEYgl_account_segment_code_KEYYear_End_Close_Balance_Sheet_Account_Distribution

Schema diagram