Share via


OrderGroup

This 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 WSTR None Stores the alternate currency type for the order.
alt_lcid LONG None Stores the alternate currency identifier code for the order.
billing_currency WSTR None Stores the type of currency used in the order.
d_DateCreated DATETIME None Records the date the order was created.
d_DateLastChanged DATETIME None Records the date the order was last changed.
default_currency WSTR None Stores the default type of currency used in the order.
default_lcid LONG None Stores the local currency identifier code for the order.
g_UserIDChangedBy UUID None Stores the globally unique identifier (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 when the order was created.
order_number WSTR None Stores the order number.
order_status_code LONG None Stores a code indicating the status of the order. User definable.
ordergroup_id UUID {00000000-0000-0000-0000-000000000000} Stores the unique key for the object.
previous_order_id UUID None Store the previous order_id for the order, if it exists.
saved_cy_oadjust_subtotal CURRENCY None Stores the adusted current year subtotal for the order.
saved_cy_total_total CURRENCY None Stores the saved current year total for the order.
saved_order_name WSTR None Stores the saved name for the order.
SiteName WSTR Not available None
total_lineitems LONG None Stores the total number of line items.
user_first_name WSTR None Stores the first name of the user associated with the order.
user_id WSTR None Stores the universally unique identifier (UUID) of the user associated with the order.
user_last_name WSTR None Stores the last name of the user associated with the order.
user_name WSTR None Stores the full name of the user associated with the order.
user_org_name WSTR None Stores the name of the organization associated with the order.

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


All rights reserved.