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 |
||
| (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) | ||
| − | |||
| − | |||
| − | |||
| − | |||
| + | *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) | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | wmLabelTransaction | ||
| − | |||
| − | |||
| − | |||
| − | |||
Latest revision as of 00:34, 4 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
