sn_ent_asset

«Enterprise asset» / Expanded Model and Asset Classes (sn_ent)

Table Details

Name:
sn_ent_asset
Label:
Enterprise asset (en)
Created On:
2022.12.29 15:58:59
Created By:
admin
Updated On:
2022.12.29 15:58:58
Updated By:
system
Column Updated On:
2022.12.29 15:58:59
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_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
×

Diagram sn_ent_asset  «Enterprise asset» / Expanded Model and Asset Classes (sn_ent)

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