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

说明：双&括起来的是变量，执行查询前须换为常量，如： &上日&

SELECT a.BillDate AS FDate, MAX(YEAR(a.BillDate)) AS FYear,
      MAX(MONTH(a.BillDate)) AS FPeriod, '记' AS FGroupID, '1' AS FNumber,
      '1243.02' 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(i.BillCode + ',数量：' + LTRIM(STR(a.Qty, 15, 3))
      + '吨；' + i.Comment + '；' + LTRIM(i.explain)) AS FExplanation, 0 AS FQuantity,
      '*' AS FMeasureUnitID, 0 AS FUnitPr