cmn_location

«Location» / Global (global)

Derivation Hierarchy

cmn_location
«Location»
Global
Subclasses:
No Subclasses
Siblings:
No Siblings

Table Details

Name:
cmn_location
Label:
Location (en)
Created On:
2022.09.17 01:43:42
Created By:
system
Updated On:
2022.09.17 02:55:01
Updated By:
system
Column Updated On:
2022.09.17 02:10:39
Column Updated By:
system
Scope Name:
Global
Scope:
global
Listing:
open
Dictionary:
open

Columns

+ Status Name Label Datatype Length Scope Reference Included By
  city
 City string 40 Global cmn_location
  cmn_location_source
 Location source string[choice] 40 Global cmn_location
  cmn_location_type
 Location type string[choice] 40 Global cmn_location
  company
 Company reference 32 Global core_company cmn_location
  contact
 Contact reference 32 Global sys_user cmn_location
  coordinates_retrieved_on
 Coordinates retrieved on glide_date_time 40 Global cmn_location
  country
 Country string[choice] 40 Global cmn_location
  duplicate
 Duplicate boolean 40 Global cmn_location
  fax_phone
 Fax phone string 40 Global cmn_location
  full_name
 Full name string 255 Global cmn_location
  latitude
 Latitude float 40 Global cmn_location
  lat_long_error
 Lat long error string 1000 Global cmn_location
  life_cycle_stage
 Life Cycle Stage reference 40 Global life_cycle_stage cmn_location
  life_cycle_stage_status
 Life Cycle Stage Status reference 40 Global life_cycle_stage_status cmn_location
  longitude
 Longitude float 40 Global cmn_location
  managed_by_group
 Managed by group reference 32 Global sys_user_group cmn_location
 
D
name
 Name string 100 Global cmn_location
  parent
 Parent reference 32 Global cmn_location cmn_location
  phone
 Phone string 40 Global cmn_location
  phone_territory
 Phone territory reference 32 Global sys_phone_territory cmn_location
  primary_location
 Primary location reference 32 Global cmn_location cmn_location
  state
 State / Province string 40 Global cmn_location
  stock_room
 Stock room boolean 40 Global cmn_location
  street
 Street multi_two_lines 255 Global cmn_location
  sys_created_by
 Created by string 40 Global cmn_location
  sys_created_on
 Created glide_date_time 40 Global cmn_location
 
K
sys_id
 Sys ID GUID 32 Global cmn_location
  sys_mod_count
 Updates integer 40 Global cmn_location
  sys_updated_by
 Updated by string 40 Global cmn_location
  sys_updated_on
 Updated glide_date_time 40 Global cmn_location
  time_zone
 Time zone string[choice] 40 Global cmn_location
  zip
 Zip / Postal Code string 40 Global cmn_location
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
consumer missing missing missing missing
primary missing missing missing missing
type missing missing missing missing

Referenced

cmn_location referenced from table:
alm_asset, alm_stockroom, alm_transfer_order, ast_contract, ast_license_base, change_request_imac, cmdb, cmn_building, cmn_cost_center, cmn_location, cmn_notif_message, contract_rel_location, dl_u_assignment, dsl, incident_fact_table, interaction, itil_appointment, mtg_definition, mtg_meeting, sc_category, sc_category_location_mtom, sc_category_location_no_mtom, sc_cat_item, sc_cat_item_location_mtom, sc_cat_item_location_no_mtom, service_subscribe_location, sys_user, task, task_location, user_criteria, v_ais_result_improvement_rule_condition_builder_values
×

Diagram cmn_location  «Location» / 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