Difference between revisions of "GT:Whistle Label Management System"
From coolearthwiki
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 |
||
| Line 22: | Line 22: | ||
| − | wmLabelPrinter | + | *wmLabelPrinter |
| − | Defines the valid printers for the corresponding label as | + | **Defines the valid printers for the corresponding label as |
| − | company | + | ***company |
| − | in_whs_key | + | ***in_whs_key |
| − | labelID | + | ***labelID |
| − | PrinterID (printer path + name) | + | ***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) |
Revision as of 20:26, 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)
