Skip to main content
GL

AH

PX.Objects.GLRelease 2025.2

No summary is documented for this DAC in the release source.

Field NameTypeDisplay NameForeign Key
AccountIDDefault Navigation
intAccountAccount
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.
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.
BegBalanceNonexistent in DB
decimal?-
Description:Beginning balance of the account in the base currency of the branch.
BranchIDDefault Navigation
intBranchBranch
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.
CuryBegBalanceNonexistent in DB
decimal?-
Description:Beginning balance of the account in the currency of the account.
CuryFinBegBalance
decimalCuryFinBegBalance-
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
decimalCuryFinYtdBalance-
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.
CuryPtdCreditNonexistent in DB
decimal?-
Description:The period-to-date credit of the account in the currency of the account.
CuryPtdDebitNonexistent in DB
decimal?-
Description:The period-to-date debit of the account in the currency of the account.
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.
CuryYtdBalanceNonexistent in DB
decimal?-
Description:The year-to-date balance of the account in the currency of the account.
DetDeletedObsolete
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
decimalFin. 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.
FinFlagNonexistent 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
FinPeriodIDDefault Navigation
stringFinancial PeriodFinPeriod
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
decimalFin. 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
decimalFin. 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-
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.
FinYearNonexistent in DB
string-
Description:The identifier of the financial year. Determined from the FinPeriodID field.
FinYtdBalance
decimalFin. YTD 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.
LastModifiedDateTime
datetime-
Description:No description available
LedgerIDDefault Navigation
intLedgerLedger
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.
PtdCreditNonexistent in DB
decimal?-
Description:The period-to-date credit of the account in the base currency of the branch.
PtdDebitNonexistent in DB
decimal?-
Description:The period-to-date debit of the account in the base currency of the branch.
PtdRevaluedNonexistent in DB
decimal?-
Description:The period-to-date revalued balance of the account in the base currency of the branch.
REFlagNonexistent in DBObsolete
bool?-
Description:An obsolete unused field.
SubIDDefault Navigation
intSubaccountSub
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.
YtdBalanceNonexistent 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