UserManualforKingdeeK/3V14.2BOSCustomizedDevelopmentToolkitStatementThecopyrightofthisdocumentisownedbyKingdeeSoftware(China)Co.,Ltd.Nopartofthisdocumentmaybealtered,reproduced,excerpted,translated,reprintedorrewritteninanyformorbyanymeanswithoutpriorwrittenconsentofKingdee.KingdeeSoftware(China)Co.,Ltd.November,2015PrefaceThankyouforusingtheUserManualforKingdeeK/3V14.2BOSCustomizedDevelopmentToolkit.Themanualisorganizedinthefollowingsections,helpingyoutoeffectivelyusetheBOSCustomizedDevelopmentToolkit: GeneralDescription Instructions Procedures Functions&Features SystemSettingsThePrefaceprovidesyouwiththewaytoobtainotherhelpfulinformationaswellastheconventions.TargetReadersThismanualisintendedforuserswhohavesolidworkexperienceandexpertiseintherelatedareaandknowthebasicsoftheKingdeeK/3system.Beforefirsttimeuse,itisrecommendedthatyouattendoneormoreourtrainingprograms.Formoreinformationaboutthetraining,pleasecontactourlocalKingdeeoffice.Tolearnmoredetailsaboutthesystem,suchasuserinterfaces,pleasefamiliarizeyourselfwiththeKingdeeK/3systemandtheMSSQLSERVER,andreadthetechnicaldocumentationthatcomeswiththeKingdeeK/3system.SourcesofRelevantInformationYoumayacquaintyourselfwithoursystemandgetserviceandhelpthroughthefollowingchannels.1.OnlineTokeepyourselfuptodatewithourlatestKingdeeK/3products,applicationsandsolutions,pleasevisitourwebsiteathttp://www.kingdee.com/.2.Pre-saleConsultingTomeetenterprises’developmentandmanagementneeds,weprovidemanagementconsultationandsolutions,helpingenterprisestomakequickandrightdecisions.3.ProductTrainingTostayattheforefrontoftechnologicalandmanagementinnovations,Kingdeeiscommittedtoprovidingcustomerswithholisticindustrialsolutions.Inadditiontoitswiderangeofqualityproducts,Kingdeealsoofferscomprehensivetraining,helpinguserstoquicklydeploytheirsoftwareapplications.4.ConsultingBasedontheextensiveexperienceofmorethan10,000customersaswellasadvancedmanagementideasandmanagementsoftwareapplicationsworldwide,KingdeehasdevelopedGoldenFingerImplementationMethodology,asoftwareapplicationmethodologythatsuitsChina’sactualsituation-.KingdeehasnohesitationinhelpingyouachievemoresuccessbyleveragingitssolidexperienceandexpertiseinenterprisemanagementandITtechnology.5.FieldSupportOurqualifiedprofessionalsarealwaysreadytodiscusswithyoufacetofaceaboutanyissuesandconductfieldresearchandanalysistoworkoutarightsolutionimmediately.6.CRMServiceByutilizingtheKingdeeEAS-CRM,apowerfulcustomerrelationshipmanagementsystem,Kingdeehasestablishedacomprehensivecustomerinformationmanagementlibrary,enablingKingdeetosolvecustomers’problemsimmediately,tomaintainanexhaustivecustomerrecordandtoprovidecustomerswithlong-term,sustainable,efficientservices.7.CSPServiceKingdeereliesonitsyearsofexperienceandstate-of-the-artmanagementpracticestoprovideintegratedCSPservicethatbestsuitscustomers’need.Astheindustry’smostholisticservice,theCSPisdistinguishedbyafullrangeoffeaturesthatbuildonKingdee’scutting-edgetechnologyandprofessionalserviceteam.8.CallCenterThroughcustomercallcenter,weprovideyouwithattentiveserviceandrespondtoyourquestionsandconcernsquickly.9.PersonalizedServiceInresponsetocustomers’needforpersonalizedservice,weprovidecustomizedserviceandutilizealltheresourcesavailabletoofferyoufull-featuredapplicationstogetherwithourpartners.10.ConvenientServiceAsaproviderofbothsolutionsandproducts,weofferyoueasyaccesstoourservices,removingyourworryofchoosingfromawideselectionofsolutionswhileatthesametimeensuringthecompatibilityandintegrityofourproductsandsolutions.11.PartnershipWearelookingtoforgestrategicpartnershipwithotherITindustryleadersinordertoprovideyouwithanextensivearrayofservices,includingenterprisemanagementconsulting,systemsintegration,trainingandmore.InadditiontoKingdee’sbroadserviceportfolio,youalsogainaccesstoservicesofferedbyKingdee’spartners.12.UpgradeOurupgradeserviceenablesyoutomitigateinflationrisks,toprotectyourvalue-addedinvestmentovertime,andtocost-effectivelyupgradeyoursystem.ProductDesignBasedonthebasemanagementphilosophy,KingdeeK/3incorporatesrobustmanagementcapabilities,includingbusinessflowplanning,organization,andcoordinationacrosstheproduct(service)valuechainaswellaseffectivebusinessandmanagementprocedures.Intermsofstrategicmanagement,thesystemfocusesonenterprises’masterdata,basicbusinessflows,internalcontrol,knowledgemanagement,employee’sconduct.Additionally,itprovidestheabilitytosupplyalltheinformationrequiredfordecision-makingthroughoutstrategicmanagementproceduresbyutilizingawidevarietyoftoolsandmethodsandtomonitortheproblemsarisingoutofstrategyimplementationinrealtime,thushelpingenterprisestosharpentheircompetitiveedge.Acornerstoneoftheenterprise'scontinuousmanagementpractice,basemanagementdetermineswhethertheenterprise’sstrategicobjectivescanberealizedandwhethertheenterprise’sdevelopmentisreallysustainable.Thismanagementpracticefeaturesprocessmanagement,becauseitprovidesfirst-handdocumentsthatcantrulyreflectbusinessproceduresandhelpsmakebusinessandstrategicdecisionsthroughrationalknowledge.AboutKingdeeKingdeeInternationalSoftwareGroupCompanyLimitedisaleadingproviderofbusinesssoftwareande-businessapplicationsolutionintheAsia-Pacificregion,andoneofthefast-growingISVinglobalsoftwaremarket,andaleadingcompanyofChinesesoftwareindustry.ThesoftwareproductdevelopedandsoldbyKingdeeincludesthebusinessmanagementsoftwarethatmeetsthedemandofbusinessmanagementofthefast-growingnewmarket,thee-businessapplicationsoftwarethatoffersserviceviaInternet,aswellasthemiddlewaresoftwareusedbyenterprisestoestablishe-businessplatform.Besides,Kingdeealsoprovidescustomersworldwidewithsoftware-relatedmanagementconsulting,implementationandtechnicalservice.Kingdee’sunique“fastconfiguration,fastimplementation,fastapplication,fasteffect”globalizedproductandservicepositioningcanhelpcustomersmeetthechallengeoftheuncertaincommercialenvironmentcalmly,realizetheperfectcombinationofbusinessflowandITtechnology,carryouteffectivemanagementinnovationandensurefast,sustainableandhealthygrowthoftheorganization.KingdeeInternationalSoftwareGroupCompanyLimitedisthecreatorofChina’sfirstaccountingsoftwarebasedonWINDOWS,firstpureJAVAmiddlewaresoftware,andfirstthree-tierERPsystembasedonInternetplatform.KingdeeK/3isthebusinesssoftwarewiththehighestoccupationratiointheERPmarketamongChinesesmallandmedium-sizedenterprises.InOctober2004,Kingdeeformallyreleasedthenewgenerationproduct-KingdeeEAS4.0(KingdeeEnterpriseApplicationSuite).KingdeeEASbasesitselfuponKingdeeBOS-thecommercialoperationsystemindependentlyresearchedanddevelopedbyKingdee.Ittargetsatlargeandsmall-sizedenterprises,adoptsthenewestERPIImanagementideaandintegrateddesign.Itiscomposedofover50applicationmodulesandcoversenterprise’sinternalresourcemanagement,supplychainmanagement,customerrelationshipmanagement,knowledgemanagement,commercialintelligence,etc.andrealizesthebusinesscoordinationamongenterprisesandtheapplicationintegrationofe-business.CompilationAgreement AgreementofGeneralFormatFormatDescriptionArialCharacterTextInputMessageItalicPromptMessage AgreementofGraphicalInterfaceFormatFormatDescriptionWindowname.Generalmenuitemordendritestructuremenuitem.Buttoninthewindow.BoldOptionintheform.->Continuousselectionofmenuanditssubmenuordendritestructure. AgreementofKeyboardOperationFormatDescriptionKey1Keynameonthekeyboard.Key1+Key2Presstwokeyssimultaneously. AgreementofMouseActionFormatDescriptionClickPressleftmouseandclickanobject.Double-clickContinuallypressleftmousetwiceandopenanobject.Right-clickSelectanobjectandpressrightmouse.Drag-dropNon-stoppressleftmouseandmovemousetodesignatedpositionthenreleasesthemouse. SpecialSignsFormatDescriptionCautionRemindsusersofpossibleseriousconsequenceandcalluser’sattentiontouseitdiscreetly.NoteProvidessomeimportantdescriptions.ExampleGivesanexamplesothatuserscanunderstanditveryclearly.PreconditionReferstotheoperationthatmustbecompletedbeforeacertainoperation.DefinitionDefinesfinancialorcomputertermsthatappear.DescriptionofSymbolsofFlowChartThismanualusesEPC(Event-driven-ProcessChain)todepictthemainbusinessflow.EPCreferstoEvent-driven-ProcessChain.Throughconnectingtoeventandtask,userscansetupthemoduleofcomplicatedbusinessflowandmakeananalysis.EPCmethodnotonlyusesintelligiblesymbolsandlanguagetohelpusersandconsultantsdescribebusinessinformationsystem,butalsointegratesorganizationalstructure,function,dataandinformationflow.EPCmodulecandemonstratehowtheinterruptionoftaskchainandliabilitychainaffectsacompany’sabilitytooptimizeitsbusinessflow.Bymatchingtheorganizationwitheachtask,userscanseewhichdepartmentorpostisinvolvedwiththeflowveryconveniently.ConcerningthedescriptionofthesymbolsmentionedinEPCchart,seethetablebelow:NameIconDefinitionExampleEventItdescribesthehappeningofthestateofaffairs,andoppositelyactsasatrigger.ReceivingoriginalvoucherFunctionsItdescribestheconversionfrominitialstatetofinalstate.NewVoucherOrganizationUnitItdescribestheenterprise’sstructureroughly.AccountantoffinancialdepartmentInformation,Material,ResourceObjectItdescribestheobjectinrealworld(forexample,businessobject,andmaterialobject).AccountRouteItdisplaystheprecedencerelationshipofconnectionofdifferentflows(navigationassistance).VoucherhandlingprocedureLogicOperationalCharacterItdescribesthelogicrelationshipbetweeneventandfunctionorflow.“XOR”:Onehastomakeexclusivechoicefrommultipleflows.“V”:Itstandsfor“or”relation.“Λ”:Itstandsfor“and”relation.ControlFlowItdescribestheprecedenceandlogicdependencyrelationshipbetweeneventandfunctionorflow.InformationFlow,MaterialsCirculationItdefineswhetherafunctioncanberead,alteredorwrittenin.AllocationofResource,OrganizationUnitItdescribeswhichunit(staff)orresourcecanbeusedtoprocessacertainfunctionorflow.FeedbackThankyouforusingourproductandusermanual.ThismanualisdeliveredtogetherwithafeedbackformYouarehighlyappreciatedtoindicateyouropinionsandsuggestionsonourproductorusermanualandsendtheformtoourlocalKingdeeofficeorfaxittoourK/3ProductDepartmentat+86-755-26615016.Kingdeeislookingforwardtoyoursuggestionsandopinions.6TableofContentsChapter1SystemOverview..11.1SystemComposition.11.2SystemFeatures.11.2.1DetailedDataDictionary.21.2.2DataExchangeStandardComplyingwiththeW3CSpecification.21.2.3UsefulSupportingTool.31.2.4CompleteOnlineHelp..31.2.5RepresentativeExampleCodes.41.2.6CompleteBOSPlug-inDevelopmentManual..41.3ModuleLocationinK/3ERPSystem..4Chapter2DatabaseDescriptionGenerator.62.1ViewingK/3DatabaseStructure.62.1.1LoginInterface..62.1.2ViewingK/3DatabaseStructure..72.2AddingaSelf-definedTableorField.102.3GeneratingDescriptionSQL.112.4NotesforMaintainingDataDictionarybySelf-definingSQLStatements.12Chapter3KingdeeSchemaEditor..133.1SchemeOperations..133.1.1LoggingonMainInterface..133.1.2SchemeOperations..133.1.3NodeOperations..133.1.4ImportingfromDatabase..133.1.5ImportingExternalObject.133.1.6GeneratingSchemaFile.133.1.7GeneratingDataPipingArchitecture..133.2SchemaSettingsSpecifications..133.2.1ValidityofSchemaSettings..133.2.2RelatedComponents..133.2.3RelatedDBArchitecture.133.2.4RegularExpressions..133.2.5DataTypeDefinitionandDescriptions.133.2.6CorrespondenceRelationbetweenSqlServerandSchemaDataType..133.3LocationofSchemaEditor..13AppendixAFeedbackForm..14UserManualforKingdeeK/3V14.2BOSCustomizedDevelopmentToolkitChapter1SystemOverviewChapter1SystemOverviewAsmoreandmorecustomersusetheK/3system,theuniversalversionhardlysatisfiesspecialrequirementsofsomecustomers.Tomatchtheserequirements,Kingdeespecificallyprovidesthecustomizeddevelopmenttoolkit(softwaredevelopmentkit).ThiskitenablesthecustomertoperformappropriatesecondarydevelopmentbasedontheK/3systemtosatisfyspecialrequirements.Thesoftwaredevelopmentkitisdesignedfortheconsultationspecialist,implementationadvisor,andenterpriseITbuilderrelatedtotheK/3product.BasedontheK/3system,theusercanusethiskittocustomizetheindustrialversionfortheK/3customerwithspecialrequirements,workoutthespecialreport,extendfunctionsoftheexistingsystem,andintegratethethird-partysystem.1.1SystemCompositionThesoftwaredevelopmentkitintegratesallthesecondarydevelopmentsupportingtools,componentinterfacesandtheirdescriptions,datadictionaries,dataexchangestandards,andotherrelevantinformation.Thecontentinthekitisextractedandsortedfromallthebusinessmodules.Thefollowingdiagramshowstheintegrationofthissystemwithothersystems:1.2SystemFeaturesThesoftwaredevelopmentkitexternallyprovidesthesoftwarestandard,designidea,anddesignprincipleofKingdeeK/3system.Itoffersthesecondarydevelopment1Chapter1SystemOverviewUserManualforKingdeeK/3V14.2BOSCustomizedDevelopmentToolkit2personnelaK/3-basedapplicationplatformusedforsecondarydevelopment,aswellascompletedevelopmenttoolsanddevelopmentreferences.Thesoftwaredevelopmentkithasthefollowingfeatures:A.DetaileddatadictionaryB.DataexchangestandardcomplyingwiththeW3CspecificationC.UsefulsupportingtoolsD.CompleteonlinehelpE.Representativeexamplecodes1.2.1DetailedDataDictionaryThedatabaseisthetechnicalcoreoftheK/3system,sothedetaileddatadictionaryisadescriptiondocumentoftheK/3databasetablestructure.IthelpstheuserwiththesecondarydevelopmentcapabilityclarifythedatastoragestatusoftheK/3systemandinter-tablerelations.Ifyouknowhowthedataisstored,youcan:A.DirectlyqueryandexportsomedesireddatanotprovidedbytheKingdeereportthroughtheSQLquerystatement.B.Providetheoperationinterfaceofsomedatabyprogrammingtorealizesomespecialfunctions.C.Exchangedatathroughdirectlyprogrammingbyusingthedatabasedescriptiondocument,andintegratethedataofothersoftware.1.2.2DataExchangeStandardComplyingwiththeW3CSpecificationThedataexchangestandardinterfaceofKingdeedefinesthebusinessobjectoftheK/3systemasXMLSchemainaccordancewiththeW3Cinternationalstandard.Inaddition,itprovidesthecomponentssupportingdataimportandexport.ThedataexchangestandardinterfacecanexchangetheXMLdatadocumentcheckedthroughXMLSchemawiththeK/3systemdata.ThedataexchangestandardinterfaceofKingdeeconsistsof:A.ExchangeinterfacedescriptionofallthebusinessobjectsB.XMLSchemaofallthebusinessobjectsC.KingdeeSchemaeditor1.ExchangeinterfacedescriptionofallthebusinessobjectsTheexchangeinterfacedescriptionofallthebusinessobjectsisanExceldocument,whichdetailstherelevantbusinessobjects,itemscontainedinthebusinessobjects,andtheirrelations.XMLSchemaisdefinedaccordingtotheobjects,items,andrelationsprovidedinthisdocument.Youcandouble-clicktoopenthedocumentsolongasExcelisinstalledatyourcomputer.2.XMLSchemaofallthebusinessobjectsUserManualforKingdeeK/3V14.2BOSCustomizedDevelopmentToolkitChapter1SystemOverviewXMLSchemaofallthebusinessobjectsistheformatdefinitionaccordingtothecontenttobeexchanged.ItaimstoverifythedatalegalitywhendataisexchangedwiththeK/3system.YoucancheckitsstructurethroughtheIEorKingdeeSchemaeditor.3.KingdeeSchemaeditorKingdeeSchemaeditorisatoolusedtodefinethebusinessobjectSchema.Initially,itisdevelopedtocustomizeKingdeedataexchangeSchema.Now,itisavailablefortheuser,whocanusethistooltodefineSchemaforotherbusinessobjects.1.2.3UsefulSupportingToolThesecondarydevelopmentkitisusedforsecondarydevelopmentoraccountsetdatacheck,andprovidingthehelpinformationaboutupgrade.Itprovidesthefollowingfunctions:A.PatchpackageinstallationB.DatacheckC.Accountsetupgrade1.PatchpackageinstallationWhenthesecondarydevelopmentuserdevelopssomecomponentsorwritesSQLstatementsusedtoaddatabletotheK/3database,howcanthisuserautomaticallyloadthesecomponentsandSQLstatementstotheclientinstallationdirectoryandregisterthem,oraddthemtotheM-sever?Thepatchpackageprovidestherelatedoptions.Afterperformingtheaboveoperations,youcanexecuteyourSQLstatementsatthedatabase.2.DatacheckDatacheckisusedtocheckwhethertheuser'saccountsetstructureisconsistentwiththelatestdatabasestructure,andwhethertheuser’saccountsetdataiscomplete.Ifthetwostructuresareinconsistentorthedataisincomplete,thesystemprovidesthedetailedpromptlist.Afterreadingthispromptlog,theusermanuallymakesadjustmentortakesothermeasuresasactuallyneededtoperfectthestructureordataandobtainthecorrectresult.3.AccountsetupgradeTheaccountsetupgradetoolisusedtoupgradeKingdeefinancesoftwareV6.2/3totheK/3systemV8.0.Then,theusercanupgradetheK/3systemV8.0toahigherversion.1.2.4CompleteOnlineHelpKingdeeSDKonlinehelpistheinterfacedescriptiondocumentthatprovidesbusinessobjectcomponentsoftheK/3system.Byreadingthisdocument,theusercanlearnaboutspecificcomponentsofthesebusinessobjectsandrelatedfunctionscompletedbythesecomponents,andcallingmethods.Inthecaseofsecondarydevelopment,the3Chapter1SystemOverviewUserManualforKingdeeK/3V14.2BOSCustomizedDevelopmentToolkit4usercanselectivelycallthesecomponentstoaccessrelevantdataandextendnecessaryfunctions.KingdeeSDKonlinehelpiscomposedof:1.ReferencemanualfortheBaseDataExchangecomponent2.UserreferencefortheBaseDataExChange2component3.ReferencemanualfortheEBCGLcomponent4.UsermanualforExpImp805.K3customizeddevelopmenttoolkit6.DescriptionforthecustomizedconsoleofK3system7.ReferencemanualfortheKFOcomponent8.ReferencemanualforXMLKFO29.Referencemanualforsecondarydevelopmentoftheproxyservice10.Referenceforthecommercialdocumentcomponent11.ReferenceforthesecondarydevelopmentplatformVBA12.Applicationsolutionforthesecondarydevelopmentplatform13.Referencemanualfortheinvoiceinterface14.Referencemanualforthevoucherinterface15.Referencemanualfortheuniversalreport16.ReferencemanualforuserloginAfteryouinstallAdobeAcrobat4.0oralaterversionatyourcomputer,youcandouble-clicktoopenandbrowseanyoftheabovereferencemanuals.1.2.5RepresentativeExampleCodesExamplecodesareaseriesofexamplescalledbyservicecomponentinterfaces,whichcompletesomecomponent-relatedreportqueryormaintenancefunctions.TheseexamplecodescanrunintheenvironmentthatconsistsofthesecondarydevelopmentplatformandVBA.1.2.6CompleteBOSPlug-inDevelopmentManualKingdeeBOSplug-indevelopmentmanualistheinterfacedescriptiondocumentthatprovidestheK/3BOSplug-inmodel.Thismanualenablestheusertoknowprovidingmethods,properties,functions,andcallingcasesoftheseBOSobjects.Inthecaseofsecondarydevelopment,theusercanusethismanualasneededtodeveloprelevantplug-ins.1.3ModuleLocationinK/3ERPSystemFigure1-1showsthelocationofthesystemintheK/3ERP.UserManualforKingdeeK/3V14.2BOSCustomizedDevelopmentToolkitChapter1SystemOverviewFigure1-15UserManualforKingdeeK/3V14.2BOSCustomizedDevelopmentToolkitChapter2DatabaseDescriptionGenerator6Chapter2DatabaseDescriptionGeneratorThedatabasedescriptiongeneratorisusedtomaintainthedatadictionaryoftheuniversalreportandviewtheK/3databasestructure.Withthistool,theusercandirectlyaddanewdatabasetabletothedatadictionaryoftheuniversalreport.Thedatabasedescriptiongeneratorprovidesthefollowingfunctions:ViewingtheK/3databasestructureAddacustomizedtabletothedatadictionaryAddacustomizedfieldtothedatadictionary GeneratingthedescriptionSQL Notesformaintainingthedatadictionarybyself-definingSQLstatements2.1ViewingK/3DatabaseStructure2.1.1LoginInterfaceAftertheCustomizationDevelopmentToolkitisinstalled,youcanlogonBOSIDE.OnBOSIDE,clickK3BOSSDK->CustomizedDevelopmentTool->DBDescriptionGenerationTooltodisplaytheKingdeeK/3SystemLogininterface.Selectthespecificaccountsettostartthedatabasedescriptiongenerator.Youmustensurethattheaccountsetiscorrect,andtheusernameandpasswordarelegal.OntheKingdeeK/3SystemLogininterface,clickOKtodisplaytheKingdeeK/3BOSinterface.ClickK/3BOSSDKonthetoolbar,andselectCustomizedDevelopmentTool->DBDescriptionGenerationTooltodisplaytheGeneratorforDescofSQLDatainterface,asshowninFigure2-1.Chapter2DatabaseDescriptionGeneratorUserManualforKingdeeK/3V14.2BOSCustomizedDevelopmentToolkitFigure2-1GeneratorforDescofSQLDatamaininterface2.1.2ViewingK/3DatabaseStructure1.Theaboveinterfaceliststhedetailedinformationdescribedbytheuniversalreport:PropertyDescriptionDatabaseDisplayTableCodeTableIDYoucanidentifythetableasthesystempresettableortheuser’sself-definednewtablethroughthetableID.-Thefirst5000IDs(0<=ID<5000)inthemoduleindicatesystempresettables.-Thesubsequent5000IDs(5000<=ID<10000)inthemoduleindicateself-definedtables.T_TableDescription.FTableIDTableNameDatabasetablenameT_TableDescription.FNameTabledescriptionTabledescriptionnameT_TableDescription.FDescriptionSubsystemNameofthemoduletowhichthecurrenttablebelongsT_TableDescription.FSubsytemIDSubsystemCodeCodeofthemoduletowhichthecurrenttablebelongsT_SubSystem.FSubSysIDTableTypeTypeofthecurrenttable:FType=0,indicatingthatthecurrenttableisdisplayedintheuniversalreportdatadictionary.FType=1,indicatingthatthecurrenttableisnotdisplayedintheuniversalreportdatadictionary.FType=3,indicatingthatthecurrenttableisT_TableDescription.FType7UserManualforKingdeeK/3V14.2BOSCustomizedDevelopmentToolkitChapter2DatabaseDescriptionGenerator8PropertyDescriptionDatabaseDisplayaviewdisplayedintheuniversalreport.GeneratingSQLSwitchTogenerateaSQLstatement,selectthisoption.2.Performthefollowingoperationsonthedatadirectorylistedontheinterfaceasneeded:Sortingthedatadictionariesbymodule;Sortingthedatadictionariesbytable;Viewingtheinformationaboutatableorfield.EnterthetablenameintheSearchbox.Thetargettablewillbedisplayedatthefirstlineinthelist.3.Toviewthefielddescriptioninthetargettable:1)Double-clickatargettabletodisplaytheStructuralInfoofMaintforminterface.Theinterfacedisplayspropertiesofthecurrenttable.DataItemDescriptionTableNameDescriptionnameofthecurrenttableTableNoteDescriptivetextaboutthecurrenttableSelf-definedtableornotWhetherthecurrenttableistheuser’sself-definednewtableIfthetableissettoaself-definedtable,thedescriptionofthistableandthefielddescriptioninitaremaintainedwhentheaccountsetisupgradedtothenewversion.Theuserdoesnotneedtoaddthetable.CorrespondingtothedatabaseT_Tabledescriptio.FSefDefSign(FSefDefSign=0:notaself-definedtable;FSefDefSign=1:aself-definedtable)DisplayintheURTornotWhetherthecurrenttableisdisplayedintheuniversalreportdatadictionaryWhenthetableisaview,thisoptionisdisabled,namely,thetableisdisplayedintheuniversalreportbydefaultCorrespondingtothedatabaseT_Tabledescriptio.FType(FType=0:displayedintheuniversalreport;FType=1:notdisplayedintheuniversalreport)Chapter2DatabaseDescriptionGeneratorUserManualforKingdeeK/3V14.2BOSCustomizedDevelopmentToolkitFigure2-2StructuralInfoofMaintforminterface2)TheStructuralInfoofMaintforminterfacedisplaysallthefieldsandfielddescriptionsinthecurrenttable.PropertyDescriptionRelatedDatabaseFieldFieldNameDatabasefieldnameT_FieldDescripTion.FFieldNameFieldDescrDescriptionofthefieldT_FieldDescripTion.FDescriptionFieldTypeFieldtypeTheuniversalreportsupportsonly4fieldtypes:Integer,Float,String,andDateTimeT_FieldDescripTion.FFieldTypeDisplayinthereport,Yes/No?WhetherthecurrentfieldisinthedatadictionaryoftheuniversalreportT_FieldDescripTion.FTypeRemarksDescriptivetextaboutthecurrentfieldT_FieldDescripTion.FNoteSelf-definedfieldornotWhetherthecurrentfieldisafielddescriptionnewlyself-definedormodifiedbytheuserT_FieldDescripTion.FSefDefSign9UserManualforKingdeeK/3V14.2BOSCustomizedDevelopmentToolkitChapter2DatabaseDescriptionGenerator2.2AddingaSelf-definedTableorFieldIntheactualapplication,theuserusuallyneedstostoretheenterprise’scharacteristicdatabysecondarilydevelopinganewtable.Similarly,thedatashouldbeanalyzedandpresentedthroughthereport.Theusercanselecttheuniversalreporttool,butthesystemdoesnotpresettheuser’sself-definedtabledescriptioninthedatadictionaryoftheuniversalreport.Therefore,theusercanaddthetableandfielddescriptionbyusingthedatabasedescriptiongenerator.1.SelectNewfromtheGeneratorforDescofSQLDatamaininterfacetodisplaytheGenerateTable&Fielddescriptioninterface,asshowninFigure2-3.Inthedatabaselistattheleftpart,selectoneormorenewtablestobedisplayedinthedatadictionaryoftheuniversalreport(youcanselecttablesbypressingCtrlandShift).Figure2-3GenerateTable&Fielddescriptioninterface2.Addtheselectedtabletotheblankboxontherightpartoftheinterface.3.IntheSubsystemIDlistatthebottompartontheinterface,selectthemoduletowhichthenewtableisadded.Note:Sincetheuniversalreportimplementsauthorizationcontrolbasedonthemodule,besuretoaddthetabletothecorrectmodule.4.ClickGenerateDescription.Thesystemautomaticallyaddsthetableinformationtothetabledescriptiontable(T_TableDescription)oftheuniversalreportaccordingtotheselectedtableandmodule.5.ReturntotheGeneratorforDescofSQLDatamaininterface,findthetablejustadded,anddouble-clickit.OntheStructuralInfoofMaintforminterface,maintainthetableandfieldasactuallyneeded.Note10Chapter2DatabaseDescriptionGeneratorUserManualforKingdeeK/3V14.2BOSCustomizedDevelopmentToolkit Forthenewtabledescription,besuretoselecttheSelf-definedtableorNotcheckbox.Thus,yourself-definedandmaintainednewtablewillbemaintainedanddisplayedinthedatadictionarywhentheaccountsetisupgradednexttime. Forthenewfielddescription,besuretoselecttheSelf-definedfieldorNotcheckbox.Thus,yourself-definedandmaintainedfielddescriptionwillbemaintainedanddisplayedinthedatadictionarywhentheaccountsetisupgradednexttime. Afteraddingormodifyingthedescriptionusingthedatabasedescriptiongenerator,executetheRefreshK/3DataDepictfunctionafterusingtheuniversalreport.Thisensuresthatthenewormodifieddescriptionisdisplayedinthedatadictionaryoftheuniversalreport. Youcanidentifywhetheratableisaself-definedtableusingeitherofthefollowingmethods:1.TableID:Thefirst5000IDs(0<=ID<5000)inthemoduleindicatesystempresettables.Thesubsequent5000IDs(5000<=ID<10000)inthemoduleindicateself-definedtables.2.DirectlyviewtheSelf-definedtableorNotpropertyontheStructuralInfoofMaintforminterface.2.3GeneratingDescriptionSQLBeforeupgradingtheaccountset,youcansavethedescriptionSQLstatementoftheself-definedtableorself-definedfieldasafilethroughtheSQLstatementgeneratingfunction.Thisensuresthattheself-definedtableandfielddescriptioniscompleteaftertheupgrade.Selecttheself-definedtableforwhichyouwanttogenerateaSQLfile.PerformthefollowingstepsthroughtheToolmenu:Step1.Markthetablenotinusage(Step1:MarkTableNotinUsage).Step2.Updatethedatatype(Step2:UpdateDataType).Step3.Hidespecialtypes(Step3:HideSpecialTypes).Step4.GenerateaSQLstatement(Step4:GenerateSQL…)throughtheGenerateSQLStatementdialogbox,asshowninFigure2-4.Figure2-4GenerateSQLStatementdialogbox11UserManualforKingdeeK/3V14.2BOSCustomizedDevelopmentToolkitChapter2DatabaseDescriptionGenerator121)TogenerateaSQLdescriptionabouttheself-definednewtablethroughtheGenerateSQLStatementdialogbox,selectSelf-definedfromtheSelectGeneratingTypedrop-downlistboxandtheTableDesccheckbox.2)TogenerateaSQLstatementabouttheself-definedfielddescription,selectSelf-definedfromtheSelectGeneratingTypedrop-downlistboxandtheFieldDesccheckbox.3)SelectandconfirmtheSQLfilesavinglocation.4)Aftertheaccountsetisupgraded,directlyexecutetheseSQLfilesfortheaccountsetdatabase.Note:IfyouneedtogenerateSQLstatementsforsometablesonly,checkwhetherthetableIDinthegeneratedSQLstatementandthesametableIDaftertheupgradeindicatethesametable,andseeifthereisanyIDconflict.Ifthetableistheuser’sself-definednewtableandthetableIDconflictswithanothertableID,manuallyaddittotheSQL,changethetableIDtothesystemID+5000orthemaximumvalueabove5000+1.IfthetableisasystempresettableandthetableIDconflictswithanothertableID,manuallychangethetableIDintheSQLtothemaximumtableID+1(tableID<5000).2.4NotesforMaintainingDataDictionarybySelf-definingSQLStatementsIfyoumaintainthenewtableandfielddescriptionbydirectlycompilingSQLstatementstoadddescription,insteadofusingthedatabasedescriptiongeneratorprovidedbyus,observethefollowingrules:1.InT_TabledescriptionandT_Fielddescription,thetableIDofthenewtablemustbeequaltothecurrentmoduleIDfollowedby5000,thetableIDofthenextnewtablemustbethecurrentmoduleIDfollowedby5001,andsoon.Forexample,addtheuser’sself-definedtablet_def_notestothetransactionmodule.Then,thetableIDisequalto13(moduleID)+5000=135000.2.InT_TabledescriptionandT_Fielddescription,thefieldFSefDefSign=1(whetheritisself-definedastrue).UserManualforKingdeeK/3V14.2BOSCustomizedDevelopmentToolkitChapter3KingdeeSchemaEditorChapter3KingdeeSchemaEditorNote:ThefollowingcontentsarenotavailablefortheEnglishversionatthetimebeing.3.1SchemeOperations3.1.1LoggingonMainInterface3.1.2SchemeOperations3.1.3NodeOperations3.1.4ImportingfromDatabase3.1.5ImportingExternalObject3.1.6GeneratingSchemaFile3.1.7GeneratingDataPipingArchitecture3.2SchemaSettingsSpecifications3.2.1ValidityofSchemaSettings3.2.2RelatedComponents3.2.3RelatedDBArchitecture3.2.4RegularExpressions3.2.5DataTypeDefinitionandDescriptions3.2.6CorrespondencebetweenSqlServerandSchemaDataType3.3LocationofSchemaEditor13UserManualforKingdeeK/3V14.2BOSCustomizedDevelopmentToolkitAppendixA14AppendixAFeedbackFormUserManualforKingdeeK/3V14.2CustomizedDevelopmentToolkit1.Makecommentsonthefollowingindexesbyticking(√)theappropriatecells.ExcellentGoodFairPoorAccuracyCompletenessAccessibilityClarityGraphicsOverall2.Inyouropinion,Kingdeeshouldimprovethefollowing: Text Specialty Structurearrangement Graphicdescription Appendixes Presentation Tableofcontents Typicalexamples Processdescription HelpDetailtheimprovementsuggestionshere.3.Whatareyouunsatisfiedwith?4.Others5.PleaseprovidefullcontactssothatKingdeecancontactyouquickly.Name:Title:Telephone:E-mail:Company:Address:
