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

From coolearthwiki
Jump to: navigation, search
m
 
(One intermediate revision by the same user not shown)
Line 16: Line 16:
 
*wmLabelDefinition
 
*wmLabelDefinition
 
**Defines the label location as
 
**Defines the label location as
    ***labelID (integer)
+
***labelID (integer)
    ***labelFilename (file and path)
+
***labelFilename (file and path)
    ***labelType (PALLET, SSCC, CASE)
+
***labelType (PALLET, SSCC, CASE)
  
  
 
*wmLabelPrinter
 
*wmLabelPrinter
 +
**Defines the valid printers for the corresponding label as
 +
***company
 +
***in_whs_key
 +
***labelID
 +
***PrinterID (printer path + name)
  
  **Defines the valid printers for the corresponding label as
 
    ***company
 
    ***in_whs_key
 
    ***labelID
 
    ***PrinterID (printer path + name)
 
  
 
'''CONFIGURATION TABLES'''
 
'''CONFIGURATION TABLES'''
  
 
*wmLabelInfoXRef
 
*wmLabelInfoXRef
 
+
**Defines the label at the Customer Level as
  **Defines the label at the Customer Level as
+
***labelID
    ***labelID
+
***item
    ***item
+
***pack
    ***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)
    ***customerKey (en_cust_key)
+
***tranType (STAGE, XYZ)
    ***tranType (STAGE, XYZ)
+
  
  
 
*wmLabelOrderXRef
 
*wmLabelOrderXRef
 
+
**Defines the label at the Order Level as
  **Defines the label at the Order Level as
+
***labelID
    ***labelID
+
***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)
+
  
  
 
*wmLabelProduct
 
*wmLabelProduct
 
+
**Defines the label at the Product Level as
  **Defines the label at the Product Level as
+
***labelID
    ***labelID
+
***item
    ***item
+
***pack
    ***pack
+
***so_prod_key
    ***so_prod_key
+
  
  
 
*wmLabelTranItemPack
 
*wmLabelTranItemPack
 
+
**Defines the label at the Transaction Type + Item Pack Level as
  **Defines the label at the Transaction Type + Item Pack Level as
+
***labelID
    ***labelID
+
***tranType (RECEIVE, REPORT PROD, MISC PROD RPT, SPLIT PALLET, STAGE)
    ***tranType (RECEIVE, REPORT PROD, MISC PROD RPT, SPLIT PALLET, STAGE)
+
***item
    ***item
+
***pack
    ***pack
+
  
  
 
*wmLabelTransaction
 
*wmLabelTransaction
 
+
**Defines the label at the Transaction Type Level as
  **Defines the label at the Transaction Type Level as
+
***labelID
    ***labelID
+
***tranType (RECEIVE, REPORT PROD, MISC PROD RPT, SPLIT PALLET, STAGE)
    ***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)