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
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 |
File Formats and Examples
WEM file specification:
Extraction Criteria: AAI-73 - Send PO to WEM.msg