Differences

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

Link to this comparison view

Both sides previous revision Previous revision
control_database_tables [2019/02/07 10:57]
kcifreo
control_database_tables [2019/02/07 10:58] (current)
kcifreo
Line 9: Line 9:
 |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|| |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\\+**Tables Used Undirectly By Control** 
 + 
 +\\
 CCCSConfiguration CCCSConfiguration
  
Line 20: Line 22:
 UPSShippingLogForShipments UPSShippingLogForShipments
  
-Query to pull unused tables+**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.
Line 150: Line 152:
 Order By name Order By name
  
-@@_SP_@@ 
 \\ \\