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 |