PM
OffsetAccount
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AccountCD | nvarchar(10) | Account | - | |
Description:Key field. The user-friendly unique identifier of the account. | ||||
AccountClassID | nvarchar(20) | Account Class | AccountClass | |
Description:Identifier of the account class, to which the account is assigned. Corresponds to the AccountClass.AccountClassID field. | ||||
AccountGroupID | int | Account Group | PMAccountGroup | |
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 | int | Account 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 | bit | Active | - | |
Description:Indicates whether the Account is active. | ||||
AllowManualEntry | bit | Allow Manual Entry | - | |
Description:Are direct transations from all subledgers available to this account. | ||||
Box1099 | smallint | 1099 Box | - | |
Description:The box on the 1099 form associated with this account. | ||||
COAOrder | smallint | COA 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. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CuryID | nvarchar(5) | Currency | Currency | |
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 | bit | Direct Post | - | |
Description:Reserved for backward compatibility. | ||||
GLConsolAccountCD | nvarchar(30) | Consolidation Account | Account | |
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 | bit | Cash Account | - | |
Description:Indicates whether the accounts has on or several Cash Accounts associated with it. | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
NoSubDetail | bit | Use 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 | bit | Require 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". | ||||
RevalCuryRateTypeId | nvarchar(6) | Revaluation Rate Type | CurrencyRateType | |
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. | ||||
TaxCategoryID | nvarchar(15) | Tax Category | TaxCategory | |
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 | ||||