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