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

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

SELECT a.BillDate AS FDate, MAX(YEAR(a.BillDate)) AS FYear, MAX(MONTH(a.BillDate))
      AS FPeriod, '记' AS FGroupID, '1' AS FNumber, '1291.01' AS FAccountNum,
      '发出商品' AS FAccountName, 'RMB' AS FCurrencyNum, '人民币' AS FCurrencyName,
      - SUM(a.Total) AS FAmountFor, - SUM(a.Total) AS FDebit, 0 AS FCredit,
      '唐艳华' AS FPreparerID, 'NONE' AS FCheckerID, 'NONE' AS FApproveID,
      'NONE' AS FCashierID, '' AS FHandler, '*' AS FSettleTypeID, '' AS FSettleNo,
      MAX(CONVERT(CHAR(10), i.billdate, 23) + ',' + i.BillCode + ',' + LTRIM(STR(a.Qty, 15,
      3)) + '吨；' + i.Comment + '；' + LTRIM(i.explain)) AS FExplanation, 0 AS FQuantity,
      '*' AS FMeasureUnitID, 0 AS FUnitPrice, '' AS FReference, MAX(a.BillDate)
      AS FTransDate, '' AS FTransNo, 0 AS FAttachments, 999 AS FSerialNum,
      '' AS FObjectName, '' AS FParameter, 1 AS FExchangeRate, 0 AS FEntryID,
      MAX('客户---' + LTRIM(b.UserCode) + '---' + LTRIM(b.FullName) + '||部门---' + k.UserCode + '---' + k.FullName ) AS FItem, 0 AS FPosted, '' AS FInternalInd,
      '' AS FCashFlow, k.UserCode AS Expr1, MAX(k.FullName) AS Expr2, b.UserCode,
      MAX(b.FullName) AS Expr3, i.BillCode, 1 AS xh
FROM InOutstocktable a INNER JOIN