Versions Compared

Old Version 3

changes.mady.by.user Tony Ornelas-A

Saved on

compared with

New Version Current

changes.mady.by.user Jim Brashears

Saved on

Key

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

Table of Contents

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.rcm.agrisoftcmcculturatech.com JIRA
    columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
    serverId9d395f28-7110-3e09-a064-46c1f4565f20
    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

 

Validation

  1. x

File Formats and Examples

  1. WEM file specification: GENERIC INTERFACE - RECEIVING ORDERS TO WEM.doc
  2. Extraction Criteria: AAI-73 - Send PO to WEM.msg