bos过磅导出.sql

这是一个基于金蝶K/3的磅秤插件源代码。安装本差价需要金蝶K/310.0以上的版本。本插件是客户端程序。在车辆过磅时自动产生金蝶K/3的出库单。

GO

INSERT INTO ICClassTableInfo(FClassTypeID,FPage,FCaption_CHS,FCaption_CHT,FCaption_EN,FKey,FFieldName,FTableName,FTableNameAs,FListIndex,FListClassName,FVisible,FEnable,FNeedSave,FMustInput,FCtlType,FProperty,FLookUpType,FLookUpClassID,FLookUpList,FSRCFieldName,FSRCTableName,FSRCTableNameAs,FDSPFieldName,FFNDFieldName,FValueLocation,FFilter,FFilterGroup,FValueType,FDspColType,FEditlen,FValuePrecision,FSaveRule,FDefValue,FAction,FUserDefine,FNote,FKeyWord,FLeft,FTop,FHeight,FWidth,FCondition,FTabIndex,FLock,FSum,FPrec,FScale,FLayer,FLoadAction,FUnControl,FFont,FSourceType,FSubKey,FParentKey,FConditionExt,FFrameBorder,FFrameBorderColor,FLabelWidth,FLabelColor,FTextColor,FIsF7) 
VALUES (200000000,2,'客户','客户','客户','FKeHu','FKeHu','t_NHG_CheLiangJingChangEntry','',103,0,-1,0,1,0,1,'',1,1,'','FItemID','t_Organization','','FName','FNumber',1,'','',56,500,255,4,'','','',1,'','',5158,7738,346,1620,'0',5,0,0,0,10,0,'',16,'',1,'','',0,0,0,0,0,0,0) 
GO

INSERT INTO ICClassTableInfo(FClassTypeID,FPage,FCaption_CHS,FCaption_CHT,FCaption_EN,FKey,FFieldName,FTableName,FTableNameAs,FListIndex,FListClassName,FVisible,FEnable,FNeedSave,FMustInput,FCtlType,FProperty,FLookUpType,FLookUpClassID,FLookUpList,FSRCFieldName,FSRCTableName,FSRCTableNameAs,FDSPFieldName,FFNDFieldName,FValueLocation,FFilter,FFilterGroup,FValueType,FDspColType,FEditlen,FValuePrecision,FSaveRule,FDefValue,FAction,FUserDefine,FNote,FKeyWord,FLeft,FTop,FHeight,FWidth,FCondition,FTabIndex,FLock,FSum,FPrec,FScale,FLayer,FLoadAction,FUnControl,FFont,FSourceType,FSubKey,FParentKey,FConditionExt,FFrameBorder,FFrameBorderColor,FLabelWidth,FLabelColor,FTextColor,FIsF7) 
VALUES (200000000,2,'皮重','小數','Decimal Fraction','FPiZhong','FPiZhong','t_NHG_CheLiangJingChangEntry','',103,0,-1,0,1,0,2,'',0,0,'','','','','','',1,'','',106,9,20,13,'','','',1,'','',0,0,350,1275,'1',6,0,1,28,3,0,'',16,'',0,'','',0,0,0,0,0,0,0) 
GO

INSERT INTO ICClassTableInfo(FClassTypeID,FPage,FCaption_CHS,FCaption_CHT,FCaption_EN,FKey,FFieldName,FTableName,FTableNameAs,FListIndex,FListClassName,FVisible,FEnable,FNeedSave,FMustInput,FCtlType,FProperty,FLookUpType,FLookUpClassID,FLookUpList,FSRCFieldName,FSRCTableName,FSRCTableNameAs,FDSPFieldName,FFNDFieldName,FValueLocation,FFilter,FFilterGroup,FValueType,FDspColType,FEditlen,FValuePrecision,FSaveRule,FDefValue,FAction,FUserDefine,FNote,FKeyWord,FLeft,FTop,FHeight,FWidth,FCondition,FTabIndex,FLock,FSum,FPrec,FScale,FLayer,FLoadAction,FUnControl,FFont,FSourceType,FSubKey,FParentKey,FConditionExt,FFrameBorder,FFrameBorderColor,FLabelWidth,FLabelColor,FTextColor,FIsF7) 
VALUES (200000000,2,'进厂时间','長日期','Long date','FJingChangShiJian','FJingChangShiJian','t_NHG_CheLiangJingChangEntry','',103,0,-1,0,1,0,0,'',0,0,'','','','','','',0,'','',61,502,50,8,'','','',1,'','',0,0,0,1380,'2',7,0,0,0,0,0,'',55,'',13,'','',0,0,0,0,0,0,0) 
GO

INSERT INTO ICClassTableInfo(FClassTypeID,FPage,FCaption_CHS,FCaption_CHT,FCaption_EN,FKey,FFieldName,FTableName,FTableNameAs,FListIndex,FListClassName,FVisible,FEnable,FNeedSave,FMustInput,FCtlType,FProperty,FLookUpType,FLookUpClassID,FLookUpList,FSRCFieldName,FSRCTableName,FSRCTableNameAs,FDSPFieldName,FFNDFieldName,FValueLocation,FFilter,FFilterGroup,FValueType,FDspColType,FEditlen,FValuePrecision,FSaveRule,FDefValue,FAction,FUserDefine,FNote,FKeyWord,FLeft,FTop,FHeight,FWidth,FCondition,FTabIndex,FLock,FSum,FPrec,FScale,FLayer,FLoadAction,FUnControl,FFont,FSourceType,FSubKey,FParentKey,FConditionExt,FFrameBorder,FFrameBorderColor,FLabelWidth,FLabelColor,FTextColor,FIsF7) 
VALUES (200000000,2,'皮重钩稽','小數1','Decimal Fraction1','FPiZhongGouJi','FPiZhongGouJi','t_NHG_CheLiangJingChangEntry','',101,0,12,0,1,0,2,'',0,0,'','','','','','',1,'','',106,9,20,13,'','','',1,'','',0,0,350,1455,'1',8,-1,0,28,3,0,'',16,'',0,'','',0,0,0,0,0,0,0) 
GO

INSERT INTO ICClassTableInfo(FClassTypeID,FPage,FCaption_CHS,FCaption_CHT,FCaption_EN,FKey,FFieldName,FTableName,FTableNameAs,FListIndex,FListClassName,FVisible,FEnable,FNeedSave,FMustInput,FCtlType,FProperty,FLookUpType,FLookUpClassID,FLookUpList,FSRCFieldName,FSRCTableName,FSRCTableNameAs,FDSPFieldName,FFNDFieldName,FValueLocation,FFilter,FFilterGroup,FValueType,FDspColType,FEditlen,FValuePrecision,FSaveRule,FDefValue,FAction,FUserDefine,FNote,FKeyWord,FLeft,FTop,FHeight,FWidth,FCondition,FTabIndex,FLock,FSum,FPrec,FScale,FLayer,FLoadAction,FUnControl,FFont,FSourceType,FSubKey,FParentKey,FConditionExt,FFrameBorder,FFrameBorderColor,FLabelWidth,FLabelColor,FTextColor,FIsF7) 
VALUES (200000000,2,'关闭字段','整數','Integer','FGuanBi','FGuanBi','t_NHG_CheLiangJingChangEntry','',101,0,12,0,1,0,3,'',0,0,'','','','','','',1,'','',56,10,10,4,'','','',1,'','',0,0,350,1230,'1',9,-1,0,0,0,0,'',16,'',0,'','',0,0,0,0,0,0,0) 
GO

/****** Object:Data   单据编号：ICBillNo    Script Date: 2006-07-17 ******/

if not exists (SELECT * FROM  ICBillNo WHERE FBillID=200000000) 
begin 
  INSERT INTO ICBillNo(FBillID,FBillName,FPreLetter,FSufLetter,FCurNo,FBillName_CHT,FBillName_EN,FFormat,FPos,FCanAlterBillNo,FCheckAfterSave,FUseBillCodeRule,FDesc) 
  VALUES (200000000,'成品车辆进厂登记单_BOS',NULL,NULL,6,'單據200000000_BOS','Doc200000000_BOS','00000000',200000000,0,0,1,'00000006') 
end 

GO

/****** Object:Data   单据权限类弄表：t_ObjectAccessType    Script Date: 2006-07-17 ******/

Delete t_ObjectAccessType WHERE FObjectType=4100 And FObjectID =200000000
GO
INSERT INTO t_ObjectAccessType(FObjectType,FObjectID,FIndex,FAccessMask,FAccessUse,FName,FDescription,FName_cht,FName_en,FDescription_cht,FDescription_en) 
VALUES (4100,200000000,1,2097152,1048576,'查看','查看','查看','Search','查看','Search') 
GO

INSERT INTO t_ObjectAccessType(FObjectType,FObjectID,FIndex,FAccessMask,FAccessUse,FName,FDescription,FName_cht,FName_en,FDescription_cht,FDescription_en) 
VALUES (4100,200000000,2,131072,3145728,'新增','新增','新增','New','新增','New') 
GO

INSERT INTO t_ObjectAccessType(FObjectType,FObjectID,FIndex,FAccessMask,FAccessUse,FName,FDescription,FName_cht,FName_en,FDescription_cht,FDescription_en) 
VALUES (4100,200000000,3,65536,3145728,'删除','删除','刪除','Del.','刪除','Del.') 
GO

INSERT INTO t_ObjectAccessType(FObjectType,FObjectID,FIndex,FAccessMask,FAccessUse,FName,FDescription,FName_cht,FName_en,FDescription_cht,FDescription_en) 
VALUES (4100,200000000,4,4194304,3145728,'修改','修改','修改','Edit','修改','Edit') 
GO

INSERT INTO t_ObjectAccessType(FObjectType,FObjectID,FIndex,FAccessMask,FAccessUse,FName,FDescription,FName_cht,FName_en,FDescription_cht,FDescription_en) 
VALUES (4100,200000000,5,16,3145728,'引出内部数据','引出内部数据','引出內部資料','Exp Internal Data','引出內部資料','Exp Internal Data') 
GO

INSERT INTO t_ObjectAccessType(FObjectType,FObjectID,FIndex,FAccessMask,FAccessUse,FName,FDescription,FName_cht,FName_en,FDescription_cht,FDescription_en) 
VALUES (4100,200000000,6,32768,3145728,'打印','打印','列印','Print','列印','Print') 
GO

INSERT INTO t_ObjectAccessType(FObjectType,FObjectID,FIndex,FAccessMask,FAccessUse,FName,FDescription,FName_cht,FName_en,FDescription_cht,FDescription_en) 
VALUES (4100,200000000,7,64,3145728,'禁用','禁用','禁用','Disable','禁用','Disable') 
GO

/****** Object:Data   单据权限对象表：t_ObjectType    Script Date: 2006-07-17 ******/

Delete t_ObjectType WHERE FObjectType=4100 And FObjectID =200000000
GO
INSERT INTO t_ObjectType(FObjectType,FObjectID,FName,FDescription,FName_cht,FName_en,FDescription_cht,FDescription_en) 
VALUES (4100,200000000,'成品车辆进厂登记单',NULL,'單據200000000','Doc200000000',NULL,NULL) 
GO

/****** Object:Data   单据权限表：t_ObjectAccess    Script Date: 2006-07-17 ******/

Delete t_ObjectAccess WHERE FObjectType=4100 And FObjectID =200000000
GO
INSERT INTO t_ObjectAccess(FGroupID,FObjectType,FObjectID,FIndex) 
VALUES (2101,4100,200000000,0) 
GO

INSERT INTO t_ObjectAccess(FGroupID,FObjectType,FObjectID,FIndex) 
VALUES (2101,4100,200000000,1) 
GO

INSERT INTO t_ObjectAccess(FGroupID,FObjectType,FObjectID,FIndex) 
VALUES (2102,4100,200000000,0) 
GO

INSERT INTO t_ObjectAccess(FGroupID,FObjectType,FObjectID,FIndex) 
VALUES (2102,4100,200000000,1) 
GO

INSERT INTO t_ObjectAccess(FGroupID,FObjectType,FObjectID,FIndex) 
VALUES (2102,4100,200000000,2) 
GO

INSERT INTO t_ObjectAccess(FGroupID,FObjectType,FObjectID,FIndex) 
VALUES (2102,4100,200000000,3) 
GO

INSERT INTO t_ObjectAccess