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