GL
AH
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 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. | ||||
BranchID | 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. | ||||
CuryBegBalanceNonexistent in DB | decimal? | - | ||
Description:Beginning balance of the account in the currency of the account. | ||||
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 | CuryFinYtdBalance | - | |
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 | 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. | ||||
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 | ||||
FinPeriodID | 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 | - | ||
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 | decimal | Fin. 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 | ||||
LedgerID | 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. | ||||
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. | ||||
SubID | 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. | ||||
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 | ||||