随笔分类 - 存货核算

存货核算相关记录

摘要：--投料及生产耗用包材 select a.月,a.年,a.一类编码 as 父项一类编码,a.存货一类 as 父项存货一类,a.大类编码 as 父项大类编码,a.存货大类 as 父项存货大类,a.分类编码 as 父项分类编码,a.存货分类 as 父项存货分类,a.存货编码 as 父项存货编码,a.存货阅读全文

posted @ 2022-08-29 11:37 ccode_name 阅读(32) 评论(0) 推荐(0) 编辑

半成品生产领料

摘要：--半成品生产领料select a.月,a.年,a.一类编码,a.存货一类,a.大类编码 as 父项大类编码,a.存货大类 as 父项存货大类,a.分类编码 as 父项分类编码,a.存货分类 as 父项存货分类,a.存货编码 as 父项存货编码,a.存货名称 as 父项存货名称,a.规格型号 as 阅读全文

posted @ 2022-08-24 09:55 ccode_name 阅读(37) 评论(0) 推荐(0) 编辑

收发存汇总表

摘要：--收发存汇总表 select ia.iYear as 年,ia.iMonth as 月,ia.cWhCode as 仓库编码,war.cWhName as 仓库,ia.cInvCode as 存货编码,invc.cInvCName as 存货分类,inv.cInvName as 存货名称,inv. 阅读全文

posted @ 2022-08-24 09:22 ccode_name 阅读(136) 评论(0) 推荐(0) 编辑