双&号括起来的变量要先替换后才能执行, 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 + ':'