RevaluedGLHistory

PX.Objects.CMRelease 2025.2

The DAC represents a view into the base GLHistory entity and provides information required for the GL Accounts Revaluation process (see RevalueGLAccounts). Records of this type are used to select and display data from GLHistory prior to revaluation process (see RevalueGLAccounts.glaccountlist). The revaluation process itself is also performed based on these records and makes adjustments and generates transactions from them (see .

Select a row for its description 50 of 50 fields

	Field Name	Type	Display Name	Foreign Key
	`AccountID`Default Navigation	`int`	Account	Account
Description:The identifier of the account associated with the history record. This field is a part of the compound key of the record. Corresponds to the Account.AccountID field.
	`AccountType`Nonexistent in DB	`string`	Type	-
Description:No description available
	`AllocBegBalance`	`decimal`		-
Description:The beginning allocation balance (the amount allocated for periods preceding the period of the history record).
	`AllocPtdBalance`	`decimal`		-
Description:The period-to-date allocation balance (the amount allocated since the beginning of the period of the history record).
	`BalanceType`	`char(1)`	Balance Type	-
Description:The type of the balance. Allowed values are: ""A"" - Actual, ""R"" - Reporting, ""S"" - Statistical, ""B"" - Budget. See Ledger.BalanceType.
	`BegBalance`Nonexistent in DB	`decimal?`		-
Description:Beginning balance of the account in the base currency of the branch.
	`BranchID`Default Navigation	`int`	Branch	Branch
Description:The identifier of the branch associated with the history record. This field is a part of the compound key of the record. Corresponds to the Branch.BAccountID field.
	`CuryBegBalance`Nonexistent in DB	`decimal?`		-
Description:Beginning balance of the account in the currency of the account.
	`CuryEffDate`Nonexistent in DB	`DateTime?`		-
Description:No description available
	`CuryFinBegBalance`	`decimal`	CuryFinBegBalance	-
Description:The beginning balance of the account in the currency of the account. The value of this field is based on the GLTran.FinPeriodID field, which can be overridden by the user. See also CuryTranBegBalance.
	`CuryFinPtdCredit`	`decimal`		-
Description:The period-to-date credit total of the account in the currency of the account. The value of this field is based on the GLTran.FinPeriodID field, which can be overridden by the user. See also CuryTranPtdCredit.
	`CuryFinPtdDebit`	`decimal`		-
Description:The period-to-date debit total of the account in the currency of the account. The value of this field is based on the GLTran.FinPeriodID field, which can be overridden by the user. See also CuryTranPtdDebit.
	`CuryFinYtdBalance`	`decimal`	Foreign Currency Balance	-
Description:The year-to-date balance of the account in the currency of the account. The value of this field is based on the GLTran.FinPeriodID field, which can be overridden by the user. See also CuryTranYtdBalance.
	`CuryID`	`nvarchar(5)`		Currency
Description:Identifier of the Currency of the history record. Corresponds to the Currency.CuryID field.
	`CuryMultDiv`Nonexistent in DB	`string`		-
Description:No description available
	`CuryPtdCredit`Nonexistent in DB	`decimal?`		-
Description:The period-to-date credit of the account in the currency of the account.
	`CuryPtdDebit`Nonexistent in DB	`decimal?`		-
Description:The period-to-date debit of the account in the currency of the account.
	`CuryRate`Nonexistent in DB	`decimal?`	Currency Rate	-
Description:No description available
	`CuryRateTypeID`Default NavigationNonexistent in DB	`string`	Currency Rate Type	CurrencyRateType
Description:No description available
	`CuryTranBegBalance`	`decimal`		-
Description:The beginning balance of the account in the currency of the account.
	`CuryTranPtdCredit`	`decimal`		-
Description:The period-to-date credit of the account in the currency of the account. The value of this field is based on the GLTran.TranPeriodID field, which cannot be overridden by the user and is determined by the date of the transactions. See also CuryFinPtdCredit.
	`CuryTranPtdDebit`	`decimal`		-
Description:The period-to-date debit of the account in the currency of the account. The value of this field is based on the GLTran.TranPeriodID field, which cannot be overridden by the user and is determined by the date of the transactions. See also CuryFinPtdDebit.
	`CuryTranYtdBalance`	`decimal`		-
Description:The year-to-date balance of the account in the currency of the account. The value of this field is based on the GLTran.TranPeriodID field, which cannot be overridden by the user and is determined by the date of the transactions. See also CuryFinYtdBalance.
	`CuryYtdBalance`Nonexistent in DB	`decimal?`		-
Description:The year-to-date balance of the account in the currency of the account.
	`DetDeleted`Obsolete	`bit`		-
Description:An unused obsolete field. In the past, it was used to indicate that the related account or subaccount had been deleted from the system so as to exclude the corresponding financial periods from GL balance validation process.
	`FinBegBalance`	`decimal`	Fin. Begining Balance	-
Description:The beginning balance of the account in the base currency of the branch. The value of this field is based on the GLTran.FinPeriodID field, which can be overridden by the user. See also TranBegBalance.
	`FinFlag`Nonexistent in DB	`bool?`		-
Description:The flag determining the balance fields, to which the PtdCredit, PtdDebit, YtdBalance, BegBalance, PtdRevalued and their Cury* counterparts are mapped. When set to "true", the above fields are mapped to their Fin* analogs (e.g. PtdDebit will represent - get and set - FinPtdDebit), otherwise they are mapped to their Tran* analogs (e.g. PtdDebit corresponds to TranPtdDebit
	`FinPeriodID`Default Navigation	`string`	Financial Period	FinPeriod
Description:The identifier of the financial period of the history record. This field is a part of the compound key of the record. Corresponds to the FinPeriod.FinPeriodID field.
	`FinPtdCredit`	`decimal`	Fin. PTD Credit	-
Description:The period-to-date credit total of the account in the base currency of the branch. The value of this field is based on the GLTran.FinPeriodID field, which can be overridden by the user. See also TranPtdCredit.
	`FinPtdDebit`	`decimal`	Fin. PTD Debit	-
Description:The period-to-date debit total of the account in the base currency of the branch. The value of this field is based on the GLTran.FinPeriodID field, which can be overridden by the user. See also TranPtdDebit.
	`FinPtdRevalued`	`decimal`	Difference	-
Description:The period-to-date revalued balance of the account in the base currency of the branch. The value of this field is based on the GLTran.FinPeriodID field, which can be overridden by the user. There is no corresponding amount field that depends on the GLTran.TranPeriodID field.
	`FinYear`Nonexistent in DB	`string`		-
Description:The identifier of the financial year. Determined from the FinPeriodID field.
	`FinYtdBalance`	`decimal`	Original Balance	-
Description:The year-to-date balance of the account in the base currency of the branch. The value of this field is based on the GLTran.FinPeriodID field, which can be overridden by the user. See also TranYtdBalance.
	`FinYtdRevalued`Nonexistent in DB	`decimal?`	Revalued Balance	-
Description:No description available
	`LastModifiedDateTime`	`datetime`		-
Description:No description available
	`LastRevaluedFinPeriodID`	`string`	Last Revaluation Period	-
Description:No description available
	`LedgerID`Default Navigation	`int`	Ledger	Ledger
Description:The identifier of the ledger associated with the history record. This field is a part of the compound key of the record. Corresponds to the Ledger.LedgerID field.
	`PtdCredit`Nonexistent in DB	`decimal?`		-
Description:The period-to-date credit of the account in the base currency of the branch.
	`PtdDebit`Nonexistent in DB	`decimal?`		-
Description:The period-to-date debit of the account in the base currency of the branch.
	`PtdRevalued`Nonexistent in DB	`decimal?`		-
Description:The period-to-date revalued balance of the account in the base currency of the branch.
	`REFlag`Nonexistent in DBObsolete	`bool?`		-
Description:An obsolete unused field.
	`RateReciprocal`Nonexistent in DB	`decimal?`		-
Description:No description available
	`Selected`Nonexistent in DB	`bool?`	Selected	-
Description:No description available
	`SubID`Default Navigation	`int`	Subaccount	Sub
Description:The identifier of the subaccount associated with the history record. This field is a part of the compound key of the record. Corresponds to the Sub.SubID field.
	`TranBegBalance`	`decimal`		-
Description:The beginning balance of the account in the base currency of the branch. The value of this field is based on the GLTran.TranPeriodID field, which cannot be overridden by the user and is determined by the date of the transactions. See also FinBegBalance.
	`TranPtdCredit`	`decimal`		-
Description:The period-to-date credit total of the account in the base currency of the branch. The value of this field is based on the GLTran.TranPeriodID field, which cannot be overridden by the user and is determined by the date of the transactions. See also FinPtdCredit.
	`TranPtdDebit`	`decimal`		-
Description:The period-to-date debit total of the account in the base currency of the branch. The value of this field is based on the GLTran.TranPeriodID field, which cannot be overridden by the user and is determined by the date of the transactions. See also FinPtdDebit.
	`TranYtdBalance`	`decimal`		-
Description:The year-to-date balance of the account in the base currency of the branch. The value of this field is based on the GLTran.TranPeriodID field, which cannot be overridden by the user and is determined by the date of the transactions. See also FinYtdBalance.
	`YtdBalance`Nonexistent in DB	`decimal?`		-
Description:The year-to-date balance of the account in the base currency of the branch.
	`tstamp`	`timestamp`		-
Description:No description available