Table: dbo.GL_Account_Segment
Columns
NameTypeConstraintsDescription
gl_account_segment_KEYint (4)NOT NULLPrimary key for this table.
descriptionnvarchar (100)NOT NULLLabel of the segment.
client_KEYint (4)NOT NULLKey of client that owns the account segment.
mask_orderint (4)NOT NULLOrder in which the segment appears in this Mask. A mask_order of 0 means the segment is not in the mask.
is_corebit (1)NOT NULLFlag indicating the core segment of the mask.
patternnvarchar (120)NOT NULLMask pattern of this segment.
colorint (4)NOT NULLColor of the underline for this segment.
separatornvarchar (2)NOT NULLSeparator that appears after this segment in the mask.
sort_orderint (4)NOT NULLSort order for this account segment. A sort_order of 0 means the segment is not in the mask.
is_primarybit (1)NOT NULLIf true this Segment is to be used during the Close Year process when closing by individual segment, reporting and rounding balances.
allow_leading_zerobit (1)NOT NULLIf True 0 is saved in the code and the code is used as is. If False 0 is stripped from the code and the code is padding if necessary.
Primary key
NameColumnsDescription
PK_GL_Account_Segmentgl_account_segment_KEY
Unique constraints
NameColumnsDescription
UK_GL_Account_Segment$client_KEY$descriptionclient_KEY, description
Foreign keys
NameColumnsReferenced tableDescription
FK_GL_Account_Segment__Client__client_KEYclient_KEYClient (client_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_GL_Account_Segment_Code__GL_Account_Segment__gl_account_segment_KEYgl_account_segment_KEYGL_Account_Segment_Code
FK_GL_Account_Segment_Csa_Description__GL_Account_Segment__gl_account_segment_KEYgl_account_segment_KEYGL_Account_Segment_Csa_Description
FK_Enter_Transaction_User_Preference__GL_Account_Segment__compute_hash_with_gl_account_segment_KEYcompute_hash_with_gl_account_segment_KEYEnter_Transaction_User_Preference

Schema diagram