s.sql

行业应急系统 包括: 应急系统（待遇核发） 发放系统 开发环境:Delphi5 (sp1)+ Oracle 8.05 MultiExport是一个可以将数据按指定字段倒出

/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(307,3,'单位地址',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(308,3,'邮政编码',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(309,3,'成立日期',1,'','Date      ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(310,3,'参保日期',1,'','Date      ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(311,3,'所属行业',1,'SELECT dmmc as Value FROM tDMB WHERE zdbz=''SSHY'' ORDER BY DM','String    ',
'','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(312,3,'行业代码',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(313,3,'主管部门代码',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(314,3,'主管部门名称',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(315,3,'经济类型',1,'SELECT dmmc as Value FROM tDMB WHERE zdbz=''JJLX'' ORDER BY DM','String    ',
'','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(316,3,'隶属关系',1,'SELECT dmmc as Value FROM tDMB WHERE zdbz=''LSGX'' ORDER BY DM','String    ',
'','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(317,3,'单位性质',1,'SELECT dmmc as Value FROM tDMB WHERE zdbz=''DWXZ'' ORDER BY DM','String    ',
'','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(318,3,'制度类别',1,'SELECT dmmc as Value FROM tDMB WHERE zdbz=''CZLB'' ORDER BY DM','String    ',
'','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(319,3,'单位状态',1,'SELECT dmmc as Value FROM tDMB WHERE zdbz=''DWZT'' ORDER BY DM','String    ',
'','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(320,3,'部门号',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(321,3,'结算方式',1,'SELECT dmmc as Value FROM tDMB WHERE zdbz=''JSFS'' ORDER BY DM','String    ',
'','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(322,3,'银行行号',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(323,3,'开户银行',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(324,3,'帐户名称',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(325,3,'银行帐户',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(326,3,'法人代表',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(327,3,'法人电话',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(328,3,'法人身份证号',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(329,3,'财务负责人',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(330,3,'财务电话',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(331,3,'社保专管员',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(332,3,'社保专管员电话',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(333,3,'单位经办部门',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(334,3,'经办部门负责人',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(335,3,'传真',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(336,3,'所在城市',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(337,3,'执行城市标准',1,'SELECT dmmc as Value FROM tDMB WHERE zdbz=''DYBZ'' ORDER BY DM',
'String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(338,3,'待遇执行办法',1,'SELECT dmmc as Value FROM tDMB WHERE zdbz=''DYZXBF'' ORDER BY DM',
'String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(339,3,'统筹调整标志',1,'SELECT dmmc as Value FROM tDMB WHERE zdbz=''TCTZBZ'' ORDER BY DM',
'String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(340,3,'经办人',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(341,3,'经办日期',1,'','Date      ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(342,3,'审核人',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(343,3,'审核日期',1,'','Date      ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(430,4,'干部交通费',1,'','Number    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(431,4,'离退休费总额',1,'','Number    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(432,4,'待遇标准',1,'','Number    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(433,4,'备注',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(501,5,'社保机构代码',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(435,4,'邮政编码',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(436,4,'联系电话',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(437,4,'联系地址',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(438,4,'亲属姓名',1,'','Number    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(439,4,'亲属身份证号',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(440,4,'与本人关系',1,'SELECT dmmc as Value FROM tDMB WHERE zdbz=''QSGX'' ORDER BY DM','String    ',
'','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(441,4,'亲属联系电话',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(442,4,'亲属邮编',1,'','Date      ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(443,4,'亲属联系地址',1,'','Date      ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(444,4,'经办人',1,'','Date      ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(445,4,'经办日期',1,'','Date      ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(446,4,'审核人',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(447,4,'审核日期',1,'','Date      ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(434,4,'业务状态',1,'SELECT dmmc as Value FROM tDMB WHERE zdbz=''TLTXJBXX_YWZT'' ORDER BY DM',
'String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(709,7,'业务状态',1,'SELECT dmmc as Value FROM tDMB WHERE zdbz=''TRYJBXX_YWZT'' ORDER BY DM',
'String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(202,2,'省区名',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(203,2,'地区名',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(204,2,'县区名',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(205,2,'机构级别',1,'SELECT dmmc as Value FROM tDMB WHERE zdbz=''JGJB'' ORDER BY DM','String    ',
'','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(206,2,'地址',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(207,2,'邮政编码',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(208,2,'银行行号',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES