GLBudgetTree

PX.Objects.GL

20 of 20 fields

	Field Name	Type	Display Name	Foreign Key
	`GroupID`	`uniqueidentifier`	GroupID	-
Description:The unique identifier of the budget tree node.
	`AccountID`Default Navigation	`int`	Account	Account
Description:No description available
	`AccountMask`	`nvarchar(10)`	Account Mask	-
Description:For a group node (see IsGroup), defines the mask for selection of the child budget tree nodes by their accounts. The selector on the AccountID field of the child nodes allows only accounts, whose Account.AccountCD matches the specified mask.
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`char(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`		-
Description:No description available
	`Description`	`nvarchar(150)`	Description	-
Description:The description of the budget tree node. Defaults to the description of the account, but can be overwritten by a user.
	`GroupMask`	`varbinary(32)`		-
Description:The group mask showing which restriction groups the budget tree node belongs to. To learn more about the way restriction groups are managed, see the documentation for the GL Account Access (GL104000) form (which corresponds to the GLAccess graph).
	`Included`Nonexistent in DB	`bit`	Included	-
Description:An unbound field that is used in the user interface to include the budget tree node into a restriction group. Also see GLBudgetTree.GroupMask.
	`IsGroup`	`bit`	Node	-
Description:The identifier of the GL account of the budget tree node. The value of the field can be empty for the group nodes(seeIsGroup).
	`LastModifiedByID`Default Navigation	`uniqueidentifier`	Last Modified By	Users
Description:No description available
	`LastModifiedByScreenID`	`char(8)`		-
Description:No description available
	`LastModifiedDateTime`	`datetime`		-
Description:No description available
	`ParentGroupID`	`uniqueidentifier`	ParentGroupID	GLBudgetTree
Description:The identifier of the parent budget tree node. Corresponds to the GroupID field. The value is equal to Guid.Empty for the nodes on the first level of the tree.
	`Rollup`	`bit`	Rollup	-
Description:No description available
	`Secured`Nonexistent in DB	`bit`	Secured	-
Description:An unbound field that indicates (if set to "true") that access to the budget tree node is restricted, because the node is included into a restriction group or groups. This field is populated only in the context of the Budget Configuration (GL205000) form (GLBudgetTreeMaint).
	`SortOrder`	`int`	Sort Order	-
Description:An integer field that defines the order in which budget tree nodes that belong to one parent appear relative to each other. The value of this field is changed by users when they move budget tree nodes by using the corresponding actions on the Budget Configuration (GL205000) form.
	`SubID`Default Navigation	`int`	Subaccount	Sub
Description:The identifier of the GL subaccount of the budget tree node. Corresponds to the Sub.SubID field. The value of the field can be empty for the group (see IsGroup) nodes.
	`SubMask`	`nvarchar(30)`	Subaccount Mask	-
Description:For a group node (see IsGroup), defines the mask for selection of the child budget tree nodes by their subaccounts. The selector on the SubID field of the child nodes allows only subaccounts, whose Sub.SubCD matches the specified mask.
	`TStamp`	`timestamp`		-
Description:No description available