技巧集锦033：0价发票登记的问题

SELECT * FROM INVOICEMT WHERE InvoiceCode='03017736'

SELECT * FROM INVOICEDT WHERE EntId ='E2SVHJM7RVQ' AND BillNo =1485
SELECT * FROM INVOICEBILL WHERE EntId ='E2SVHJM7RVQ' AND BillNo =1485


INSERT INTO INVOICEDT
            (BillNo,EntId,BillSn,BillSort,GoodsId,PackId,Meas,AngleId,Num,Price,Taxprice,BaseNum,DedRate,Amount,Rate,Tax,TaxAmount,jiesje,IsSettle,RfBillNo,RfBillSn,unit)


--SELECT * FROM INVOICEDT WHERE EntId ='E2SVHJM7RVQ' AND BillNo =1485
--UNION ALL 
SELECT 1485 AS BillNo,EntId,2 AS BillSn,2 AS BillSort,GoodsId,PackId,Meas,AngleId,Num,Price,Taxprice,BaseNum,DedRate,Amount,Rate,Tax,TaxAmount,0.00 AS jiesje,'N'IsSettle,BillNo AS RfBillNo,BillSn AS RfBillSn,unit
FROM PURINDT
WHERE EntId ='E2SVHJM7RVQ' AND billno =1363


INSERT INTO INVOICEBILL
            (BillNo,BillSn,EntId,BillSort,BillAmt,TaxAmount,Amount,Tax,RfBillNo,RfBillCode,Summaries,RfRuleId,Dates,DeptId,SaleManId)

 

SELECT 1485 AS BillNo,2 AS BillSn,EntId,2 AS BillSort,TaxAmount AS BillAmt,TaxAmount,Amount,Tax,BillNo AS RfBillNo,'PRKGSK00000253' AS RfBillCode,'采购入库单' AS Summaries,'12ealvx84t7bl04x' AS RfRuleId,'2019-12-05' AS Dates,'K2SWWP9OKGQ' AS DeptId,'K2SWXGMTJOM' AS SaleManId
FROM PURINDT
WHERE EntId ='E2SVHJM7RVQ' AND billno =1363

SELECT RuleId,Dates,DeptId,SaleManId,* FROM PURINMT WHERE EntId ='E2SVHJM7RVQ' AND BillNo = 1363