accountingbook
The AccountingBook table defines different sets of books used for financial reporting, supporting multiple accounting standards and compliance requirements.
Columns
| Name | Type | References | Description |
| basebook | String | The base accounting book associated with this record, defining the primary ledger where financial transactions are recorded. This field ensures accurate financial reporting and compliance with accounting standards by distinguishing among different sets of books, such as GAAP, IFRS, or tax-based accounting. | |
| customform | String | The custom form used for this record, allowing organizations to tailor the layout and fields displayed when entering or viewing financial data. This field ensures that accounting entries align with company-specific workflows and reporting requirements. | |
| effectiveperiod | String | The accounting period during which this record is valid, determining the time frame for financial transactions. This field ensures that revenues, expenses, and adjustments are recognized in the correct reporting period based on accrual or cash accounting principles. | |
| externalid | String | The unique identifier (Id) assigned to this record by an external system, such as an ERP, CRM, or third-party financial application. This field facilitates seamless data exchange and integration between NetSuite and other platforms for consistent financial tracking. | |
| includechildren | Boolean | Indicates whether this record applies to child entities within the organizational hierarchy, such as subsidiaries or divisions. This setting ensures that financial structures, consolidation rules, and reporting frameworks are consistently applied across related entities. | |
| isadjustmentonly | Boolean | Indicates whether this record is restricted to adjustments only, meaning it cannot be used for standard transactions. This field ensures that specific accounts or books are reserved exclusively for financial corrections, reallocations, or reconciliation adjustments without affecting operational entries. | |
| isconsolidated | Boolean | Indicates whether this record is included in financial consolidation processes, allowing multiple entities' financial results to be aggregated. This setting ensures that organizations with multiple subsidiaries can generate consolidated financial statements while eliminating intercompany transactions where applicable. | |
| isprimary | Boolean | Indicates whether this record represents the primary accounting book for the entity, which is used as the default for financial transactions. This value ensures that accounting entries are automatically recorded in the main ledger unless a secondary book is specified for multi-book accounting compliance. | |
| name | String | The official name assigned to this record, which is used for identification in searches, reports, and system processes. This name ensures consistency in financial documentation and improves usability when managing multiple accounting books. | |
| status | String | The current status of this record, indicating whether it is active, inactive, or pending. This status determines whether the record is available for use in financial transactions and reporting, ensuring proper control over outdated or restricted entries. | |
| subsidiary | String | The subsidiary associated with this record, defining the legal entity under which transactions are recorded. This value ensures that financial data is accurately attributed to the appropriate business unit, supporting multi-entity accounting and compliance with regional financial regulations. |