core_company

«Company» / Global (global)

Derivation Hierarchy

core_company
«Company»
Global
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
×

Diagram core_company  «Company» / Global (global)

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