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

From coolearthwiki
Jump to: navigation, search
m (New page: '''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 ...)
 
m
 
(4 intermediate revisions by the same user not shown)
Line 15: Line 15:
  
 
*wmLabelDefinition
 
*wmLabelDefinition
 +
**Defines the label location as
 +
***labelID (integer)
 +
***labelFilename (file and path)
 +
***labelType (PALLET, SSCC, CASE)
  
  **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)
  
wmLabelPrinter
 
  
  Defines the valid printers for the corresponding label as
+
'''CONFIGURATION TABLES'''
    company
+
    in_whs_key
+
    labelID
+
    PrinterID (printer path + name)
+
  
'''
+
*wmLabelInfoXRef
CONFIGURATION TABLES'''
+
**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)
  
wmLabelInfoXRef
 
  
  Defines the label at the Customer Level as
+
*wmLabelOrderXRef
    labelID
+
**Defines the label at the Order Level as
    item
+
***labelID
    pack
+
***orderKey
    orderKey
+
***orderType (integer; 0-undefined, 1-PO, 2-SO, 3-WT, 6-PM)
    orderType (integer; 0-undefined, 1-PO, 2-SO, 3-WT, 6-PM)
+
    customerKey (en_cust_key)
+
    tranType (STAGE, XYZ)
+
  
  
wmLabelOrderXRef
+
*wmLabelProduct
 +
**Defines the label at the Product Level as
 +
***labelID
 +
***item
 +
***pack
 +
***so_prod_key
  
  Defines the label at the Order Level as
 
    labelID
 
    orderKey
 
    orderType (integer; 0-undefined, 1-PO, 2-SO, 3-WT, 6-PM)
 
  
 +
*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
  
wmLabelProduct
 
  
  Defines the label at the Product Level as
+
*wmLabelTransaction
    labelID
+
**Defines the label at the Transaction Type Level as
    item
+
***labelID
    pack
+
***tranType (RECEIVE, REPORT PROD, MISC PROD RPT, SPLIT PALLET, STAGE)
    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)
+

Latest revision as of 20: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)