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