--˲����selecta.card_code"Ƭ",a.asset_code"ʲ",c.unitcode"������������֯�֯�֯�֯",c.unitname"��",d.code"˲",d.name�����"˲",a.pk_card,a.pk_corp,b.pk_cardhistory,b.fk_accbook�����fromfa_cardainnerjoinfa_cardhistorybona.pk_card=b.fk_cardin...

时间:2024-04-26 20:23栏目:NC/NCCloud

--多账簿selecta.card_code"卡片编号",a.asset_code"资产编码",c.code"组织编号",c.name"组织名称",d.code"账簿编号",d.name"账簿名称",a.pk_card,a.pk_org,b.pk_cardhistory,b.pk_accbookfromfa_cardainnerjoinfa_cardhistorybona.pk_card=b.pk_cardinnerjoinorg_financeorgcona.pk_org=c.pk_f...

时间:2024-04-26 20:18栏目:NC/NCCloud

--begin----------备份相关的数据createtabelgl_voucher_0105asselect*fromgl_voucherwherepk_accountingbook=(selectpk_accountingbookfromorg_accountingbookwherecode='1031001-0001')andyear='2014'andperiod='08'andnum=1131anddr=0;createtabelgl_detail_0105asselect*fromgl_detailwherepk_accountingbook=(s...

时间:2024-04-26 19:54栏目:NC/NCCloud

--！！！执行脚本时，要确保没有人在做凭证相关的业务，最好停掉中间件，然后再执行脚本createtablegl_vouchermaxno_0409asselect*fromgl_vouchermaxno;createtablegl_vouchernosuppl_0409asselect*fromgl_vouchernosuppl;deletefromgl_vouchermaxno;--删除最大号表数据de...

时间:2024-04-26 20:05栏目:NC/NCCloud

select*fromgl_cashflowcasewherepk_detailnotin(selectpk_detailfromgl_detailwherepk_voucherin(selectpk_voucherfromgl_detailwherepk_accasoain(selectpk_accasoafrombd_accasoawherepk_accountin(selectpk_accountfrombd_accountwherecashtype>0))))

时间:2024-04-26 19:41栏目:NC/NCCloud

--1.修改当前账簿的资产账簿启用期间selectpk_accperiodschemefrombd_accperiodschemewhereaccperiodschemecode='会计期间方案编码';--查询会计期间方案主键selectpk_accperiodfrombd_accperiodwhereperiodyear='2016'andpk_accperiodscheme='会计方案主键';--会计年主键selec...

时间:2024-04-26 20:12栏目:NC/NCCloud

--Ϣ�������DELETEFROMt_SystemProfileWHEREFKey='unPosKey'INSERTINTOt_SystemProfile(FCategory,FKey,FValue,FReadonly,FDescription,FLevel,FExplanation,FFormat,FSort,FDescription_cht,FDescription_en)VALUES('General','unPosKey','1',0,'','','','',1,'','')GOUPDATEt_objectaccesstypeSETFObjectID...

时间:2024-09-14 16:16栏目:金蝶其他系列

--如扩大长度为1000：（查询分析器中若执行sql不成功，需点击执行SQL右边的执行方言）altertableT_ORG_AdminalterFReserveFieldFirstvarchar(1000)altertableT_ORG_AdminhisalterFReserveFieldFirstvarchar(1000)

时间:2024-09-22 21:41栏目:EAS Cloud

selectFIELDSNfromT_HR_SCmpItemwherefname_l2like'%工资%';--查询出字段序号为586altertablet_hr_scmpcaltablealters586decimal(13,3)。--s586即为前面查询出的序号586前面加s即可，若上面查询的序号为600，则s586要改成s600

时间:2024-09-22 22:38栏目:EAS Cloud

SELECT*FROMT_HR_sFixAdjustSalarywhereFAdminOrgUnitIDisnullorFPositionIDisnull;--查询select*intoT_HR_sFixAdjustSalary1028fromT_HR_sFixAdjustSalary;--备份deleteFROMT_HR_sFixAdjustSalarywhereFAdminOrgUnitIDisnullorFPositionIDisnull;--删除组织、职位为空的数据

时间:2024-09-22 22:53栏目:EAS Cloud