GT:Whistle Label Management System

Order of Precedence for Label Look-up

• Customer+Item+Pack+OrderType+Order
• Customer+Item+Pack+TranType
• Customer+Item+Pack
• OrderType+Order
• TranType+Item+Pack
• TranType
• Item+Pack
• Default Label

DEFINITIONS TABLES

• wmLabelDefinition

 **Defines the label location as
   ***labelID (integer)
   ***labelFilename (file and path)
   ***labelType (PALLET, SSCC, CASE)

wmLabelPrinter

 Defines the valid printers for the corresponding label as
   company
   in_whs_key
   labelID
   PrinterID (printer path + name)

CONFIGURATION TABLES

wmLabelInfoXRef

 Defines the label at the Customer Level as
   labelID
   item
   pack
   orderKey
   orderType (integer; 0-undefined, 1-PO, 2-SO, 3-WT, 6-PM)
   customerKey (en_cust_key)
   tranType (STAGE, XYZ)

wmLabelOrderXRef

 Defines the label at the Order Level as
   labelID
   orderKey
   orderType (integer; 0-undefined, 1-PO, 2-SO, 3-WT, 6-PM)

wmLabelProduct

 Defines the label at the Product Level as
   labelID
   item
   pack
   so_prod_key

wmLabelTranItemPack

 Defines the label at the Transaction Type + Item Pack Level as
   labelID
   tranType (RECEIVE, REPORT PROD, MISC PROD RPT, SPLIT PALLET, STAGE)
   item
   pack

wmLabelTransaction

 Defines the label at the Transaction Type Level as
   labelID
   tranType (RECEIVE, REPORT PROD, MISC PROD RPT, SPLIT PALLET, STAGE)