View source for GT:Whistle Label Management System

'''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)