GL
GLBudgetLine2
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AccountID | int | Account | Account | |
Description:The identifier of the GL account of the budget article. Corresponds to the Account.AccountID field. The value of the field can be empty for the group articles (see IsGroup). | ||||
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 | Distributed Amount | - | |
Description:The total amount of the budget article distributed between the periods of the year. The value of this field is calculated as a sum of amounts of the detail lines of the budget article (see GLBudgetLineDetail.Amount) and cannot be edited by a user. A budget article cannot be released until its Amount and AllocatedAmount are equal to each other. | ||||
Amount | decimal | Amount | - | |
Description:The amount that is budgeted for the article for a particular year. The value can be edited by a user and indicates the decision to allocate the specified amount to the particular budget article. After the article is released, the amount can still be edited. If the amount is changed, the article will be marked as unreleased (see Released) and can be released again, which will result in updating the budget ledger figures to match the current state of the article. | ||||
BranchID | 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. | ||||
ClearedNonexistent in DB | bool? | - | ||
Description:The field is reserved for internal use. | ||||
ComparisonNonexistent in DB | bool? | - | ||
Description:No description available | ||||
CreatedByID | 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. | ||||
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. | ||||
GroupMask | varbinary | - | ||
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 | ||||
IsRolledUpNonexistent in DB | bool? | - | ||
Description:No description available | ||||
IsUploadedNonexistent in DB | bool? | - | ||
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LedgerID | int | 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. | ||||
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 | Released Amount | - | |
Description:The currently released amount of the article, which matches the figures in the budget ledger. This field is updated with the value of the Amount field upon release of the budget article. The difference between the values of this field and the Amount field shows the difference between the current state of the article and the corresponding figures in the budget ledger. | ||||
Rollup | bit | Rollup | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
SortOrderNonexistent 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 | 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. | ||||
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. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||