account
The Account table stores financial account details, including general ledger accounts used for recording transactions.
Columns
| Name | Type | References | Description |
| id [KEY] | Integer | The system-generated identifier for the account record (Id). This Id is used internally for database indexing, relationship mapping, and uniquely distinguishing accounts within NetSuite. | |
| accountsearchdisplayname | String | The display name of the account, which appears in search results and lists for easier identification. This name can differ from the official account name to improve usability. | |
| accountsearchdisplaynamecopy | String | A duplicate of the account's primary name, often used for reporting consistency and alternative naming conventions in different system views. | |
| acctnumber | String | The unique account number assigned to the general ledger account. This number is used in financial transactions, reporting, and reconciliation processes. | |
| accttype | String | The financial category assigned to the account, determining its function in accounting processes. Common types include Asset, Liability, Equity, Income, and Expense. These types dictate how transactions impact financial statements. | |
| billableexpensesacct | String | The designated general ledger account used to track billable expenses. This account ensures that reimbursable costs incurred on behalf of customers are properly recorded and included in invoices. | |
| cashflowrate | String | The method that is used to categorize the account’s impact on cash flow, affecting financial planning and cash management strategies. Common classifications include Operating, Investing, and Financing activities. | |
| category1099misc | String | The IRS 1099-MISC tax category assigned to the account, used for tracking reportable payments to vendors and independent contractors. This classification is necessary for tax compliance and annual reporting. | |
| class | String | A classification used to segment transactions by department, division, or function for internal reporting and budgeting purposes. This classification helps organizations analyze financial data across different operational areas. | |
| currency | String | The currency in which transactions for this account are recorded. This currency is particularly relevant for multi-currency environments where financial activities occur in different denominations. | |
| deferralacct | String | The general ledger account used for revenue or expense deferrals. Deferral accounts are crucial for recognizing revenue and expenses in the correct accounting period under accrual accounting principles. | |
| department | String | The department associated with this account, allowing transactions to be allocated to specific organizational units. Departments help track financial performance at a more granular level. | |
| description | String | A detailed explanation of the account’s purpose, usage, and role in financial transactions. This explanation helps users understand the function of the account within the chart of accounts. | |
| displaynamewithhierarchy | String | The display name of the account, including its position within a hierarchical structure. This name is useful for organizations that use parent-child account relationships to organize financial data. | |
| eliminate | Boolean | Indicates whether intercompany transactions involving this account should be eliminated during financial consolidation. This value is used to prevent double counting of revenue or expenses in multi-entity organizations. | |
| externalid | String | A unique Id assigned to the account by an external system, enabling seamless integration and data exchange with third-party applications. | |
| fullname | String | The complete name of the account, including any hierarchical context. This name helps users identify the account’s role in financial reporting when multiple accounts have similar names. | |
| generalrate | String | The default rate type assigned to transactions for this account, used in financial calculations, allocations, and revenue recognition models. | |
| includechildren | Boolean | Indicates whether financial data from child accounts should be included in reports for this account. Used in roll-up reporting where summary accounts aggregate data from multiple subaccounts. | |
| inventory | Boolean | Specifies whether the account is linked to inventory management. If the value is 'true', this account is involved in tracking stock levels, cost of goods sold (COGS), and inventory valuation. | |
| isinactive | Boolean | Indicates whether the account is marked as inactive. Inactive accounts are hidden from selection in transactions but remain in historical records for auditing and reporting purposes. | |
| issummary | Boolean | Indicates whether the account functions as a summary account, aggregating financial data from multiple subaccounts rather than recording direct transactions. | |
| location | String | The specific geographic or operational location assigned to the account. This location is used for regional financial tracking and compliance with location-based reporting requirements. | |
| parent | String | The parent account within a hierarchical chart of accounts. This structure is used for financial roll-ups where subaccounts report to a higher-level account. | |
| restricttoaccountingbook | String | Specifies whether this account is limited to a specific accounting book. This value is used in multi-book accounting environments where different financial ledgers operate under distinct reporting standards. | |
| revalue | Boolean | Indicates whether foreign currency balances in this account should be revalued based on fluctuating exchange rates. This value is essential for companies dealing with multi-currency transactions to ensure accurate financial reporting. | |
| sbankcompanyid | String | The company-assigned Id for a linked bank account. This Id is used for payment processing, reconciliations, and electronic funds transfers (EFT). | |
| sbankname | String | The name of the financial institution where the account is held. This name is used in banking transactions, reconciliations, and electronic payments. | |
| sbankroutingnumber | String | The bank routing number associated with the account, used for processing wire transfers, ACH transactions, and direct deposits. | |
| sspecacct | String | Specifies whether this account is designated as a special account type, such as a clearing account, suspense account, or system-generated control account. | |
| subsidiary | String | The subsidiaries that use this account for financial transactions. This information is relevant for multi-entity organizations to ensure proper financial tracking and reporting across different business units. |