Sorry, no, that is not a field exposed by Intuit in their qbXML SDK unless you are using QuickBooks 2007 (the USA version take uses SDK v6) and QODBC v7 or higher.
The following is an example address in QuickBooks 2007:
Because the state of VIC failed validation by QuickBooks, it is moved to City and State is empty. Using QODBC the same address information can be extracted using:
SELECT FullName, BillAddressAddr1, BillAddressAddr2, BillAddressAddr3, BillAddressAddr4,
BillAddressAddr5, BillAddressCity, BillAddressState, BillAddressPostalCode, BillAddressCountry,
BillAddressNote, BillAddressBlockAddr1, BillAddressBlockAddr2, BillAddressBlockAddr3,
BillAddressBlockAddr4, BillAddressBlockAddr5
FROM Customer where FullName='Data Access Worldwide'
To see how all the fields/columns are mapped, I've expanded the query results into the table below:
| Column Name |
Value |
| FullName |
Data Access Worldwide |
| BillAddressAddr1 |
Data Access Worldwide |
| BillAddressAddr2 |
PO Box 873 |
| BillAddressAddr3 |
Shop 9 - 246 Dorset Road |
| BillAddressAddr4 |
|
| BillAddressAddr5 |
|
| BillAddressCity |
Boronia VIC |
| BillAddressState |
|
| BillAddressPostalCode |
3156 |
| BillAddressCountry |
Australia |
| BillAddressNote |
QuickBooks 2007 Only |
| BillAddressBlockAddr1 |
Data Access Worldwide |
| BillAddressBlockAddr2 |
PO Box 873 |
| BillAddressBlockAddr3 |
Shop 9 - 246 Dorset Road |
| BillAddressBlockAddr4 |
Boronia VIC 3156 Australia |
| BillAddressBlockAddr5 |
QuickBooks 2007 Only |
Note: The BillAddressBlockAddr block fields/columns are read-only and cannot be inserted or updated directly. |
