`corporations`.`corp_id`, - standalone field `corporations`.`corp_initials`, - standalone filed - sometimes used in joins for reports `corporations`.`corp_name`, - standalone filed - often used in joins for reports `corporations`.`corp_address`, - basic info group `corporations`.`corp_address_2`, - basic info group `corporations`.`corp_city`, - basic info group `corporations`.`corp_state`, - basic info group - sometimes looked up for special treatment per state `corporations`.`corp_zip`, - basic info group `corporations`.`corp_status`, - standalone field - used in multiple queries to determine if active/inactive `corporations`.`corp_ein`, - standalone field - encrypted for storage `corporations`.`corp_country_id`, - basic info group `corporations`.`corp_phone`, - basic info group `corporations`.`corp_web_address`, - basic info group `corporations`.`corp_e_mail`, - basic info group `corporations`.`corp_logo`, - basic look and feel `corporations`.`corp_look_feel`, - basic look and feel `corporations`.`corp_bg_color`, - basic look and feel `corporations`.`corp_text_color`, - basic look and feel `corporations`.`corp_title_color`, - basic look and feel `corporations`.`corp_link_color`, - basic look and feel `corporations`.`corp_rollover_color`, - basic look and feel `corporations`.`corp_rollover_bg_color`, - basic look and feel `corporations`.`corp_row_color`, - basic look and feel `corporations`.`corp_row_text_color`, - basic look and feel `corporations`.`corp_hr_color`, - basic look and feel `corporations`.`corp_error_row_color`, - basic look and feel `corporations`.`corp_error_row_text_color`, - basic look and feel `corporations`.`start_week_day`, - payroll info group `corporations`.`end_week_day`, - payroll info group `corporations`.`pay_frequency_id`, - payroll info group `corporations`.`corp_overtime_value`, - payroll info group `corporations`.`state_withholding_initials`, - payroll info group `corporations`.`irs_customer_id`, - payroll info group `corporations`.`state_customer_id`, - payroll info group `corporations`.`suta_customer_id`, - payroll info group `corporations`.`federal_withholding_id`, - payroll info group `corporations`.`state_withholding_id`, - payroll info group `corporations`.`payee_social_withholding_id`, - payroll info group `corporations`.`corp_social_withholding_id`, - payroll info group `corporations`.`payee_medicare_withholding_id`, - payroll info group `corporations`.`corp_medicare_withholding_id`, - payroll info group `corporations`.`futa_withholding_id`, - payroll info group `corporations`.`suta_withholding_id`, - payroll info group `corporations`.`suta_wage_limit`, - payroll info group `corporations`.`suta_tax_percentage`, - payroll info group `corporations`.`show_corp_on_web`, - ecommerce group `corporations`.`corp_notes`, - basic info group `corporations`.`corp_end_date`, - basic info group `corporations`.`corp_start_date`, - basic info group `corporations`.`title_parts`, - parts group `corporations`.`tax_category_id`, - parts group `corporations`.`number_of_decimals`, - parts group `corporations`.`part_mark_up`, - parts group `corporations`.`show_invoice_conversions`, - parts group `corporations`.`from_physical_month`, - basic info group `corporations`.`from_physical_day`, - basic info group `corporations`.`to_physical_month`, - basic info group `corporations`.`to_physical_day`, - basic info group `corporations`.`lock_down_date`, - basic info group `corporations`.`tax_fee_1`, - invoice group `corporations`.`tax_fee_2`, - invoice group `corporations`.`tax_fee_3`, - invoice group `corporations`.`tax_fee_4`, - invoice group `corporations`.`tax_fee_5`, - invoice group `corporations`.`tax_fee_6`, - invoice group `corporations`.`customer_invoice_name`, - invoice group `corporations`.`customer_invoice_short`, - invoice group `corporations`.`transition_invoice_name`, - invoice group `corporations`.`transition_invoice_short`, - invoice group `corporations`.`customer_search_type_id`, - customer group `corporations`.`vendor_search_type_id`, - vendor group `corporations`.`default_customer_name`, - customer group `corporations`.`default_customer_short`, - customer group `corporations`.`default_part_name`, - parts group `corporations`.`default_part_short`, - parts group `corporations`.`default_loc_name`, - location group `corporations`.`default_loc_short`, - location group `corporations`.`default_salesperson_name`, - invoice group `corporations`.`default_salesperson_short`, - invoice group `corporations`.`show_units_on_web`, - ecommerce group `corporations`.`show_parts_on_web`, - ecommerce group `corporations`.`show_bin_numbers`, - invoice group `corporations`.`default_recalc_taxes`, - invoice group `corporations`.`default_recalc_payroll`, - payroll info group `corporations`.`show_line_num_inv`, - invoice group `corporations`.`show_line_num_dep`, - deposit group `corporations`.`show_line_num_po`, - po group `corporations`.`show_unit_of_measure`, - invoice group `corporations`.`show_line_num_rec`, - expense group `corporations`.`default_part_number`, - parts group `corporations`.`default_part_number_short`, - parts group `corporations`.`default_customer_terms`, - customer group `corporations`.`default_corp_type`, - basic info group `corporations`.`default_corp_type_short`, - basic info group `corporations`.`specific_unit_name`, - stock/unit group `corporations`.`invoice_thank_you_line`, - invoice group `corporations`.`invoice_show_signature_1`, - invoice group `corporations`.`invoice_signature_text_1`, - invoice group `corporations`.`invoice_show_signature_2`, - invoice group `corporations`.`invoice_signature_text_2`, - invoice group `corporations`.`invoice_extra_line_1`, - invoice group `corporations`.`invoice_extra_line_2`, - invoice group `corporations`.`invoice_extra_line_3`, - invoice group `corporations`.`barcode_quick_cart`, - cart group `corporations`.`quick_cash_checkout`, - cart group `corporations`.`checkout_payment_number`, - cart group `corporations`.`default_printable_invoice`, - cart group `corporations`.`default_barcode_size`, - parts group `corporations`.`show_unit_prices`, - ecommerce group `corporations`.`show_parts_prices`, - ecommerce group `corporations`.`web_return_address`, - ecommerce group `corporations`.`show_contact_page`, - ecommerce group `corporations`.`use_loc_specific_inventory`, - cart group `corporations`.`limited_invoice_name`, - invoice group `corporations`.`show_signature_1_invoice`, - invoice group `corporations`.`show_signature_1_limited`, - invoice group `corporations`.`show_signature_1_mini`, - invoice group `corporations`.`show_signature_2_invoice`, - invoice group `corporations`.`show_signature_2_limited`, - invoice group `corporations`.`show_signature_2_mini`, - invoice group `corporations`.`external_po_name`, - invoice group - seems like a po setting but it deals with paying with a PO for an invoice `corporations`.`use_external_po`, - invoice group - tied to use_external_po - makes it show up in the cart to record the external PO `corporations`.`po_name_basic_live`, - po group `corporations`.`po_name_basic_request`, - po group `corporations`.`po_name_special_live`, - po group `corporations`.`po_name_special_request`, - po group `corporations`.`show_taxes`, - invoice group `corporations`.`cc_payment_mode`, - cart group `corporations`.`advanced_add_switch`, - cart group `corporations`.`allow_cross_corp_billing`, - cart group `corporations`.`customer_tax_name`, - customer group `corporations`.`loc_license_name`, - location group `corporations`.`custom_disclaimer_text`, - invoice group - deals with the invoice disclaimer `corporations`.`custom_disclaimer_id`, - invoice group `corporations`.`customer_id`, - standalone field - only used by adilas to tie in a customer to a corp (not used that much...) new master tables does a better job. `corporations`.`customer_start_date_name`, - customer group `corporations`.`customer_end_date_name`, - customer group `corporations`.`period_start_date_name`, - customer group `corporations`.`period_end_date_name`, - customer group `corporations`.`customer_queue_name`, - customer group `corporations`.`calendar_block_size`, - elements of time group `corporations`.`time_slot_block_size`, - elements of time group `corporations`.`time_slot_frequency_id`, - elements of time group `corporations`.`time_slot_start_range`, - elements of time group `corporations`.`time_slot_end_range`, - elements of time group `corporations`.`default_time_report_type`, - elements of time group `corporations`.`default_time_period`, - elements of time group `corporations`.`time_show_group_subs`, - elements of time group `corporations`.`customer_queue_short`, - customer group `corporations`.`use_customer_queue`, - customer group `corporations`.`queue_flush_rate`, - customer group `corporations`.`use_review_cart`, - cart group `corporations`.`web_price_name`, - ecommerce group `corporations`.`web_price_short`, - ecommerce group `corporations`.`show_tax_breakdown`, - invoice group `corporations`.`cart_quick_search_list`, - cart group `corporations`.`custom_homepages`, - standalone field - spot to store a list of custom links and custom pages `corporations`.`web_store_id`, - ecommerce group `corporations`.`web_salesperson_id`, - ecommerce group `corporations`.`web_invoice_type_id`, - ecommerce group `corporations`.`web_merchant_setting_id`, - ecommerce group `corporations`.`web_customer_login_1`, - ecommerce group `corporations`.`web_customer_login_2`, - ecommerce group `corporations`.`web_allow_quotes`, - ecommerce group `corporations`.`web_allow_invoices`, - ecommerce group `corporations`.`web_allow_new_customers`, - ecommerce group `corporations`.`web_allow_statements`, - ecommerce group `corporations`.`web_allow_histories`, - ecommerce group `corporations`.`web_allow_bill_pay`, - ecommerce group `corporations`.`web_thumbnail_display_size`, - ecommerce group `corporations`.`web_show_count`, - ecommerce group `corporations`.`web_show_nav`, - ecommerce group `corporations`.`web_check_quantity`, - ecommerce group `corporations`.`web_show_quote_button`, - ecommerce group `corporations`.`web_show_order_button`, - ecommerce group `corporations`.`web_quote_button_text`, - ecommerce group `corporations`.`web_order_button_text`, - ecommerce group `corporations`.`web_invoice_button_text`, - ecommerce group `corporations`.`web_include_shipping`, - ecommerce group `corporations`.`web_shipping_part_id`, - ecommerce group `corporations`.`web_shipping_general_value`, - ecommerce group `corporations`.`web_skip_shipping`, - ecommerce group `corporations`.`web_customer_type_id`, - ecommerce group `corporations`.`web_wholesale_prices`, - ecommerce group `corporations`.`web_send_email_from`, - ecommerce group `corporations`.`web_cc_email_to`, - ecommerce group `corporations`.`corp_stock_name_full`, - stock/unit group `corporations`.`corp_stock_name`, - stock/unit group `corporations`.`corp_make_name`, - stock/unit group `corporations`.`corp_model_name`, - stock/unit group `corporations`.`corp_inventory_type_name`, - stock/unit group `corporations`.`corp_sub_inventory_type_name`, - stock/unit group `corporations`.`corp_vin_name`, - stock/unit group `corporations`.`use_rfid_tag_numbers`, - parts group `corporations`.`rfid_tag_number_name`, - parts group `corporations`.`corp_key_alias`, - standalone field - used in the login process `corporations`.`temp_use`, - standalone field - used for different reasons during migration or special tasks. random `corporations`.`restore_quote_to_cart_setting`, - cart group `corporations`.`auto_apply_discount_to_ecommerce`, - ecommerce group `corporations`.`default_discount_type`, - cart group `corporations`.`discount_requires_manager_approval`,- cart group `corporations`.`discount_campaign_settings`, - cart group `corporations`.`auto_restore_rfid`, - cart group `corporations`.`ecommerce_theme_folder`, - ecommerce group `corporations`.`secure_theme_folder`, - basic look and feel `corporations`.`secure_shopping_cart_skins`, - cart group `corporations`.`secure_header_choice`, - basic look and feel `corporations`.`secure_footer_choice`, - basic look and feel `corporations`.`secure_css_choice`, - basic look and feel `corporations`.`alternate_corp_logo`, - basic look and feel `corporations`.`watermark_image`, - basic look and feel --- Russell's fields are below here, for the most part... --- `corporations`.`web_theme_color`, - 2nd ecommerce group `corporations`.`web_show_sm`, - 2nd ecommerce group `corporations`.`web_show_med`, - 2nd ecommerce group `corporations`.`web_show_ib`, - 2nd ecommerce group `corporations`.`web_show_dt`, - 2nd ecommerce group `corporations`.`web_show_ft`, - 2nd ecommerce group `corporations`.`web_show_ftb`, - 2nd ecommerce group `corporations`.`web_contact_email`, - 2nd ecommerce group `corporations`.`web_quote_email`, - 2nd ecommerce group `corporations`.`web_invoice_email`, - 2nd ecommerce group `corporations`.`web_show_address_type`, - 2nd ecommerce group `corporations`.`web_return_address_name`, - 2nd ecommerce group `corporations`.`web_address_1_link`, - 2nd ecommerce group `corporations`.`web_address_1_name`, - 2nd ecommerce group `corporations`.`web_address_2_link`, - 2nd ecommerce group `corporations`.`web_address_2_name`, - 2nd ecommerce group `corporations`.`web_address_3_link`, - 2nd ecommerce group `corporations`.`web_address_3_name`, - 2nd ecommerce group `corporations`.`web_address_4_link`, - 2nd ecommerce group `corporations`.`web_address_4_name`, - 2nd ecommerce group `corporations`.`web_address_5_link`, - 2nd ecommerce group `corporations`.`web_address_5_name`, - 2nd ecommerce group `corporations`.`default_ecommerce_image`, - 2nd ecommerce group `corporations`.`web_shipping_type`, - 2nd ecommerce group `corporations`.`web_contact_message`, - 2nd ecommerce group `corporations`.`web_show_google_map`, - 2nd ecommerce group `corporations`.`web_google_long`, - 2nd ecommerce group `corporations`.`web_google_lat`, - 2nd ecommerce group `corporations`.`web_invoice_type`, - 2nd ecommerce group `corporations`.`web_thank_you_message`, - 2nd ecommerce group `corporations`.`web_drop_down_name`, - 2nd ecommerce group `corporations`.`web_shipping_o1`, - 2nd ecommerce group `corporations`.`web_shipping_o1_amount`, - 2nd ecommerce group `corporations`.`web_shipping_o2`, - 2nd ecommerce group `corporations`.`web_shipping_o2_amount`, - 2nd ecommerce group `corporations`.`web_shipping_o3`, - 2nd ecommerce group `corporations`.`web_shipping_o3_amount`, - 2nd ecommerce group `corporations`.`web_shipping_o4`, - 2nd ecommerce group `corporations`.`web_shipping_o4_amount`, - 2nd ecommerce group `corporations`.`web_shipping_o5`, - 2nd ecommerce group `corporations`.`web_shipping_o5_amount`, - 2nd ecommerce group `corporations`.`web_email_invoice_customer`, - 2nd ecommerce group `corporations`.`web_email_invoice_me`, - 2nd ecommerce group `corporations`.`web_email_quote_customer`, - 2nd ecommerce group `corporations`.`web_email_quote_me`, - 2nd ecommerce group `corporations`.`web_order_message`, - 2nd ecommerce group `corporations`.`web_quote_message`, - 2nd ecommerce group `corporations`.`web_send_invoice_email`, - 2nd ecommerce group `corporations`.`web_send_quote_email`, - 2nd ecommerce group `corporations`.`web_quote_type`, - 2nd ecommerce group `corporations`.`web_email_message_invoice`, - 2nd ecommerce group `corporations`.`web_email_message_order`, - 2nd ecommerce group `corporations`.`web_email_message_quote`, - 2nd ecommerce group `corporations`.`ecommerce_tab_icon`, - 2nd ecommerce group `corporations`.`ecommerce_logo`, - 2nd ecommerce group `corporations`.`ecommerce_logo_width`, - 2nd ecommerce group `corporations`.`web_social_icons_top`, - 2nd ecommerce group `corporations`.`web_social_icons_footer`, - 2nd ecommerce group `corporations`.`web_social_icon1_link`, - 2nd ecommerce group `corporations`.`web_social_icon1_type`, - 2nd ecommerce group `corporations`.`web_social_icon2_link`, - 2nd ecommerce group `corporations`.`web_social_icon2_type`, - 2nd ecommerce group `corporations`.`web_social_icon3_link`, - 2nd ecommerce group `corporations`.`web_social_icon3_type`, - 2nd ecommerce group `corporations`.`web_social_icon4_link`, - 2nd ecommerce group `corporations`.`web_social_icon4_type`, - 2nd ecommerce group `corporations`.`web_social_icon5_link`, - 2nd ecommerce group `corporations`.`web_social_icon5_type`, - 2nd ecommerce group `corporations`.`web_social_icon6_link`, - 2nd ecommerce group `corporations`.`web_social_icon6_type`, - 2nd ecommerce group `corporations`.`web_social_icon7_link`, - 2nd ecommerce group `corporations`.`web_social_icon7_type`, - 2nd ecommerce group `corporations`.`web_social_icon8_link`, - 2nd ecommerce group `corporations`.`web_social_icon8_type`, - 2nd ecommerce group `corporations`.`web_social_icon1_footer_link`, - 2nd ecommerce group `corporations`.`web_social_icon1_footer_type`, - 2nd ecommerce group `corporations`.`web_social_icon2_footer_link`, - 2nd ecommerce group `corporations`.`web_social_icon2_footer_type`, - 2nd ecommerce group `corporations`.`web_social_icon3_footer_link`, - 2nd ecommerce group `corporations`.`web_social_icon3_footer_type`, - 2nd ecommerce group `corporations`.`web_social_icon4_footer_link`, - 2nd ecommerce group `corporations`.`web_social_icon4_footer_type`, - 2nd ecommerce group `corporations`.`web_social_icon5_footer_link`, - 2nd ecommerce group `corporations`.`web_social_icon5_footer_type`, - 2nd ecommerce group `corporations`.`web_use_extra_footer`, - 2nd ecommerce group `corporations`.`web_use_footer_first_col`, - 2nd ecommerce group `corporations`.`web_footer_logo`, - 2nd ecommerce group `corporations`.`web_footer_message`, - 2nd ecommerce group `corporations`.`web_footer_extra_link`, - 2nd ecommerce group `corporations`.`web_footer_extra_link_name`, - 2nd ecommerce group `corporations`.`web_use_footer_contact`, - 2nd ecommerce group `corporations`.`web_use_footer_list_links`, - 2nd ecommerce group `corporations`.`web_footer_list_links_name`, - 2nd ecommerce group `corporations`.`web_footer_list_link1`, - 2nd ecommerce group `corporations`.`web_footer_list_link1_name`, - 2nd ecommerce group `corporations`.`web_footer_list_link2`, - 2nd ecommerce group `corporations`.`web_footer_list_link2_name`, - 2nd ecommerce group `corporations`.`web_footer_list_link3`, - 2nd ecommerce group `corporations`.`web_footer_list_link3_name`, - 2nd ecommerce group `corporations`.`web_footer_list_link4`, - 2nd ecommerce group `corporations`.`web_footer_list_link4_name`, - 2nd ecommerce group `corporations`.`web_footer_list_link5`, - 2nd ecommerce group `corporations`.`web_footer_list_link5_name`, - 2nd ecommerce group `corporations`.`web_footer_list_link6`, - 2nd ecommerce group `corporations`.`web_footer_list_link6_name`, - 2nd ecommerce group `corporations`.`web_use_footer_pic_links`, - 2nd ecommerce group `corporations`.`web_footer_pic_links_name`, - 2nd ecommerce group `corporations`.`web_footer_pic_link1`, - 2nd ecommerce group `corporations`.`web_footer_pic1`, - 2nd ecommerce group `corporations`.`web_footer_pic_link2`, - 2nd ecommerce group `corporations`.`web_footer_pic2`, - 2nd ecommerce group `corporations`.`web_footer_pic_link3`, - 2nd ecommerce group `corporations`.`web_footer_pic3`, - 2nd ecommerce group `corporations`.`web_footer_pic_link4`, - 2nd ecommerce group `corporations`.`web_footer_pic4`, - 2nd ecommerce group `corporations`.`web_footer_pic_link5`, - 2nd ecommerce group `corporations`.`web_footer_pic5`, - 2nd ecommerce group `corporations`.`web_footer_pic_link6`, - 2nd ecommerce group `corporations`.`web_footer_pic6`, - 2nd ecommerce group `corporations`.`web_footer_pic_link7`, - 2nd ecommerce group `corporations`.`web_footer_pic7`, - 2nd ecommerce group `corporations`.`web_footer_pic_link8`, - 2nd ecommerce group `corporations`.`web_footer_pic8`, - 2nd ecommerce group `corporations`.`web_footer_pic_link9`, - 2nd ecommerce group `corporations`.`web_footer_pic9`, - 2nd ecommerce group `corporations`.`seo_description`, - 2nd ecommerce group `corporations`.`show_hide_shop_introduction`, - 2nd ecommerce group `corporations`.`use_affiliate_email`, - 2nd ecommerce group `corporations`.`use_cloned_sites`, - 2nd ecommerce group `corporations`.`use_coupon_code`, - 2nd ecommerce group `corporations`.`use_secure_lockdown`, - 2nd ecommerce group `corporations`.`use_url_affiliate`, - 2nd ecommerce group `corporations`.`footer_logo_width`, - 2nd ecommerce group `corporations`.`use_quote_am_email`, - 2nd ecommerce group `corporations`.`use_customer_queue_for_ecommerce`, - 2nd ecommerce group `corporations`.`general_web_queue_name`, - 2nd ecommerce group `corporations`.`use_ecommerce_email_quote`, - 2nd ecommerce group `corporations`.`use_ecommerce_email_invoice`, - 2nd ecommerce group `corporations`.`web_use_sub_attribute_search`, - 2nd ecommerce group `corporations`.`web_sub_attribute_show`, - 2nd ecommerce group `corporations`.`web_show_tags_item_page`, - 2nd ecommerce group `corporations`.`web_show_tags_description_page`, - 2nd ecommerce group `corporations`.`web_use_tag_search`, - 2nd ecommerce group `corporations`.`web_sub_inventory_sale`, - 2nd ecommerce group `corporations`.`web_use_real_reviews`, - 2nd ecommerce group `corporations`.`web_use_app_icon`, - 2nd ecommerce group `corporations`.`web_app_icon_title`, - 2nd ecommerce group `corporations`.`web_app_icon_192`, - 2nd ecommerce group `corporations`.`web_app_icon_180`, - 2nd ecommerce group `corporations`.`web_app_icon_167`, - 2nd ecommerce group `corporations`.`web_app_icon_152`, - 2nd ecommerce group `corporations`.`web_app_icon_120`, - 2nd ecommerce group `corporations`.`web_app_icon_76`, - 2nd ecommerce group `corporations`.`web_app_icon_32`, - 2nd ecommerce group --- some old and some new below here... --- `corporations`.`parent_attribute_grouping_name`, - parts group `corporations`.`parent_attribute_name`, - parts group `corporations`.`individual_parent_attribute_grouping_name`,- parts group `corporations`.`individual_parent_attribute_name`, - parts group `corporations`.`web_category_buffer`, - 2nd ecommerce group `corporations`.`web_hide_inventory`, - 2nd ecommerce group `corporations`.`web_use_password_renewal`, - 2nd ecommerce group `corporations`.`po_vendor_name_2`, - po group `corporations`.`receipt_vendor_name_2`, - expense group `corporations`.`auto_round_invoices`, - invoice group `corporations`.`invoice_rounding_break_point`, - invoice group `corporations`.`invoice_rounding_part_id`, - invoice group `corporations`.`show_po_address_vendor_2`, - po group `corporations`.`show_po_address_bottom_of_page`, - po group `corporations`.`invoice_quote_email_contact`, - invoice group `corporations`.`web_show_category_amount`, - 2nd ecommerce group `corporations`.`default_ecommerce_part_image` - 2nd ecommerce group