Introduction

Mappings and requirements for promoting ERP Purchase Order records to a Brill Least-Cost Formulation 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	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

* At this point, we do not know if we are multiplying this cost by 100 (hundred-weight conversion).

** We need confirmation that we are using the current cost for the price, or the previous cost field.