U6采购入库单表体自动带采购订单号

ksuser

create trigger trigger_rds on rdrecords after insert as
begin
  update a set a.cdefine22= --表体自定义项1
     b.sourcevouchercode from pu_arrbody as b
       inner join rdrecords as a
         on a.iposid=b.iposid
            where a.iposid=b.iposid
end

--需要做到货单

zhanghucupite

最后一行是多余的吧

zhanghucupite

create trigger trigger_rds on rdrecords after insert as
begin
  update a set a.cdefine22= --表体自定义项1
     b.sourcevouchercode from pu_arrbody as b
       inner join rdrecords as a
         on（ a.iposid=b.iposid）