Purchase Order to WEM

Owned by Tony Ornelas-A
Last updated: Apr 06, 2016 by Jim Brashears
1 min read

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

ERP

ALIAS

AAI

WEM

Default

POLine.POLineSeqno

PO Line Sequence #

PurchaseOrder_Stage.Sequence

Order Number

 

POPurOrd.POSeqNo

PO Sequence #

PurchaseOrder_Stage.LineSequence

 

 

POPurOrd.divcd

Division Code

PurchaseOrder_Stage.DivisionCode

 

 

POPurOrd.PurOrdNo

PO #

PurchaseOrder_Stage.OrderNumber

PO Number

 

POPurOrd.podt

PO Date

PurchaseOrder_Stage.Date

 

 

Vendor.VendorSeqNo

 

PurchaseOrder_Stage.VendorID

 

 

Vendor.sname

Vendor #

PurchaseOrder_Stage.VendorCode

Vendor

 

Vendor.name

Vendor Name

PurchaseOrder_Stage.VendorName

 

 

ItemMaster.invclscd

Inventory Type

PurchaseOrder_Stage.InventoryType

 

 

ItemMaster.itemcd

Item #

PurchaseOrder_Stage.SourceItemCode

Material

 

ItemMaster.desc

Item Description

PurchaseOrder_Stage.ItemDesc

 

 

POLine.totdelqty

Quantity

PurchaseOrder_Stage.Quantity

 

 

POLine.unitcst

Unit Cost

PurchaseOrder_Stage.Price

 

 

POLine.totdelqty * POLine.unitcst

Extended

PurchaseOrder_Stage.Extended

 

 

 

 

 

Destination

 

 

 

 

Lot Code

 

 

 

 

Vehicle ID

 

 

 

 

Driver

 

 

 

 

Carrier

 

 

 

 

Sample Required

FALSE

 

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