Skip to main content
GL

Account

PX.Objects.GL
Field NameTypeDisplay NameForeign Key
AccountCD API
nvarchar(10)Account-
Description:Key field. The user-friendly unique identifier of the account.
AccountClassIDDefault Navigation
nvarchar(20)Account ClassAccountClass
Description:Identifier of the account class, to which the account is assigned. Corresponds to the AccountClass.AccountClassID field.
AccountGroupIDDefault Navigation
intAccount GroupPMAccountGroup
Description:No description available
AccountID API
intAccount ID-
Description:Unique identifier of the account. Database identity.
AccountingType
char(1)-
Description:The type of the Entity. Extensibility point. Possible values are: ""F"" - Financial Accounting, Account
Active API
bitActive-
Description:Indicates whether the Account is active.
AllowManualEntry
bitAllow Manual Entry-
Description:Are direct transations from all subledgers available to this account.
Box1099
smallint1099 Box-
Description:The box on the 1099 form associated with this account.
COAOrder
smallintCOA Order-
Description:The relative order of the account in the chart of accounts. The value of this field is used to order accounts in the reports of the General Ledger module, when Custom Order option is selected in the GLSetup.COAOrder field of the GL Preferences.
ControlAccountModule
char(2)Control Account Module-
Description:Acumatica module for witch the Account is control account. Allowed values are: ""AP"" - Accounts Payable, ""AR"" - Accounts Receivable, ""TX"" - TX, ""FA"" - Fixed Assets, ""DR"" - Deferred Revenue, ""SO"" - Sales Order, ""PO"" - Purchase Order, ""IN"" - Inventory. Defaults to the type, specified in the account class.
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
char(8)-
Description:No description available
CreatedDateTime API
datetime-
Description:No description available
CuryIDDefault Navigation
nvarchar(5)CurrencyCurrency
Description:Identifier of the Currency of the account. Corresponds to the Currency.CuryID field.
Description API
nvarchar(60)Description-
Description:The description of the account.
DirectPost
bitDirect Post-
Description:Reserved for backward compatibility.
GLConsolAccountCDDefault Navigation
nvarchar(30)Consolidation AccountAccount
Description:The identifier of the external General Ledger account in the chart of accounts of the parent company, to which the balance of this account will be exported in the process of consolidation. This field is relevant only if the company is a consolidation unit in the parent company.
GroupMask
varbinary(32)-
Description:The group mask showing which restriction groups the Account belongs to. To learn more about the way restriction groups are managed, see the documentation for the GL Account Access (GL104000) form (which corresponds to the GLAccess graph).
IncludedNonexistent in DB
bitIncluded-
Description:An unbound field used in the User Interface to include the Account into a restriction group. To learn more about the way restriction groups are managed, see the documentation for the GL Account Access (GL104000) form (which corresponds to the GLAccess graph).
IsCashAccount
bitCash Account-
Description:Indicates whether the accounts has on or several Cash Accounts associated with it.
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified ByUsers
Description:No description available
LastModifiedByScreenID
char(8)-
Description:No description available
LastModifiedDateTime API
datetime-
Description:No description available
NoSubDetail
bitUse Default Subaccount-
Description:If set to "true", indicates that the system must set the subaccount to the default subaccount, when this account is selected for a document or transaction. Defaults to "false".
NoteID
uniqueidentifier-
Description:Identifier of the Note object, associated with the document. Corresponds to the Note.NoteID field.
PostOption API
char(1)Post Option-
Description:Defines how the transactions created in other modules are posted to this account. In the scope of the account overrides the APSetup.SummaryPost, ARSetup.SummaryPost and similar settings in other modules. Allowed values are: ""S"" - Summary (transactions amounts are summarized for each account and subaccount pair), ""D"" - Details (each transaction from other module results in a journal transaction. Defaults to ""D"" - Detail.
ReadableActiveNonexistent in DB
intReadableActive-
Description:No description available
RequireUnits API
bitRequire Units-
Description:When set to "true", indicates that every transaction posted to this account must have Qunatity and Units of Measure specified. Defaults to "false".
RevalCuryRateTypeIdDefault Navigation
nvarchar(6)Revaluation Rate TypeCurrencyRateType
Description:The identifier of the Exchange Rate Type that is used for the account in the process of revaluation. This field is required only for the accounts denominated to a foreign currency. Corresponds to the CurrencyRateType.CuryRateTypeID field.
TaxCategoryIDDefault Navigation
nvarchar(15)Tax CategoryTaxCategory
Description:Identifier of the Tax Category associated with the account. Corresponds to the TaxCategory.TaxCategoryID field.
TransactionsForGivenCurrencyExistsNonexistent in DBObsolete
bit-
Description:Obsolete field.
tstamp
timestamp-
Description:No description available
Type API
char(1)Type-
Description:The type of the account. Allowed values are: ""A"" - Asset, ""L"" - Liability, ""I"" - Income, ""E"" - Expense. Defaults to the type, specified in the account class.
TypeTotalNonexistent in DB
nvarchar(1)TypeTotal-
Description:No description available