EHSS Interface Specification0819 to client.docx

EHSS Interface Specification0819 to client.docx

《EHSS Interface Specification0819 to client.docx》由会员分享，可在线阅读，更多相关《EHSS Interface Specification0819 to client.docx（12页珍藏版）》请在冰豆网上搜索。

EHSSInterfaceSpecification0819toclient

InterfaceSpecificationforEHSS

EHSSProject

VersionDRAFT

08/15/08

Author：

ToddyTu，GeorgeCao

Contents

1.Overview3

1.Overview3

2.InterfaceSignatures3

2.1NewProduct3

2.1.1Purpose3

2.1.2UsageFlow3

2.1.3BusinessDescription3

2.1.4AccessFlow3

2.1.5WebServiceParameters3

2.2InterfaceTwo:

ContainerSize3

2.2.1Purpose3

2.2.2UsageFlow3

2.2.3AccessFlow3

2.2.4WebserviceParameters3

2.3BillofLadingPrinting3

2.3.1Purpose3

2.3.2UsageFlow3

2.3.3BusinessDescription3

2.1.6AccessFlow3

2.1.7WebserviceParameters3

1.Overview

Thediagrambelowprovidesahigh-levelinfrastructureoverviewoftheDobersystem.

SimplifiedInterfaceList:

1）NewProduct

        JDEEHSS

2）ContainerSizes

        EHSSJDE

3）BillofLadingPrinting

        JDEEHSS

Thefollowingsarefieldsandsampledatafortheinterfaces:

IMITM

IMLITM

IMDSC1

IMDSC2

1001

000901-00

Bleach

Bulk

1002

000901-01

Bleach

1GallonPail

2312

000901-05

Bleach

55GallonDrum

I

1.MITM:

JDEprimarykey–systemgenerated–NeverdisplayedinEHSS

2.IMLITM:

*******-**（*****forrawmaterial,*******forproducts,thelatter2digitsarecontainercode.）–userdefined

3.IMDSC1:

Productname（text）

4.   IMDSC2:

Productdescription

Forrawmaterialthecodeis5charactersinlength（XXXXX）

ForFinishedgoodsthecodeis6charactersinlengthfollowedbya“-“thentwocharactersforthepackagesize（XXXXXX-XX）

2.InterfaceSignatures

2.1NewProduct

2.1.1Purpose

WhenJDEiscreatinganewproduct,itactivatesTriggertocalltheinterfacetosynchronicallysavethethreefieldsvalue（IMITM,IMLITM,IMDSC1）intotheEHSStableEHSS_CHMC.

2.1.2UsageFlow

2.1.3

BusinessDescription

ThefollowingsareourdesignforthebusinessoftheinterfacefromJDEtoEHSS.

WeatpresentfirstlyassumethecontainercodeisdefinedandconfiguredinEHSS;

WecangettheproductcodeandcontainercodefromtheIMLITMfromtheJDE;

First,wewilljudgeifthecontainercodeisdefined（exist）inEHSS,ifwecannotfindthecontainercodeinEHSS,theoperationwillstop.ElseifthecontainercodeisfoundwewillcheckinEHSSiftheproductcodeexists:

1）IftheproductcodedoesnotexistinEHSS,wewillinserttheIMITM,IMDSC1andProductCodeintosomeEHSStable.

2）IftheproductcodealreadyexistsinEHSS,wewilljudgeifthecontainercodeexistsinsomeEHSStablerelatedtotheproductcode.

a）Ifthecontainercodedoesnotexist,wewillinsertitintothetablerelatedtotheproductcode;

b）Elseifthecontainerexists,wewillnotifythatthecontainercodehasalreadyinthetablerelatedtotheproductcode..

CommentsbyDober:

1）ThecontainercodeandcontainerdescriptionarecurrentlyinEHSS

2）Thecontainercodeanddescriptionisnotproductspecific

2.1.4AccessFlow

Descriptionofflowdesignabove:

Whennewproductscreated,JDEwritesrelateddatainthetemptable.（Werequireanewfieldaddedintothetemptableindicatingthesuccessofsynchronous）.EHSScallstheweb-servicetoreadthedatainthetemptablebotheverydayandmanuallyandinsertsthedataintotheEHSStableandupdatesthestatusofthenewlyaddedsynchronousfieldinthetemptable.

2.2InterfaceTwo:

ContainerSize

2.2.1Purpose

Whennewproductanditscontainercreated,itwilltriggerEHSStogetthecontainerdescription（IMDSC2）throughthisinterface.

2.2.2UsageFlow

ThepurposeofthisinterfaceistopullallthecontainersizeswhicharesetupforthisproductinJDE

ThecontainerdescriptionandIMDSC2arenotthesamething.

TheIMDSC2shouldbedisplayedonthepageofthecontainerpropertypage（seebelow）andotherrelatedpageasDOTshipping.

ThefullitemnumberdefinedinFieldSpecalsoneedstobeaddedontothepagebelow.

ThereasonforgoingtoJDEistodisplaytotheuserwhatcontainersizestheproducttheyareconfiguringissetinJDE.Forexampleiftheyareworkingwithitem123456thenJDEwouldprovidethemwith123456-00,123456-05iftheitemwasonlysetupinbulkand55galdrums

EHSSwillnothavethefunctiontocreateacontainerforaproduct.SothepagebelowwillbeoutoftheEHSS.

JDEdoesnotsupplyacontainerdescription.Theonlyplace“05”isdescribedasadrumisinEHSS.TheJDEfieldDSC2maycontainthecontainersizebutthatmaynotalwaysbetrue.DSC2is30charactertextfieldswhichareinputtedforeachitem.Wewouldnotwanttouseafreeformtextfieldtodefinethecontainersizes.

EHSSwilladdafieldtosavetheDSC2fromJDE.

JDEdoesnotprovideacontainersizeininterface1.JDEwillsupplytheEHSSsystemwiththefirst6charactersoftheitemname.Withinterface2theuserisgivenalltheavailablecontainersizes.

Forexample:

1Usersenters123456-00toJDE

2.JDEtriggersinterface1toEHSSandpasses123456

3.Usesenters123456-05toJDE

4.JDEdoesnottriggerinterface2sincethisisnota“newproduct”toEHSS

5.UserenterEHSStoconfigurenewproduct123456

6.WhenuserstartstosetupcontainerssizeEHSStriggersinterface2

7.JDEinterface2returns-00and-05toEHSS

8.UserthenconfigurestransportationinfoinEHSSfortheabovecontainersizes.

3）Fortheright-topboxinthechartabove,itsays“EHSSUsersaccesstheContainerPropertiesPage”,Itmeansthattheuserhasaccessedtheavailable（approved）containersizesforaexistingproduct.

Thecontainercodecreated（defined）inEHSSundertheconfiguration—containerlistmenu.

Thecodedescriptioncreated（defined）inEHSSundertheconfiguration—containerlistmenu.

Thecontainercodesanddescriptionsarethesameforallproducts.

2.2.3AccessFlow

2.3BillofLadingPrinting

2.3.1Purpose

WhentheBillofLadingiscreatedinJDE,IttriggersthisinterfaceandgetssomeinformationoftheproductfromEHSS.

2.3.2UsageFlow

2.3.3BusinessDescription

ThedatafieldsthatwillprintontheBOLandpickticketforthefinishgoodarethefollowing:

FG0811-1,FG76,FG74,FG75,FG78,FG79,FG77,FG87,FG88,FG0815-1,FG89,FG0815-2,FG152,FG153,FG154,UDC75

Note:

TogetUDC75useFG155equaltoUDC74. 

ThedatafieldsthatwillprintontheBOLandpickticketfortherawmaterialsarethefollowing:

RM0812-1,RM62,RM60,RM61,RM64,RM65,RM63,RM73,RM74,RM0815-1,RM75,RM0815-2,RM100,RM101,RM102,UDC75

Note:

TogetUDC75useRM103equaltoUDC74.

EHSStosupplyJDEonlyproductiondata

ThemethodwhichOptiousestogetdatafromEHSSshouldnotmatter.IwillstartthetestingofthewebinterfacecallfromOptiosoon,IfitdoesnotworkthenyouwillalreadyhadtoproducetheSQLforthewebservicesoIwilljustaskfortheSQLcallyouusethenDoberwilltailortomeetOptiorequirements

2.1.5AccessFlow