sal.sql

用友系统二次开发 存货管理 客户管理 订货审核 退货审核 铺货计划 调货计划

INSERT INTO InventoryBarCodeSet 
(cInvCode, cBarCode, cRuleId, cAssignId, cInvName, cInvCCode, cInvCName, cFree1, cFree2) 
DELETE FROM ItemAllotAnalysis
WHERE fchrID IN (SELECT ItemAllotAnalysis.fchrID
		   FROM ItemAllotAnalysis INNER JOIN Item ON ItemAllotAnalysis.fchrItemID = Item.fchrItemID FULL OUTER JOIN
	 OPENDATASOURCE ('SQLOLEDB','SERVER=erpserver1;UID=sa;PWD=11111;DATABASE=UFSOFT_U8_Retail' ).UFDATA_168_2008.dbo._PM_V_InventoryColorSize
	    		       UF_DATA ON Item.fchrItemCode = UF_DATA.cInvCode AND ItemAllotAnalysis.fchrValueName = UF_DATA.cFree
	          WHERE (UF_DATA.cInvCode IS NULL))