面向ERP系统整合信用证平台的研究

上海交通大学硕士学位论文面向ERP系统整合信用证平台的研究姓名：方贵红申请学位级别：硕士专业：软件工程指导教师：蔡鸿明20090101ERPVERPERPEnterpriseResourcePlanningERPERPERPERPERPERPERPERPERPVIERPERPERPERPERPERPERPERPERPVIITHESTUDYOFTHEINTEGRATEDERPSYSTEMWITHITSOWNELECTRONICLETTERCREDITPLATFORMABSTRACTERPEnterpriseResourcePlanningsystemismodernenterprisemanagementsoftware,whichiswidelyusedtomanagethegoodflow,cashflowandinformationofacompanyandimprovethemanagementefficiency.Theelectronicletterofcreditnowwidelyusedasreceiptsininternationaltrades,whichareusuallycreditbyanindividualelectronicletterofcreditplatform(another-software).Inordertocreateanelectronicletterofcredit,datetransformationisneededbetweenERPsystemandelectronicletterofcreditplatform.Thisprocessreducestheaccuracyandsecurityofelectronicletterofcredit,whichalsoconsumelotsoftime,anddecreasetheefficiencyofthecompany.Inordertosolvetheseproblems,theelectronicletterofcreditplatformandERPsystemareintegratedtoformanewsysteminpresentstudy.Inthisstudy,setoutoffacttheanalysisofrequirementiscarriedoutfromtherealtarget,inordertoidentifythebusinessprocess,andtheanalysisofbusinessprocessisalsotakenup.Thedesignandmodulesplitionofsystemarecarriedoutinordertoidentifytherelationshipofdataandformstructure;TherealizationofERPintergratingcreditletterplatformistakenupaccordingtotheformertheory,anddiscussionofperformanceispresented.TheelectronicletterofcreditplatformandbackgrounddataandERPsystemareintegratedtoformanewsysteminpresentstudy.Inthisstudy,businessflow,dateflowandsystemplatformarenewlydesigned.Theblockedge,systemdesignandblockdivisionaredefinedbythebusinessflow.Thedaterelationsandrelativetablesarealsodesigned.Byallabovenewdefinition,electronicletterofcreditplatformiscreatedasapartofERPsystem.Electroniclettercreditofcreatedjustbycallingthedateofbusinessflow,cashflowandotherneededinformation.TheintegrationofletterofcreditsystemandERPsystemhaslotsofERPVIIIadvantages.Astheyareinonesystemnow,thereisnoneedofdatetransformation.Therefore,theaccuracy,consistencyandreliabilityofelectronicletterofcreditcanbeconfirmed.Themanagementefficiencyofthecompanyisalsoimprovedbysavingthetimeofdatetransformation.TheintegratedERPsystem,withitsownelectronicletterofcreditplatform,isactuallyusedinaLogisticsCompany.Besidetheconfirmingoftheaccuracy,consistencyandreliabilityofelectronicletterofcredit,thisnewsystemalsoimprovethemanagementefficiencyofthecompanybyreducingthetimespendingonthemanagementofelectronicletterofcredit,includingcreating,revisingandquery.KEYWORDS:ERPSystemElectronicLetterofcreditLetterofcreditPlatformIntegration200931220093122009312ERP11.1ERPEnterpriseResourcePlanningERPOracleERPERPERPERPERPERPERPERPERP1.1.1ERP[1]ERPERP[2]EUCPUCP500[3][4]ERP2ERPERPERP[5][6]ERPERPERPERPERPERPERP1.1.2[1]12208018%2.5%[7]10www.1001yes.net10%5%ERP32151516EUCPI.Oe2aEUCPEUCP()()20009200262000i25[361B2B.ERP4Bolero1995TTCLUBSWIFTBOLERD()BoleroE-UCPTradecard1998BOLERD.NETTRADECARDTradecardTradecardCCEWebCCEWebBoleroCCEWebERPGarterGroupInc[16]ERPMRP/MRP[17]ERPERPERPERP,ERPERP51.1.3ERP2060ERPERP31.MRPMRPBOM;)2.MRPMRP,2070MRPMRP(2).MRPMRPMRP;(CRP).MRPMRPMRPMRP;.MRP.43.MRPERP6[18]MRP11.MRPIIMRPIIMRP11ERPGartnerGroupInc.(Gartner)2090ERP(EnterpriseResourcesPlanning)MRP(ManufacturingResourcesPlanning,)[17]MRP-11ERP3:1.ERP.2.ERP.LP(LeanProduction)(AgileManufacturing).3.ERP.3ERP;.ERPERPERP2090(AgileManufacturing)(TheoryofConstraints)ERP[21]ERP71.2ERP75%100[27]APIApplicationProprammingInterfaceAPIWindowsAPIERP81.31.3.1ERPERPERPERPERPERPERPERPERPERPERPERPERPERP1.3.2ERPERPERPERPERPERPERPERPERPERP9ERP2.12.1.12080[8]100501[9]4/5/1.5127.6.4.3.9.8.2.10.11.2-1Figure2-1Lettercreditofpaymentflowchart1.ERP102.3.4.5.()6.7.2.1.2ERPERPERPERP11ERPERPERP2060ERP.ERP3MRPMRPMRP-IIMRP-IIERP3:1.ERP.2.ERP.LP(LeanProduction)(AgileManufacturing)3.ERP.3ERP.ERP2.22.2.1ERPERPERP12ERP1.1)ERPAPIApplicationProgrammingInterface2)3)ERPWebERP,,[11]2.ERP[12]WebServiceWebServiceERP,InternetERPWebService[13]WebserviceERPERP2-2WebserviceFigure2-2DataExchangeWaybasedonWebservicePDMERP[14][15]ERP13ERPERPERPERPERPERPERPERP,ERP,ERPERPERP2-3ERPFigure2-3ERPsystempassivenessreaddataERPERPERPERPERPERP2-4ERPFigure2-4ERPsysteminitiativereaddataERPERP/2-5/Figure2-5DataExchangeWaybasedonfileortableERPERP142.2.2ERPERPERPERPERPERP12345123ERPERP1)2)3)4)2-6ERPFigure2-6ThestructureofintegratedERPsystemwithlettercreditERPERPERPERPERP15ERPERP2.3ERPERP163.13.1.1200241[25]ERPERPERPERPERP173.1.2ERPERP3.23.2.1ERP1.Yes,NoNoYes3-1Figure3-1examineflowchartoflettercreditERP18(1)(2)(3)(4)(5)(6)2.ERP19YesNoNoYes3-2Figure3-2examineflowchartofchangelettercredit3-2(1)(2)(3)(4)ERP20(5)(6)3.NoNoYes3-3Figure3-3Specialpermitsflowchartoflettercredit3-3(1)(2)ERP21(3)(4)(5)3.2.2ERPERPERPAP-11YesYesYes3NONo33-4ERPFigure3-4paymentflowchartofintegratedERPsystemwithlettercredit3-4ERPERPERP(1)ERPERP22(2)(3)(4)(5)3.3ERPERP234.1ERPERPMRP/MRP4-1ERPERP4-1ERPFigure4-1partofERPsystemstructuremodule--ERP(1)ERPERPERP(2)ERP24(3)(4)ERP//(5)4.24.2.1100%AX1000USD500USD500ERP25USDA500USD4.2.11.(1)ERP(2)(3)////5.1(4)ERP262.(1)(2)(3)//5.13.(1)//ERP27(2)4.3