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
NameTypeConstraintsDescription
ar_item_group_KEYint (4)NOT NULLPrimary key for this table.
group__ar_item_KEYint (4)NOT NULLAn item key of type Group or Sales tax group that is the parent item for this group.
member__ar_item_KEYint (4)NOT NULLAn item key that is not of type Group or Sales tax group that is a child item for this group.
quantitydecimal (9, 4)NOT NULLThe quantity of member items to be used.
sequence_numberint (4)NOT NULLA 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
NameColumnsDescription
PK_AR_Item_Groupar_item_group_KEY
Unique constraints
NameColumnsDescription
UK_AR_Item_Group$group__ar_item_KEY$member__ar_item_KEYgroup__ar_item_KEY, member__ar_item_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_AR_Item_Group__AR_Item__group__ar_item_KEYgroup__ar_item_KEYAR_Item (ar_item_KEY)
FK_AR_Item_Group__AR_Item__member__ar_item_KEYmember__ar_item_KEYAR_Item (ar_item_KEY)

Schema diagram