JDBC Driver for MYOB

Build 24.0.9060

ContactAddressItems

Contact address items.

Table Specific Information

Select

The driver will process all filters client side.

Columns

Name Type References Description
ID [KEY] Integer LineId which represents the index of the line.
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.

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