Updated: 2014-04-28

Version: Control 5.1

List of the tables used by Control

Tables Used Directly By Control

|Account \\ AccountContact \\ AccountContactUserField \\ AccountUserField \\ Address \\ AddressLink \\ AdvQuery \\ AssemblyLink \\ CalendarLink \\ CalendarStatus \\ CatalogItem \\ Closeout \\ CommissionRate \\ ContactActivity \\ ContractPeriod \\ CustomerGoodsItem \\ CustomRange \\ Dashboard \\ DiscountTable \\ DiscountTableItem \\ DivisionData \\ Element \\ EmailActivity \\ Employee \\ EmployeeContact \\ EmployeeGroup \\ GLAccount \\ GoodsItemPartLink \\ Graphic \\ Inventory \\ InventoryLog \\ IOTemplate \\ Journal \\ Ledger \\ MarketingListItem \\ Part \\ PartInfoTemplate \\ PartInventoryConversion \\ PartUsageCard \\ Payment||PaymentAccount \\ PaymentPlan \\ PaymentTerms \\ Payroll \\ PayrollPaycheck \\ PayrollPaycheckPayItem \\ PayrollPayItem \\ PayrollPayItemLink \\ PayrollPTO \\ PayrollTaxTable \\ PayrollTaxTableRow \\ PhoneNumber \\ PostalCodeTaxClass \\ PricingElement \\ PricingGraphic \\ PricingLevel \\ PricingLink \\ PricingPlan \\ PricingTable \\ ProdModLink \\ ProductTaxabilityCode \\ ProductTaxExemptLink \\ Promotion \\ QuickProduct \\ RecurringActivity \\ ReportElement \\ ReportMenuItem \\ RuleAction \\ RuleActivity \\ RuleMacro \\ SalesGoal \\ ScheduledPayment \\ SecurityRightChange \\ SelectionList \\ SelectionListItem \\ ServiceContractType \\ ServiceTicketPriority \\ Shipments \\ ShippingMethod||SpeedNote \\ StateTaxExemptionLink \\ Station \\ Store \\ StoreConstant \\ TaxClass \\ TaxLink \\ TimeCard \\ TransDetail \\ TransDetailGraphic \\ TransDetailParam \\ TransHeader \\ TransHeaderUserField \\ TransMod \\ TransPart \\ TransTax \\ TransVariation \\ UserColumns \\ UserFieldDef \\ UserFieldLayout \\ UserName \\ UserOption \\ Variable \\ VendorTransDetail \\ Warehouse \\ TransDetailHistory \\ TransDetailGraphicHistory \\ TransDetailParamHistory \\ TransHeaderHistory \\ TransHeaderHistoryUserField \\ TransModHistory \\ TransPartHistory \\ TransTaxHistory \\ TransVariationHistory \\ VendorTransDetailHistory \\ Warden \\ DBSettings \\ Sequence||

**Tables Used Undirectly By Control**

\\
CCCSConfiguration

CCCSCustomer

CCCSTransactions

FedExShippingLogForShipments

UPSShippingLogForShipments

**Query to pull unused tables**

This query can be used to pull a list of tables in a given database that are not in the above list.

[[:code_formatsql|code format"sql"]]

select name

from sys.tables

where name not in ('dtproperties',

<code>
                 'Account', 'AccountContact', 'AccountContactUserField', 'AccountUserField',
</code>

<code>
                 'Address', 'AddressLink', 'AdvQuery', 'AssemblyLink', 'CalendarLink',
</code>

<code>
                 'CalendarStatus', 'CatalogItem', 'Closeout', 'ContactActivity', 'ContractPeriod',
</code>

<code>
                 'CustomerGoodsItem', 'CustomRange', 'Dashboard', 'DiscountTable',
</code>

<code>
                 'DiscountTableItem', 'DivisionData', 'Element', 'EmailActivity', 'Employee', 'EmployeeContact',
</code>

<code>
                 'EmployeeGroup', 'GLAccount', 'GoodsItemPartLink', 'Graphic', 'Inventory',
</code>

<code>
                 'InventoryLog', 'IOTemplate', 'Journal', 'Ledger', 'MarketingListItem', 'Part',
</code>

<code>
                 'PartInfoTemplate', 'PartInventoryConversion', 'PartUsageCard', 'Payment',
</code>

<code>
                 'PaymentAccount', 'PaymentPlan', 'PaymentTerms', 'Payroll', 'PayrollPaycheck',
</code>

<code>
                 'PayrollPaycheckPayItem', 'PayrollPayItem', 'PayrollPayItemLink', 'PayrollPTO',
</code>

<code>
                 'PayrollTaxTable', 'PayrollTaxTableRow', 'PhoneNumber', 'PostalCodeTaxClass',
</code>

<code>
                 'PricingElement', 'PricingGraphic', 'PricingLevel', 'PricingLink', 'PricingPlan',
</code>

<code>
                 'PricingTable', 'ProdModLink', 'ProductTaxabilityCode', 'ProductTaxExemptLink',
</code>

<code>
                 'Promotion', 'QuickProduct', 'RecurringActivity', 'ReportElement', 'ReportMenuItem',
</code>

<code>
                 'RuleAction', 'RuleActivity', 'RuleMacro', 'SalesGoal', 'ScheduledPayment',
</code>

<code>
                 'SecurityRightChange', 'SelectionList', 'SelectionListItem', 'ServiceContractType',
</code>

<code>
                 'ServiceTicketPriority', 'Shipments', 'ShippingMethod', 'SpeedNote',
</code>

<code>
                 'StateTaxExemptionLink', 'Station', 'Store', 'StoreConstant', 'TaxClass', 'TaxLink',
</code>

<code>
                 'TimeCard', 'TransDetail', 'TransDetailGraphic', 'TransDetailParam', 'TransHeader',
</code>

<code>
                 'TransHeaderUserField', 'TransMod', 'TransPart', 'TransTax', 'TransVariation',
</code>

<code>
                 'UserColumns', 'UserFieldDef', 'UserFieldLayout', 'UserName', 'UserOption',
</code>

<code>
                 'Variable', 'VendorTransDetail', 'Warehouse', 'CommissionRate',
</code>

<code>
                 'TransDetailHistory', 'TransDetailGraphicHistory', 'TransDetailParamHistory',
</code>

<code>
                 'TransHeaderHistory', 'TransHeaderHistoryUserField', 'TransModHistory',
</code>

<code>
                 'TransPartHistory', 'TransTaxHistory', 'TransVariationHistory',
</code>

<code>
                 'VendorTransDetailHistory', 'Warden', 'DBSettings', 'Sequence',
</code>

<code>
                 'CCCSConfiguration', 'CCCSCustomer',
</code>

<code>
                 'CCCSTransactions', 'FedExShippingLogForShipments',
</code>

<code>
                 'UPSShippingLogForShipments')
</code>

Order By name

\\