Partilhar via


OrderAddress Table

For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.

The OrderAddress table in the transactions database contains information about an address that is associated with a completed order.

The following table describes the columns in the OrderAddress table.

Column name

Type

Allow null

Description

OrderGroupId

uniqueidentifier

no

The ID of the order group that is associated with the address.

This is a primary key and a foreign key.

OrderAddressId

nvarchar(50)

no

The ID of the address.

This is a primary key.

Name

nvarchar(64)

yes

The name of the address, for example "home" or "work".

FirstName

nvarchar(64)

yes

The first name of the person who is associated with the address.

LastName

nvarchar(64)

yes

The last name of the person who is associated with the address.

Organization

nvarchar(64)

yes

The organization or company that is associated with the address.

Line1

nvarchar(80)

yes

The first line of the address.

Line2

nvarchar(80)

yes

The second line of the address.

City

nvarchar(64)

yes

The city of the address.

State

nvarchar(64)

yes

The state of the address.

CountryCode

nvarchar(50)

yes

The country code of the address.

CountryName

nvarchar(50)

yes

The name of the country.

PostalCode

nvarchar(20)

yes

The postal code of the address.

RegionCode

nvarchar(50)

yes

The region code of the address.

RegionName

nvarchar(64)

yes

The name of the region.

DaytimePhoneNumber

nvarchar(32)

yes

The daytime telephone number of the person who is associated with the address.

EveningPhoneNumber

nvarchar(32)

yes

The evening telephone number of the person who is associated with the address.

FaxNumber

nvarchar(32)

yes

The fax number of the person who is associated with the address.

Email

nvarchar(64)

yes

The e-mail address of the person who is associated with the address.

MarshalledData

image

yes

A binary large object (BLOB) that stores a serialized representation of the values of weakly typed indexer properties.

See Also

Other Resources

Transaction Database Tables

Transaction Configuration Database Tables