====== ERP NOT-SAP INTEGRATION ======
===== 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 |
^ share data type | from file (XML) |
^ server | fkt20g.fa.franke.world (10.100.145.20) |
^ path | ~/frankeerp/FWK |
^ credentials | frankeerp:FrankeERP |

===== FPL - Poland Plant =====
^ ERP | JetCAM |
^ share data type | from file (FSM) |
^ server | fkt20g.fa.franke.world (10.100.145.20) |
^ path | ~/frankeerp/FPL |
^ credentials | frankeerp:FrankeERP |

^ ERP | PBS |
^ share data type | database |
^ server | 10.100.145.20 |
^ role | frankeerp:FrankeERP |
^ database | andon_FPL |
^ schemas | workorder,workdata |

===== FHP - Ruston Plant =====
^ ERP | PBS |
^ share data type | database |
^ server | 10.60.1.21 |
^ 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 |