Table Details

Name:
sn_ent_industrial_asset
Label:
Industrial asset (en)
Created On:
2022.12.29 15:59:04
Created By:
admin
Updated On:
2022.12.29 15:59:04
Updated By:
system
Column Updated On:
2022.12.29 15:59:05
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 alm_asset
  active_to
Active transfer order boolean 40 Global alm_asset
  asset_function
Asset function choice[choice] 40 Global alm_asset
  asset_tag
Asset tag string 40 Global alm_asset
  assigned
Assigned glide_date_time 40 Global alm_asset
  assigned_to
Assigned to reference 32 Global sys_user alm_asset
  beneficiary
Beneficiary reference 255 Global core_company alm_asset
  checked_in
Checked in glide_date_time 40 Global alm_asset
  checked_out
Checked out glide_date_time 40 Global alm_asset
  ci
Configuration Item reference 32 Global cmdb_ci alm_asset
  comments
Comments string 4000 Global alm_asset
  company
Company reference 32 Global core_company alm_asset
  cost
Cost currency 20 Global alm_asset
  cost_center
Cost center reference 32 Global cmn_cost_center alm_asset
  delivery_date
Order received glide_date_time 40 Global alm_asset
  department
Department reference 32 Global cmn_department alm_asset
  depreciated_amount
Depreciated amount currency 20 Global alm_asset
  depreciation
Depreciation reference 32 Global cmdb_depreciation alm_asset
  depreciation_date
Depreciation effective date glide_date_time 40 Global alm_asset
 
D
display_name
Display name string 255 Global alm_asset
  disposal_reason
Disposal reason string 255 Global alm_asset
  due
Due glide_date_time 40 Global alm_asset
  due_in
Due in string[choice] 40 Global alm_asset
  expenditure_type
Expenditure type string[choice] 40 Global alm_asset
  gl_account
GL account string 40 Global alm_asset
  install_date
Installed glide_date_time 40 Global alm_asset
  install_status
State integer[choice] 40 Global alm_asset
  invoice_number
Invoice number string 40 Global alm_asset
  justification
Justification string[choice] 80 Global alm_asset
  lease_id
Lease contract string 40 Global alm_asset
  life_cycle_stage
Life Cycle Stage reference 40 Global life_cycle_stage alm_asset
  life_cycle_stage_status
Life Cycle Stage Status reference 40 Global life_cycle_stage_status alm_asset
  location
Location reference 32 Global cmn_location alm_asset
  managed_by
Managed by reference 32 Global sys_user alm_asset
 
M
model
Model reference 32 Global cmdb_model alm_asset
 
M
model_category
Model category reference 32 Global cmdb_model_category alm_asset
  old_status
Old status string 40 Global alm_asset
  old_substatus
Old substatus string 40 Global alm_asset
  order_date
Ordered glide_date_time 40 Global alm_asset
  owned_by
Owned by reference 32 Global sys_user alm_asset
  parent
Parent reference 32 Global alm_asset alm_asset
  po_number
PO number string 40 Global alm_asset
  pre_allocated
Pre-allocated boolean 40 Global alm_asset
  purchase_date
Purchased glide_date 40 Global alm_asset
 
M
quantity
Quantity integer 40 Global alm_asset
  request_line
Request line reference 32 Global sc_req_item alm_asset
  resale_price
Resale price price 20 Global alm_asset
  reserved_for
Reserved for reference 32 Global sys_user alm_asset
  residual
Residual value currency 20 Global alm_asset
  residual_date
Residual date glide_date 40 Global alm_asset
  retired
Retired date glide_date 40 Global alm_asset
  retirement_date
Scheduled retirement glide_date 40 Global alm_asset
  salvage_value
Salvage value currency 20 Global alm_asset
  serial_number
Serial number string 100 Global alm_asset
  skip_sync
Skip sync boolean 40 Global alm_asset
  stockroom
Stockroom reference 32 Global alm_stockroom alm_asset
  substatus
Substate string[choice] 40 Global alm_asset
  supported_by
Supported by reference 32 Global sys_user alm_asset
  support_group
Support group reference 32 Global sys_user_group alm_asset
  sys_class_name
Class sys_class_name[choice] 80 Global alm_asset
  sys_created_by
Created by string 40 Global alm_asset
  sys_created_on
Created glide_date_time 40 Global alm_asset
  sys_domain
Domain domain_id 32 Global alm_asset
  sys_domain_path
Domain Path domain_path 255 Global alm_asset
 
K
sys_id
Sys ID GUID 32 Expanded Model and Asset Classes sn_ent_industrial_asset
  sys_mod_count
Updates integer 40 Global alm_asset
  sys_updated_by
Updated by string 40 Global alm_asset
  sys_updated_on
Updated glide_date_time 40 Global alm_asset
  vendor
Vendor reference 32 Global core_company alm_asset
  warranty_expiration
Warranty expiration glide_date 40 Global alm_asset
  work_notes
Work notes journal_input 4000 Global alm_asset
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) Tokyo
account missing missing missing missing
consumer missing missing missing missing
model_component_id missing missing missing missing missing
primary_contact missing missing missing missing
product_instance_id missing missing missing missing missing
resold_value missing missing missing

Referenced

alm_asset referenced from table:
alm_asset, alm_transfer_order_line, asset_reclamation_request, asset_task, clm_m2m_contract_asset, clm_m2m_rate_card_asset, cmdb, fm_expense_line, itam_asset_usage, m2m_fixed_asset_to_asset

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