Updated: 2016-04-15

Version: Control 5.7

Table Purpose, Usage, and Notes

This table contains the information associated with each Artwork Group

Information on Table Data

**

Table Structure

~ Table.FieldName ~ Data Type ~ Description ~ Links To
AccountID Int The ID of the Account (customer) for the artwork group. Account.ID
ArtworkApprovalDT Smalldatetime The DateTime that the artwork was approved or moved to a status past Approved (whether by a customer or employee). This field is NULLed if the Artwork is moved to a pre-approval status.
ArtworkDueDT Smalldatetime The Due DateTime for this Artwork Group.
BandID Tinyint The current band of the Artwork Group _ArtworkBand.ID
ClassTypeID SmallInt The class type for artwork groups.
CollectionChoiceID INT The ArtworkItem.ItemIndex of the chosen artwork in a Choice Group. (Note: This field is not a foreign key field to avoid circular loops.)
CollectionTypeID Tinyint The current collection type of the Artwork Group should it have more than 1 artwork item. _ArtworkCollectionType.ID
Description varchar(255) The description for the group which appears on the client summary screen and also on the summary page of client app
GroupCreatedDT SmallDateTime The DateTime the Group was Created
GroupName Char(2) The Artwork Group Name, ranging from ‘A’ to ‘ZZ’.
ID Int ID of each Artwork Group
IsActive Bit Indicates if the ArtworkGroup is active. Artwork groups that apply to no line items are automatically set to InActive.
PriorityID Tinyint The current priority of the Artwork Group. _ArtworkPriority.ID
SeqID Smallint
StatusDT Smalldatetime The Datetime the current status was set.
StatusID Tinyint The current status of the Artwork Group. _ArtworkStatus.ID
TransHeaderID Int The TransHeader associated with this Artwork Group. TransHeader.ID

Related Tables