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

Version 1 Next »

Introduction

Mappings and requirements for promoting ERP Purchase Order records to a WEM Feed Batcher system via an export file.

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