/* 这里写 初始化的数据 */


-- 初始化  编号 【Editby shaocx,2023-08-18】
	DELETE wms_config_serial_rule where SerialType =10;
	GO
	
		INSERT INTO dbo.wms_config_serial_rule
(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete)
VALUES(10, N'1', 10, 1, N'UD', 15, 0, 1, N'UndoStoRec', 0, N'测试编号编号-前缀', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO dbo.wms_config_serial_rule
(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete)
VALUES(11, N'1', 10, 2, N'Y4', 4, 0, 1, NULL, 0, N'测试编号编号-年份', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO dbo.wms_config_serial_rule
(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete)
VALUES(12, N'1', 10, 3, N'M2', 4, 0, 1, NULL, 0, N'测试编号编号-月份', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO dbo.wms_config_serial_rule
(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete)
VALUES(13, N'1', 10, 4, N'D2', 4, 0, 1, NULL, 0, N'测试编号编号-日', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO dbo.wms_config_serial_rule
(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete)
VALUES(14, N'1', 10, 5, N'SN', 3, 0, 1, NULL, 0, N'测试编号编号-流水号', NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);


-- 初始化  替代品编号 【Editby liuwq,2024-04-25】
	DELETE wms_config_serial_rule where SerialType =20;
	GO
	
		INSERT INTO dbo.wms_config_serial_rule
(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete)
VALUES(20, N'1', 20, 1, N'UD', 15, 0, 1, N'SG', 0, N'替代品编号-前缀', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO dbo.wms_config_serial_rule
(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete)
VALUES(21, N'1', 20, 2, N'Y4', 4, 0, 1, NULL, 0, N'替代品编号-年份', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO dbo.wms_config_serial_rule
(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete)
VALUES(22, N'1', 20, 3, N'M2', 4, 0, 1, NULL, 0, N'替代品编号-月份', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO dbo.wms_config_serial_rule
(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete)
VALUES(23, N'1', 20, 4, N'D2', 4, 0, 1, NULL, 0, N'替代品编号-日', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO dbo.wms_config_serial_rule
(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete)
VALUES(24, N'1', 20, 5, N'SN', 3, 0, 1, NULL, 0, N'替代品编号-流水号', NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);



-- 初始化  控制属性规则编号 【Editby liuwq,2024-04-25】
	DELETE wms_config_serial_rule where SerialType =30;
	GO
	
		INSERT INTO dbo.wms_config_serial_rule
(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete)
VALUES(30, N'1', 30, 1, N'UD', 15, 0, 1, N'CR', 0, N'控制属性规则编号-前缀', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO dbo.wms_config_serial_rule
(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete)
VALUES(31, N'1', 30, 2, N'Y4', 4, 0, 1, NULL, 0, N'控制属性规则编号-年份', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO dbo.wms_config_serial_rule
(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete)
VALUES(32, N'1', 30, 3, N'M2', 4, 0, 1, NULL, 0, N'控制属性规则编号-月份', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO dbo.wms_config_serial_rule
(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete)
VALUES(33, N'1', 30, 4, N'D2', 4, 0, 1, NULL, 0, N'控制属性规则编号-日', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO dbo.wms_config_serial_rule
(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete)
VALUES(34, N'1', 30, 5, N'SN', 3, 0, 1, NULL, 0, N'控制属性规则编号-流水号', NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);



-- 初始化  ASN单号 【Editby liuwq,2024-06-24】
	DELETE wms_config_serial_rule where SerialType =40;
	GO
	
		INSERT INTO dbo.wms_config_serial_rule
(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete)
VALUES(40, N'1', 40, 1, N'UD', 15, 0, 1, N'ASN', 0, N'ASN单号-前缀', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
		INSERT INTO dbo.wms_config_serial_rule
(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete)
VALUES(41, N'1', 40, 2, N'BT', 15, 0, 1, N'101', 0, N'业务类型-采购收货', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO dbo.wms_config_serial_rule
(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete)
VALUES(42, N'1', 40, 3, N'Y4', 4, 0, 1, NULL, 0, N'ASN单号-年份', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO dbo.wms_config_serial_rule
(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete)
VALUES(43, N'1', 40, 4, N'M2', 4, 0, 1, NULL, 0, N'ASN单号-月份', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO dbo.wms_config_serial_rule
(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete)
VALUES(44, N'1', 40, 5, N'D2', 4, 0, 1, NULL, 0, N'ASN单号-日', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO dbo.wms_config_serial_rule
(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete)
VALUES(45, N'1', 40, 6, N'SN', 4, 0, 1, NULL, 0, N'ASN单号-流水号', NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);




-- 初始化  上架单号 【Editby liuwq,2024-06-24】
	DELETE wms_config_serial_rule where SerialType =50;
	GO
	
		INSERT INTO dbo.wms_config_serial_rule
(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete)
VALUES(50, N'1', 50, 1, N'UD', 15, 0, 1, N'MOVE', 0, N'上架单号-前缀', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
		INSERT INTO dbo.wms_config_serial_rule
(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete)
VALUES(51, N'1', 50, 2, N'BT', 15, 0, 1, N'301', 0, N'业务类型-组盘上架', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO dbo.wms_config_serial_rule
(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete)
VALUES(52, N'1', 50, 3, N'Y4', 4, 0, 1, NULL, 0, N'上架单号-年份', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO dbo.wms_config_serial_rule
(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete)
VALUES(53, N'1', 50, 4, N'M2', 4, 0, 1, NULL, 0, N'上架单号-月份', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO dbo.wms_config_serial_rule
(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete)
VALUES(54, N'1', 50, 5, N'D2', 4, 0, 1, NULL, 0, N'上架单号-日', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO dbo.wms_config_serial_rule
(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete)
VALUES(55, N'1', 50, 6, N'SN', 4, 0, 1, NULL, 0, N'上架单号-流水号', NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);




-- 初始化  下架单号 【Editby liuwq,2024-06-24】
	DELETE wms_config_serial_rule where SerialType =60;
	GO
	
		INSERT INTO dbo.wms_config_serial_rule
(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete)
VALUES(60, N'1', 60, 1, N'UD', 15, 0, 1, N'MOVE', 0, N'下架单号-前缀', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
		INSERT INTO dbo.wms_config_serial_rule
(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete)
VALUES(61, N'1', 60, 2, N'BT', 15, 0, 1, N'201', 0, N'业务类型-组盘上架', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO dbo.wms_config_serial_rule
(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete)
VALUES(62, N'1', 60, 3, N'Y4', 4, 0, 1, NULL, 0, N'下架单号-年份', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO dbo.wms_config_serial_rule
(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete)
VALUES(63, N'1', 60, 4, N'M2', 4, 0, 1, NULL, 0, N'下架单号-月份', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO dbo.wms_config_serial_rule
(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete)
VALUES(64, N'1', 60, 5, N'D2', 4, 0, 1, NULL, 0, N'下架单号-日', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO dbo.wms_config_serial_rule
(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete)
VALUES(65, N'1', 60, 6, N'SN', 4, 0, 1, NULL, 0, N'下架单号-流水号', NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);



-- 初始化  报检单号 【Editby liuwq,2024-06-24】
	DELETE wms_config_serial_rule where SerialType =70;
	GO
	
		INSERT INTO dbo.wms_config_serial_rule
(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete)
VALUES(70, N'1', 70, 1, N'UD', 15, 0, 1, N'QC', 0, N'报检单号-前缀', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
		INSERT INTO dbo.wms_config_serial_rule
(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete)
VALUES(71, N'1', 70, 2, N'BT', 15, 0, 1, N'401', 0, N'业务类型-进料检验', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO dbo.wms_config_serial_rule
(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete)
VALUES(72, N'1', 70, 3, N'Y4', 4, 0, 1, NULL, 0, N'报检单号-年份', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO dbo.wms_config_serial_rule
(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete)
VALUES(73, N'1', 70, 4, N'M2', 4, 0, 1, NULL, 0, N'报检单号-月份', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO dbo.wms_config_serial_rule
(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete)
VALUES(74, N'1', 70, 5, N'D2', 4, 0, 1, NULL, 0, N'报检单号-日', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO dbo.wms_config_serial_rule
(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete)
VALUES(75, N'1', 70, 6, N'SN', 4, 0, 1, NULL, 0, N'报检单号-流水号', NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);





DELETE wms_sys_basic_data where BasicDataType='1';
INSERT INTO wms_sys_basic_data(
 [Id], 
 [BasicDataType],
 [BasicDataValue],
 [BasicDataUnit],
 [OperationRemark],
 [CreateUserName],
 [CreateTime],
 [UpdateUserName],
 [UpdateTime],
 [IsDelete]
)
VALUES
	(
	    '576489124704338',
		'1', -- 调度系统启动相关
		'000000',  -- 有值就代表有机器启动了调度系统 （000000是默认的空值）
		'',
		'调度系统启动相关',
		'sys',
		getdate(),
		'sys',
		getdate(),
		0
	);