金蝶k3wise 核算项目、辅助资料

最新推荐文章于 2022-08-01 13:41:18 发布

landv

最新推荐文章于 2022-08-01 13:41:18 发布

阅读量845

点赞数

分类专栏：历史笔记

本文链接：https://blog.csdn.net/qq_30895047/article/details/103829037

版权

历史笔记专栏收录该内容

514 篇文章 12 订阅

订阅专栏

金蝶k3wise 核算项目、辅助资料

----核算项目信息
select * from t_ItemClass  
----核算项目字段信息
select * from t_ItemPropDesc where FItemClassID= 1  
update t_ItemPropDesc set FViewMask=8 where FName='城市' and FItemClassID=1 --锁定字段
----核算项目内容表
select * from t_Item where FItemClassID=1
select * from t_Organization    --FItemClassID = 1 
select * from t_Department        --FItemClassID = 2 
select * from t_Emp                --FItemClassID = 3 
select * from t_ICItem            --FItemClassID = 4 
select * from t_Stock            --FItemClassID = 5 
select * from t_Exp                --FItemClassID = 6 
select * from t_MeasureUnit        --FItemClassID = 7 
select * from t_Supplier        --FItemClassID = 8 
select * from cbCostObj            --FItemClassID = 2011 
select * from t_WorkCenter        --FItemClassID = 14 

---辅助资料
select * from t_SubMesType  ---
select * from t_SubMessage where FTypeID = 20


select * from t_Identity  
--单据最大内码
select * from ICMaxNum where FTableName like '%icstockbill%'