领用出库

/***** SQL Script for Microsoft SQL Server *****/

--Alter Table: SaleOutMt [ 销售业务出库汇总 ] @ 2019-11-08 10:09:59
--New table column(s);
IF NOT EXISTS(SELECT * FROM syscolumns WHERE object_name(id) = 'SaleOutMt' AND name = 'KK_BusinessId')
	ALTER TABLE SaleOutMt ADD KK_BusinessId char(11) NULL DEFAULT '';

DELETE FROM TbStru WHERE upper(TbName) = 'SALEOUTMT' AND upper(FdName) = 'KK_BUSINESSID';
INSERT INTO TbStru (TbName, SortNum, FdName, FdDesc, Is_Null, DefaultValue, Explains, IsDevFld) 
	VALUES ('SaleOutMt', 53, 'KK_BusinessId', '单位ID', 'Y', '', '新增字段，2019-11-08', 'N');
IF NOT EXISTS(SELECT * FROM FldList WHERE FdName = 'KK_BusinessId') 
INSERT INTO FldList (FdName, FdDesc, FdType, FdSize, FdDec, DefaultValue) 
	VALUES ('KK_BusinessId', '单位ID', 'char', 11, 0, '');