分区常用代码的第1页U9脚本大全PO终止，后台改状态脚本updatePM_POLinesetCancel_Canceled=0,Cancel_CancelDate=null,Cancel_CancelUser=null,Cancel_CancelReason=nullwherePurchaseOrderin(selectIDfromPM_PurchaseOrderwhereDocNo='564191')updatePM_POShipLinesetCancel_Canceled=0,Cancel_CancelDate=null,Cancel_CancelUser=null,Cancel_CancelReason=nullwherePOLinein(selectIDfromPM_POLinewherePurchaseOrderin(selectIDfromPM_PurchaseOrderwhereDocNo='564191'))updatePM_PurchaseOrdersetCancel_Canceled=0,Cancel_CancelDate=null,Cancel_CancelUser=null,Cancel_CancelReason=nullwhereDocNo='564191'改系统启用状态的脚本updateUBF_SM_AppStatesetIsEnabled=0,EnableDate=null,EnableUser=nullwhereID=1001910293209585查用户操作记录select*fromUBF_Portal_OperationRecordwhereOccurrenceTime>='2014-01-0412:25:30'andOccurrenceTime<'2014-01-0412:55:57'库存在手量更新execP_InvTrans_WhQohRebuild'','1002305137407081'---料品ID,空表示全部账簿科目失效updateCBO_NaturalAccountSOBPropertysetEffective_IsEffective=0whereOrgin(selectIDfromBase_OrganizationwhereCode='015')取堆位计划数据到过磅系统中间表selectOrgCode,ShipmentNo,LWPO,a.CabinetNo,c.Code,a.DescFlexSegments_PrivateDescSeg1,d.NamefromLM_HeapBitPlanLineajoinLM_HeapBitPlanbona.HeapBitPlan=b.IDleftjoinCBO_Bincona.Bin=c.IDleftjoin(selectEValue,NamefromUBF_Sys_ExtEnumValuexjoinUBF_Sys_ExtEnumValue_Trlyonx.ID=y.IDwhereExtEnumTypeUIDin(selectUIDfromubf_sys_extenumtypewhereCode='UFIDA.U9.Cust.LM.Lit.UserPubLicBE.DisLocalEnum'))dona.DisLocalEnum=d.EValuewhereb.Org=1002106211219055andb.DocStatusEnum=2anda.PlanStatusEnumin(0,2)anda.Binisnotnullanda.CabinetNoin('')INSERTINTOU9_LOC_Interface(cmpNo,SHIPMENT_NO,PO_NO,CNTR_NO,LOC_NO,Machine_NO,CreateBy,CreateDate,unloadplate)VALUES('971','IJX1314626','34470130','CCLU7372378','0203D','28車間','Tolly','2014-02-12','1#卸貨臺')--更新实体类型值集值updateBase_ValueSetDefsetEntityType=1002703219891445,CodeAttribute=1002703219891453,NameAttribute=1002703219891454whereCode='ItemSpec'--更新枚举类型值集值updateBase_ValueSetDefsetEnumType=1002312283452368whereCode='TCEnum'--selectEntityType,CodeAttribute,*fromBase_ValueSetDefwhereCode='ItemSpec'---查找实体或枚举对应的IDselectID,*fromUBF_MD_ClasswhereFullNamelike'%ItemSpec'orderbyCreateTimedesc----查找实体下字段的IDselectName,*fromUBF_MD_AttributewhereMD_Class_ID='4FFBABAD-32EC-477C-963F-3AD6139427A9'----凭证签字加内账连接串insertintoGD_CUST_IQCParametervalues(1002706044798845,getdate(),'Tolly',getdate(),'Tolly',0,'neizhangIP','172.23.1.219:MRPRW:^M2dmin','leemanpaper',1002705253515024)----查死锁select*fromsys.sysprocesseswhereblocked<>0select*fromsys.sysprocessesorderbywaitresource---查报表词条及对应报表名selectcValue,c.cName,c.cDescriptionfromUBF_MD_ASRPT_ReportTemplate_langajoinUBF_MD_ASRPT_CategoryconA.uReportID=c.IDwherea.cKey+convert(nvarchar(500),a.uReportID)in(selectcKey+convert(nvarchar(500),uReportID)from(selectcKey,uReportID,count(*)numfromUBF_MD_ASRPT_ReportTemplate_langgroupbycKey,uReportID)aawherenum=1)anda.cCulture='zh-CN'---查U9页面、菜单词条selectr.DisplayName,t.DisplayNamefromUBF_RES_ResourceValuerjoinUBF_MD_UIRComponentuonr.ComponentID=u.UIDjoinUBF_MD_UIRComponent_trltonu.ID=t.IDandt.SysMLFlag='zh-CN'where1=1andr.[Type]notin('BEEntityStereotype','BEEventAttribute','BPEvent','BEAutoEvent','BPEventAttribute','BPOperationAttribute','BPOperationImplementsOperation','SvrOperationAttribut...
