当前位置: 首页 > news >正文

柳编网站建设意义百度热榜

柳编网站建设意义,百度热榜,北京建设部网站官网,如何使用万网主机建设网站-- 销售出库单查询 SELECT 销售出库单 AS 单据类型, a.cCode AS 单号, a.dDate AS 日期, a.cMaker AS 制单人, a.cHandler AS 审核人, a.dVeriDate AS 审核日期, b.cInvCode AS 存货编码, b.iQuantity AS 数量, b.cBatch AS 批号, c.…

-- 销售出库单查询
SELECT 
    '销售出库单' AS 单据类型,
    a.cCode AS 单号,
    a.dDate AS 日期,
    a.cMaker AS 制单人,
    a.cHandler AS 审核人,
    a.dVeriDate AS 审核日期,
    b.cInvCode AS 存货编码,
    b.iQuantity AS 数量,
    b.cBatch AS 批号,
    c.cInvSN AS 序列号
FROM 
    rdrecord32 a
JOIN 
    rdrecords32 b ON a.ID = b.ID
JOIN 
    ST_SNDetail_SaleOut c ON b.AutoID = c.iVouchsID
WHERE 
    a.dDate >= '2025-01-01' AND a.dDate <= GETDATE()

UNION ALL

-- 其他出库单查询
SELECT 
    '其他出库单' AS 单据类型,
    main.cCode AS 单号,
    main.dDate AS 日期,
    main.cMaker AS 制单人,
    main.cHandler AS 审核人,
    main.dVeriDate AS 审核日期,
    sub.cInvCode AS 存货编码,
    sub.iQuantity AS 数量,
    sub.cBatch AS 批号,
    sn.cInvSN AS 序列号
FROM 
    RdRecord09 main
JOIN 
    rdrecords09 sub ON main.ID = sub.ID
JOIN 
    ST_SNDetail_OtherOut sn ON sub.AutoID = sn.iVouchsID
WHERE 
    main.dDate >= '2025-01-01' AND main.dDate <= GETDATE()

UNION ALL

-- 采购入库单查询
SELECT 
    '采购入库单' AS 单据类型,
    rdrecord01.cCode AS 单号,
    rdrecord01.dDate AS 日期,
    rdrecord01.cMaker AS 制单人,
    rdrecord01.cHandler AS 审核人,
    rdrecord01.dVeriDate AS 审核日期,
    rdrecords01.cInvCode AS 存货编码,
    rdrecords01.iQuantity AS 数量,
    rdrecords01.cBatch AS 批号,
    ST_SNDetail_PUIN.cInvSN AS 序列号
FROM 
    rdrecord01
JOIN 
    rdrecords01 ON rdrecord01.ID = rdrecords01.ID
LEFT JOIN 
    ST_SNDetail_PUIN ON rdrecords01.AutoID = ST_SNDetail_PUIN.iVouchsID
WHERE 
    rdrecord01.dDate >= '2025-01-01' AND rdrecord01.dDate <= GETDATE()

UNION ALL

-- 材料出库单查询
SELECT 
    '材料出库单' AS 单据类型,
    r11.cCode AS 单号,
    r11.dDate AS 日期,
    r11.cMaker AS 制单人,
    r11.cHandler AS 审核人,
    r11.dVeriDate AS 审核日期,
    rds11.cInvCode AS 存货编码,
    rds11.iQuantity AS 数量,
    rds11.cBatch AS 批号,
    sndmo.cInvSN AS 序列号
FROM 
    rdrecord11 r11
LEFT JOIN 
    rdrecords11 rds11 ON r11.ID = rds11.ID
LEFT JOIN 
    ST_SNDetail_MaOut sndmo ON rds11.AutoID = sndmo.iVouchsID
WHERE 
    r11.dDate >= '2025-01-01' AND r11.dDate <= GETDATE()

UNION ALL

-- 产成品入库单查询
SELECT 
    '产成品入库单' AS 单据类型,
    recordinlist.ccode AS 单号,
    recordinlist.ddate AS 日期,
    recordinlist.cmaker AS 制单人,
    recordinlist.chandler AS 审核人,
    recordinlist.dveridate AS 审核日期,
    recordinlist.cinvcode AS 存货编码,
    recordinlist.iquantity AS 数量,
    recordinlist.cbatch AS 批号,
    ST_SNDetail_PROIN.cInvSN AS 序列号
FROM 
    recordinlist WITH (NOLOCK)
LEFT JOIN 
    ST_SNDetail_PROIN ON ST_SNDetail_PROIN.iVouchsID = recordinlist.autoid
WHERE 
    recordinlist.ddate >= '2025-01-01' AND recordinlist.ddate <= GETDATE()

UNION ALL

-- 其他入库单查询
SELECT 
    '其他入库单' AS 单据类型,
    rdrecord08.cCode AS 单号,
    rdrecord08.dDate AS 日期,
    rdrecord08.cMaker AS 制单人,
    rdrecord08.cHandler AS 审核人,
    rdrecord08.dVeriDate AS 审核日期,
    rdrecords08.cInvCode AS 存货编码,
    rdrecords08.iQuantity AS 数量,
    rdrecords08.cBatch AS 批号,
    ST_SNDetail_OtherIN.cInvSN AS 序列号
FROM 
    rdrecord08
JOIN 
    rdrecords08 ON rdrecord08.ID = rdrecords08.ID
LEFT JOIN 
    ST_SNDetail_OtherIN ON rdrecords08.AutoID = ST_SNDetail_OtherIN.iVouchsID
WHERE 
    rdrecord08.dDate >= '2025-01-01' AND rdrecord08.dDate <= GETDATE();

http://www.cadmedia.cn/news/1999.html

相关文章:

  • 济南香港国际网站建设百度提交收录入口
  • 哈尔滨房地产网站建设入门seo技术教程
  • 粘合剂东莞网站建设重庆百度推广开户
  • 企业网站推广服务协议百度点击工具
  • 设计教学网站推荐简阳seo排名优化课程
  • 湖南旅游最新seo视频教程
  • 网站建设微信公众号文章如何进行搜索引擎优化
  • 广州网站设计哪里好营销策划的十个步骤
  • 网站建设干货图书厦门网站设计公司
  • 电脑网络太原关键词优化公司
  • 信用网站建设招标书西安网站建设维护
  • 婚礼摄影作品网站公众号推广渠道
  • 温江区规划建设局网站品牌营销理论
  • 郴州新网招聘手机版seo优化内页排名
  • 青岛网站建设方案公司企业内训机构
  • 如何把网站排名做的靠前优化大师免费版
  • 寿光建设网站软件制作
  • 税务门户网站建设方案国际局势最新消息今天
  • 在建设厅网站怎么办建造师延期网站上不去首页seo要怎么办
  • 注册网站填写不了地区搜狗收录提交
  • 艾臣网站建设网络营销策划方案ppt
  • 网站内做全文搜索注册网站需要多少钱?
  • 建设银行义乌分行网站seo公司排行
  • 网站建设中 gif福州短视频seo平台
  • 即墨网站建设招聘视频优化是什么意思
  • 网站建设是永久性的吗永久免费客服系统软件
  • 酒店网站的建设方案足球世界排名前十
  • 庆阳网站设计 贝壳下拉长沙网站关键词排名公司
  • 没有限制的国外搜索引擎重庆seo排名优化
  • 今天国际新闻最新消息厦门seo小谢