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:
- Others??
Information on Table Data
- ClassTypeIDs Stores in Table:
- 8911 - Daily Closeout
- 8912 - Monthly Closeout
- 8913 - Yearly Closeout
- 8914 - Export Closeout
- 8915 - Royalty Closeout
- 8916 - CC Settlement
- 8917 - Weekly Closeout
- 8918 - Quarterly Closeout
- 8919 - Session Closeout
- 9750 - Account Reconciliation
- 20000 - Master Payment
- 20001 - Order Payment
- 20002 - Over Payment
- 20003 - Change Return
- 20004 - Order Refund
- 20005 - Credit Refund
- 20006 - Order Credit Memo
- 20007 - Failed Payment
- 20008 - Tip Recorded
- 20009 - Bill Payment
- 20010 - Credit Adjustment
- 20015 - Write Off
- 20020 - Finance Charge
- 20025 - System Finance Charge
- 20030 - CC Activity
- 20035 - Journal Entry
- 20036 - Deposit
- 20037 - Master Bill Payment
- 20038 - Miscellaneous Receipt
- 20040 - Master Tip Payout
- 20041 - Detail Tip Payout
- 20050 - Master Time Card
- 20051 - Detail Time Card
- 20060 - Email Activity
- 20061 - Email Activity Template
- 20065 - Note Activity
- 20070 - Viewing CC Number Activity
- 20500 - Transaction Activity
- 20505 - Line Item Activity
- 20510 - Company Activity
- 20520 - Transaction Part Usage Activity
- 20521 - Station Activity
- 20522 - Proof Approval Activity
- 20530 - Inventory Adjustment
- 20535 - Global Inventory Adjustment Activity
- 20540 - Import Activity
- 20550 - Global Cost Adjustment Activity
- 20565 - Part Usage Card (NOT! Not a split table. See PartUsageCard Table instead.)
- 20570 - Backup Activity
- 20580 - Service Item
- 20590 - Report Activity
- 20600 - Login Activity
- 20610 - Logout Activity
- 20620 - Authentication Activity
- 20700 - Reservation Activity
- 21100 - Contact Activity
- 21150 - Contact Activity Template
- 21200 - Macro Activity
- 21250 - Macro Activity Template
- 21300 - Work Assignment
- 21350 - Work Assignment Template
- 23110 - Contact Acitvity Action
- 23120 - Email Action
- 23130 - Report Action
- 23141 - UDF Action
- 23144 - Popup Action
- 23146 - Transaction Action
- 23148 - Another Macro Action
- 23150 - Company Activity Action
- 23160 - Service Contract Action
- 23170 - Work Assignment Action
- 23180 - Transaction Update Action
- 35250 - Payroll Activity
- 35300 - Master Payroll Payment
- 35301 - Payroll Payment
- JournalActivityType ID's in Table:
- 1 -Time Card
- 2 - Payment
- 3 - Order
- 4 - Payment
- 5 - Recurring Order
- 6 - Company
- 7 - System
- 8 -
- 9 -
- 10 - Contact Activity
- 11 -
- 12 -
- 13 - Close Out
- 14 - Email
- 15 - Note
- 16 - Macro Activity
- 17 - Part Usage Card
- 18 - Credit Memo
- 19 - Contact Activity Template
- 20 - Email Template
- 21 - Import
- 22 - Credit Card Process
- 23 - Line Item Activity
- 24 - Database Backup
- 25 - Service Ticket
- 26 -
- 27 - Report
- 28 - Work Assignment
- 29 - Work Assignment Template
- 30 - Login
- 31 - Logout
- 32 - Purchase Order
- 33 -
- 34 -
- 35 -
- 36 - Bill
- 37 - Receiving Document
- 38 - Deposit Made
- 39 - Account Reconciliation
- 40 - Journal Entry
- 41 - View Credit Card Number
- 42 - Macro Activity Template
- 43 - Bill Payment
- 44 - Payroll
- 45 - Station Activity
- 46 - Payroll Payment
- 47 -
- 48 -
- 49 - Stage Activity
- ActivityType ID's in Table:
- 1 - Created
- 2 - Edited
- 3 - Estimate Converted
- 4 - Estimate Lost
- 5 - Order Status Marked WIP
- 6 - Order Status Marked Built
- 7 - Order Status Marked Sale
- 8 - Order Status Marked Closed
- 9 - Order Voided
- 10 - Station Changed
- 11 - Estimate Voided
- 12 -
- 13 -
- 14 - Service Ticket Status Marked Sale
- 15 -
- 16 -
- 17 - Service Ticket Voided
- 18 - Service Ticket Status Marked Closed
- 19 - Failed Backup
- 20 - Successful Backup
- 21 - Other
- 22 - Call
- 23 - Appt
- 24 - Mtg
- 25 - To Do
- 26 - Work Assignment
- 27 - Login
- 28 - Logout
- 29 -
- 30 -
- 31 - Purchase Order Marked Requested
- 32 - Purchase Order Marked Approved
- 33 - Purchase Order Marked Ordered
- 34 - Purchase Order Marked Closed
- 35 - Purchase Order Cancelled
- 36 - Purchase Order Rejected
- 37 - Purchase Order Marked Received
- 38 - Purchase Order Converted
- 39 - Receiving Document Converted
- 40 - Bill Converted
- 41 - Stage Changed
- 42 -
- 43 - Inventory Edited
- 44 - Inventory Transfer
- 45 - Production Terminal Usage
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
You could leave a comment if you were logged in.