Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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: 
    Jira Legacy
    serverjira.agrisoftcmc.com JIRA
    keyAAI-73

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

...