管家婆ERP V3Ⅱ生产拆装单生成金蝶财务软件K3 V10.3标准凭证引入的SQL select 查询语句

双&号括起来的变量要先替换后才能执行， left(k.usercode,3)='021'  是限制查询仓库的范围，因为多家母子公司使用一套ERP，所以需要限制只查询某一家公司的数据

SELECT a.BillDate AS FDate, YEAR(a.BillDate) AS FYear, MONTH(a.BillDate) AS FPeriod,
      '记' AS FGroupID, '1' AS FNumber, '1243.02' AS FAccountNum,
      '废纸类商品（项目核算）' AS FAccountName, 'RMB' AS FCurrencyNum,
      '人民币' AS FCurrencyName,
      CASE WHEN a.qty > 0 THEN a.Total ELSE a.total * - 1 END AS FAmountFor,
      CASE WHEN (a.qty) > 0 THEN a.total ELSE 0 END AS FDebit, CASE WHEN (a.qty)
      < 0 THEN a.total ELSE 0 END AS FCredit, '童美华' AS FPreparerID,
      'NONE' AS FCheckerID, 'NONE' AS FApproveID, 'NONE' AS FCashierID,
      '' AS FHandler, '*' AS FSettleTypeID, '' AS FSettleNo,
      i.BillCode + ',' + p.FullName + ':'