dprd_fd.sql

不处的管理软件包

Insert into fd_fields (iID,sName,sCaption,sSourceField,iEntityID,iFieldOption,bPersistent,bIsUsed,sHelpContextID,sTaskID,iEditProp,iDataType,iReferenceType,iRefFldSqc,iQryFldsqc,iLength,iDecimals,bAllowNull,sDefaultValue,iRow,iStartCol,iInputCol,iEndCol,dblLeft,dblWidth,dblInputLeft,dblInputWidth,dblTop,dblHeight,dblMin,dblMax) Values (103,'accdef_name','账户名称','cAccName',1,'0','1','1',Null,Null,'0','1',0,0,2,80,Null,'0',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null)
Insert into fd_fields (iID,sName,sCaption,sSourceField,iEntityID,iFieldOption,bPersistent,bIsUsed,sHelpContextID,sTaskID,iEditProp,iDataType,iReferenceType,iRefFldSqc,iQryFldsqc,iLength,iDecimals,bAllowNull,sDefaultValue,iRow,iStartCol,iInputCol,iEndCol,dblLeft,dblWidth,dblInputLeft,dblInputWidth,dblTop,dblHeight,dblMin,dblMax) Values (104,'open_date','开户日期','dOpenDate',1,'0','1','1',Null,Null,'0','2',2,0,3,10,Null,'0',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null)
Insert into fd_fields (iID,sName,sCaption,sSourceField,iEntityID,iFieldOption,bPersistent,bIsUsed,sHelpContextID,sTaskID,iEditProp,iDataType,iReferenceType,iRefFldSqc,iQryFldsqc,iLength,iDecimals,bAllowNull,sDefaultValue,iRow,iStartCol,iInputCol,iEndCol,dblLeft,dblWidth,dblInputLeft,dblInputWidth,dblTop,dblHeight,dblMin,dblMax) Values (105,'accunit_id','单位ID','accunit_id',1,'0','1','1',Null,Null,'2','9',0,0,0,15,Null,'0',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null)
Insert into fd_fields (iID,sName,sCaption,sSourceField,iEntityID,iFieldOption,bPersistent,bIsUsed,sHelpContextID,sTaskID,iEditProp,iDataType,iReferenceType,iRefFldSqc,iQryFldsqc,iLength,iDecimals,bAllowNull,sDefaultValue,iRow,iStartCol,iInputCol,iEndCol,dblLeft,dblWidth,dblInputLeft,dblInputWidth,dblTop,dblHeight,dblMin,dblMax) Values (106,'accunit_code','单位编码','cUnitCode',1,'0','1','1',Null,Null,'0','1',1,0,4,50,Null,'0',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null)
Insert into fd_fields (iID,sName,sCaption,sSourceField,iEntityID,iFieldOption,bPersistent,bIsUsed,sHelpContextID,sTaskID,iEditProp,iDataType,iReferenceType,iRefFldSqc,iQryFldsqc,iLength,iDecimals,bAllowNull,sDefaultValue,iRow,iStartCol,iInputCol,iEndCol,dblLeft,dblWidth,dblInputLeft,dblInputWidth,dblTop,dblHeight,dblMin,dblMax) Values (107,'irate_id','利率ID','irate_id',1,'0','1','1',Null,Null,'2','9',0,0,0,15,Null,'0',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null)
Insert into fd_fields (iID,sName,sCaption,sSourceField,iEntityID,iFieldOption,bPersistent,bIsUsed,sHelpContextID,sTaskID,iEditProp,iDataType,iReferenceType,iRefFldSqc,iQryFldsqc,iLength,iDecimals,bAllowNull,sDefaultValue,iRow,iStartCol,iInputCol,iEndCol,dblLeft,dblWidth,dblInputLeft,dblInputWidth,dblTop,dblHeight,dblMin,dblMax) Values (108,'irate_code','利率编码','cIntrID',1,'0','1','1',Null,Null,'0','1',0,0,5,50,Null,'0',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null)
Insert into fd_fields (iID,sName,sCaption,sSourceField,iEntityID,iFieldOption,bPersistent,bIsUsed,sHelpContextID,sTaskID,iEditProp,iDataType,iReferenceType,iRefFldSqc,iQryFldsqc,iLength,iDecimals,bAllowNull,sDefaultValue,iRow,iStartCol,iInputCol,iEndCol,dblLeft,dblWidth,dblInputLeft,dblInputWidth,dblTop,dblHeight,dblMin,dblMax) Values (109,'cad_id','结息日ID','cad_id',1,'0','1','1',Null,Null,'2','9',0,0,0,15,Null,'1',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null)
Insert into fd_fields (iID,sName,sCaption,sSourceField,iEntityID,iFieldOption,bPersistent,bIsUsed,sHelpContextID,sTaskID,iEditProp,iDataType,iReferenceType,iRefFldSqc,iQryFldsqc,iLength,iDecimals,bAllowNull,sDefaultValue,iRow,iStartCol,iInputCol,iEndCol,dblLeft,dblWidth,dblInputLeft,dblInputWidth,dblTop,dblHeight,dblMin,dblMax) Values (110,'cad_code','结息日编码','cCadID',1,'0','1','1',Null,Null,'0','1',0,0,6,50,Null,'1',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null)
Insert into fd_fields (iID,sName,sCaption,sSourceField,iEntityID,iFieldOption,bPersistent,bIsUsed,sHelpContextID,sTaskID,iEditProp,iDataType,iReferenceType,iRefFldSqc,iQryFldsqc,iLength,iDecimals,bAllowNull,sDefaultValue,iRow,iStartCol,iInputCol,iEndCol,dblLeft,dblWidth,dblInputLeft,dblInputWidth,dblTop,dblHeight,dblMin,dblMax) Values (111,'accbank','开户银行','cAccBank',1,'0','1','1',Null,Null,'0','1',0,0,7,100,Null,'1',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null)
Insert into fd_fields (iID,sName,sCaption,sSourceField,iEntityID,iFieldOption,bPersistent,bIsUsed,sHelpContextID,sTaskID,iEditProp,iDataType,iReferenceType,iRefFldSqc,iQryFldsqc,iLength,iDecimals,bAllowNull,sDefaultValue,iRow,iStartCol,iInputCol,iEndCol,dblLeft,dblWidth,dblInputLeft,dblInputWidth,dblTop,dblHeight,dblMin,dblMax) Values (112,'qcye_mny','期初余额','mb',1,'0','1','1',Null,Null,'0','3',0,0,8,17,'2','1','0',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null)
Insert into fd_fields (iID,sName,sCaption,sSourceField,iEntityID,iFieldOption,bPersistent,bIsUsed,sHelpContextID,sTaskID,iEditProp,iDataType,iReferenceType,iRefFldSqc,iQryFldsqc,iLength,iDecimals,bAllowNull,sDefaultValue,iRow,iStartCol,iInputCol,iEndCol,dblLeft,dblWidth,dblInputLeft,dblInputWidth,dblTop,dblHeight,dblMin,dblMax) Values (113,'qcjs_mny','期初积数','mh',1,'0','1','1',Null,Null,'0','3',0,0,9,17,'2','1','0',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null)
Insert into fd_fields (iID,sName,sCaption,sSourceField,iEntityID,iFieldOption,bPersistent,bIsUsed,sHelpContextID,sTaskID,iEditProp,iDataType,iReferenceType,iRefFldSqc,iQryFldsqc,iLength,iDecimals,bAllowNull,sDefaultValue,iRow,iStartCol,iInputCol,iEndCol,dblLeft,dblWidth,dblInputLeft,dblInputWidth,dblTop,dblHeight,dblMin,dblMax) Values (114,'qcye_natural_mny','期初本位币余额','qcye_natural_mny',1,'0','1','1',Null,Null,'0','3',0,0,10,17,'2','1','0',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null)
Insert into fd_fields (iID,sName,sCaption,sSourceField,iEntityID,iFieldOption,bPersistent,bIsUsed,sHelpContextID,sTaskID,iEditProp,iDataType,iReferenceType,iRefFldSqc,iQryFldsqc,iLength,iDecimals,bAllowNull,sDefaultValue,iRow,iStartCol,iInputCol,iEndCol,dblLeft,dblWidth,dblInputLeft,dblInputWidth,dblTop,dblHeight,dblMin,dblMax) Values (115,'qcjs_natural_mny','期初本位币积数','qcjs_natural_mny',1,'0','1','1',Null,Null,'0','3',0,0,11,17,'2','1','0',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null)
Insert into fd_fields (iID,sName,sCaption,sSourceField,iEntityID,iFieldOption,bPersistent,bIsUsed,sHelpContextID,sTaskID,iEditProp,iDataType,iReferenceType,iRefFldSqc,iQryFldsqc,iLength,iDecimals,bAllowNull,sDefaultValue,iRow,iStartCol,iInputCol,iEndCol,dblLeft,dblWidth,dblInputLeft,dblInputWidth,dblTop,dblHeight,dblMin,dblMax) Values (116,'datasrc_flag','数据来源','iDataSrc',1,'0','1','1',Null,Null,'0','5',0,0,12,1,Null,'0','0',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null)
Insert into fd_fields (iID,sName,sCaption,sSourceField,iEntityID,iFieldOption,bPersistent,bIsUsed,sHelpContextID,sTaskID,iEditProp,iDataType,iReferenceType,iRefFldSqc,iQryFldsqc,iLength,iDecimals,bAllowNull,sDefaultValue,iRow,iStartCol,iInputCol,iEndCol,dblLeft,dblWidth,dblInputLeft,dblInputWidth,dblTop,dblHeight,dblMin,dblMax) Values (117,'type_flag','账户类型标志','itype',1,'0','1','1',Null,Null,'0','5',0,0,13,1,Null,'0','1',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null)
Insert into fd_fields (iID,sName,sCaption,sSourceField,iEntityID,iFieldOption,bPersistent,bIsUsed,sHelpContextID,sTaskID,iEditProp,iDataType,iReferenceType,iRefFldSqc,iQryFldsqc,iLength,iDecimals,bAllowNull,sDefaultValue,iRow,iStartCol,iInputCol,iEndCol,dblLeft,dblWidth,dblInputLeft,dblInputWidth,dblTop,dblHeight,dblMin,dblMax) Values (118,'io_flag','账户内外部标志','iio',1,'0','1','1',Null,Null,'0','6',0,0,14,1,Null,'0','0',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null)
Insert into fd_fields (iID,sName,sCaption,sSourceField,iEntityID,iFieldOption,bPersistent,bIsUsed,sHelpContextID,sTaskID,iEditProp,iDataType,iReferenceType,iRefFldSqc,iQryFldsqc,iLength,iDecimals,bAllowNull,sDefaultValue,iRow,iStartCol,iInputCol,iEndCol,dblLeft,dblWidth,dblInputLeft,dblInputWidth,dblTop,dblHeight,dblMin,dblMax) Values (119,'yt_flag','预提标志','iYt',1,'0','1','1',Null,Null,'0','6',0,0,15,1,Null,'1',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null)
Insert into fd_fields (iID,sName,sCaption,sSourceField,iEntityID,iFieldOption,bPersistent,bIsUsed,sHelpContextID,sTaskID,iEditProp,iDataType,iReferenceType,iRefFldSqc,iQryFldsqc,iLength,iDecimals,bAllowNull,sDefaultValue,iRow,iStartCol,iInputCol,iEndCol,dblLeft,dblWidth,dblInputLeft,dblInputWidth,dblTop,dblHeight,dblMin,dblMax) Values (120,'yt_cad_id','预提结息日ID','yt_cad_id',1,'0','1','1',Null,Null,'2','9',0,0,0,15,Null,'1',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null)
Insert into fd_fields (iID,sName,sCaption,sSourceField,iEntityID,iFieldOption,bPersistent,bIsUsed,sHelpContextID,sTaskID,iEditProp,iDataType,iReferenceType,iRefFldSqc,iQryFldsqc,iLength,iDecimals,bAllowNull,sDefaultValue,iRow,iStartCol,iInputCol,iEndCol,dblLeft,dblWidth,dblInputLeft,dblInputWidth,dblTop,dblHeight,dblMin,dblMax) Values (121,'yt_cad_code','预提结息日代码','cYtID',1,'0','1','1',Null,Null,'0','1',0,0,16,50,Null,'1',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null)
Insert into fd_fields (iID,sName,sCaption,sSourceField,iEntityID,iFieldOption,bPersistent,bIsUsed,sHelpContextID,sTaskID,iEditProp,iDataType,iReferenceType,iRefFldSqc,iQryFldsqc,iLength,iDecimals,bAllowNull,sDefaultValue,iRow,iStartCol,iInputCol,iEndCol,dblLeft,dblWidth,dblInputLeft,dblInputWidth,dblTop,dblHeight,dblMin,dblMax) Values (122,'ration_mny','定额金额','mqot',1,'0','1','1',Null,Null,'0','3',0,0,0,17,'2','1',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null)
Insert into fd_fields (iID,sName,sCaption,sSourceField,iEntityID,iFieldOption,bPersistent,bIsUsed,sHelpContextID,sTaskID,iEditProp,iDataType,iReferenceType,iRefFldSqc,iQryFldsqc,iLength,iDecimals,bAllowNull,sDefaultValue,iRow,iStartCol,iInputCol,iEndCol,dblLeft,dblWidth,dblInputLeft,dblInputWidth,dblTop,dblHeight,dblMin,dblMax) Values (123,'money_name','币别','cexch_name',1,'0','1','1',Null,Null,'0','1',0,0,17,8,Null,'0',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null)
Insert into fd_fields (iID,sName,sCaption,sSourceField,iEntityID,iFieldOption,bPersistent,bIsUsed,sHelpContextID,sTaskID,iEditProp,iDataType,iReferenceType,iRefFldSqc,iQryFldsqc,iLength,iDecimals,bAllowNull,sDefaultValue,iRow,iStartCol,iInputCol,iEndCol,dblLeft,dblWidth,dblInputLeft,dblInputWidth,dblTop,dblHeight,dblMin,dblMax) Values (124,'deficit_flag','赤字控制','deficit_flag',1,'0','1','1',Null,Null,'0','6',0,0,0,1,Null,'1',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null)
Insert into fd_fields (iID,sName,sCaption,sSourceField,iEntityID,iFieldOption,bPersistent,bIsUsed,sHelpContextID,sTaskID,iEditProp,iDataType,iReferenceType,iRefFldSqc,iQryFldsqc,iLength,iDecimals,bAllowNull,sDefaultValue,iRow,iStartCol,iInputCol,iEndCol,dblLeft,dblWidth,dblInputLeft,dblInputWidth,dblTop,dblHeight,dblMin,dblMax) Values (125,'deficit_mny','赤字金额','deficit_mny',1,'0','1','1',Null,Null,'0','3',0,0,18,17,'2','1',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null)
Insert into fd_fields (iID,sName,sCaption,sSourceField,iEntityID,iFieldOption,bPersistent,bIsUsed,sHelpContextID,sTaskID,iEditProp,iDataType,iReferenceType,iRefFldSqc,iQryFldsqc,iLength,iDecimals,bAllowNull,sDefaultValue,iRow,iStartCol,iInputCol,iEndCol,dblLeft,dblWidth,dblInputLeft,dblInputWidth,dblTop,dblHeight,dblMin,dblMax) Values (126,'deficitrestrict_flag','赤字时限制操作','deficitrestrict_flag',1,'0','1','1',Null,Null,'0','6',0,0,19,1,Null,'1',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null)
Insert into fd_fields (iID,sName,sCaption,sSourceField,iEntityID,iFieldOption,bPersistent,bIsUsed,sHelpContextID,sTaskID,iEditProp,iDataType,iReferenceType,iRefFldSqc,iQryFldsqc,iLength,iDecimals,bAllowNull,sDefaultValue,iRow,iStartCol,iInputCol,iEndCol,dblLeft,dblWidth,dblInputLeft,dblInputWidth,dblTop,dblHeight,dblMin,dblMax) Values (127,'freeze_flag','冻结标志','istate',1,'0','1','1',Null,Null,'0','6',0,0,20,1,Null,'1',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null)
Insert into fd_fields (iID,sName,sCaption,sSourceField,iEntityID,iFieldOption,bPersistent,bIsUsed,sHelpContextID,sTaskID,iEditProp,iDataType,iReferenceType,iRefFldSqc,iQryFldsqc,iLength,iDecimals,bAllowNull,sDefaultValue,iRow,iStartCol,iInputCol,iEndCol,dblLeft,dblWidth,dblInputLeft,dblInputWidth,dblTop,dblHeight,dblMin,dblMax) Values (128,'destroy_flag','销户标志','bDestroy',1,'0','1','1',Null,Null,'0','6',0,0,22,1,Null,'1',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null)
Insert into fd_fields (iID,sName,sCaption,sSourceField,iEntityID,iFieldOption,bPersistent,bIsUsed,sHelpContextID,sTaskID,iEditProp,iDataType,iReferenceType,iRefFldSqc,iQryFldsqc,iLength,iDecimals,bAllowNull,sDefaultValue,iRow,iStartCol,iInputCol,iEndCol,dblLeft,dblWidth,dblInputLeft,dblInputWidth,dblTop,dblHeight,dblMin,dblMax) Values (129,'digest','备注信息','digest',1,'0','1','1',Null,Null,'0','7',3,0,21,255,Null,'1',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null)
Insert into fd_fields (iID,sName,sCaption,sSourceField,iEntityID,iFieldOption,bPersistent,bIsUsed,sHelpContextID,sTaskID,iEditProp,iDataType,iReferenceType,iRefFldSqc,iQryFldsqc,iLength,iDecimals,bAllowNull,sDefaultValue,iRow,iStartCol,iInputCol,iEndCol,dblLeft,dblWidth,dblInputLeft,dblInputWidth,dblTop,dblHeight,dblMin,dblMax) Values (201,'accgrp_id','账户类型ID','accgrp_id',2,'0','1','1',Null,Null,'2','9',0,0,0,15,Null,'0',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null)
Insert into fd_fields (iID,sName,sCaption,sSourceField,iEntityID,iFieldOption,bPersistent,bIsUsed,sHelpContextID,sTaskID,iEditProp,iDataType,iReferenceType,iRefFldSqc,iQryFldsqc,iLength,iDecimals,bAllowNull,sDefaultValue,iRow,iStartCol,iInputCol,iEndCol,dblLeft,dblWidth,dblInputLeft,dblInputWidth,dblTop,dblHeight,dblMin,dblMax) Values (202,'accgrp_code','账户类型代码','accgrp_code',2,'0','1','1',Null,Null,'0','1',0,0,0,20,Null,'0',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null)
Insert into fd_fields (iID,sName,sCaption,sSourceField,iEntityID,iFieldOption,bPersistent,bIsUsed,sHelpContextID,sTaskID,iEditProp,iDataType,iReferenceType,iRefFldSqc,iQryFldsqc,iLength,iDecimals,bAllowNull,sDefaultValue,iRow,iStartCol,iInputCol,iEndCol,dblLeft,dblWidth,dblInputLeft,dblInputWidth,dblTop,dblHeight,dblMin,dblMax) Values (203,'accgrp_name','账户类型名称','accgrp_name',2,'0','1','1',Null,Null,'0','1',0,0,0,50,Null,'0',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null)
Insert into fd_fields (iID,sName,sCaption,sSourceField,iEntityID,iFieldOption,bPersistent,bIsUsed,sHelpContextID,sTaskID,iEditProp,iDataType,iReferenceType,iRefFldSqc,iQryFldsqc,iLength,iDecimals,bAllowNull,sDefaultValue,iRow,iStartCol,iInputCol,iEndCol,dblLeft,dblWidth,dblInputLeft,dblInputWidth,dblTop,dblHeight,dblMin,dblMax) Values (204,'parent_id','上级类型ID','parent_id',2,'0','1','1',Null,Null,'2','9',0,0,0,15,Null,'1',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null)
Insert into fd_fields (iID,sName,sCaption,sSourceField,iEntityID,iFieldOption,bPersistent,bIsUsed,sHelpContextID,sTaskID,iEditProp,iDataType,iReferenceType,iRefFldSqc,iQryFldsqc,iLength,iDecimals,bAllowNull,sDefaultValue,iRow,iStartCol,iInputCol,iEndCol,dblLeft,dblWidth,dblInputLeft,dblInputWidth,dblTop,dblHeight,dblMin,dblMax) Values (205,'digest','备注','digest',2,'0','1','1',Null,Null,'0','7',0,0,0,255,Null,'1',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null)