dprd_fd.sql

不处的管理软件包

/*=============================================================*/
/* Database name:  U8资金管理8.50升级脚本                       */
/* DBMS name:      Microsoft SQL Server 2000                   */
/* Created on:     2002-4-28 11:12:05                          */
/* Created by:     章景峰                                      */
/*=============================================================*/

if exists (select 1 from sysobjects where id = object_id('fd_entities') and type = 'U')
	if not exists (select 1 from fd_entities where iID = 1)
	begin
	delete from fd_entities
/*Insert 数据*/
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 (1,'fd_accdef','账户定义',1,'010000000000000','fd_accdef','accdef_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 (2,'fd_accgrp','账户组定义',2,'020000000000000','fd_accgrp','accgrp_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 (3,'fd_cadset_h','结息日设置',3,'030000000000000','fd_cadset','cad_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 (8,'fd_irate_h','利率设置',8,'080000000000000','fd_intra','irate_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 (9,'fd_accunit','账户单位',9,'090000000000000','fd_accunit','accunit_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 (10,'fd_query_h','单据查询',10,'100000000000000','fd_query_h','query_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 (21,'fd_insiderec','内部存款单',21,'210000000000000','fd_transactions','transactions_id',Null,Null,Null,Null,Null,11,20,8,9364,6611,Null,'1','2',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 (22,'fd_insidepay','内部取款单',22,'220000000000000','fd_transactions','transactions_id',Null,Null,Null,Null,Null,12,20,8,8946,5544,Null,'1','2',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 (23,'fd_insidesettle','内部结算单',23,'230000000000000','fd_transactions','transactions_id',Null,Null,Null,Null,Null,13,20,8,8946,5166,Null,'1','2',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 (24,'fd_bankrecsettle','银行收款结算单',24,'240000000000000','fd_transactions','transactions_id',Null,Null,Null,Null,Null,14,20,8,9333,5541,Null,'1','2',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 (25,'fd_bankpaysettle','银行付款结算单',25,'250000000000000','fd_transactions','transactions_id',Null,Null,Null,Null,Null,15,20,8,9363,5544,Null,'1','2',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 (26,'fd_bankrec','银行存款单',26,'260000000000000','fd_transactions','transactions_id',Null,Null,Null,Null,Null,16,20,8,9435,5166,Null,'1','2',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 (27,'fd_bankpay','银行取款单',27,'270000000000000','fd_transactions','transactions_id',Null,Null,Null,Null,Null,17,20,8,9510,5166,Null,'1','2',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 (28,'fd_banksettle','银行结算单',28,'280000000000000','fd_transactions','transactions_id',Null,Null,Null,Null,Null,18,20,8,9690,5166,Null,'1','2',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 (29,'fd23_内部高级结算单','内部高级结算单',29,'290000000000000','fd_transactions','transactions_id',Null,Null,Null,Null,Null,19,21,8,8946,7512,Null,'1','2',23,'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 (30,'fd24_上拨单','上划单',30,'300000000000000','fd_transactions','transactions_id',Null,Null,Null,Null,Null,20,20,8,9766,6816,Null,'1','2',24,'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 (31,'fd_insidefixeddeposit','内部定期存款单',31,'310000000000000','fd_transactions','transactions_id',Null,Null,Null,Null,Null,21,20,8,8946,5166,Null,'1','3',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 (32,'fd_insidefixedfetch','内部定期取款单',32,'320000000000000','fd_transactions','transactions_id',Null,Null,Null,Null,Null,22,20,8,8898,5166,Null,'1','3',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 (33,'fd_bankfixeddeposit','银行定期存款单',33,'330000000000000','fd_transactions','transactions_id',Null,Null,Null,Null,Null,23,20,8,8946,5166,Null,'1','3',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 (34,'fd_bankfixedfetch','银行定期取款单',34,'340000000000000','fd_transactions','transactions_id',Null,Null,Null,Null,Null,24,20,8,8946,5166,Null,'1','3',0,'0',0)