dprd_fd.sql

不处的管理软件包

Insert into fd_entities (iID,sName,sCaption,iBIType,sMaxOID,sSourceTable,sOIDSourceField,iParentID,sParentField,sTaskID,sHelpContextID,sDescription,iSheet,iRows,iCols,iWidth,iHeight,sPzSign,iIsUsed,iVchType,iDeriveBIType,bIsAutoAlarm,iAlarmDays) Values (41,'fd_loan','内部贷款单',41,'410000000000000','fd_transactions','transactions_id',Null,Null,Null,Null,Null,31,21,8,8946,6594,Null,'1','4',0,'0',3)
Insert into fd_entities (iID,sName,sCaption,iBIType,sMaxOID,sSourceTable,sOIDSourceField,iParentID,sParentField,sTaskID,sHelpContextID,sDescription,iSheet,iRows,iCols,iWidth,iHeight,sPzSign,iIsUsed,iVchType,iDeriveBIType,bIsAutoAlarm,iAlarmDays) Values (42,'fd_loanreturn','内部贷款还款单',42,'420000000000000','fd_transactions','transactions_id',Null,Null,Null,Null,Null,32,20,8,9639,6678,Null,'1','4',0,'0',0)
Insert into fd_entities (iID,sName,sCaption,iBIType,sMaxOID,sSourceTable,sOIDSourceField,iParentID,sParentField,sTaskID,sHelpContextID,sDescription,iSheet,iRows,iCols,iWidth,iHeight,sPzSign,iIsUsed,iVchType,iDeriveBIType,bIsAutoAlarm,iAlarmDays) Values (43,'fd_termloan','内部拆借单',43,'430000000000000','fd_transactions','transactions_id',Null,Null,Null,Null,Null,33,20,8,8946,5544,Null,'1','4',0,'0',3)
Insert into fd_entities (iID,sName,sCaption,iBIType,sMaxOID,sSourceTable,sOIDSourceField,iParentID,sParentField,sTaskID,sHelpContextID,sDescription,iSheet,iRows,iCols,iWidth,iHeight,sPzSign,iIsUsed,iVchType,iDeriveBIType,bIsAutoAlarm,iAlarmDays) Values (44,'fd_termloanreturn','内部拆借还款单',44,'440000000000000','fd_transactions','transactions_id',Null,Null,Null,Null,Null,34,20,8,9639,6933,Null,'1','4',0,'0',0)
Insert into fd_entities (iID,sName,sCaption,iBIType,sMaxOID,sSourceTable,sOIDSourceField,iParentID,sParentField,sTaskID,sHelpContextID,sDescription,iSheet,iRows,iCols,iWidth,iHeight,sPzSign,iIsUsed,iVchType,iDeriveBIType,bIsAutoAlarm,iAlarmDays) Values (45,'fd_bankloan','银行贷款单',45,'450000000000000','fd_transactions','transactions_id',Null,Null,Null,Null,Null,35,20,8,8946,5166,Null,'1','4',0,'0',3)
Insert into fd_entities (iID,sName,sCaption,iBIType,sMaxOID,sSourceTable,sOIDSourceField,iParentID,sParentField,sTaskID,sHelpContextID,sDescription,iSheet,iRows,iCols,iWidth,iHeight,sPzSign,iIsUsed,iVchType,iDeriveBIType,bIsAutoAlarm,iAlarmDays) Values (46,'fd_bankloanreturn','银行贷款还款单',46,'460000000000000','fd_transactions','transactions_id',Null,Null,Null,Null,Null,36,20,8,9639,6300,Null,'1','4',0,'0',0)
Insert into fd_entities (iID,sName,sCaption,iBIType,sMaxOID,sSourceTable,sOIDSourceField,iParentID,sParentField,sTaskID,sHelpContextID,sDescription,iSheet,iRows,iCols,iWidth,iHeight,sPzSign,iIsUsed,iVchType,iDeriveBIType,bIsAutoAlarm,iAlarmDays) Values (51,'fd_insidedepositaccrual','内部存款利息单',51,'510000000000000','fd_transactions','transactions_id',Null,Null,Null,Null,Null,41,20,8,8946,4788,Null,'1','5',0,'0',0)
Insert into fd_entities (iID,sName,sCaption,iBIType,sMaxOID,sSourceTable,sOIDSourceField,iParentID,sParentField,sTaskID,sHelpContextID,sDescription,iSheet,iRows,iCols,iWidth,iHeight,sPzSign,iIsUsed,iVchType,iDeriveBIType,bIsAutoAlarm,iAlarmDays) Values (52,'fd_insideloanaccrual','内部贷款利息单',52,'520000000000000','fd_transactions','transactions_id',Null,Null,Null,Null,Null,42,20,8,9639,5166,Null,'1','5',0,'0',3)
Insert into fd_entities (iID,sName,sCaption,iBIType,sMaxOID,sSourceTable,sOIDSourceField,iParentID,sParentField,sTaskID,sHelpContextID,sDescription,iSheet,iRows,iCols,iWidth,iHeight,sPzSign,iIsUsed,iVchType,iDeriveBIType,bIsAutoAlarm,iAlarmDays) Values (53,'fd_termloanaccrual','内部拆借利息单',53,'530000000000000','fd_transactions','transactions_id',Null,Null,Null,Null,Null,43,20,8,9639,5166,Null,'1','5',0,'0',3)
Insert into fd_entities (iID,sName,sCaption,iBIType,sMaxOID,sSourceTable,sOIDSourceField,iParentID,sParentField,sTaskID,sHelpContextID,sDescription,iSheet,iRows,iCols,iWidth,iHeight,sPzSign,iIsUsed,iVchType,iDeriveBIType,bIsAutoAlarm,iAlarmDays) Values (54,'fd_bankdepositaccrual','银行存款利息单',54,'540000000000000','fd_transactions','transactions_id',Null,Null,Null,Null,Null,44,20,8,8946,4788,Null,'1','5',0,'0',0)
Insert into fd_entities (iID,sName,sCaption,iBIType,sMaxOID,sSourceTable,sOIDSourceField,iParentID,sParentField,sTaskID,sHelpContextID,sDescription,iSheet,iRows,iCols,iWidth,iHeight,sPzSign,iIsUsed,iVchType,iDeriveBIType,bIsAutoAlarm,iAlarmDays) Values (55,'fd_bankloanaccrual','银行贷款利息单',55,'550000000000000','fd_transactions','transactions_id',Null,Null,Null,Null,Null,45,20,8,9639,5166,Null,'1','5',0,'0',3)
Insert into fd_entities (iID,sName,sCaption,iBIType,sMaxOID,sSourceTable,sOIDSourceField,iParentID,sParentField,sTaskID,sHelpContextID,sDescription,iSheet,iRows,iCols,iWidth,iHeight,sPzSign,iIsUsed,iVchType,iDeriveBIType,bIsAutoAlarm,iAlarmDays) Values (61,'fd_loanapply','贷款申请单',61,'610000000000000','fd_transactions','transactions_id',Null,Null,Null,Null,Null,51,20,8,8946,5040,Null,'1','6',0,'0',0)
Insert into fd_entities (iID,sName,sCaption,iBIType,sMaxOID,sSourceTable,sOIDSourceField,iParentID,sParentField,sTaskID,sHelpContextID,sDescription,iSheet,iRows,iCols,iWidth,iHeight,sPzSign,iIsUsed,iVchType,iDeriveBIType,bIsAutoAlarm,iAlarmDays) Values (62,'fd_guarantee','担保单',62,'620000000000000','fd_transactions','transactions_id',Null,Null,Null,Null,Null,52,20,8,8946,5796,Null,'1','6',0,'0',3)
Insert into fd_entities (iID,sName,sCaption,iBIType,sMaxOID,sSourceTable,sOIDSourceField,iParentID,sParentField,sTaskID,sHelpContextID,sDescription,iSheet,iRows,iCols,iWidth,iHeight,sPzSign,iIsUsed,iVchType,iDeriveBIType,bIsAutoAlarm,iAlarmDays) Values (63,'fd_accrualnotify','利息通知单',63,'630000000000000','fd_transactions','transactions_id',Null,Null,Null,Null,Null,53,20,8,8946,4788,Null,'1','6',0,'0',0)
Insert into fd_entities (iID,sName,sCaption,iBIType,sMaxOID,sSourceTable,sOIDSourceField,iParentID,sParentField,sTaskID,sHelpContextID,sDescription,iSheet,iRows,iCols,iWidth,iHeight,sPzSign,iIsUsed,iVchType,iDeriveBIType,bIsAutoAlarm,iAlarmDays) Values (64,'fd_hastennotify','催款通知单',64,'640000000000000','fd_transactions','transactions_id',Null,Null,Null,Null,Null,54,20,8,9639,3654,Null,'1','6',0,'0',0)
Insert into fd_entities (iID,sName,sCaption,iBIType,sMaxOID,sSourceTable,sOIDSourceField,iParentID,sParentField,sTaskID,sHelpContextID,sDescription,iSheet,iRows,iCols,iWidth,iHeight,sPzSign,iIsUsed,iVchType,iDeriveBIType,bIsAutoAlarm,iAlarmDays) Values (80,'fd25_下拨单','下拨单',80,'800000000000000','fd_transactions','transactions_id',Null,Null,Null,Null,Null,70,20,8,9348,6816,Null,'1','2',25,'0',0)
Insert into fd_entities (iID,sName,sCaption,iBIType,sMaxOID,sSourceTable,sOIDSourceField,iParentID,sParentField,sTaskID,sHelpContextID,sDescription,iSheet,iRows,iCols,iWidth,iHeight,sPzSign,iIsUsed,iVchType,iDeriveBIType,bIsAutoAlarm,iAlarmDays) Values (90,'fd_settleprice','结算价格',90,'900000000000000','fd_settle','settle_id',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,'0',0,Null,Null)
Insert into fd_entities (iID,sName,sCaption,iBIType,sMaxOID,sSourceTable,sOIDSourceField,iParentID,sParentField,sTaskID,sHelpContextID,sDescription,iSheet,iRows,iCols,iWidth,iHeight,sPzSign,iIsUsed,iVchType,iDeriveBIType,bIsAutoAlarm,iAlarmDays) Values (91,'fd_accset','账户科目设置',91,'910000000000000','fd_accset','accset_id',1,'accdef_id',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,'0',0,Null,Null)
Insert into fd_entities (iID,sName,sCaption,iBIType,sMaxOID,sSourceTable,sOIDSourceField,iParentID,sParentField,sTaskID,sHelpContextID,sDescription,iSheet,iRows,iCols,iWidth,iHeight,sPzSign,iIsUsed,iVchType,iDeriveBIType,bIsAutoAlarm,iAlarmDays) Values (92,'fd_cadset_b','结息日子表',92,'920000000000000','fd_cadsets','cad_b_id',3,'cad_id',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,'0',0,Null,Null)
Insert into fd_entities (iID,sName,sCaption,iBIType,sMaxOID,sSourceTable,sOIDSourceField,iParentID,sParentField,sTaskID,sHelpContextID,sDescription,iSheet,iRows,iCols,iWidth,iHeight,sPzSign,iIsUsed,iVchType,iDeriveBIType,bIsAutoAlarm,iAlarmDays) Values (97,'fd_irate_b','利率子表',97,'970000000000000','fd_intras','irate_b_id',8,'irate_id',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,'0',0,Null,Null)
Insert into fd_entities (iID,sName,sCaption,iBIType,sMaxOID,sSourceTable,sOIDSourceField,iParentID,sParentField,sTaskID,sHelpContextID,sDescription,iSheet,iRows,iCols,iWidth,iHeight,sPzSign,iIsUsed,iVchType,iDeriveBIType,bIsAutoAlarm,iAlarmDays) Values (98,'fd_query_b','单据查询子表',98,'980000000000000','fd_query_b','query_b_id',10,'query_id',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,'0',0,Null,Null)
Insert into fd_entities (iID,sName,sCaption,iBIType,sMaxOID,sSourceTable,sOIDSourceField,iParentID,sParentField,sTaskID,sHelpContextID,sDescription,iSheet,iRows,iCols,iWidth,iHeight,sPzSign,iIsUsed,iVchType,iDeriveBIType,bIsAutoAlarm,iAlarmDays) Values (99,'fd_settle_b','结算价格子表',99,'990000000000000','fd_settle_b','settle_b_id',90,'settle_id',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,'0',0,Null,Null)
	end
go


if exists (select 1 from sysobjects where id = object_id('fd_fields') and type = 'U')
	if not exists (select 1 from fd_fields where iID = 101)
	begin
	delete from fd_fields
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 (101,'accdef_id','账户ID','accdef_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 (102,'accdef_code','账户号','cAccID',1,'0','1','1',Null,Null,'0','1',0,0,1,50,Null,'0',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null)