DECLARE @ORPD_ID NVARCHAR(50)
SET @ORPD_ID=DBO.CREATE_MAX_NUM('ORPD_ID')
INSERT T_ORPD(ORPD_SUPPLERID,ORPD_ID,ORPD_DOCDATE,ORPD_CURRENCY,ORPD_CRATE,ORPD_SYS,ORPD_SYSDATE,ORPD_DATE2,ORPD_TYPE)
SELECT LHJY_SUPID,@ORPD_ID,CONVERT(VARCHAR(10), GETDATE(), 120),'RMB',1,LHJY_IQCMAN,GETDATE(),GETDATE(),'01'
FROM INSERTED
INNER JOIN USR_LHJY_D ON LHJY_ID=HJY1_ID
WHERE HJY1_MOVEBACK <> 0
INSERT T_ORPD_D(RPD1_ID,RPD1_ITEMCODE,RPD1_BASENO,RPD1_QUANTITY,RPD1_WHSCODE,RPD1_FJFY,RPD1_TOTALFJ,RPD1_WQTY,RPD1_WS,RPD1_PRICE,RPD1_BASELINE,RPD1_PONUM,RPD1_POID,RPD1_UNRECEIVE,RPD1_THYY)
SELECT @ORPD_ID,HJY1_ITEMCODE,HJY1_ID,HJY1_MOVEBACK,HYJ1_WHSCODE,0,0,HJY1_YQTHZL, HJY1_WS,PDN1_PRICE,HJY1_NUM,PDN1_BASELINE,PDN1_BASENO,HJY1_MOVEBACK,HJY1_THYY
FROM INSERTED INNER JOIN USR_LHJY_D ON LHJY_ID=HJY1_ID
INNER JOIN USR_MATRIAL ON HJY1_ITEMCODE=MTR_NO
INNER JOIN T_OPDN_D ON HJY1_OPDNNUM=PDN1_NUM
WHERE HJY1_MOVEBACK <> 0
最新发布