Differences

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

Link to this comparison view

Last revision Both sides next revision
control_database_tables [2019/01/30 09:22]
127.0.0.1 external edit
control_database_tables [2019/02/07 10:57]
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
  
 +@@_SP_@@
 +\\
  
- 
-<​code>​