Skip to main content
PM

OffsetAccount

PX.Objects.PM.PostGraphExtRelease 2025.2

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

Field NameTypeDisplay NameForeign Key
AccountCD
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:Identifier of the Account Group, that includes this account. Used only if the Projects module has been activated. Corresponds to the PMAccountGroup.GroupID field.
AccountID
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
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
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
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-
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
bool?Included-
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
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
nvarchar(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
int?-
Description:The user-friendly label indicating whether the account is active. Used in the reports. The value of this field depends solely on the Active flag.
RequireUnits
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
bool?-
Description:Obsolete field.
Type
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
string-
Description:The read-only label used for totals of the account type in the reports. The value of this field depends solely on the type of the account.
tstamp
timestamp-
Description:No description available