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

Latest revision as of 19:34, 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)