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
  • InventoryControl
  • Version 7
  • InventoryControl v7: Default label tables and fields
Subscribe Download PDF

InventoryControl v7: Default label tables and fields

Scott Leonard
2018-07-26
in Version 7

When InventoryControl 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 the disk paths where the labels are stored.

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

Note: Item Label is listed first since it's the most often edited (instead of third as in InventoryControl's Labels dialog).

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

Labels, Item Label
Used for: Printing item label from Item List (data has been permanently added to database).
filename: Inventory Item.LABX
table: dbo.vLabelerItem

available fields:
item_id
* item_number
* description
manufacturer
name
unit_of_measure
alt_item_number
Category
item_type_name

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

Labels, "Add, Assemble, Receive Item Label"
Used for: Printing item label when adding on PC (data is in temporary holding table during Add process)
filename: AddTransactionItemLabelDB.LABX
table: vPendingItems

available fields:
trans_date
entry_date
date_acquired
adjust_type
quantity
cost
serial_number
date_code
po
lot
pallet
print_label_no
* item_number
* item_description
item_cost
avgcost
alt_item_number
list_price
sale_price
company_id
location
location_description
user_id
site_name
site_description
supplier_number
supplier_name
transaction_id
record_status

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

Labels, "Add, Receive Item Label for Mobile Device"
filename: MobileDeviceAddTransactionItemLabelDB.LABX
table: vAddTransactions

available fields:
trans_date
entry_date
date_acquired
adjust_type
quantity
cost
serial_number
date_code
po
lot
pallet
print_label_no
* item_number
* item_description
item_cost
avgcost
alt_item_number
list_price
sale_price
company_id
location
location_description
user_id
site_name
site_description
supplier_number
supplier_name
transaction_id
record_status

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

Labels, Location Label
filename: Inventory Location.LABX
table: vLabelerLocation

available fields:
location_idĀ  (internal code)
* codeĀ  (location name)
* locationDes
* site_name

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

Labels, Transaction Label Date Code
filename: Inventory DateCode.LABX
table: vLabelerDateCode

available fields:
transaction_id
* date_code

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

Labels, Transaction Label Lot
filename: Inventory Lot.LABX
table: vLabelerLot

available fields:
transaction_id
* lot

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

Labels, Transaction Label Pallet
filename: Inventory Pallet.LABX
table: vLabelerPallet

available fields:
transaction_id
* pallet

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

Labels, Transaction Label Serial Number
filename: Inventory Serial Number.LABX
table: vLabelerSN

Note: no field is linked to the barcode!
available fields:
transaction_id
item_id
serial_number

Rate the quality of this page

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

3 of 14 people found this page helpful

Related Pages

  • InventoryControl Label File Paths

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