Differences
This shows you the differences between two versions of the page.
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_@@ | ||
\\ | \\ | ||