table - sn_ent_transportation_model «Transportation model»

Derivation Hierarchy

cmdb_model «Product Model» Global
\| +—	sn_ent_model «Enterprise good model» Expanded Model and Asset Classes
	\| +—	sn_ent_transportation_model «Transportation model» Expanded Model and Asset Classes

Subclasses:: No Subclasses
Siblings:: sn_ent_industrial_model, sn_ent_tactical_model, sn_ent_medical_model, sn_ent_wearable_model, sn_ent_retail_model, sn_ent_facility_model, sn_ent_construction_model

Table Details

Name:: sn_ent_transportation_model
Label:: Transportation model (en)

Created On:: 2022.12.29 15:59:16
Created By:: admin

Updated On:: 2022.12.29 15:59:16
Updated By:: system

Column Updated On:: 2022.12.29 15:59:17
Column Updated By:: admin

Scope Name:: Expanded Model and Asset Classes
Scope:: sn_ent

Listing:: open
Dictionary:: open

Columns

Status	Name	Label	Datatype	Length	Scope	Reference	Included By
	acquisition_method	Acquisition method	string[choice]	40	Global		cmdb_model
	ac_dc	AC/DC	choice[choice]	40	Expanded Model and Asset Classes		sn_ent_model
	asset_tracking_strategy	Asset tracking strategy	string[choice]	40	Global		cmdb_model
	asset_tracking_unit	Asset tracking unit	reference	32	Global	cmdb_model_unit	cmdb_model
	barcode	Barcode	string	40	Global		cmdb_model
	bundle	Bundle	boolean	40	Global		cmdb_model
	certified	Certified	boolean	40	Global		cmdb_model
	classification	Classification	reference	32	Expanded Model and Asset Classes	sn_ent_model_classification	sn_ent_model
	cmdb_ci_class	CMDB CI class	string	40	Global		cmdb_model
	cmdb_model_category	Model categories	glide_list	1024	Global	cmdb_model_category	cmdb_model
	comments	Comments	string	4000	Global		cmdb_model
	cooling	Cooling	decimal	15	Expanded Model and Asset Classes		sn_ent_model
	cooling_unit	Cooling unit	choice[choice]	40	Expanded Model and Asset Classes		sn_ent_model
	cost	Cost	price	15	Global		cmdb_model
	depreciation	Depreciation	reference	32	Global	cmdb_depreciation	cmdb_model
	description	Description	translated_html	8000	Global		cmdb_model
D	display_name	Display name	string	255	Global		cmdb_model
	engine_power	Engine power	decimal	15	Expanded Model and Asset Classes		sn_ent_transportation_model
	engine_size	Engine size	decimal	15	Expanded Model and Asset Classes		sn_ent_transportation_model
	engine_type	Engine type	choice[choice]	40	Expanded Model and Asset Classes		sn_ent_transportation_model
	expenditure_type	Expenditure type	string[choice]	40	Global		cmdb_model
	flow_rate	Flow Rate (cfm)	integer	40	Global		cmdb_model
	fuel_tank_size	Fuel tank size	decimal	15	Expanded Model and Asset Classes		sn_ent_transportation_model
	fuel_type	Fuel type	choice[choice]	40	Expanded Model and Asset Classes		sn_ent_transportation_model
	full_name	Full name	string	100	Global		cmdb_model
	hazardous	Hazardous	boolean	40	Expanded Model and Asset Classes		sn_ent_model
	iso_certified	ISO Certified	boolean	40	Expanded Model and Asset Classes		sn_ent_model
	life_cycle_stage	Life Cycle Stage	reference	40	Global	life_cycle_stage	cmdb_model
	life_cycle_stage_status	Life Cycle Stage Status	reference	40	Global	life_cycle_stage_status	cmdb_model
	main_component	Main component	reference	32	Global	cmdb_m2m_model_component	cmdb_model
	manufacturer	Manufacturer	reference	32	Global	core_company	cmdb_model
	model_number	Model number	string	80	Global		cmdb_model
	model_year	Model year	integer	40	Expanded Model and Asset Classes		sn_ent_transportation_model
	name	Name	string	80	Global		cmdb_model
	owner	Owner	reference	32	Global	sys_user	cmdb_model
	passenger_capacity	Passenger capacity	decimal	15	Expanded Model and Asset Classes		sn_ent_transportation_model
	personal_info	Personally Identifiable Information (PII)	boolean	40	Expanded Model and Asset Classes		sn_ent_model
	picture	Picture	user_image	40	Global		cmdb_model
	power_consumption	Power (watts)	integer	40	Global		cmdb_model
	pressure	Pressure	decimal	15	Expanded Model and Asset Classes		sn_ent_model
	pressure_unit	Pressure unit	choice[choice]	40	Expanded Model and Asset Classes		sn_ent_model
	product_catalog_item	Catalog Item	reference	32	Global	sc_cat_item	cmdb_model
	rack_units	Height (U)	integer	40	Global		cmdb_model
	refrigerant_type	Refrigerant type	choice[choice]	40	Expanded Model and Asset Classes		sn_ent_model
	salvage_value	Salvage value	currency	20	Global		cmdb_model
	short_description	Short description	string	100	Global		cmdb_model
	sla	SLA	string	30	Global		cmdb_model
	sound_power	Sound Power (bels)	integer	40	Global		cmdb_model
	status	Status	string[choice]	40	Global		cmdb_model
	storage_capacity	Storage capacity	decimal	15	Expanded Model and Asset Classes		sn_ent_transportation_model
	sys_class_name	Class	sys_class_name[choice]	80	Global		cmdb_model
	sys_created_by	Created by	string	40	Global		cmdb_model
	sys_created_on	Created	glide_date_time	40	Global		cmdb_model
	sys_domain	Domain	domain_id	32	Global		cmdb_model
	sys_domain_path	Domain path	domain_path	255	Global		cmdb_model
K	sys_id	Sys ID	GUID	32	Expanded Model and Asset Classes		sn_ent_transportation_model
	sys_mod_count	Updates	integer	40	Global		cmdb_model
	sys_updated_by	Updated by	string	40	Global		cmdb_model
	sys_updated_on	Updated	glide_date_time	40	Global		cmdb_model
	temperature	Temperature	decimal	15	Expanded Model and Asset Classes		sn_ent_model
	temperature_unit	Temperature unit	choice[choice]	40	Expanded Model and Asset Classes		sn_ent_model
	type	Type	string[choice]	40	Global		cmdb_model
	useful_life	Useful life (months)	integer	40	Expanded Model and Asset Classes		sn_ent_model
	weight	Weight (lbs)	integer	40	Global		cmdb_model

Passive

Mandatory

Display Value

Key

Unique

Deleted

Table Distribution

Washington Vancouver Uta Tokyo (Vanilla) Tokyo Sandiego

Deviating Attributes

Column	Current Environment	Washington	Vancouver	Uta	Tokyo (Vanilla)	Tokyo
ac_dc		missing	missing	missing	missing	missing
classification		missing	missing	missing	missing	missing
company	missing	missing			missing	missing
cooling		missing	missing	missing	missing	missing
cooling_unit		missing	missing	missing	missing	missing
current	missing
current_unit	missing
customer_visible	missing	missing			missing	missing
depth	missing
dimensions_unit	missing
energy_star	missing
energy_use	missing
engine_power		missing	missing	missing	missing	missing
engine_size		missing	missing	missing	missing	missing
engine_type		missing	missing	missing	missing	missing
expected_lifetime_co2e	missing
fuel_tank_size		missing	missing	missing	missing	missing
fuel_type		missing	missing	missing	missing	missing
hazardous		missing	missing	missing	missing	missing
height	missing
iso_certified		missing	missing	missing	missing	missing
length	missing
model_year		missing	missing	missing	missing	missing
name		different	different	different	different	different
passenger_capacity		missing	missing	missing	missing	missing
personal_info		missing	missing	missing	missing	missing
power_unit	missing
pressure		missing	missing	missing	missing	missing
pressure_unit		missing	missing	missing	missing	missing
rated_power	missing
refrigerant_type		missing	missing	missing	missing	missing
storage_capacity		missing	missing	missing	missing	missing
temperature		missing	missing	missing	missing	missing
temperature_unit		missing	missing	missing	missing	missing
unit_of_measure_system	missing
useful_life		missing	missing	missing	missing	missing
voltage	missing
voltage_unit	missing
volume	missing
volume_unit	missing
weight_decimal	missing
weight_unit	missing
width	missing
	show all 43 ...

Referenced

cmdb_model referenced from table:: alm_asset, alm_m2m_stockroom_model, alm_stock_rule, alm_transfer_order_line, asset_task, ast_contract, cmdb, cmdb_ci_model_entry, cmdb_class_info, cmdb_m2m_model_compatibility, cmdb_m2m_model_component, cmdb_m2m_model_substitute, cmdb_model_lifecycle, pc_vendor_cat_item, sc_cat_item, sn_prod_cat_rel_m2m_product_catalog_item

Diagram sn_ent_transportation_model «Transportation model» / Expanded Model and Asset Classes (sn_ent)

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