Table of Contents

Introduction 

1. Mappings and requirements for promoting ERP Purchase Order records to a Brill Least-Cost Formulation system via an export file.
2. See also:

   Jira Legacy
   server jira.agrisoftcmc.com JIRA key AAI-26

    

Mappings

...

ERP	ALIAS	AAI	Brill	Default
POLine.POLineSeqno	PO Line Sequence #	PurchaseOrder_Stage.Sequence
POPurOrd.POSeqNo	PO Sequence #	PurchaseOrder_Stage.LineSequence
POPurOrd.divcd	Division Code	PurchaseOrder_Stage.DivisionCode	Plant Code
POPurOrd.PurOrdNo	PO #	PurchaseOrder_Stage.OrderNumber
POPurOrd.podt	PO Date	PurchaseOrder_Stage.Date
Vendor.VendorSeqNo		PurchaseOrder_Stage.VendorID
Vendor.sname	Vendor #	PurchaseOrder_Stage.VendorCode
Vendor.name	Vendor Name	PurchaseOrder_Stage.VendorName
ItemMaster.invclscd	Inventory Type	PurchaseOrder_Stage.InventoryType
ItemMaster.itemcd	Item #	PurchaseOrder_Stage.SourceItemCode	Ingredient Code
ItemMaster.desc	Item Description	PurchaseOrder_Stage.ItemDesc
POLine.totdelqty	Quantity	PurchaseOrder_Stage.Quantity
POLine.unitcst	Unit Cost	PurchaseOrder_Stage.Price	Current Cost*
POLine.totdelqty * POLine.unitcst	Extended	PurchaseOrder_Stage.Extended
			Record Type IP
			Previous Cost**
			Stock Status
			Add ON Base Cost

...