Updated: 2009-09-16
Version: Control 4.4
Table Purpose, Usage, and Notes
This table is the basis of all activity tracking. Many activities are recorded only in the Journal table, while others record additional information in split tables.
Split Tables linked to the Journal (WHERE Journal.ID SplitTable.ID) include:
Information on Table Data
Table Structure
| ~ Table.FieldName | ~ Data Type | ~ Description | ~ Links To | ||||
| Journal.AccountClassTypeID | int | ||||||
| Journal.AccountID | int | ID of the Customer/Prospect Account | |||||
| Journal.ActivityType | int | ||||||
| Journal.ActivityTypeText | nvarchar(50) | ||||||
| Journal.Billable | datetime | ||||||
| Journal.BillingNotes | text | ||||||
| Journal.BillingType | int | ||||||
| Journal.CalendarLinksXML | text | ||||||
| Journal.ClassTypeID | int | Identifier for the Type of Object | |||||
| Journal.Completed | datetime | ||||||
| Journal.CompletedByID | int | ||||||
| Journal.ContactClassTypeID | int | ||||||
| Journal.ContactID | int | ||||||
| Journal.CurrentState | int | Has no practical relevance, Cyrious Techs see this link. | |||||
| Journal.Description | nvarchar(50) | ||||||
| Journal.DetailAmount | decimal(18, 4) | ||||||
| Journal.DivisionID | int | ID of the Division for this Transaction | EmployeeGroup.ID | ||||
| Journal.EmployeeID | int | ID of the Employee | Employee.ID | ||||
| Journal.EndDateTime | datetime | ||||||
| Journal.EndGLGroupID | int | ||||||
| Journal.HasCalendarLinks | bit | ||||||
| Journal.ID | int | Primary Key for the Table | |||||
| Journal.IsActive | bit | Not Used for This Table | |||||
| Journal.IsBillable | bit | ||||||
| Journal.IsDetail | bit | ||||||
| Journal.IsSummary | bit | ||||||
| Journal.IsSystem | bit | Used to Mark Required Records | |||||
| Journal.IsVoided | bit | ||||||
| Journal.JournalActivityText | nvarchar(25) | ||||||
| Journal.JournalActivityType | int | ||||||
| Journal.LinkClassTypeID | int | What this field links to depends on which type of journal record this is. | Example: VendorTransDetail.ClassTypeID |
||||
| Journal.LinkID | int | What this field links to depends on which type of journal record this is. | Example: VendorTransDetail.ID |
||||
| Journal.LinkStoreID | int | Not Used. | |||||
| Journal.ModifiedByComputer | nvarchar(25) | HostName of computer that last modified this record | |||||
| Journal.ModifiedByUser | nvarchar(25) | Windows User who last modified this record | |||||
| Journal.ModifiedDate | datetime | DateTime this Record was last modified | |||||
| Journal.Notes | text | ||||||
| Journal.PartClassTypeID | int | ||||||
| Journal.PartID | int | ||||||
| Journal.QueryEnd | datetime | ||||||
| Journal.QueryStart | datetime | ||||||
| Journal.RecurringActivityID | int | ||||||
| Journal.RecurringClassTypeID | int | ||||||
| Journal.Reminder | datetime | ||||||
| Journal.ReminderPrompt | bit | ||||||
| Journal.Scheduled | datetime | ||||||
| Journal.SeqID | int | ||||||
| Journal.SpecialCode | varchar(25) | ||||||
| Journal.Start | datetime | ||||||
| Journal.StartGLGroupID | int | ||||||
| Journal.StationClassTypeID | int | ||||||
| Journal.StationID | int | ||||||
| Journal.StoreID | int | Not Used. | |||||
| Journal.SummaryAmount | decimal(18, 4) | ||||||
| Journal.SummaryClassTypeID | int | ||||||
| Journal.SummaryID | int | ||||||
| Journal.TipRecipientID | int | ||||||
| Journal.TotalBilledTime | float | ||||||
| Journal.TotalTime | datetime | ||||||
| Journal.TransactionClassTypeID | int | ||||||
| Journal.TransactionID | int | ||||||
| Journal.UseActualTime | bit | ||||||
| Journal.Voided | datetime | ||||||
| Journal.VoidedEntryClassTypeID | int | ||||||
| Journal.VoidedEntryID | int | ||||||
| Journal.VoidedReason | text |
Related Tables