INSERTINTOT_PUR_CONFIG(FCODE,FVALUE)VALUES('PurPriceSorter','Kingdee.K3.Core.SCM.Args.EffectiveDateFirstPurPriceSorter,Kingdee.K3.Core');

时间:2024-09-07 16:35栏目:云星空K3 Cloud

sql1：selectSBatchAdjustBill.fnumber单据编码,person.FNUMBER员工编码,person.Fname_l2员工姓名,casewhenSBatchAdjustBill.FBILLSTATE=0then'未提交'whenSBatchAdjustBill.FBILLSTATE=1then'未审批'whenSBatchAdjustBill.FBILLSTATE=2then'审批中'end审批状态,SBatchAdjustBillentry.Fid当前...

时间:2024-09-09 18:22栏目:金蝶EAS Cloud

--添加辅助属性字段altertableT_BD_STOCKALERTADDF_CUS_FAUXPROPIDBIGINTNOTNULLDEFAULT(0);altertableT_BD_STOCKALERTADDF_CUS_FAUXPROPNUmbervarchar(200)NOTNULLDEFAULT('');GOCREATEVIEWV_STK_WARNSTOCKCUSASSELECT((((CONVERT(VARCHAR(8000),TM.FMATERIALID)+'_')+CONVERT(VARCHAR(8000),TM.FUSEORGID))+'_')+...

时间:2024-09-07 13:33栏目:云星空K3 Cloud

--1、新建期间临时表，将需要保留的期间数据插入--------------------------------新建期间临时表------------------------------DROPTABLETEMPTIME;createtableTEMPTIMEasSELECTfid,fnumberFROMT_BD_PeriodWHEREfperiodyear>2020;--总账1CREATETABLECASHFLOWSPLITRECORDASselect*fromT_G...

时间:2024-09-06 03:23栏目:金蝶EAS Cloud