Difference between revisions of "GT:Whistle Label Management System"
From coolearthwiki
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) | |
− | + | ***labelFilename (file and path) | |
− | + | ***labelType (PALLET, SSCC, CASE) | |
*wmLabelPrinter | *wmLabelPrinter | ||
+ | **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 | |
− | + | ***labelID | |
− | + | ***item | |
− | + | ***pack | |
− | + | ***orderKey | |
− | + | ***orderType (integer; 0-undefined, 1-PO, 2-SO, 3-WT, 6-PM) | |
− | + | ***customerKey (en_cust_key) | |
− | + | ***tranType (STAGE, XYZ) | |
− | + | ||
*wmLabelOrderXRef | *wmLabelOrderXRef | ||
− | + | **Defines the label at the Order Level as | |
− | + | ***labelID | |
− | + | ***orderKey | |
− | + | ***orderType (integer; 0-undefined, 1-PO, 2-SO, 3-WT, 6-PM) | |
− | + | ||
*wmLabelProduct | *wmLabelProduct | ||
− | + | **Defines the label at the Product Level as | |
− | + | ***labelID | |
− | + | ***item | |
− | + | ***pack | |
− | + | ***so_prod_key | |
− | + | ||
*wmLabelTranItemPack | *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 | *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)
- Defines the label location as
- 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
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)
- Defines the label at the Customer Level as
- wmLabelOrderXRef
- Defines the label at the Order Level as
- labelID
- orderKey
- orderType (integer; 0-undefined, 1-PO, 2-SO, 3-WT, 6-PM)
- Defines the label at the Order Level as
- wmLabelProduct
- Defines the label at the Product Level as
- labelID
- item
- pack
- so_prod_key
- Defines the label at the Product Level as
- 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
- Defines the label at the Transaction Type + Item Pack Level as
- wmLabelTransaction
- Defines the label at the Transaction Type Level as
- labelID
- tranType (RECEIVE, REPORT PROD, MISC PROD RPT, SPLIT PALLET, STAGE)
- Defines the label at the Transaction Type Level as