Table: dbo.GL_Account_N_GL_Account_Segment_Code
Columns
NameTypeConstraintsDescription
gl_account_n_gl_account_segment_code_KEYint (4)NOT NULLPrimary key for this table.
gl_account_KEYint (4)NOT NULLKey of account that uses the corresponding account_segment_code.
gl_account_segment_code_KEYint (4)NOT NULLKey of account_segment_code the account needs.
Primary key
NameColumnsDescription
PK_GL_Account_N_GL_Account_Segment_Codegl_account_n_gl_account_segment_code_KEY
Unique constraints
NameColumnsDescription
UK_GL_Account_N_GL_Account_Segment_Code$gl_account_KEY$gl_account_segment_code_KEYgl_account_KEY, gl_account_segment_code_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_GL_Account_N_GL_Account_Segment_Code__GL_Account__gl_account_KEYgl_account_KEYGL_Account (gl_account_KEY)
FK_GL_Account_N_GL_Account_Segment_Code__GL_Account_Segment_Code__gl_account_segment_code_KEYgl_account_segment_code_KEYGL_Account_Segment_Code (gl_account_segment_code_KEY)

Schema diagram