bom_clear.php,⾦蝶KIS专业版常⽤SQL语句
由于结束初始化后很多参数不能在⾦蝶软件⾥直接修改，所以要借助SQL查询分析器。黄自
1.允许负库存
洗空调
Update t_systemprofile Set FValue=0 where FCategory='IC' And FKey='UnderStock'
Fvalue = 1 不允许负库存
Fvalue = 0 允许负库存
2.库存更新控制
Update t_systemprofile t FValue=0 where FCategory='IC' and FKey='UPSTOCKWHENSAVE'
Fvalue = 0 单据审核后更新
Fvalue = 1 单据保存后更新
孔子儿子*****************************************************************************
*****************************************************************************
⼀客户新建⽴帐套，录⼊物料及数量后，代码作⼤的变更，需要重新导过，因为其他系统正常，就采⽤了删除物料，重新导⼊的⽅法：1.删除仓库数据，
若启⽤了业务系统，删除delete from icbal
若没有启⽤业务系统，删除delete from IcInvbal
2.删除BOM表机械制图基础知识入门
delete from ICbomChild
文成公主delete from Icbom
delete from ICBomgroup
3.删除物料；
知为要删除物料，先删除附属信息表。
lect * from t_icitemba where fitemid in (lect Fitemid from t_item where fitemclassid=4)
delete from t_icitemba where fitemid in (lect Fitemid from t_item where fitemclassid=4)
delete from t_icitemcore where fitemid in (lect Fitemid from t_item where fitemclassid=4)
delete from t_icitemcustom where fitemid in (lect Fitemid from t_item where fitemclassid=4)
delete from t_icitemdesign where fitemid in (lect Fitemid from t_item where fitemclassid=4)
delete from t_icitemmaterial where fitemid in (lect Fitemid from t_item where fitemclassid=4)
delete from t_icitemplan where fitemid in (lect Fitemid from t_item where fitemclassid=4)
delete from t_icitemquality where fitemid in (lect Fitemid from t_item where fitemclassid=4)
delete from t_icitemstandard where fitemid in (lect 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_FAExpen
delete from t_FAClear
delete from t_faalter --主表
-----删除固定资产表
交的组词delete from t_FABalCardItem
(责任编辑：admin)
