{$page}

This page lists the standard tables used in Control for all database information.

For security purposes, tables or field are excluded from this listing if they are associated with user security or might contain sensitive credit card information.

Table List

~ Table Name ~ Last Updated ~ Use
* Account Table 9/22/2009 Stores Customers, Prospects, and Vendors
* AccountContact Table 10/14/2009 Stores Individual Contact Information for Accounts
* AccountContactUserField Table 08/31/2016 Stores UDF values for Account Contacts
* AccountUserField Table 08/31/2016 Stores UDF values for Accounts
* Address Table 9/23/2009 Stores Addresses for AccountContact, Employees, etc.
* AddressLink Table 9/30/2009 Stores links between Addresses and Companies, Contacts, or the Store
* AdvQuery Table 08/31/2016 Stores Advanced Queries for Sales & Marketing
* ArtworkComment Table 04/15/2016 Stores the text and graphing data for all Artwork comments made by Named Roles
* ArtworkDefaultPlayer Table 04/15/2016 Stores the Employee and Customer Default Roles Linked to each Account Record
* ArtworkDefaultRoleLink Table 04/15/2016 Stores the link between the Artwork Roles and Artwork Default Players
* ArtworkGroup Table 04/15/2016 Stores the information associated with each Artwork Group
* ArtworkGroupStatusHistory Table 04/15/2016 Stores the history of all status changes for an Artwork Group
* ArtworkGroupTransDetailLink Table 04/15/2016 Stores the link between the TransDetail table and Artwork Groups
* ArtworkItem Table 04/15/2016 Stores the records associated with each Artwork item.
* ArtworkLog Table 04/15/2016 Stores all of the log entries for artwork related events
* ArtworkNotificationHistory Table 04/15/2016 Stores the history of all Artwork email notifications
* ArtworkPlayer Table 04/15/2016 Stores the link between individuals involved in artwork approval to an order
* ArtworkPlayerRoleLink Table 04/15/2016 Stores which roles a particular player is assigned
* ArtworkProofFile Table 04/15/2016 Stores all attributes of a Proof File
* ArtworkSchema Table 04/15/2016 Stores the dates migrated of each schema version used for Artwork
* AssemblyLink Table 10/16/2009 Stores the link for Assembly containers between the parent and child Products (or Derived Products)
* CalendarLink Table 08/31/2016 Stores the link between the Employee and Journal tables for calendar activities
* CatalogItem Table 08/31/2016 Stores all Products used as Catalog Items for Vendors
* CCCSConfigurationData Table 10/12/2016 Stores all info for your account with Elavon (RegistrationKey, BankNumber, etc…)
* CCCSCustomer Table 10/12/2016 Stores all info for a customer's credit card
* CCCSTransaction Table 10/12/2016 Stores record for each time a credit card was processed through CCCS
* CCToken Table 10/12/2016 Stores all of the info for a card on file record. This table replaces the CCCSCustomer Table in Control 6.0
* CCTransaction Table 10/12/2016 Stores record for each time a credit card was processed through Freeway. This table replaces the CCCSTransaction Table in Control 6.0
* Closeout Table 08/31/2016 Stores Dates and Times of Closeouts
* CommissionRate Table 08/31/2016 Stores all the rates used on Commission Plans used in Pricing Setup
* ContactActivity Table 08/31/2016 Stores all the basic info releated to Activities that isn't stored in the Journal
* CustomerGoodsItem Table 10/08/2009 Stores products, modifiers, and courses.
* CustomRange Table 08/31/2016 Stores info related to Custom Date Ranges in System Setup
* Dashboard Table 10/12/2009 Stores info related to Dashboards
* DiscountTable Table 08/31/2016 Stores the Header row for a Discount Table
* DiscountTableItem Table 08/31/2016 Stores the rows in a Discount Table
* Element Table 08/31/2016 Stores miscellaneous items with a name and little other information.
* EmailActivity Table 08/31/2016 Stores basic info for email activites linked to the Journal table
* Employee Table 9/24/2009 Stores employee information.
* EmployeeContact Table 9/24/2009 Stores information about employee contact numbers.
* EmployeeGroup Table 9/24/2009 Stores information about Employee Groups and Divisions
* FedExShippingLog Table 08/31/2016 Stores log info for items shipped through FedEx
* GL Table 08/31/2016 General Ledger view used to see everything in the Ledger table that is on the Balance Sheet
* GLAccount Table 08/31/2016 Stores all account information for the Chart of Accounts used in Accounting Setup
* GoodsItemPartLink Table 08/31/2016 Stores the Link between the CustomGoodsItem view and the Part tables
* Graphic Table 08/31/2016 Stores the info for graphics used on Store and Divisions
* Inventory Table 08/31/2016 Stores the current values associated with all Parts that are set to Track Inventory
* InventoryLog Table 08/31/2016 Stores the history of all changes made to the Inventory table
* IOTemplate Table 08/31/2016 Stores the properties of Pricing Forms
* Journal Table 08/31/2016 Stores all information about Activities that are tracked in the program
* Ledger Table 08/31/2016 Stores all movement between Chart of Accounts for financial assets
* MarketingListItem Table 08/31/2016 Stores the lists displayed for Industry, Origin, and Region on a Company record found in System Setup
* Part Table 08/31/2016 Stores all information about Parts found in Part Setup
* PartInfoTemplate Table 08/31/2016 Stores information about Parts found in the Adjust Part Information screen
* PartInventoryConversion Table 08/31/2016 Stores the conversion values shown for Additional Units of a Part
* PartUsageCard Table 08/31/2016 Stores amounts for the Part Usage Cards associated with Parts on an Order
* PartUserField Table 04/30/2010 Stores UDF data for Parts
* Payment Table 08/31/2016 Stores Payment info and is relational to the Journal record with the same ID
* PaymentAccount Table 08/31/2016 Stores Payment Methods found in Accounting Setup
* PaymentPlan Table 08/31/2016 Stores Payment Plans found in Accounting Setup
* PaymentTerms Table 08/31/2016 Stores Payment Terms found in Accounting Setup
* Payroll Table 08/31/2016 Stores time and date info associated with processed Payrolls
* PayrollPaycheck Table 08/31/2016 Stores all paychecks that were created while processing Payroll
* PayrollPaycheckPayItem Table 08/31/2016 Stores all Payroll items used in each of the processed Payrolls
* PayrollPayItem Table 08/31/2016 Stores the different items you see used for Payroll in the Payroll Setup area
* PayrollPayItemLink Table 08/31/2016 Stores the link between Payroll Pay Items and the Employee tables
* PayrollPTO Table 08/31/2016 Stores all Paid Time Off info for Employees included in Payroll
* PayrollTaxTable Table 08/31/2016 Stores the basic info about the Tax Tables found in Payroll Setup
* PayrollTaxTableRow Table 08/31/2016 Stores the detailed info about the Tax Tables found in Payroll Setup
* PhoneNumber Table 08/31/2016 Stores Phone Numbers for Accounts, Contact, Employees, etc.
* PostalCodeTaxClass Table 08/31/2016 Stores the Tax Class used for specific Postal Codes
* PrCA.Board.Data Table 06/16/2017 Stores information related to all job boards
* PrCA.Board.Enum.SortType Table 06/16/2017
* PrCA.Board.MyBoard Table 06/16/2017 Stores the link between employee and job boards
* PrCA.Board.StationLink Table 06/16/2017 Stores the link between boards and stations
* PrCA.Job.Data Table 06/16/2017 Stores information related to jobs
* PrCA.Job.TransactionLink Table 06/16/2017 Stores the link between jobs and tranactions
* PrCA.Schema Table 06/16/2017 Stores the schema version for PrCA
* PricingElement Table 08/31/2016 Stores miscellaneous pricing items with a name and little other information. Most used for groups/categories.
* PricingGraphic Table 09/02/2016 Stores the information about pictures that are saved to products in Product Setup
* PricingLevel Table 08/31/2016 Stores the information about the Pricing Levels found in Pricing Setup
* PricingLink Table 09/02/2016 Stores the link between Products and Variables, Parts to Calendars, Modifiers to QtyApplied variable
* PricingPlan Table 08/31/2016 Stores various pricing information with how it relates to specific products. Linked by GoodsItemID
* PricingTable Table 08/31/2016 Stores the pricing tables that are the Lookup Tables found in Pricing Setup
* ProdModLink Table 10/14/2009 Stores the links between Products and Modifiers.
* ProductTaxabilityCode Table 08/31/2016 Stores the information about Taxability Codes found in Accounting Setup
* ProductTaxExemptLink Table 09/02/2016 Stores the Product Taxability Code and provides a list of which tax accounts are exempt
* ProductUserField Table 04/30/2010 Stores UDF data for Products.
* Promotion Table 08/31/2016 Stores the Promotions found in Pricing Setup
* QuickProduct Table 08/31/2016 Stores the information about Quick Products found in Pricing Setup
* RecurringActivity Table 08/31/2016 Stores the Recurring Activities found in Sales & Marketing
* ReportElement Table 08/31/2016 Stores any changes made to reports that are stored as the default
* ReportMenuItem Table 08/31/2016 Stores all info about reports that are not default in the SystemConfig
* RuleAction Table 08/31/2016 Stores all Actions that are associated with created Macros
* RuleActivity Table 08/31/2016 Stores all Macro Acitivities
* RuleMacro Table 08/31/2016 Stores all Macro information not stored in RuleAction table
* SalesGoal Table 08/31/2016 Stores Sales Goals found in System Setup
* ScheduledPayment Table 08/31/2016 Stores all info on Scheduled Payments
* SecurityRightChange Table 08/31/2016 Stores changes made to Security Setup that are not default in SystemData
* SelectionList Table 08/31/2016 Stores info for all Selection Lists found in Pricing Setup
* SelectionListItem Table 08/31/2016 Stores info of the tables associated with each Selection List found in Pricing Setup
* Sequence Table 10/6/2009 Tracks Sequenced Numbers, like the Next Order Number
* ServiceContractType Table 08/31/2016 Stores the Service Ticket Contract Types found in System Setup
* ServiceTicketPriority Table 08/31/2016 Stores the Priorities for Orders, Estimates, and Service Tickets found in System Setup
* Shipments Table 08/31/2016 Stores all shipments added on the Shipping tab of orders, estimates, and service tickets.
* ShippingMethod Table 08/31/2016 Stores the different shipping methods used on the Shipping tab.
* SpeedNote Table 08/31/2016 Stores the info from all the non default Notes and Greetings sections in System Setup
* StateTaxExemptionLink Table 08/31/2016 Stores the link between state specific tax exemptions and their associated companies
* Station Table 08/31/2016 Stores information about each Station found in Production Setup
* Store Table 08/31/2016 Stores the information about the Business found in System Setup
* StoreConstant Table 08/31/2016 Stores the User Constants used in CFL
* SystemUnit Table 10/08/2009 System table for storing the unit of measurement used with Parts
* TaxClass Table 08/31/2016 Stores the Header Record for Each Tax Class
* TaxLink Table 08/31/2016 Links the TaxClass to the GL Tax Accounts they use
* TimeCard Table 08/31/2016 Stores all the time cards created
* TransDetail Table 08/31/2016 Stores the Line Item information for an Order, Estimate, or Recurring Order
* TransDetailGraphic Table 09/02/2016 Stores a bitmap image of the product layout used for the line item in TransDetail
* TransDetailGraphicHistory Table 08/31/2016 Stores the TransDetailGraphic when archived
* TransDetailHistory Table 08/31/2016 Stores the TransDetail when archived
* TransDetailParam Table 08/31/2016 Write Line Item Variable for Reporting. Never read by Control.
* TransDetailParamHistory Table 08/31/2016 Stores the TransDetailParam when archived
* TransHeader Table 08/31/2016 The Header record for Orders, Estimate, Bills, POs,RDs, and Recurring Orders
* TransHeaderHistory Table 08/31/2016 Stores the TransHeader when archived
* TransHeaderHistoryUserField Table 08/31/2016 Stores the TransHeaderUserField when archived
* TransHeaderUserField Table 08/31/2016 Stores the UDF values for TransHeader records
* TransMod Table 08/31/2016 Stores the Modifier Values for Line Items
* TransModHistory Table 08/31/2016 Stores the TransMod when archived
* TransPart Table 08/31/2016 Stores the Part quantities for Line Items
* TransPartHistory Table 08/31/2016 Stores the TransPart when archived
* TransTax Table 08/31/2016 Write Order/Estimate Tax Information for Reporting. Never read by Control.
* TransTaxHistory Table 08/31/2016 Stores the TransTax when archived
* TransVariation Table 08/31/2016 Stores the Variation Header for Transactions
* TransVariationHistory Table 08/31/2016 Stores the TransVariation when archived
* UPSShippingLog Table 08/31/2016 Stores the log info for items shipped through UPS
* UserFieldDef Table 08/31/2016 Stores the UDF Definitions for all types that use UDFs
* UserFieldLayout Table 08/31/2016 Stores the UDF Layouts found in User Defined Field Setup
* UserName Table 10/01/2009 Stores the User Login Information
* UserOption Table 08/31/2016 Stores the options chosen for each employee in User Options
* Variable Table 08/31/2016 Stores the Global and Product specific Variable Setup Information
* VendorTransDetail Table 08/31/2016 Stores the Line Item information for a Bill, PO, or RD
* VendorTransDetailHistory Table 08/31/2016 Stores the VendorTransDetail when archived

Source

Version: Control 6.0

See Also