ODBC Driver for QuickBooks

Build 24.0.9175

OtherNames

Manages QuickBooks 'Other Name' entities, allowing creation, updates, deletion, and queries for non-customer or vendor names.

Columns

Name Type ReadOnly References ColumnSize Description
ID [KEY] String True 255

The unique identifier for the other name entry.

Name String False 41

The name of the other name entry. This value is required when adding a new record.

IsActive Boolean False

Indicates whether the other name entry is currently active.

CompanyName String False 41

The company name associated with the customer, vendor, employee, or person listed under other names.

Salutation String False 15

A title or salutation, such as Mr., Mrs., Dr., etc., associated with the other name entry.

FirstName String False 25

The first name of the individual listed under other names.

MiddleName String False 25

The middle name of the individual listed under other names.

LastName String False 25

The last name of the individual listed under other names.

OtherNameAddress_Addr1 String False 500

The first line of the address associated with the other name entry.

OtherNameAddress_Addr2 String False 500

The second line of the address associated with the other name entry.

OtherNameAddress_Addr3 String False 500

The third line of the address associated with the other name entry.

OtherNameAddress_Addr4 String False 500

The fourth line of the address associated with the other name entry.

OtherNameAddress_Addr5 String False 41

The fifth line of the address associated with the other name entry.

OtherNameAddress_City String False 255

The city name for the address associated with the other name entry.

OtherNameAddress_State String False 255

The state or province name for the address associated with the other name entry.

OtherNameAddress_PostalCode String False 30

The postal or ZIP code for the address associated with the other name entry.

OtherNameAddress_Country String False 255

The country name for the address associated with the other name entry.

OtherNameAddress_Note String False 41

Additional notes or information about the address associated with the other name entry.

Phone String False 21

The primary phone number for the customer, vendor, employee, or person listed under other names.

AltPhone String False 41

An alternate phone number for the customer, vendor, employee, or person listed under other names.

Fax String False 21

The fax number for the customer, vendor, employee, or person listed under other names.

Email String False 1023

The email address for communication with the customer, vendor, employee, or person listed under other names.

Contact String False 41

The name of the primary contact person associated with the other name entry.

AltContact String False 41

The name of an alternate contact person associated with the other name entry.

AccountNumber String False 99

The account number linked to the other name entry.

Notes String False 5000

Any notes or additional details about the other name entry.

ExternalGUID String False

A user-defined globally unique identifier (GUID) for the other name entry, enclosed in curly brackets. Can be used only during inserts and requires QBXML 8.0 or higher.

CustomFields String False

Custom fields associated with the other name entry, formatted in XML and returned by QuickBooks.

TimeCreated Datetime True

The timestamp when the other name entry was initially created.

TimeModified Datetime True

The timestamp of the most recent modification to the other name entry.

EditSequence String True 16

A versioning identifier for this copy of the other name entry object.

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