用友U8产成品入库单序列号SQL语句查询

用友U8产成品入库单序列号SQL语句查询"/>

用友U8产成品入库单序列号SQL语句查询

CREATE VIEW cprkxlhcx_zd AS --产成品入库序列号查询

SELECT recordinlist.autoid ,

ST_SNDetail_PROIN.iVouchsID ,

recordinlist.cwhcode AS 仓库 ,

recordinlist.cwhname AS 仓库名称 ,

recordinlist.cdepname AS 部门 ,

recordinlist.crdname AS 入库类别 ,

recordinlist.csource AS 单据来源 ,

recordinlist.cmpocode AS 项目编码 ,

recordinlist.cinvcode AS 存货编码 ,

recordinlist.cinvaddcode AS 产品代码 ,

recordinlist.cinvname AS 存货名称 ,

recordinlist.cinvstd AS 规格型号 ,

recordinlist.cinvm_unit AS 单位 ,

recordinlist.cbatch AS 批号 ,

recordinlist.iquantity AS 数量 ,

recordinlist.cmpocode AS 生产订单号 ,

recordinlist.imoseq AS 生产订单行号 ,

recordinlist.ddate AS 入库日期 ,

recordinlistode AS 入库单号 ,

recordinlist.cmemo AS 备注 ,

recordinlist.irowno AS 行号 ,

recordinlist.cmaker AS 制单人 ,

recordinlist.chandler AS 审核人 ,

recordinlist.dveridate AS 审核日期 ,

recordinlist.cbmemo A