Here is the list of tables that are needed from E9/E10 to run the EFP integration (Standard):

  • In E9, the tables should be owned by dbo
  • In E10 the tables should be owned by erp.

TableName

  1. COA
  2. COAActCat
  3. COASegment
  4. COASegValues
  5. Company
  6. CurrExRate (FxRate)
  7. FiscalPer
  8. GLAccount
  9. GLBook
  10. GLBookPer
  11. GLBudgetDtl
  12. GLJrnDtl
  13. GLPeriodBal
  14. XbSyst 
  15. erp.BudgetCode (only mandatory for Epicor 10.1)



Here is the extra tables needed from E9/E10 to run the EFP integration (Advanced):

TableName

  1. APInvHed
  2. APTran
  3. BankAcct
  4. Country
  5. CustGrup
  6. Customer
  7. InvcHead
  8. Part
  9. PartClass
  10. ProdGrup
  11. SalesRep
  12. SalesTer
  13. ShipTo
  14. Terms
  15. Vendor



Here is the extra tables needed from E9/E10 to run the EFP integration (Sales):

TableName

  1. Country
  2. CustGrup
  3. Customer
  4. InvcDtl
  5. InvcHead
  6. OrderDtl
  7. OrderHed
  8. OrderRel
  9. Part
  10. PartClass
  11. PartCost
  12. PartPlant
  13. Plant
  14. ProdGrup
  15. SalesRep
  16. SalesTer
  17. ShipDtl
  18. ShipHead
  19. ShipTo