JDBC Driver for MYOB

Build 22.0.8462

ContactAddressItems

Contact address items.

Table Specific Information

Select

The driver will process all filters client side.

Columns

Name Type Description
ContactID [KEY] Uuid Unique identifier in the form of a guid.
City String City of address record.
ContactName String Contact Name on address record.
Country String Country of location for address record.
Email String Email contact of address record.
Fax String Fax number of address record.
Location Integer One contact can have up to five address records.
Phone1 String Phone number 1 of address record.
Phone2 String Phone number 2 of address record.
Phone3 String Phone number 3 of address record.
PostCode String Postcode of address record.
Salutation String Salutation text for address record.
State String State of address record. Updated in 2018.1, this field is required for addresses with a country that is blank or Australia. Where required, valid values are: AAT , ACT , NSW , NT , QLD , SA , TAS , VIC, WA.
Street String Full content of Address field.
CompanyFileId String The ID of the company file. Takes precedence over the CompanyFileId connection property.

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