修改金蝶采购订单的默认采购方式

复制代码
/*** 修改 Purchase Order 的默认采购方式  

SELECT * FROM t_SubMessage WHERE FTypeID=162 -- AND FID='PO02' -- FName LIKE '%Drop%' --或者使用名字查询 
SELECT FDefaultValue,FLookUpCls,* FROM dbo.ICTemplate WHERE FID='P02'AND FFieldName = 'FPOStyle'
--UPDATE dbo.ICTemplate SET FDefaultValue='252' WHERE FID='P02'AND FFieldName = 'FPOStyle'
***/

/***修改 customer和supplier 交易默认币种

Query   money type
SELECT t1.FCurrencyID AS FInterID ,t1.FName AS FName ,t1.FNumber AS FNumber,*  FROM t_Currency AS t1  --WHERE t1.FCurrencyID =1000
// change  default money type 
SELECT * FROM ICTemplate WHERE  FFieldName = 'FCurrencyID' 
UPDATE dbo.ICTemplate SET FDefaultValue='1' WHERE  FFieldName = 'FCurrencyID'
// change supplier default money type 
SELECT  FValueAddRate,FCyID,* FROM dbo.t_Supplier 
UPDATE t_Supplier SET FCyID=1 
// change customer default money type 
select FItemID,FCyID,* from t_Organization where FItemID = 10074
UPDATE t_Organization SET FCyID=1
***/

也可以使用金蝶模板编辑工具进行默认值编辑
 
复制代码

 

posted @   shzy2012  阅读(1234)  评论(0编辑  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示