--˲����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

--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

--多账簿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

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

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

--查询有入库但是未完全开采购发票的采购订单selectdistinctpo.vordercodefrombd_corpbp,po_orderpo,po_order_bpb,bd_busitypebusiwherepo.dr=0andpb.dr=0andpo.pk_corp=bp.pk_corpandpb.pk_corp=bp.pk_corpandpo.corderid=pb.corderidandpo.cbiztype=busi.pk_busitypeandpb.naccuminvoicenum

时间:2024-02-26 14:43栏目:U8Cloud

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

selectpk_voucherfromgl_vouchervwherev.year='2015'andv.period='07'andv.num=12andv.pk_accountingbookin(selectpk_accountingbookfromorg_accountingbookwherecode='账簿编码')select'会计平台日志-目标系统'||a.des_system||'-单据类型'||a.des_billtypeasdescname,a.src_relationidassrcidfromfip_o...

时间:2024-04-26 20:00栏目: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