JDBC Driver for Magento

Build 22.0.8462

CustomerAddress

CustomerAddress is an auto generated table

Columns

Name Type ReadOnly Description
Id [KEY] Int False

ID

City String False

City name

Company String False

Company

CountryId String False

Country code in ISO_3166-2 format

CustomerId Int False

Customer ID

DefaultBilling Bool False

If this address is default billing address

DefaultShipping Bool False

If this address is default shipping address.

ExtensionAttributes String False

This is an auto-generated column

Fax String False

Fax number

Firstname String False

First name

Lastname String False

Last name

Middlename String False

Middle name

Postcode String False

Postcode

Prefix String False

Prefix

Region String False

This is an auto-generated column

RegionId Int False

Region ID

Street String False

Street

Suffix String False

Suffix

Telephone String False

Telephone number

VatId String False

Vat id

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
AddressId_p Int

This is an auto-generated column

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