Skip to main content
GL

Ledger

PX.Objects.GL
Field NameTypeDisplay NameForeign Key
LedgerCDDefault Navigation
nvarchar(10)Ledger ID-
Description:Key field. Unique user-friendly identifier of the Ledger.
BalanceType
char(1)Type-
Description:The type of the balance of the ledger. Possible values are: ""A"" - Actual, ""R"" - Reporting, ""S"" - Statistical, ""B"" - Budget.
BaseCuryIDDefault Navigation
nvarchar(5)CurrencyCurrency
Description:Base Currency of the Ledger. Corresponds to the Currency.CuryID field. Defaults to the base currency of the company.
ConsolAllowed
bitConsolidation Source-
Description:When set to "true", indicates that the system must use the Ledger as a source Ledger for consolidation. Defaults to "false".
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
char(8)-
Description:No description available
CreatedDateTime
datetimeCreated On-
Description:No description available
DefBranchIDObsolete
int-
Description:The identifier of the consolidating Branch of the Ledger. Corresponds to the Branch.BranchID field.
Descr
nvarchar(60)Description-
Description:The description of the Ledger.
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified ByUsers
Description:No description available
LastModifiedByScreenID
char(8)-
Description:No description available
LastModifiedDateTime API
datetimeLast Modified On-
Description:No description available
LedgerID API
intLedger ID-
Description:Database identity. Unique identifier of the Ledger.
NoteID
uniqueidentifier-
Description:No description available
OrganizationID
intOrganization
Description:Reference to Organization record. The field is filled only for ledgers of actual type and is used for data denormalization.
PostInterCompanyObsolete
bitBranch Accounting-
Description:When set to "true", indicates that the system must automatically generate inter-branch transactions for this Ledger to balance transactions for all branches involved. This field is relevant only if the Inter-Branch Transactions feature has been activated and the Consolidating Branch is specified. Defaults to "false".
SelectedNonexistent in DB
bitSelected-
Description:Indicates whether the Ledger is selected for processing.
tstamp
timestamp-
Description:No description available