cli:franke:erp_integration_next

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
cli:franke:erp_integration_next [2018/01/26 16:13]
f.zoppini [FHP Plant] 		cli:franke:erp_integration_next [2019/09/27 10:55] (current)
f.zoppini [FFB - Argentina Plant]
Line 1: Line 1:
 ====== ERP NOT-SAP INTEGRATION ====== ====== ERP NOT-SAP INTEGRATION ======
-===== FWK - KWC Plant =====+===== Database configuration ===== 
 +<code sql> 
 +CREATE USER frankeerp WITH PASSWORD 'FrankeERP'; 
 +GRANT ALL ON TABLE workorder TO frankeerp; 
 +GRANT ALL ON TABLE workdata TO frankeerp; 
 +</code> 
 +===== FWK - Unterkulm Plant (KWC) =====
 ^ ERP | proALPHA | ^ ERP | proALPHA |
 ^ share data type | from file (XML) | ^ share data type | from file (XML) |
Line 14: Line 20:
 ^ credentials | frankeerp:FrankeERP | ^ credentials | frankeerp:FrankeERP |
  
-===== FPL Plant ===== 
 ^ ERP | PBS | ^ ERP | PBS |
 ^ share data type | database | ^ share data type | database |
 ^ server | 10.100.145.20 | ^ server | 10.100.145.20 |
 ^ role | frankeerp:FrankeERP | ^ role | frankeerp:FrankeERP |
 +^ database | andon_FPL |
 ^ schemas | workorder,workdata | ^ schemas | workorder,workdata |
  
-===== FHP Plant =====+===== FHP - Ruston Plant =====
 ^ ERP | PBS | ^ ERP | PBS |
 ^ share data type | database | ^ share data type | database |
 ^ server | 10.60.1.21 | ^ server | 10.60.1.21 |
 ^ role | frankeerp:FrankeERP | ^ role | frankeerp:FrankeERP |
 +^ database | andon_FHP |
 +^ schemas | workorder,workdata |
 +
 +===== FNO - China Nokite Plant =====
 +^ ERP | PBS |
 +^ share data type | database |
 +^ server | 10.164.1.88 |
 +^ role | frankeerp:FrankeERP |
 +^ database | andon_FNO |
 +^ schemas | workorder,workdata |
 +
 +===== FPK - China Heshan Plant =====
 +^ ERP | PBS |
 +^ share data type | database |
 +^ server | 10.164.1.88 |
 +^ role | frankeerp:FrankeERP |
 +^ database | andon_FPK |
 +^ schemas | workorder,workdata |
 +
 +===== FSA - South Africa Plant =====
 +^ ERP | SAGE |
 +^ share data type | database |
 +^ server | 10.184.1.36 |
 +^ role | frankeerp:FrankeERP |
 +^ database | andon_FSA |
 +^ schemas | workorder,workdata |
 +
 +===== FFB - Argentina Plant =====
 +^ ERP | Local |
 +^ share data type | database |
 +^ server | 10.60.1.21 |
 +^ role | frankeerp:FrankeERP |
 +^ database | andon_FFB |
 +^ schemas | workorder,workdata |
 +
 +===== FKC - Canada Plant =====
 +^ ERP | PBS |
 +^ share data type | database |
 +^ server | 10.60.1.21 |
 +^ role | frankeerp:FrankeERP |
 +^ database | andon_FKC |
 ^ schemas | workorder,workdata | ^ schemas | workorder,workdata |
  • cli/franke/erp_integration_next.1516979605.txt.gz
  • Last modified: 2018/01/26 16:13
  • by f.zoppini