Table: dbo.GL_Account_Segment
Columns
Name | Type | Constraints | Description
gl_account_segment_KEY | int (4) | NOT NULL | Primary key for this table.
description | nvarchar (100) | NOT NULL | Label of the segment.
client_KEY | int (4) | NOT NULL | Key of client that owns the account segment.
mask_order | int (4) | NOT NULL | Order in which the segment appears in this Mask. A mask_order of 0 means the segment is not in the mask.
is_core | bit (1) | NOT NULL | Flag indicating the core segment of the mask.
pattern | nvarchar (120) | NOT NULL | Mask pattern of this segment.
color | int (4) | NOT NULL | Color of the underline for this segment.
separator | nvarchar (2) | NOT NULL | Separator that appears after this segment in the mask.
sort_order | int (4) | NOT NULL | Sort order for this account segment. A sort_order of 0 means the segment is not in the mask.
is_primary | bit (1) | NOT NULL | If true this Segment is to be used during the Close Year process when closing by individual segment, reporting and rounding balances.
allow_leading_zero | bit (1) | NOT NULL | If 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
Name | Columns | Description
PK_GL_Account_Segment | gl_account_segment_KEY |
Unique constraints
Name | Columns | Description
UK_GL_Account_Segment$client_KEY$description | client_KEY, description |

Foreign keys
Name | Columns | Referenced table | Description
FK_GL_Account_Segment__Client__client_KEY | client_KEY | Client (client_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_GL_Account_Segment_Code__GL_Account_Segment__gl_account_segment_KEY | gl_account_segment_KEY | GL_Account_Segment_Code |
FK_GL_Account_Segment_Csa_Description__GL_Account_Segment__gl_account_segment_KEY | gl_account_segment_KEY | GL_Account_Segment_Csa_Description |
FK_Enter_Transaction_User_Preference__GL_Account_Segment__compute_hash_with_gl_account_segment_KEY | compute_hash_with_gl_account_segment_KEY | Enter_Transaction_User_Preference |