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