GL
GLHistory
PX.Objects.GL31 of 31 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AccountID | int | Account | Account | |
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
FinPeriodID | char(6) | Financial Period | - | |
Description:No description available | ||||
LedgerID | int | Ledger | Ledger | |
Description:No description available | ||||
SubID | int | Subaccount | Sub | |
Description:No description available | ||||
AllocBegBalance | decimal(19, 4) | - | ||
Description:The beginning allocation balance (the amount allocated for periods preceding the period of the history record). | ||||
AllocPtdBalance | decimal(19, 4) | - | ||
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:No description available | ||||
CuryFinBegBalance | decimal(19, 4) | CuryFinBegBalance | - | |
Description:No description available | ||||
CuryFinPtdCredit | decimal(19, 4) | - | ||
Description:No description available | ||||
CuryFinPtdDebit | decimal(19, 4) | - | ||
Description:No description available | ||||
CuryFinYtdBalance | decimal(19, 4) | CuryFinYtdBalance | - | |
Description:No description available | ||||
CuryID | nvarchar(5) | Currency | ||
Description:No description available | ||||
CuryTranBegBalance | decimal(19, 4) | - | ||
Description:No description available | ||||
CuryTranPtdCredit | decimal(19, 4) | - | ||
Description:No description available | ||||
CuryTranPtdDebit | decimal(19, 4) | - | ||
Description:No description available | ||||
CuryTranYtdBalance | decimal(19, 4) | - | ||
Description:No description available | ||||
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(19, 4) | Fin. Begining Balance | - | |
Description:No description available | ||||
FinPtdCredit | decimal(19, 4) | Fin. PTD Credit | - | |
Description:No description available | ||||
FinPtdDebit | decimal(19, 4) | Fin. PTD Debit | - | |
Description:No description available | ||||
FinPtdRevalued | decimal(19, 4) | - | ||
Description:No description available | ||||
FinYear | nvarchar(MAX) | - | ||
Description:The identifier of the financial year. Determined from the FinPeriodID field. | ||||
FinYtdBalance | decimal(19, 4) | Fin. YTD Balance | - | |
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
REFlagNonexistent in DBObsolete | bit | - | ||
Description:No description available | ||||
TranBegBalance | decimal(19, 4) | - | ||
Description:No description available | ||||
TranPtdCredit | decimal(19, 4) | - | ||
Description:No description available | ||||
TranPtdDebit | decimal(19, 4) | - | ||
Description:No description available | ||||
TranYtdBalance | decimal(19, 4) | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||