Excel Add-In for NetSuite

Build 25.0.9434

accountType

The AccountType table categorizes accounts based on financial classification, such as assets, liabilities, income, and expenses.

Columns

Name Type References Description
internalid [KEY] Integer The system-generated unique identifier (Id)for the account type record. This Id is used internally for indexing, relationship mapping, and database reference to ensure data integrity.
balancesheet Boolean Indicates whether this account type is classified as a balance sheet account. This setting determines whether the account appears on the balance sheet or the income statement, affecting financial statement presentation and reporting.
defaultcashflowratetype String The default cash-flow rate type that is assigned to this account type. This type determines how transactions using this account type are categorized in cash flow statements, aiding in liquidity and cash management analysis.
defaultgeneralratetype String The default general rate type that is associated with this account type. This type defines how financial transactions are treated within specific accounting methodologies and reporting frameworks.
eliminationalgo String The elimination algorithm used for intercompany transactions when consolidating financial statements. This algorithm ensures that intercompany balances and transactions are correctly removed to prevent double counting in multi-entity financial reporting.
id String The unique Id for the account type, which can be used for external integrations, reporting, and system references. This Id allows consistent categorization of accounts across various financial processes.
includeinrevaldefault Boolean Indicates whether accounts of this type should be included in foreign currency revaluation by default. This setting ensures that accounts subject to currency fluctuations are appropriately revalued for accurate financial reporting.
left Boolean Indicates whether this account type appears on the left side of financial reports, typically associated with asset or debit accounts. This setting impacts financial statement formatting and presentation.
longname String The full descriptive name of the account type. This name provides a clearer understanding of the account type's purpose, making it easier for users to categorize accounts correctly.
seqnum Integer The sequence number that determines the display order of this account type in reports and financial statements. This sequence number ensures that account types are presented in a logical, structured manner for readability and compliance.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434