Difference between revisions of "GT:Whistle Label Management System"

Revision as of 19:33, 3 August 2010

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)