Power BI Connector for QuickBooks

Build 23.0.8839

OtherNames

Create, update, delete, and query QuickBooks Other Name entities.

Columns

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

The unique identifier.

Name String False 41

The name of the other name. This is required to have a value when inserting.

IsActive Boolean False

Whether or not the other name is active.

CompanyName String False 41

The name of the customer, vendor, employee, or person on the other-names list.

Salutation String False 15

A salutation, such as Mr., Mrs., etc.

FirstName String False 25

The first name of a customer, vendor, employee, or person on the other-names list

MiddleName String False 25

The middle name of a customer, vendor, employee, or person on the other-names list.

LastName String False 25

The last name of a customer, vendor, employee, or person on the other-names list.

OtherNameAddress_Addr1 String False 500

First line of the other-name address.

OtherNameAddress_Addr2 String False 500

Second line of the other-name address.

OtherNameAddress_Addr3 String False 500

Third line of the other-name address.

OtherNameAddress_Addr4 String False 500

Fourth line of the other-name address.

OtherNameAddress_Addr5 String False 41

Fifth line of the other-name address.

OtherNameAddress_City String False 255

City name for the other-name address of the customer, vendor, employee, or person on the other-names list.

OtherNameAddress_State String False 255

State name for the other-name address of the customer, vendor, employee, or person on the other-names list.

OtherNameAddress_PostalCode String False 30

Postal code for the other name address of the customer, vendor, employee, or person on the other-names list.

OtherNameAddress_Country String False 255

Country for the other-name address of the customer, vendor, employee, or person on the other-names list.

OtherNameAddress_Note String False 41

Note for the other-name address of the customer, vendor, employee, or person on the other-names list.

Phone String False 21

The main telephone number for the customer, vendor, employee, or person on the other-names list.

AltPhone String False 41

The alternate telephone number for the customer, vendor, employee, or person on the other-names list.

Fax String False 21

The fax number number for the customer, vendor, employee, or person on the other-names list.

Email String False 1023

The email address for communicating with the customer, vendor, employee, or person on the other-names list.

Contact String False 41

The name of a contact person for the customer, vendor, employee, or person on the other-names list.

AltContact String False 41

The name of an alternate contact person for the customer, vendor, employee, or person on the other-names list.

AccountNumber String False 99

The account number for the other-name.

Notes String False 5000

Notes on this customer, vendor, employee, or person on the other-names list.

ExternalGUID String False

Allows for the attachment of a user-defined GUID value. Can be used in only inserts and the value must be enclosed in curly brackets. Requires QBXML 8.0 or higher.

CustomFields String False

Custom fields returned from QuickBooks and formatted into XML.

TimeCreated Datetime True

The datetime the other name was made.

TimeModified Datetime True

The last datetime the other name was modified.

EditSequence String True 16

An identifier used for versioning for this copy of the object.

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