Share via


OrderForms Table

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

The OrderForms table in the transactions database contains information about the order forms that are associated with completed orders.

The following table describes the columns in the OrderForms table.

Column name

Type

Allow null

Description

OrderFormId

uniqueidentifier

no

The ID of the order form.

This is the primary key.

OrderGroupId

uniqueidentifier

no

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

This is a foreign key.

Name

nvarchar(64)

yes

The name of the order form.

BillingAddressId

nvarchar(50)

yes

The ID of the billing address that is associated with the order form.

PromoUserIdentity

nvarchar(64)

yes

An identifier for the user who is associated with the promotion code, for example, the user's logon name or e-mail address.

SubTotal

money

no

The cost of the line items in the order form.

ShippingTotal

money

no

The shipping cost for the items in the order form.

HandlingTotal

money

no

The handling cost for the line items in the order form.

TaxTotal

money

no

The tax for the items in the order form.

Total

money

no

The total cost for the order form.

Created

datetime

no

The date the order form was created.

LastModified

datetime

no

The date the order form was last modified.

ModifiedBy

nvarchar(64)

no

The user ID of the person who last modified the order form.

Status

nvarchar(64)

yes

The status of the order form.

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