ODBC Driver for NetSuite

Build 24.0.9060

account

The account table.

Columns

Name Type References Description
id [KEY] Integer Internal ID
accountsearchdisplayname String Display Name
accountsearchdisplaynamecopy String Name
acctnumber String Number
accttype String Type
billableexpensesacct String Track Billable Expenses in
cashflowrate String Cash Flow Rate Type
category1099misc String 1099-MISC Category
class String Restrict to Class
currency String Currency
deferralacct String Deferral Account
department String Restrict to Department
description String Description
displaynamewithhierarchy String Display Name (with hierarchy)
eliminate Boolean Eliminate Intercompany Transactions
externalid String External ID
fullname String Full Name
generalrate String General Rate Type
includechildren Boolean Include Children
inventory Boolean Inventory
isinactive Boolean Inactive
issummary Boolean Summary
location String Restrict to Location
parent String Subaccount of
restricttoaccountingbook String Restrict to Accounting Book
revalue Boolean Revalue Open Balance for Foreign Currency Transactions
sbankcompanyid String Bank Account Number
sbankname String Bank Name
sbankroutingnumber String Bank Routing Number
sspecacct String Special Account Type
subsidiary String Subsidiaries

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060