Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  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
    serverjira.agrisoftcmcrcm.culturatech.com JIRA
    columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
    serverId9d395f28-7110-3e09-a064-46c1f4565f20
    keyAAI-26
     

Mappings

ERPALIASAAIBrillDefault
POLine.POLineSeqnoPO Line Sequence #PurchaseOrder_Stage.Sequence  
POPurOrd.POSeqNoPO Sequence #PurchaseOrder_Stage.LineSequence  
POPurOrd.divcdDivision CodePurchaseOrder_Stage.DivisionCodePlant Code 
POPurOrd.PurOrdNoPO #PurchaseOrder_Stage.OrderNumber  
POPurOrd.podtPO DatePurchaseOrder_Stage.Date  
Vendor.VendorSeqNo PurchaseOrder_Stage.VendorID  
Vendor.snameVendor #PurchaseOrder_Stage.VendorCode  
Vendor.nameVendor NamePurchaseOrder_Stage.VendorName  
ItemMaster.invclscdInventory TypePurchaseOrder_Stage.InventoryType  
ItemMaster.itemcdItem #PurchaseOrder_Stage.SourceItemCodeIngredient Code 
ItemMaster.descItem DescriptionPurchaseOrder_Stage.ItemDesc  
POLine.totdelqtyQuantityPurchaseOrder_Stage.Quantity  
POLine.unitcstUnit CostPurchaseOrder_Stage.PriceCurrent Cost* 
POLine.totdelqty * POLine.unitcstExtendedPurchaseOrder_Stage.Extended  
   Record Type IP 
   Previous Cost** 
   Stock Status 
   Add ON Base Cost 

...