ODBC Driver for NetSuite

Build 25.0.9434

itemaccountmapping

Maps items to their respective general ledger accounts, helping with financial tracking and reconciliation.

Columns

Name Type References Description
accountingbook String The accounting book associated with the item account mapping, defining the financial reporting framework used for transactions.
class String The classification category assigned to the item account mapping, used for tracking and segmenting financial data.
customdimension String A customizable dimension that allows users to define and track additional categorization attributes for item account mapping.
customform String The custom form applied to this item account mapping, influencing the layout and fields available when viewed or edited.
department String The department associated with the item account mapping, helping to allocate transactions to the correct business unit.
destinationaccount String The general ledger account that serves as the destination for mapped transactions related to the specified item account.
effectivedate Date The date when this item account mapping becomes active, determining from when the mapping rules apply.
enddate Date The date when this item account mapping is no longer active, marking the end of its applicability.
externalid String A unique identifier assigned externally to the item account mapping, allowing for integration with other systems.
itemaccount String The specific item-related account being mapped, determining the financial treatment of inventory, expenses, or revenue.
location String The location associated with the item account mapping, used to allocate transactions based on geographical or business site distinctions.
sourceaccount String The original general ledger account from which transactions are being mapped to a new destination account.
subsidiary String The subsidiary to which this item account mapping applies, ensuring the correct financial reporting structure within a multi-entity organization.

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