original_pages:sql_structure_-_artworkgroup_table [Control]

{$page}

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