OrderGroup

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

The OrderGroup class describes purchase order information. Specifically, the OrderGroup object links to one or more OrderFormHeader objects and one or more OrderGroupAddresses objects. The OrderFormHeader class represents control information for the purchase order such as billing codes, tax codes, and other data required to process the purchase order. The OrderFormHeader object links to one or more OrderFormLineItems objects, which describe the specific products to be purchased. The OrderGroupAddresses class represents mailing and shipping information for purchase orders.

Data Members

Data member name

Data type

Default value

Description

alt_currency

nvarchar(255)

null

Stores the alternate currency type for the order.

alt_lcid

int

null

Stores the alternate currency identifier code for the order.

billing_currency

nvarchar(255)

null

Stores the type of currency used in the order.

d_DateCreated

datetime

null

Stores the date that the OrderGroup is created. This value is also set on the OrderForm, OrderFormLineItem, and OrderGroupAddresses objects when it is added to an OrderGroup.

d_DateLastChanged

datetime

null

Stores the date the order was last changed.

default_currency

nvarchar(255)

None

Stores the default type of currency used in the order.

default_lcid

int

None

Stores the local currency identifier code for the order.

g_UserIDChangedBy

uniqueidentifier

None

Stores the GUID of the user who last changed the order.

order_approval_decision_date

datetime

None

Records when the order was approved.

order_create_date

datetime

None

Records the date that the order was created by the LoadBasket, AddItemsForUser, and SaveAsOrder methods.

order_number

nvarchar(255)

None

Stores the order number.

order_status_code

int

None

Stores a code that indicates the status of the order. User definable.

ordergroup_id

uniqueidentifier

{00000000-0000-0000-0000-000000000000}

Stores the unique key for the object.

previous_order_id

uniqueidentifier

None

Store the previous order_id value for the order, if it exists.

saved_cy_oadjust_subtotal

money

None

Stores the adjusted subtotal for the order.

saved_cy_total_total

money

None

Stores the saved total for the order.

saved_order_name

nvarchar(255)

None

Stores the saved name for the order.

total_lineitems

int

None

Stores the total number of line items.

user_first_name

nvarchar(255)

None

Stores the first name of the user associated with the order.

user_last_name

nvarchar(255)

None

Stores the last name of the user associated with the order.

user_name

nvarchar(255)

None

Stores the full name of the user associated with the order.

user_org_name

nvarchar(255)

None

Stores the name of the organization associated with the order.

RegisteredUserID

nvarchar(255)

None

Stores the universally unique identifier (UUID) of the user associated with the order.

SiteID

binary

None

None.

Class Key

OrderGroupKey is composed of a single data member, ordergroup_id.

Relations

For a description of the relation type, see Data Warehouse Classes.

Relation Name

Parent

Child

Type

DateOrderGroup

Date

OrderGroup

2

OrderGroupOrderRel

OrderGroup

Order

2

OrderGroupSite

Site

OrderGroup

2

OrderGroupToOrderFormHeader

OrderGroup

OrderFormHeader

2

OrderGroupToOrderFormLineItems

OrderGroup

OrderFormLineItems

2

OrderGroupToOrderGroupAddresses

OrderGroup

OrderGroupAddresses

2

UserToOrderGroup

RegisteredUser

OrderGroup

2

See Also

Other Resources

Data Warehouse Classes