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 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)
Retrieved from "http://demo.coolearth.com/index.php?title=GT:Whistle_Label_Management_System&oldid=7757"