One moment please...
 
 
E-WMS   
 

WMS Bartender integration: mandatory fields and samples for all processes

Pick-IT

 

Introduction

BarTender is a bar code label design and printing solution by Seagull Scientific. BarTender can be used as stand-alone application to create bar code labels, but E-WMS also offers integration with BarTender. This allows you to automatically print bar code labels in specific steps of the E-WMS process, like Receipts or Sales Order Fulfillment. E-WMS supports two ways of integration with BarTender.

Please see this document for the requirements for using BarTender with E-WMS.


To use this BarTender integration, you will need to create SQL views. This document describes the mandatory fields for these views and provides sample views and labels.


Description

You will need SQL views to set up the BarTender integration in E-WMS. This view is used by E-WMS (to check for records and fields) and must be used in the BarTender lay-out itself when using the BarTender 'client' method. The view name must also be entered in the E-WMS label configuration in menu System, E-WMS, Labels.

The sample views and labels referred to, can be obtained from this link.

Document BarTender - configuring a BarTender lay-out for your own environment shows how to update server, database and printer in existing BarTender layouts.


Main process Process step Mandatory fields in view Base tables View + label name
         
Receipts Send to scanner PurchaseOrderNumber
Warehouse
CSPickITTransactionGUID
Orsrg, Orkrg eWMSReceiptsSend
  Read back PurchaseOrderNumber
CSPickITTransactionGUID
Orsrg, Orkrg
csPickitOrsrg
eWMSReceiptsReadback
  Validate PurchaseOrderNumber
Warehouse
CSPickITTransactionGUID
Orsrg, Orkrg
csPickitOrsrg
eWMSReceiptsValidate
  Process PurchaseOrderNumber
Warehouse
CSPickITTransactionGUID
Orsrg, Orkrg
csPickitOrsrg
eWMSReceiptsProcess
         
Sales Order Fulfillment Send to scanner SalesOrderNumber
Warehouse
csPickitTransactionGuid
Orsrg, Orkrg eWMSFulfillmentSend
  Read back SalesOrderNumber
csPickitTransactionGuid
Orsrg, Orkrg
csPickitOrsrg
eWMSFulfillmentReadback
  Validate SalesOrderNumber
Warehouse
csPickitTransactionGuid
Orsrg, Orkrg
csPickitOrsrg
eWMSFulfillmentValidate
  Process Warehouse
csPickitTransactionGuid
Orsrg, Orkrg
csPickitOrsrg
eWMSFulfillmentProcess
         
Transfers Read back TransferID
WarehouseFrom
csPickitTransfers
csPickitTransferLines
csPickitTransferSB
eWMSTransfersReadback
  Validate TransferID csPickitTransfers
csPickitTransferLines
csPickitTransferSB
eWMSTransfersValidate
  Process PickitStatus
TransferID
csPickitTransfers
csPickitTransferLines
csPickitTransferSB
eWMSTransfersProcess
         
Inventory/Counts Send to scanner several (see view) csPickitCounts
csPickitCountsSB
eWMSCountsSend
  Read back several (see view) csPickitCounts
csPickitCountsSB
eWMSCountsReadback
  Compare several (see view) csPickitCounts
csPickitCountsSB
eWMSCountsCompare
  Process several (see view) csPickitCounts
csPickitCountsSB
eWMSCountsProcess
         
Stock Transactions Read back PickITStatus
CountRangeID
csPickitCounts
csPickitCountsSB
eWMSStocktransReadback
  Validate PickITStatus
CountRangeID
csPickitCounts
csPickitCountsSB
eWMSStockTransValidate
  Process PickITStatus
CountRangeID
csPickitCounts
csPickitCountsSB
eWMSStockTransProcess
         
Sales Entry Read back SalesOrderNumber Orsrg, Orkrg eMobileSalesReadback
         
Purchase Entry Read back PurchaseOrdernumber Orsrg, Orkrg eWMSPurchaseEntryReadback
         
Replenishment Send to scanner WarehouseFrom
WarehouseTo
Itemcode
TransferID
csPickitTransfers
csPickitTransferLines
csPickitTransferSB
eWMSReplenishmentSend
  Read back TransferID csPickitTransfers
csPickitTransferLines
csPickitTransferSB
eWMSReplenishmentReadback
  Validate WarehouseFrom
WarehouseTo
TransferID
csPickitTransfers
csPickitTransferLines
csPickitTransferSB
eWMSReplenishmentValidate
  Process WarehouseFrom
WarehouseTo
TransferID
csPickitTransfers
csPickitTransferLines
csPickitTransferSB
eWMSReplenishmentProcess
         
Production Issues Send to scanner ProductionOrderNumber
Warehouse
csPickitGbkmut
Gbkmut
eWMSProdIssuesSend
  Read back ProductionOrderNumber
Warehouse
csPickitGbkmut
csPickitGbkmutEx
Gbkmut
eWMSProdIssuesReadback
  Validate ProductionOrderNumber
Warehouse
csPickitGbkmut
csPickitGbkmutEx
Gbkmut
eWMSProdIssuesValidate
  Process ProductionOrderNumber
Warehouse
csPickitGbkmut
csPickitGbkmutEx
Gbkmut
eWMSProdIssuesProcess
         
Production Receipts Read back ProductionOrderNumber csPickitGbkmut
csPickitGbkmutEx
Gbkmut
eWMSProdReceiptsReadback
  Validate ProductionOrderNumber csPickitGbkmut
csPickitGbkmutEx
Gbkmut
eWMSProdReceiptsValidate
  Process ProductionOrderNumber csPickitGbkmut
csPickitGbkmutEx
Gbkmut
eWMSProdReceiptsProcess
         
Autopack Shipment   ShipmentSSCC
DeliveryDebtor
TransactionGUID
csPickitLabelprinting
eWMSAutopackShipment
  Pallet (SSCC) ShipmentSSCC
DeliveryDebtor
TransactionGUID
csPickitLabelprinting
csPickitOrsrg
eWMSAutopackPallet
  Box (inner SSCC)   ShipmentSSCC
DeliveryDebtor
TransactionGUID
csPickitLabelprinting
csPickitOrsrg
eWMSAutopackBox
         
SSCC label printing
from hand terminal
(generated SSCC)


Shipment ShipmentSSCC
DeliveryDebtor
TransactionGUID
SSCCNumber
csPickitLabelprinting eWMSHTShipment
  Pallet (SSCC) ShipmentSSCC
DeliveryDebtor
TransactionGUID
SSCCNumber
csPickitLabelprinting eWMSHTPallet
  Box (inner SSCC) ShipmentSSCC
DeliveryDebtor
TransactionGUID
SSCCNumber
csPickitLabelprinting eWMSHTBox
         
SKU Label printing
from hand terminal

SKU - Handheld:
outer (pallet)
TransactionGUID
csPickitSKUmaster eWMSKUouter
  SKU - Handheld:
inner (box)
TransactionGUID
csPickitSKUmaster eWMSKUinner
         
Serial/Batch Generation
from hand terminal

S/B hand terminal:
batch item
TransactionGUID csPickitLabelPrinting,
ItemNumbers
eWMS_SB_Batch
  S/B hand terminal:
serial nr item
TransactionGUID csPickitLabelPrinting,
ItemNumbers
eWMS_SB_Serial
         
         


Related documents

     
 Main Category: Support Product Know How  Document Type: Support - On-line help
 Category: On-line help files  Security  level: All - 0
 Sub category: Details  Document ID: 20.639.917
 Assortment:  Date: 28-08-2017
 Release:  Attachment:
 Disclaimer