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. |