ERP NOT-SAP INTEGRATION

Database configuration

CREATE USER frankeerp WITH PASSWORD 'FrankeERP'; GRANT ALL ON TABLE workorder TO frankeerp; GRANT ALL ON TABLE workdata TO frankeerp;

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