JDBC Driver for NetSuite

Build 22.0.8462

entity

The entity table.

Columns

Name Type References Description
id [KEY] Integer Internal ID
altemail String Alt. Email
altname String Name
altphone String Alt. Phone
comments String Comments
contact Integer Contact
customer Integer Customer
datecreated Date Date Created
email String Email
employee Integer Employee
entityid String Entity ID
entitynumber Integer Number
entitytitle String Name/ID
externalid String External ID
fax String Fax
firstname String First Name
genericresource Integer Generic Resource
group Integer Group
homephone String Home Phone
isinactive Boolean Inactive
isperson Boolean Is Individual
laborcost Decimal Labor Cost
lastmodifieddate Datetime Last Modified Date
lastname String Last Name
middlename String Middle Name
mobilephone String Mobile Phone
othername Integer Other Name
parent Integer Parent
partner Integer Partner
phone String Phone
phoneticname String Furigana
project Integer Project
projecttemplate Integer Project Template
salutation String Mr./Ms...
title String Job Title
toplevelparent Integer Top Level Parent
vendor Integer Vendor
type String Type

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462