Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision 		Previous revision
control_database_tables [2019/01/30 09:22]
127.0.0.1 external edit 		control_database_tables [2019/02/07 10:58]
kcifreo
Line 1: Line 1:
-  
- 
- 
- 
 Updated: 2014-04-28 Updated: 2014-04-28
- 
- 
  
 Version: Control 5.1 Version: Control 5.1
  
 +List of the tables used by Control
  
 +Tables Used Directly By Control
  
-List of the tables used 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 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+
  
 +**Tables Used Undirectly By Control**
  
 +\\
 +CCCSConfiguration
  
 CCCSCustomer CCCSCustomer
- 
- 
  
 CCCSTransactions CCCSTransactions
- 
- 
  
 FedExShippingLogForShipments FedExShippingLogForShipments
  
 +UPSShippingLogForShipments
  
- +**Query to pull unused tables**
-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. 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"]]
- +
-[[code_formatsql|code format"sql"]] +
- +
  
 select name select name
- 
- 
  
 from sys.tables from sys.tables
- 
- 
  
 where name not in ('dtproperties', where name not in ('dtproperties',
  
 +<code>
 +                 'Account', 'AccountContact', 'AccountContactUserField', 'AccountUserField',
 +</code>
  
 +<code>
 +                 'Address', 'AddressLink', 'AdvQuery', 'AssemblyLink', 'CalendarLink',
 +</code>
  
-                   'Account', 'AccountContact', 'AccountContactUserField', 'AccountUserField',+<code> 
 +                 'CalendarStatus', 'CatalogItem', 'Closeout', 'ContactActivity', 'ContractPeriod', 
 +</code>
  
 +<code>
 +                 'CustomerGoodsItem', 'CustomRange', 'Dashboard', 'DiscountTable',
 +</code>
  
 +<code>
 +                 'DiscountTableItem', 'DivisionData', 'Element', 'EmailActivity', 'Employee', 'EmployeeContact',
 +</code>
  
-                   'Address', 'AddressLink', 'AdvQuery', 'AssemblyLink', 'CalendarLink',+<code> 
 +                 'EmployeeGroup', 'GLAccount', 'GoodsItemPartLink', 'Graphic', 'Inventory', 
 +</code>
  
 +<code>
 +                 'InventoryLog', 'IOTemplate', 'Journal', 'Ledger', 'MarketingListItem', 'Part',
 +</code>
  
 +<code>
 +                 'PartInfoTemplate', 'PartInventoryConversion', 'PartUsageCard', 'Payment',
 +</code>
  
-                   'CalendarStatus', 'CatalogItem', 'Closeout', 'ContactActivity', 'ContractPeriod',+<code> 
 +                 'PaymentAccount', 'PaymentPlan', 'PaymentTerms', 'Payroll', 'PayrollPaycheck', 
 +</code>
  
 +<code>
 +                 'PayrollPaycheckPayItem', 'PayrollPayItem', 'PayrollPayItemLink', 'PayrollPTO',
 +</code>
  
 +<code>
 +                 'PayrollTaxTable', 'PayrollTaxTableRow', 'PhoneNumber', 'PostalCodeTaxClass',
 +</code>
  
-                   'CustomerGoodsItem', 'CustomRange', 'Dashboard', 'DiscountTable',+<code> 
 +                 'PricingElement', 'PricingGraphic', 'PricingLevel', 'PricingLink', 'PricingPlan', 
 +</code>
  
 +<code>
 +                 'PricingTable', 'ProdModLink', 'ProductTaxabilityCode', 'ProductTaxExemptLink',
 +</code>
  
 +<code>
 +                 'Promotion', 'QuickProduct', 'RecurringActivity', 'ReportElement', 'ReportMenuItem',
 +</code>
  
-                   'DiscountTableItem', 'DivisionData', 'Element', 'EmailActivity', 'Employee', 'EmployeeContact',+<code> 
 +                 'RuleAction', 'RuleActivity', 'RuleMacro', 'SalesGoal', 'ScheduledPayment', 
 +</code>
  
 +<code>
 +                 'SecurityRightChange', 'SelectionList', 'SelectionListItem', 'ServiceContractType',
 +</code>
  
 +<code>
 +                 'ServiceTicketPriority', 'Shipments', 'ShippingMethod', 'SpeedNote',
 +</code>
  
-                   'EmployeeGroup', 'GLAccount', 'GoodsItemPartLink', 'Graphic', 'Inventory',+<code> 
 +                 'StateTaxExemptionLink', 'Station', 'Store', 'StoreConstant', 'TaxClass', 'TaxLink', 
 +</code>
  
 +<code>
 +                 'TimeCard', 'TransDetail', 'TransDetailGraphic', 'TransDetailParam', 'TransHeader',
 +</code>
  
 +<code>
 +                 'TransHeaderUserField', 'TransMod', 'TransPart', 'TransTax', 'TransVariation',
 +</code>
  
-                   'InventoryLog', 'IOTemplate', 'Journal', 'Ledger', 'MarketingListItem', 'Part',+<code> 
 +                 'UserColumns', 'UserFieldDef', 'UserFieldLayout', 'UserName', 'UserOption', 
 +</code>
  
 +<code>
 +                 'Variable', 'VendorTransDetail', 'Warehouse', 'CommissionRate',
 +</code>
  
 +<code>
 +                 'TransDetailHistory', 'TransDetailGraphicHistory', 'TransDetailParamHistory',
 +</code>
  
-                   'PartInfoTemplate', 'PartInventoryConversion', 'PartUsageCard', 'Payment',+<code> 
 +                 'TransHeaderHistory', 'TransHeaderHistoryUserField', 'TransModHistory', 
 +</code>
  
 +<code>
 +                 'TransPartHistory', 'TransTaxHistory', 'TransVariationHistory',
 +</code>
  
 +<code>
 +                 'VendorTransDetailHistory', 'Warden', 'DBSettings', 'Sequence',
 +</code>
  
-                   'PaymentAccount', 'PaymentPlan', 'PaymentTerms', 'Payroll', 'PayrollPaycheck', +<code> 
- +                 'CCCSConfiguration', 'CCCSCustomer', 
- +</code>
- +
-                   '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', 'CommissionRate', +
- +
- +
- +
-                   'TransDetailHistory', 'TransDetailGraphicHistory', 'TransDetailParamHistory', +
- +
- +
- +
-                   'TransHeaderHistory', 'TransHeaderHistoryUserField', 'TransModHistory', +
- +
- +
- +
-                   'TransPartHistory', 'TransTaxHistory', 'TransVariationHistory', +
- +
- +
- +
-                   'VendorTransDetailHistory', 'Warden', 'DBSettings', 'Sequence', +
- +
- +
- +
-                   'CCCSConfiguration', 'CCCSCustomer', +
- +
- +
- +
-                   'CCCSTransactions', 'FedExShippingLogForShipments', +
- +
- +
- +
-                   'UPSShippingLogForShipments')+
  
 +<code>
 +                 'CCCSTransactions', 'FedExShippingLogForShipments',
 +</code>
  
 +<code>
 +                 'UPSShippingLogForShipments')
 +</code>
  
 Order By name Order By name
  
 +\\
  
- 
-<code>