GLBudgetTree

PX.Objects.GLScreensGL105020GL205000Release 2025.2

Represents a node in the template budget structure. The structure defines the tree of budget articles and is used when articles are preloaded into a new budget (see GLBudgetLine). Records of this type don't maintain any budget amounts and are used only to define the structure of a budget, which, however, can be altered in any budget for a particular ledger, branch and year. The class is used for both group (see IsGroup) and leaf nodes. To maintain tree structure, the class stores a link to the parent node in theParentGroupID field. Records of this type are created on the Budget Configuration (GL205000) form (see the GLBudgetTreeMaint graph).

Select a row for its description 20 of 20 fields

	Field Name	Type	Display Name	Foreign Key
	`AccountID`Default Navigation	`int`	Account	Account
Description:Identifier of the GL Account of the budget tree node. May be empty for the group (see IsGroup) nodes. Corresponds to the Account.AccountID field.
	`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.
	`GroupID`	`uniqueidentifier`	GroupID	-
Description:The unique identifier of the budget tree node.
	`GroupMask`	`varbinary`		-
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	`bool?`	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	`bool?`	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