GLBudgetLine

PX.Objects.GL

34 of 34 fields

	Field Name	Type	Display Name	Foreign Key
	`BranchID`Default Navigation	`int`	Branch	Branch
Description:The identifier of the branch to which the budget article belongs. This field is a part of the compound key. Corresponds to the Branch.BranchID field.
	`FinYear`	`char(4)`	Financial Year	-
Description:The financial year to which the budget article belongs. This field is a part of the compound key. Corresponds to the FinYear.year field.
	`GroupID`	`uniqueidentifier`	GroupID	-
Description:The unique identifier of the budget article. This field is a part of the compound key.
	`LedgerID`Default Navigation	`int`	LedgerID	Ledger
Description:The identifier of the ledger to which the budget article belongs. This field is a part of the compound key. Corresponds to the Ledger.LedgerID field.
	`AccountID`Default Navigation	`int`	Account	Account
Description:No description available
	`AccountMask`	`nvarchar(10)`	Account Mask	-
Description:For a group article (see IsGroup), defines the mask for selection of the child budget articles by their accounts. The selector on the AccountID field of the child articles allows only accounts whose Account.AccountCD matches the specified mask.
	`AllocatedAmount`	`decimal(19, 4)`	Distributed Amount	-
Description:No description available
	`Amount`	`decimal(19, 4)`	Amount	-
Description:No description available
	`Cleared`Nonexistent in DB	`bit`		-
Description:The field is reserved for internal use.
	`Comparison`Nonexistent in DB	`bit`		-
Description:No description available
	`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 article. Defaults to the description of the account, but can be overwritten by user.
	`GroupMask`	`varbinary(32)`		-
Description:The group mask showing which restriction groups the budget article belongs to. The value of this field is inherited from the group mask of the corresponding budget tree node, because access to budgets is managed through the budget tree configuration.
	`IsGroup`	`bit`	Node	-
Description:Specifies (if set to "true") that the budget article represents a group of other articles. That is, the article has child articles, which are linked to this article by their ParentGroupID field.
	`IsPreloaded`	`bit`	Preloaded	-
Description:No description available
	`IsRolledUp`Nonexistent in DB	`bit`		-
Description:No description available
	`IsUploaded`Nonexistent in DB	`bit`		-
Description:No description available
	`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
	`NoteID`	`uniqueidentifier`		-
Description:No description available
	`ParentGroupID`	`uniqueidentifier`	ParentGroupID	-
Description:The identifier of the parent budget article. This field is a part of the compound key. Corresponds to the GLBudgetLine.GroupID field of the parent. The value is equal to Guid.Empty for the nodes on the first level of the tree.
	`Released`	`bit`	Released	-
Description:Specifies (if set to "true") that the budget article has been released at least once. A released article can be released again if its Amount is not equal to its ReleasedAmount.
	`ReleasedAmount`	`decimal(19, 4)`	Released Amount	-
Description:No description available
	`Rollup`	`bit`	Rollup	-
Description:No description available
	`Selected`Nonexistent in DB	`bit`	Selected	-
Description:No description available
	`SortOrder`Nonexistent in DB	`int`		-
Description:The internal field that defines the order in which non-group budget articles appear relative to each other. This field is populated only in the GLBudgetEntry graph and is not stored in the database.
	`SubID`Default Navigation	`int`	Subaccount	Sub
Description:The identifier of the GL subaccount of the budget article. Corresponds to the Sub.SubID field. Can be empty for the group articles (see IsGroup).
	`SubMask`	`nvarchar(30)`	Subaccount Mask	-
Description:For a group article (see IsGroup), defines the mask for selection of the child budget articles by their subaccounts. The selector on the SubID field of the child articles allows only subaccounts whose Sub.SubCD matches the specified mask.
	`TreeSortOrder`	`int`	TreeSortOrder	-
Description:An integer field that defines the order in which group budget articles (see IsGroup) that belong to one parent appear relative to each other in the tree view. The value of this field is automatically assigned during budget tree preload from GLBudgetTree.SortOrder of the corresponding tree node.
	`tstamp`	`timestamp`		-
Description:No description available
	`WasReleased`	`bit`		-
Description:Specifies (if set to "true") that the article was released at least once. Different from Released in that the latter will be reset to "false" upon edits of a released article, while this field will still be "true" even if the article can be released again.