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 (301,'cad_id','结息日ID','cad_id',3,'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 (302,'cad_code','结息日代码','cCadID',3,'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 (303,'month_num','结息周期(月)','iMonth',3,'0','1','1',Null,Null,'0','5',0,0,0,2,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 (304,'delay_num','延期天数','idelay',3,'0','1','1',Null,Null,'0','5',0,0,0,4,Null,'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 (305,'digest','备注','cMark',3,'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)
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 (801,'irate_id','利率ID','irate_id',8,'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 (802,'irate_code','利率代码','cIntrID',8,'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 (901,'accunit_id','账户单位ID','accunit_id',9,'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 (902,'accunit_code','账户单位代码','cUnitCode',9,'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 (903,'accunit_name','账户单位名称','cUnitName',9,'0','1','1',Null,Null,'0','1',0,0,0,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 (904,'digest','备注','cMark',9,'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)
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 (905,'type_flag','账户单位类型','iType',9,'0','1','1',Null,Null,'0','5',0,0,0,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 (1001,'query_id','单据查询ID','query_id',10,'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 (1002,'query_name','单据查询名称','query_name',10,'0','1','1',Null,Null,'0','1',0,0,0,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 (1003,'type_flag','单据类型','type_flag',10,'0','1','1',Null,Null,'0','5',0,0,0,2,Null,'0','21',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 (1004,'sqlclause','单据查询SQL语句','sqlclause',10,'0','1','1',Null,Null,'0','1',0,0,0,0,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 (1005,'orderby','单据查询排序语句','orderby',10,'0','1','1',Null,Null,'0','1',0,0,0,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 (2101,'transactions_id','业务内部编号','transactions_id',21,'0','1','1',Null,Null,'2','9',0,0,0,15,Null,'0',Null,Null,Null,Null,Null,0,0,0,0,0,0,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 (2102,'transactions_code','业务编号','transactions_code',21,'0','1','1',Null,Null,'0','9',0,0,1,10,Null,'0',Null,4,2,3,3,465,1323,1788,1323,1134,378,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 (2103,'bill_date','日期','bill_date',21,'0','1','1',Null,Null,'0','2',6,2,3,10,Null,'0',Null,4,6,7,7,5757,1323,7080,1323,1134,378,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 (2104,'rcv_acc_id','账户内部编号','rcv_acc_id',21,'0','1','1',Null,Null,'2','9',0,0,0,15,Null,'0',Null,Null,Null,Null,Null,0,0,0,0,0,0,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 (2105,'rcv_acc_code','收款账户号',Null,21,'0','0','1',Null,Null,'0','1',1,1,2,50,Null,'0',Null,6,2,3,3,465,1323,1788,1323,1638,378,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 (2106,'sum_mny','金额','sum_mny',21,'0','1','1',Null,Null,'0','3',0,3,4,17,'2','0',Null,8,2,3,3,465,1323,1788,1323,2394,378,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 (2107,'money_name','币别','money_name',21,'0','1','1',Null,Null,'1','1',0,0,5,8,Null,'0',Null,8,4,5,5,3111,1323,4434,1323,2394,378,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 (2108,'exchange_rate','汇率','exchange_rate',21,'0','1','1',Null,Null,'0','4',0,0,6,15,'6','0',Null,8,6,7,7,5757,1323,7080,1323,2394,378,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 (2109,'digest','摘要','digest',21,'0','1','1',Null,Null,'0','1',10,0,7,255,Null,'1',Null,13,2,7,7,465,1323,1788,6615,4284,378,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 (2110,'bill_name','制单','bill_name',21,'0','1','1',Null,Null,'1','1',0,0,8,20,Null,'0',Null,15,6,7,7,5757,1323,7080,1323,4788,378,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 (2111,'check_name','审核','check_name',21,'0','1','1',Null,Null,'1','1',0,0,9,20,Null,'1',Null,15,4,5,5,3111,1323,4434,1323,4788,378,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 (2112,'book_name','记账','book_name',21,'0','1','1',Null,Null,'1','1',0,0,10,20,Null,'1',Null,15,2,3,3,465,1323,1788,1323,4788,378,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 (2113,'accunit_name','收款单位名称',Null,21,'1','0','1',Null,Null,'1','1',0,0,11,80,Null,'1',Null,7,2,3,7,465,1323,1788,6615,2016,378,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 (2114,'accdef_name','收款账户名称',Null,21,'1','0','1',Null,Null,'1','1',0,0,12,80,Null,'1',Null,6,4,5,7,3111,1323,4434,3969,1638,378,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 (2115,'capitalmoney_name','大写金额',Null,21,'1','0','1',Null,Null,'1','1',0,0,0,100,Null,'1',Null,9,2,3,7,465,1323,1788,6615,2772,378,Null,Null)