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. |
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. |