GL
GLBudgetLineDetail
Stores the amount budgeted for a particular financial period under a certain article of a budget (see GLBudgetLine). The record is related to the master budget article via the (BranchID, LedgerID, FinYear, GroupID) tuple. The compound key includes all of the above fields and the FinPeriodID field.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AccountID | int | Account | ||
Description:The identifier of the GL account of the budget article. Corresponds to the Account.AccountID field. The value of this field is inherited from the GLBudgetLine.AccountID field of the master record. | ||||
Amount | decimal | Budget Amount | - | |
Description:The amount allocated to the specified financial period. The value is specified by a user or assigned by one of the procedures that distribute budgeted amounts. The values of these fields of detail lines are summed up to the GLBudgetLine.Amount field of the master record. | ||||
BranchID | int | 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. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
FinPeriodID | nvarchar(6) | - | ||
Description:The identifier of the financial period, which is represented by the record. This field is a part of the compound key. Corresponds to the FinPeriod.FinPeriodID field. | ||||
FinYear | char(4) | - | ||
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 | GLBudgetLine | |
Description:The identifier of the budget article. This field is a part of the compound key. Corresponds to the GLBudgetLine.GroupID field of the master record. | ||||
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. | ||||
ReleasedAmount | decimal | Released Amount | - | |
Description:The currently released amount for the specified financial period. This field is updated with the value of the Amount field upon release of the corresponding budget article. The difference between the value 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. | ||||
SubID | int | Subaccount | Sub | |
Description:The identifier of the GL subaccount of the budget article. Corresponds to the Sub.SubID field. The value of this field is inherited from the GLBudgetLine.SubID field of the master record. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||