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 
  * ClassTypeIDs Stores in Table:

**



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