CustomerAccountBillingAddress

CustomerAccountBillingAddress is an auto generated table. The supported operations are Querying data from this table.

Table Specific Information

Select

The 本製品 will use the AdobeCommerce API to filter the results by CustomerId while the rest of the filter is executed client side within the 本製品.

The CustomerId column must be specified in the WHERE clause to retrieve results from CustomerAccountBillingAddress. CustomerId can be used only with the equals (=) operator. For example:

SELECT * FROM [CustomerAccountBillingAddress] WHERE CustomerId = '123'

Columns


Name	Type	Description
Id [KEY]	Int	ID
City	String	City name
Company	String	Company
CountryId	String	Country code in ISO_3166-2 format
CustomerId	Int	Customer ID
DefaultBilling	Bool	If this address is default billing address
DefaultShipping	Bool	If this address is default shipping address.
ExtensionAttributes	String	This is an auto-generated column
Fax	String	Fax number
Firstname	String	First name
Lastname	String	Last name
Middlename	String	Middle name
Postcode	String	Postcode
Prefix	String	Prefix
Region	String	This is an auto-generated column
RegionId	Int	Region ID
Street	String	Street
Suffix	String	Suffix
Telephone	String	Telephone number
VatId	String	Vat id

ADO.NET Provider for Adobe Commerce

CustomerAccountBillingAddress

Table Specific Information

Select

Columns