Table: dbo.AR_Item_Group
This table stores member items for a group along with their quantity and sequence number. The group represents a package of items that can be selected to be placed on an invoice.
Columns
Name | Type | Constraints | Description
ar_item_group_KEY | int (4) | NOT NULL | Primary key for this table.
group__ar_item_KEY | int (4) | NOT NULL | An item key of type Group or Sales tax group that is the parent item for this group.
member__ar_item_KEY | int (4) | NOT NULL | An item key that is not of type Group or Sales tax group that is a child item for this group.
quantity | decimal (9, 4) | NOT NULL | The quantity of member items to be used.
sequence_number | int (4) | NOT NULL | A sequence number for the member item that represents the order inside the group in which to add the member item to the invoice.

Primary key
Name | Columns | Description
PK_AR_Item_Group | ar_item_group_KEY |
Unique constraints
Name | Columns | Description
UK_AR_Item_Group$group__ar_item_KEY$member__ar_item_KEY | group__ar_item_KEY, member__ar_item_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_AR_Item_Group__AR_Item__group__ar_item_KEY | group__ar_item_KEY | AR_Item (ar_item_KEY) |
FK_AR_Item_Group__AR_Item__member__ar_item_KEY | member__ar_item_KEY | AR_Item (ar_item_KEY) |