alm_asset

The table below describes the alm_asset table.

This table contains the following foldable columns:

  • sys_id_value
  • assigned_to_value
  • beneficiary_value
  • ci_value
  • company_value
  • cost_center_value
  • department_value
  • depreciation_value
  • location_value
  • managed_by_value
  • model_category_value
  • model_value
  • owned_by_value
  • parent_value
  • request_line_value
  • reserved_for_value
  • stockroom_value
  • support_group_value
  • supported_by_value
  • vendor_value
  • acquisition_method_display_value
  • acquisition_method_value
  • active_to_display_value
  • active_to_value
  • asset_tag_display_value
  • asset_tag_value
  • assigned_display_value
  • assigned_to_display_value
  • assigned_value
  • beneficiary_display_value
  • checked_in_display_value
  • checked_in_value
  • checked_out_display_value
  • checked_out_value
  • ci_display_value
  • comments_display_value
  • comments_value
  • company_display_value
  • cost_center_display_value
  • cost_display_value
  • cost_value
  • delivery_date_display_value
  • delivery_date_value
  • department_display_value
  • depreciated_amount_display_value
  • depreciated_amount_value
  • depreciation_date_display_value
  • depreciation_date_value
  • depreciation_display_value
  • display_name_display_value
  • display_name_value
  • disposal_reason_display_value
  • disposal_reason_value
  • due_display_value
  • due_in_display_value
  • due_in_value
  • due_value
  • expenditure_type_display_value
  • expenditure_type_value
  • gl_account_display_value
  • gl_account_value
  • install_date_display_value
  • install_date_value
  • install_status_display_value
  • install_status_value
  • invoice_number_display_value
  • invoice_number_value
  • justification_display_value
  • justification_value
  • lease_id_display_value
  • lease_id_value
  • location_display_value
  • managed_by_display_value
  • model_category_display_value
  • model_display_value
  • old_status_display_value
  • old_status_value
  • old_substatus_display_value
  • old_substatus_value
  • order_date_display_value
  • order_date_value
  • owned_by_display_value
  • parent_display_value
  • po_number_display_value
  • po_number_value
  • pre_allocated_display_value
  • pre_allocated_value
  • purchase_date_display_value
  • purchase_date_value
  • quantity_display_value
  • quantity_value
  • request_line_display_value
  • resale_price_display_value
  • resale_price_value
  • reserved_for_display_value
  • residual_date_display_value
  • residual_date_value
  • residual_display_value
  • residual_value
  • retired_display_value
  • retired_value
  • retirement_date_display_value
  • retirement_date_value
  • salvage_value_display_value
  • salvage_value_value
  • serial_number_display_value
  • serial_number_value
  • skip_sync_display_value
  • skip_sync_value
  • stockroom_display_value
  • substatus_display_value
  • substatus_value
  • support_group_display_value
  • supported_by_display_value
  • sys_class_name_display_value
  • sys_class_name_value
  • sys_created_by_display_value
  • sys_created_by_value
  • sys_created_on_display_value
  • sys_created_on_value
  • sys_domain_display_value
  • sys_domain_path_display_value
  • sys_domain_path_value
  • sys_domain_value
  • sys_id_display_value
  • sys_mod_count_display_value
  • sys_mod_count_value
  • sys_tags_display_value
  • sys_tags_value
  • sys_updated_by_display_value
  • sys_updated_by_value
  • sys_updated_on_display_value
  • sys_updated_on_value
  • vendor_display_value
  • warranty_expiration_display_value
  • warranty_expiration_value
  • work_notes_display_value
  • work_notes_value

The primary key columns in this table are returnable.

Column Name SQL Type Updatable Nullable

sys_id_value

Primary Key
 SQL_VARCHAR(64) False False

assigned_to_value

Foreign Key linked to column sys_id_value in sys_user table
 SQL_VARCHAR(64) True True

beneficiary_value

Foreign Key linked to column sys_id_value in core_company table
 SQL_VARCHAR(510) True True

ci_value

Foreign Key linked to column sys_id_value in cmdb_ci table
 SQL_VARCHAR(64) True True

company_value

Foreign Key linked to column sys_id_value in core_company table
 SQL_VARCHAR(64) True True

cost_center_value

Foreign Key linked to column sys_id_value in cmn_cost_center table
 SQL_VARCHAR(64) True True

department_value

Foreign Key linked to column sys_id_value in cmn_department table
 SQL_VARCHAR(64) True True

depreciation_value

Foreign Key linked to column sys_id_value in cmdb_depreciation table
 SQL_VARCHAR(64) True True

location_value

Foreign Key linked to column sys_id_value in cmn_location table
 SQL_VARCHAR(64) True True

managed_by_value

Foreign Key linked to column sys_id_value in sys_user table
 SQL_VARCHAR(64) True True

model_category_value

Foreign Key linked to column sys_id_value in cmdb_model_category table
 SQL_VARCHAR(64) True True

model_value

Foreign Key linked to column sys_id_value in cmdb_model table
 SQL_VARCHAR(64) True True

owned_by_value

Foreign Key linked to column sys_id_value in sys_user table
 SQL_VARCHAR(64) True True

parent_value

Foreign Key linked to column sys_id_value in alm_asset table
 SQL_VARCHAR(64) True True

request_line_value

Foreign Key linked to column sys_id_value in sc_req_item table
 SQL_VARCHAR(64) True True

reserved_for_value

Foreign Key linked to column sys_id_value in sys_user table
 SQL_VARCHAR(64) True True

stockroom_value

Foreign Key linked to column sys_id_value in alm_stockroom table
 SQL_VARCHAR(64) True True

support_group_value

Foreign Key linked to column sys_id_value in sys_user_group table
 SQL_VARCHAR(64) True True

supported_by_value

Foreign Key linked to column sys_id_value in sys_user table
 SQL_VARCHAR(64) True True

vendor_value

Foreign Key linked to column sys_id_value in core_company table
 SQL_VARCHAR(64) True True

acquisition_method_display_value

 SQL_VARCHAR(500) True True

acquisition_method_value

 SQL_VARCHAR(80) True True

active_to_display_value

 SQL_VARCHAR(500) True True

active_to_value

 SQL_BIT True True

asset_tag_display_value

 SQL_VARCHAR(500) True True

asset_tag_value

 SQL_VARCHAR(80) True True

assigned_display_value

 SQL_VARCHAR(500) True True

assigned_to_display_value

 SQL_VARCHAR(500) True True

assigned_value

 SQL_TIMESTAMP True True

beneficiary_display_value

 SQL_VARCHAR(500) True True

checked_in_display_value

 SQL_VARCHAR(500) True True

checked_in_value

 SQL_TIMESTAMP True True

checked_out_display_value

 SQL_VARCHAR(500) True True

checked_out_value

 SQL_TIMESTAMP True True

ci_display_value

 SQL_VARCHAR(500) True True

comments_display_value

 SQL_VARCHAR(8000) True True

comments_value

 SQL_VARCHAR(8000) True True

company_display_value

 SQL_VARCHAR(500) True True

cost_center_display_value

 SQL_VARCHAR(500) True True

cost_display_value

 SQL_VARCHAR(500) True True

cost_value

 SQL_VARCHAR(256) True True

delivery_date_display_value

 SQL_VARCHAR(500) True True

delivery_date_value

 SQL_TIMESTAMP True True

department_display_value

 SQL_VARCHAR(500) True True

depreciated_amount_display_value

 SQL_VARCHAR(500) True True

depreciated_amount_value

 SQL_VARCHAR(256) True True

depreciation_date_display_value

 SQL_VARCHAR(500) True True

depreciation_date_value

 SQL_TIMESTAMP True True

depreciation_display_value

 SQL_VARCHAR(500) True True

display_name_display_value

 SQL_VARCHAR(500) True True

display_name_value

 SQL_VARCHAR(510) True True

disposal_reason_display_value

 SQL_VARCHAR(500) True True

disposal_reason_value

 SQL_VARCHAR(510) True True

due_display_value

 SQL_VARCHAR(500) True True

due_in_display_value

 SQL_VARCHAR(500) True True

due_in_value

 SQL_VARCHAR(80) True True

due_value

 SQL_TIMESTAMP True True

expenditure_type_display_value

 SQL_VARCHAR(500) True True

expenditure_type_value

 SQL_VARCHAR(80) True True

gl_account_display_value

 SQL_VARCHAR(500) True True

gl_account_value

 SQL_VARCHAR(80) True True

install_date_display_value

 SQL_VARCHAR(500) True True

install_date_value

 SQL_TIMESTAMP True True

install_status_display_value

 SQL_VARCHAR(500) True True

install_status_value

 SQL_INTEGER(signed) True True

invoice_number_display_value

 SQL_VARCHAR(500) True True

invoice_number_value

 SQL_VARCHAR(80) True True

justification_display_value

 SQL_VARCHAR(500) True True

justification_value

 SQL_VARCHAR(160) True True

lease_id_display_value

 SQL_VARCHAR(500) True True

lease_id_value

 SQL_VARCHAR(80) True True

location_display_value

 SQL_VARCHAR(500) True True

managed_by_display_value

 SQL_VARCHAR(500) True True

model_category_display_value

 SQL_VARCHAR(500) True True

model_display_value

 SQL_VARCHAR(500) True True

old_status_display_value

 SQL_VARCHAR(500) True True

old_status_value

 SQL_VARCHAR(80) True True

old_substatus_display_value

 SQL_VARCHAR(500) True True

old_substatus_value

 SQL_VARCHAR(80) True True

order_date_display_value

 SQL_VARCHAR(500) True True

order_date_value

 SQL_TIMESTAMP True True

owned_by_display_value

 SQL_VARCHAR(500) True True

parent_display_value

 SQL_VARCHAR(500) True True

po_number_display_value

 SQL_VARCHAR(500) True True

po_number_value

 SQL_VARCHAR(80) True True

pre_allocated_display_value

 SQL_VARCHAR(500) True True

pre_allocated_value

 SQL_BIT True True

purchase_date_display_value

 SQL_VARCHAR(500) True True

purchase_date_value

 SQL_DATE True True

quantity_display_value

 SQL_VARCHAR(500) True True

quantity_value

 SQL_INTEGER(signed) True True

request_line_display_value

 SQL_VARCHAR(500) True True

resale_price_display_value

 SQL_VARCHAR(500) True True

resale_price_value

 SQL_VARCHAR(256) True True

reserved_for_display_value

 SQL_VARCHAR(500) True True

residual_date_display_value

 SQL_VARCHAR(500) True True

residual_date_value

 SQL_DATE True True

residual_display_value

 SQL_VARCHAR(500) True True

residual_value

 SQL_VARCHAR(256) True True

retired_display_value

 SQL_VARCHAR(500) True True

retired_value

 SQL_DATE True True

retirement_date_display_value

 SQL_VARCHAR(500) True True

retirement_date_value

 SQL_DATE True True

salvage_value_display_value

 SQL_VARCHAR(500) True True

salvage_value_value

 SQL_VARCHAR(256) True True

serial_number_display_value

 SQL_VARCHAR(500) True True

serial_number_value

 SQL_VARCHAR(200) True True

skip_sync_display_value

 SQL_VARCHAR(500) True True

skip_sync_value

 SQL_BIT True True

stockroom_display_value

 SQL_VARCHAR(500) True True

substatus_display_value

 SQL_VARCHAR(500) True True

substatus_value

 SQL_VARCHAR(80) True True

support_group_display_value

 SQL_VARCHAR(500) True True

supported_by_display_value

 SQL_VARCHAR(500) True True

sys_class_name_display_value

 SQL_VARCHAR(500) False True

sys_class_name_value

 SQL_VARCHAR(160) False True

sys_created_by_display_value

 SQL_VARCHAR(500) False True

sys_created_by_value

 SQL_VARCHAR(80) False True

sys_created_on_display_value

 SQL_VARCHAR(500) False True

sys_created_on_value

 SQL_TIMESTAMP False True

sys_domain_display_value

 SQL_VARCHAR(500) False True

sys_domain_path_display_value

 SQL_VARCHAR(500) False True

sys_domain_path_value

 SQL_VARCHAR(510) False True

sys_domain_value

 SQL_VARCHAR(64) False True

sys_id_display_value

 SQL_VARCHAR(500) False False

sys_mod_count_display_value

 SQL_VARCHAR(500) False True

sys_mod_count_value

 SQL_INTEGER(signed) False True

sys_tags_display_value

 SQL_VARCHAR(500) False True

sys_tags_value

 SQL_VARCHAR(256) False True

sys_updated_by_display_value

 SQL_VARCHAR(500) False True

sys_updated_by_value

 SQL_VARCHAR(80) False True

sys_updated_on_display_value

 SQL_VARCHAR(500) False True

sys_updated_on_value

 SQL_TIMESTAMP False True

vendor_display_value

 SQL_VARCHAR(500) True True

warranty_expiration_display_value

 SQL_VARCHAR(500) True True

warranty_expiration_value

 SQL_DATE True True

work_notes_display_value

 SQL_VARCHAR(8000) True True

work_notes_value

 SQL_VARCHAR(8000) True True