CData JDBC Driver for Magento 2019 - Online Help
Questions / Feedback?


CData JDBC Driver for Magento 2019 - Build 19.0.7354

GuestBillingAddresses is an auto generated table


Name Type ReadOnly Description
Id [KEY] Int False


City String False

City name

Company String False


CountryId String False

Country id

CustomerAddressId Int False

Customer address id

CustomerId Int False

Customer id

Email String False

Billing/shipping email

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


Prefix String False


Region String False

Region name

RegionCode String False

Region code

RegionId Int False

Region id

SameAsBilling Int False

Same as billing flag

SaveInAddressBook Int False

Save in address book flag

Street String False


Suffix String False


Telephone String False

Telephone number

VatId String False

Vat id


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
CartId_p String

The cart ID.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0