This topic describes the columns in the mf_order_item_groups table.
Column Name | Data Type | Primary Key | Is Nullable | Column ID | Comment | Reference Count | Reference To |
---|---|---|---|---|---|---|---|
order_item_group_guid | uniqueidentifier | 1 | 0 | 1 | 1 | ||
order_guid | uniqueidentifier | 0 | 0 | 2 | Primary Key | 0 | mf_orders.order_guid |
item_guid | uniqueidentifier | 0 | 1 | 3 | This is the item_guid if this Grouping Context was created using a Group Item | 0 | |
allocation_partition_guid | uniqueidentifier | 0 | 1 | 4 | 0 | mf_allocation_partitions.allocation_partition_guid | |
order_item_group_type_id | smallint | 0 | 0 | 6 | 0 | mf_order_item_group_display_types.order_item_group_type_id | |
order_item_group_cd | varchar (50) | 0 | 1 | 7 | 0 | ||
order_item_group_description | varchar (100) | 0 | 1 | 8 | 0 | ||
order_item_group_quantity | int | 0 | 0 | 9 | 0 | ||
order_item_group_notes | varchar (2000) | 0 | 1 | 10 | 0 | ||
order_item_group_tag | varchar (50) | 0 | 1 | 11 | 0 | ||
order_item_group_suppress_splitting | tinyint | 0 | 0 | 12 | 0 |