Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Introduction

  1. Mappings and requirements for promoting ERP Purchase Order records to a WEM Feed Batcher system via an export file.
  2. The export process will be creating two pairs of export files, delivered to two separate directories, one for "organic" orders, and one for other orders.
  3. See also: 
    Error rendering macro 'jira' : Unable to locate Jira server for this macro. It may be due to Application Link configuration.

Mappings

ERPALIASAAIWEMDefault
POLine.POLineSeqnoPO Line Sequence #PurchaseOrder_Stage.SequenceOrder Number 
POPurOrd.POSeqNoPO Sequence #PurchaseOrder_Stage.LineSequence  
POPurOrd.divcdDivision CodePurchaseOrder_Stage.DivisionCode  
POPurOrd.PurOrdNoPO #PurchaseOrder_Stage.OrderNumberPO Number 
POPurOrd.podtPO DatePurchaseOrder_Stage.Date  
Vendor.VendorSeqNo PurchaseOrder_Stage.VendorID  
Vendor.snameVendor #PurchaseOrder_Stage.VendorCodeVendor 
Vendor.nameVendor NamePurchaseOrder_Stage.VendorName  
ItemMaster.invclscdInventory TypePurchaseOrder_Stage.InventoryType  
ItemMaster.itemcdItem #PurchaseOrder_Stage.SourceItemCodeMaterial 
ItemMaster.descItem DescriptionPurchaseOrder_Stage.ItemDesc  
POLine.totdelqtyQuantityPurchaseOrder_Stage.Quantity  
POLine.unitcstUnit CostPurchaseOrder_Stage.Price  
POLine.totdelqty * POLine.unitcstExtendedPurchaseOrder_Stage.Extended  
   Destination 
   Lot Code 
   Vehicle ID 
   Driver 
   Carrier 
   Sample RequiredFALSE

 

File Formats and Examples

WEM file specification:

Extraction Criteria: AAI-73 - Send PO to WEM.msg

  • No labels