Table of Contents |
---|
Introduction
- Mappings and requirements for promoting ERP Purchase Order records to a WEM Feed Batcher system via an export file.
- 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.
- See also:
Jira Legacy server jira.rcm.
...
culturatech.com JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 9d395f28-7110-3e09-a064-46c1f4565f20 key AAI-73
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
- x
File Formats and Examples
- WEM file specification: GENERIC INTERFACE - RECEIVING ORDERS TO WEM.doc
- Extraction Criteria: AAI-73 - Send PO to WEM.msg