Derivation Hierarchy

Subclasses:
No Subclasses
Siblings:
No Siblings

Table Details

Name:
core_company
Label:
Company (en)
Created On:
2022.09.17 01:43:42
Created By:
system
Updated On:
2022.09.17 02:55:02
Updated By:
system
Column Updated On:
2022.09.17 02:05:41
Column Updated By:
system
Scope Name:
Global
Scope:
global
Listing:
open
Dictionary:
open

Columns

+ Status Name Label Datatype Length Scope Reference Included By
  apple_icon
Apple icon user_image 40 Global core_company
  banner_image Banner image user_image 40 Global core_company
  banner_image_light UI16 Banner Image user_image 40 Global core_company
  banner_text Banner text string 4000 Global core_company
  city
City string 50 Global core_company
  contact
Contact reference 32 Global sys_user core_company
  coordinates_retrieved_on
Coordinates retrieved on glide_date_time 40 Global core_company
  country
Country string 40 Global core_company
  customer
Customer boolean 40 Global core_company
  discount
Discount decimal 15 Global core_company
  fax_phone
Fax phone ph_number 40 Global core_company
  fiscal_year
Fiscal year glide_date 40 Global core_company
  latitude
Latitude float 40 Global core_company
  lat_long_error
Lat long error string 1000 Global core_company
  longitude
Longitude float 40 Global core_company
  manufacturer
Manufacturer boolean 40 Global core_company
  market_cap
Market cap currency 20 Global core_company
 
D
name
Name string 80 Global core_company
  notes
Notes string 4000 Global core_company
  num_employees
Number of employees integer 40 Global core_company
  parent
Parent reference 32 Global core_company core_company
  phone
Phone ph_number 40 Global core_company
  primary
Primary boolean 40 Global core_company
  profits
Profits currency 20 Global core_company
  publicly_traded
Publicly traded boolean 40 Global core_company
  rank_tier
Rank tier string[choice] 40 Global core_company
  revenue_per_year
Revenue per year currency 20 Global core_company
  state
State / Province string 40 Global core_company
  stock_price
Stock price string 40 Global core_company
  stock_symbol
Stock symbol string 40 Global core_company
  street
Street multi_two_lines 255 Global core_company
  sys_class_name
Class sys_class_name[choice] 80 Global core_company
  sys_created_by
Created by string 40 Global core_company
  sys_created_on
Created glide_date_time 40 Global core_company
 
K
sys_id
Sys ID GUID 32 Global core_company
  sys_mod_count
Updates integer 40 Global core_company
  sys_updated_by
Updated by string 40 Global core_company
  sys_updated_on
Updated glide_date_time 40 Global core_company
  theme
Theme reference 32 Global sys_ui_theme core_company
  vendor
Vendor boolean 40 Global core_company
  vendor_manager
Vendor manager glide_list 4000 Global sys_user core_company
  vendor_type
Vendor type glide_list 1024 Global vendor_type core_company
  website
Website url 1024 Global core_company
  zip
Zip / Postal code string 40 Global core_company
P
Passive
M
Mandatory
D
Display Value
K
Key
U
Unique
X
Deleted

Table Distribution

Washington Vancouver Uta Tokyo (Vanilla) Tokyo Sandiego

Deviating Attributes

Column Current Environment Washington Vancouver Uta Tokyo (Vanilla) Sandiego
canonical missing missing missing missing
hash missing missing missing missing
sso_source missing missing missing missing

Referenced

core_company referenced from table:
alm_asset, alm_transfer_order_line, alm_transfer_order_line_task, ast_contract, ast_license_base, ast_license_generic, ast_software_license, business_unit, cmdb, cmdb_ci_business_app, cmdb_ci_computer, cmdb_ci_netgear, cmdb_ci_network_adapter, cmdb_model, cmn_department, cmn_location, contract_sla, core_company, interaction, pc_vendor_cat_item, problem_task, sam_sw_product_lifecycle, sc_category_company_mtom, sc_category_company_no_mtom, sc_cat_item, sc_cat_item_company_mtom, sc_cat_item_company_no_mtom, service_subscribe_company, sn_gf_goal, sn_gf_strategy, sys_user, task, user_criteria, v_ais_result_improvement_rule_condition_builder_values

shift+click on node to show path. mouse scroll to zoom, dblclick to zoom in, dblclick+shift to zoom out