金蝶专业版常用SQL脚本
2019-09-26 09:57:52 来源：评论：0 点击：

四川金蝶冯阳：15882791810

1、反过账：
DELETE FROM t_SystemProfile WHERE FKey='unPosKey'

INSERT INTO t_SystemProfile (FCategory, FKey, FValue, FReadonly, FDescription, FLevel, FExplanation, FFormat, FSort, FDescription_cht, FDescription_en)

VALUES ('General', 'unPosKey', '1', 0, '', ' ', ' ', '', 1, '', '')

UPDATE t_objectaccesstype SET FObjectID=0 WHERE FObjectType=4 AND FObjectID=-1 AND fname='反过账'

2、允许负库存

Update t_systemprofile Set FValue=0 where FCategory='IC' And FKey='UnderStock'

Fvalue = 1 不允许负库存

Fvalue = 0 允许负库存

3、库存更新控制

Update t_systemprofile set FValue=0 where FCategory='IC' and FKey='UPSTOCKWHENSAVE'

Fvalue = 0 单据审核后更新

Fvalue = 1 单据保存后更新

3、专业版改总仓到分仓

select * from t_systemprofile where fcategory='ic'

update t_systemprofile set fvalue=1 where fcategory='ic' and fkey='CalculateType'
fvalue=0 总仓核算
fvalue=1 分仓核算

*****************************************************************************

一客户新建立帐套，录入物料及数量后，代码作大的变更，需要重新导过，因为其他系统正常，就采用了删除物料，重新导入的方法：

1.删除仓库数据，

若启用了业务系统，删除delete from icbal

若没有启用业务系统，删除delete from IcInvbal

2.删除BOM表

delete from ICbomChild

delete from Icbom

delete from ICBomgroup

3.删除物料；

要删除物料，先删除附属信息表。

select * from t_icitembase where fitemid in (select Fitemid from t_item where fitemclassid=4)

delete from t_icitembase where fitemid in (select Fitemid from t_item where fitemclassid=4)

delete from t_icitemcore where fitemid in (select Fitemid from t_item where fitemclassid=4)

delete from t_icitemcustom where fitemid in (select Fitemid from t_item where fitemclassid=4)

delete from t_icitemdesign where fitemid in (select Fitemid from t_item where fitemclassid=4)

delete from t_icitemmaterial where fitemid in (select Fitemid from t_item where fitemclassid=4)

delete from t_icitemplan where fitemid in (select Fitemid from t_item where fitemclassid=4)

delete from t_icitemquality where fitemid in (select Fitemid from t_item where fitemclassid=4)

delete from t_icitemstandard where fitemid in (select Fitemid from t_item where fitemclassid=4)

--其中Fitemclassid为4，是表示4代表物料类。接下来删除物料；

delete from t_item where fitemclassid=4 or fitemclassid=2001

--其中2001代表物料的成本对象。

然后重新导入数据即可！记得删除数据前一定要备份！

*****************************************************************************

下面是删除固定资产卡片的语句，这些语句是在K/3v10.3里执行的，同样适用于KIS专业版，清空固定资产卡片：

--删除固定资产卡片余额表

delete from t_FACard

delete from t_FACardItem

delete from t_FADept

delete from t_FAOrgFor

delete from t_FAVoucher

delete from t_FAExpense

delete from t_FAClear

delete from t_faalter --主表

-----删除固定资产表

delete from t_FABalCardItem

数据库修复语句：
use master
declare @databasename varchar(255)
set @databasename='AIS20141024120601'------一定要在此手工输入你的账套实体名
exec sp_dboption @databasename, N'single', N'true' --将目标数据库置为单用户状态
dbcc checkdb(@databasename,REPAIR_ALLOW_DATA_LOSS)
dbcc checkdb(@databasename,REPAIR_REBUILD)
exec sp_dboption @databasename, N'single', N'false'

专业版版本降级语句：

1.t_acctctl数据库中表T_AD_KDACCOUNT_GL的字段fversion

update T_AD_KDACCOUNT_GL set fversion='3.0.03.03' where facctid=51

2.要降级的账套中表t_SystemProfile的字段fvalue

update t_SystemProfile set fvalue='3.0.03.03' where FCategory = 'Base' and FKey = 'ServicePack'

3.修改系统启用期间

UPDATE t_SystemProfile SET FValue=0

WHERE (FCategory='gl') AND (FKey ='Closed')

go

SQL清空表内容：

truncate table

KIS标准版8.1 必打补丁---PT091100

KIS专业版V13.0 必打补丁---PT093463- https://pan.baidu.com/s/1JO90YKDfnAFA7uZCkQGgyw

KIS专业版V15.0 应收应付必打补丁---PT122616

链接：https://pan.baidu.com/s/1TFsOJRBXWDiyoEw1OY_gOA

提取码：w2th

KIS专业版V16.0 综合补丁---PT143025(综合累计三）
链接：https://pan.baidu.com/s/1u6kEGjTD6oyqEpJIFpyHQQ

提取码：b38u

KIS商贸版V6.1 必打补丁---PT096516. https://pan.baidu.com/s/1Tv0J4BaqrLI1LzNIpLNwMA

系统补丁：https://club.kingdee.com/forum.php?mod=viewthread&tid=1506145&extra=page%3D1

SQL 2012 Enterprise edition:
<dl class="dl-horizontal" style="box-sizing: border-box; margin-top: 0px; margin-bottom: 20px; color: rgb(51, 51, 51); font-family: " open="" sans",="" ff-tisa-web-pro-2,="" "lucida="" grande",="" "helvetica="" neue",="" helvetica,="" arial,="" "hiragino="" sans="" gb",="" gb="" w3",="" "wenquanyi="" micro="" hei",="" sans-serif;="" font-size:="" 14px;"="">

文件名: cn_sql_server_2012_enterprise_edition_x86_x64_dvd_813295.iso
SHA1: 0293D0E10AAA2E67029980BD6F9B1CAE3F260E18
文件大小: 4.71GB
发布时间: 2012-03-07

ed2k://|file|cn_sql_server_2012_enterprise_edition_x86_x64_dvd_813295.iso|5054384128|BC78EFDC4005C44F80D88E54251D4025|/

WIN10装数据库总结：（① 关闭杀毒软件、② 管理员运行、③ 账户选择 NETWORK SERVER--代理和引擎、④ 添加Everyone全部权限）

商贸版连接问题：https://club.kingdee.com/forum.php?mod=viewthread&tid=1394056

相关热词搜索：

上一篇：金蝶KIS专业版功能清单
下一篇：金蝶KIS商贸版--功能概述

分享到：

金蝶专业版常用SQL脚本
2019-09-26 09:57:52 来源：评论：0 点击：

频道总排行

频道本月排行

金蝶专业版常用SQL脚本 2019-09-26 09:57:52 来源： 评论：0 点击：

频道总排行

频道本月排行

金蝶专业版常用SQL脚本
2019-09-26 09:57:52 来源：评论：0 点击：