s.sql

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

(209,2,'银行名称',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(210,2,'帐户名称',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(211,2,'帐号',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(212,2,'会计',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(213,2,'出纳',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(214,2,'联系电话',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(215,2,'传真',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(201,2,'机构名称',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(500,5,'ZZZYXX_RYID',0,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(502,5,'转移单位',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(503,5,'申报日期',1,'','Date      ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(504,5,'结算月份',1,'','Date      ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(505,5,'个人缴费总额',1,'','Number    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(506,5,'个人缴费利息',1,'','Number    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(507,5,'单位划拨总额',1,'','Number    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(508,5,'单位划拨利息',1,'','Number    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(509,5,'个人帐户总额',1,'','Number    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(510,5,'缴费工资总额',1,'','Number    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(511,5,'转移编号',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(512,5,'转移日期',1,'','Date      ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(513,5,'业务状态',1,'SELECT dmmc as Value FROM tDMB WHERE zdbz=''TZZRYJBXX_YWZT''','String    ','',
'','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(514,5,'经办人',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(515,5,'经办日期',1,'','Date      ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(516,5,'审核人',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(517,5,'审核日期',1,'','Date      ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(518,5,'姓名',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(519,5,'社会保障号',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(520,5,'RYJBXX_RYID',0,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(600,6,'SWDYSB_RYID',0,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(601,6,'申报日期',1,'','Date      ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(602,6,'死亡日期',1,'','Date      ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(603,6,'死亡证号',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(604,6,'死亡原因',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(606,6,'审核意见',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(607,6,'经办人',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(608,6,'经办日期',1,'','Date      ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(609,6,'审核人',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(610,6,'审核日期',1,'','Date      ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(612,6,'姓名',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(613,6,'社会保障号',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(614,6,'RYJBXX_RYID',0,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(615,6,'DWXX_DWID',0,'DWXX_DWID','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(616,6,'单位代码',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(617,6,'单位名称',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(618,6,'RYJBXX_DWID',0,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(619,6,'RYJBXX_RYID',0,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(611,6,'业务状态',1,'SELECT dmmc as Value FROM tDMB WHERE zdbz=''RYZT'' ORDER BY DM','String    ',
'','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100101,1001,'DWID_FF',0,'','String    ','单位序号','tdwxx','','tdwxx')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100102,1001,'SSDWID',0,'','String    ','所属单位','tdwxx','','tdwxx')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100103,1001,'DWDM',1,'','String    ','单位代码','tdwxx','','tdwxx')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100104,1001,'DWMC',1,'','String    ','单位名称','tdwxx','','tdwxx')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100105,1001,'DMMC',1,'select dmmc as Value from tdmb where zdbz=''SSHY''','String    ','所属行业',
'tdmb','tdwxx.sshy=dm_sshy.dm and dm_sshy.zdbz=''SSHY''','dm_sshy')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100106,1001,'FRDB',1,'','String    ','法人代表','tdwxx','','tdwxx')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100107,1001,'DWJBR',1,'','String    ','单位经办人','tdwxx','','tdwxx')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100108,1001,'ZH',1,'','String    ','帐户','tdwxx','','tdwxx')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100109,1001,'KHMC',1,'','String    ','开户行','tdwxx','','tdwxx')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100110,1001,'YZBM',1,'','String    ','邮政编码','tdwxx','','tdwxx')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100111,1001,'DWDZ',1,'','String    ','单位地址','tdwxx','','tdwxx')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100112,1001,'LXDH',1,'','String    ','联系电话','tdwxx','','tdwxx')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100113,1001,'SHHFFSJ',1,'','Date      ','社会化发放时间','tdwxx','','tdwxx')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100201,1002,'RYID_FF',0,'','String    ','人员标识','tSYSField','','tSYSField')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100202,1002,'DWDM',1,'','String    ','组代码','tdwxx','dw_zdm.dwid_ff=tSYSField.dwid_ff','dw_zdm')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100203,1002,'DWMC',1,'','String    ','单位名称','tdwxx','dw_dwmc.dwid_ff=tSYSField.ssdwid',
'dw_dwmc')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100204,1002,'XM',1,'','String    ','姓名','tSYSField','','tSYSField')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100205,1002,'SFZH',1,'','String    ','身份证号','tSYSField','','tSYSField')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100206,1002,'HDJE',1,'','Number    ','核定金额','tSYSField','','tSYSField')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100207,1002,'DMMC',1,'select dmmc as Value from tdmb where zdbz=''FFXS''','String    ','发放方式',
'tDMB','tSYSField.fffs=dm_fffs.dm and dm_fffs.zdbz=''FFXS''','dm_fffs')
/