Updated: 2016-04-15
Version: Control 5.7
Table Purpose, Usage, and Notes
This table contains all of the log entries for artwork related events. This table is mostly for diagnostic and tracking, and is not accessible within Control except via reports
Information on Table Data
- ClassTypeIDs Stores in Table:
- xxxxx -
Table Structure
| ~ Table.FieldName | ~ Data Type | ~ Description | ~ Links To | ||||
| ArtworkLog.AccountID | int | The ID of the customer associated with the log entry. | Account.ID | ||||
| ArtworkLog.ArtworkGroupID | int | The ID of the Artwork Group associated with the log entry. | ArtworkGroup.ID | ||||
| ArtworkLog.ArtworkItemID | int | The ID of the Artwork Item associated with the log entry. | ArtworkItem.ID | ||||
| ArtworkLog.ClassTypeID | SmallInt | ||||||
| ArtworkLog.Description | varchar(255) | A short text description of the issue. | |||||
| ArtworkLog.Details | XML | An XML free form record containing details about the log entry. | |||||
| ArtworkLog.EntryDT | Smalldatetime | The date time of the log entry. | |||||
| ArtworkLog.ID | Int PRIMARY KEY | ||||||
| ArtworkLog.LogTypeID | tinyint | The ArtworkLogType enum describing the category of log entry this refers to. | |||||
| ArtworkLog.LogSubType | varchar(32) | A text category to subtype the log entries for these LogTypes. | |||||
| ArtworkLog.PlayerID | int | The ID of the Player (employee or contact) associated with the log entry. | ArtworkPlayer.ID | ||||
| ArtworkLog.ProofFileID | int | The ID of the Proof File associated with the log entry. | ArtworkProofFile.ID | ||||
| ArtworkLog.TransHeaderID | int | The ID of the Order or Estimate associated with the log entry. | TransHeader.ID |
Related Tables
You could leave a comment if you were logged in.