Navigate
Wasp Helpdesk
  • Register

  • or
  • Login
    Need a password reminder?
or
Contact Us
  • Get in touch

    Send us an email

  • Start a chat session

  • Knowledgebase Read help articles
  • News News & updates
  • Contact Us We are here to help
  • Training View our options
  • Product Sunsets Non-Supported Products
Barcode System Consult
Barcode Printer Consult
Barcode Label Consult
  • Portal
  • Knowledgebase
  • Discontinued Products
  • MobileAsset
  • Version 7
  • MobileAsset v7: Default label tables and fields
Subscribe Download PDF

MobileAsset v7: Default label tables and fields

Scott Leonard
2018-08-30
in Version 7

When MobileAsset v7 is initially installed, the default label files are created that are linked to the database, with valid database tables and fields available and assigned to objects in the label layout. Below are the settings for each label as well as their initial settings.

See Related Pages below for other articles about working with MobileAsset's labels.

An asterisk (*) before a field name indicates that field appears on the default label layout.

------------------------------------------

Asset Tags

filename: Asset Tag.labx
table: vLabelerAsset_AssetTag

fields ( * = on default label)
asset_id (internal identifier)
* asset_tag
serial_number
item_id
department_id (internal identifier)
purchase_date
purchase_cost
salvage_value
condition_id (internal identifier)
location_id (internal identifier)
depreciation_begin_date
depreciation_end_date
last_depreciation_date
total_depreciation
current_depreciation
depreciated_value
should_depreciate
po
warranty_begin_date
warranty_end_date
warranty_provider
is_disposed
is_checked_out
last_audit_date
parent_id (internal identifier)
transact_as_whole
linking_indicator
linking_is_child_checked_out
usrdefdate1
usrdefdate2
usrdefdate3
usrdefdate4
usrdefdate5
usrdefnumber1
usrdefnumber2
usrdefnumber3
usrdefnumber4
usrdefnumber5
usrdeftext1
usrdeftext2
usrdeftext3
usrdeftext4
usrdeftext5
usrdeftext6
usrdeftext7
usrdeftext8
usrdeftext9
usrdeftext10
record_status
company_id (internal identifier)
date_updated
* asset_description
manufacturer_id (internal identifier)
model
supplier_id (internal identifier)
checkout_duration
lead_time
linked_reference
item_number (this is Asset Type)
description
name (corresponds to asset's "Department Name" field)
site_name (corresponds to asset's "Site" field)
location (corresponds to the "Description" field of the Location List, for MAv7.0 & 7.1). See Related Pages below for a fix.

Default Label contains objects:
Description: asset_description
BarCode: asset_tag

-------------------------------------

Location Labels

filename: Location Labels.labx
table: dbo.vLabelerAssetLocation

fields ( * = on default label)
location_id (internal identifier)
* code (location name)
description (location description)
* site_name
site_description

Default Label contains objects:
- Text2.000: site_name, code
- BarCode1: code

-------------------------------------

Employee Badges

filename: Employee Badges.labx
table: dbo.vLabelerAssetEmployeeBadge

fields ( * = on default label)
employee_id (internal identifier)
* employee_number
* last_name
* first_name
* title
department_id (internal identifier)
manager_id (internal identifier)
email
date_added
usrdefdate1
usrdefdate2
usrdefdate3
usrdefdate4
usrdefdate5
usrdefnumber1
usrdefnumber2
usrdefnumber3
usrdefnumber4
usrdefnumber5
usrdeftext1
usrdeftext2
usrdeftext3
usrdeftext4
usrdeftext5
usrdeftext6
usrdeftext7
usrdeftext8
usrdeftext9
usrdeftext10
company_id (internal identifier)
record_status
date_updated
file_name
* file_data (default picture)

Default Label contains objects:
Text1.000: last_name, first_name
Text2: title
Picture1: file_data
Barcode1: employee_number


Note this article below in Related Pages: MobileAsset v7: Employee Badge label has department_id rather than the department name or code
which adds two new fields to the label: DeptName & DeptCode

-------------------------------------

Mobile Asset Tags, Mobile Check In Receipt, and Mobile Check Out Receipt: These contain ZPL code and are not editable by Labeler.

Rate the quality of this page

This page was helpful :) :( This page was not helpful

34 of 67 people found this page helpful

Related Pages

  • MobileAsset v7: Employee Badge label has department_id rather than the department name or code
  • How to edit or modify the default asset tag for MobileAsset version 7 (custom label)
  • MobileAsset v7: The data table for the Asset Tag label includes the Location description, but not the Location code
  • MobileAsset v7: How to use a customized label for the Asset Tags
  • MobileAsset v7: Setting up the data source for the Asset Tags and other labels

Quick Jump
  • Wasp Helpdesk
  • Knowledgebase
  • News
  • Contact Us
Top
Helpdesk software provided by Deskpro