tsysfield.sql

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

INSERT INTO tSYSField
(ID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLEID,TABLENAME,JOINCOND,ALIASTABLE)
VALUES
(100101,'DWID_FF',0,'','String','单位序号',1001,'tff_dwxx','','tff_dwxx')
/
INSERT INTO tSYSField
(ID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLEID,TABLENAME,JOINCOND,ALIASTABLE)
VALUES
(100102,'SSDWID',0,'','String','所属单位',1001,'tff_dwxx','','tff_dwxx')
/
INSERT INTO tSYSField
(ID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLEID,TABLENAME,JOINCOND,ALIASTABLE)
VALUES
(100103,'DWDM',1,'','String','单位代码',1001,'tff_dwxx','','tff_dwxx')
/
INSERT INTO tSYSField
(ID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLEID,TABLENAME,JOINCOND,ALIASTABLE)
VALUES
(100104,'DWMC',1,'','String','单位名称',1001,'tff_dwxx','','tff_dwxx')
/
INSERT INTO tSYSField
(ID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLEID,TABLENAME,JOINCOND,ALIASTABLE)
VALUES
(100105,'DMMC',1,'selectdmmcasValuefromtdmbwherezdbz=''SSHY''','String','所属行业',1001,
'tdmb','tff_dwxx.sshy=dm_sshy.dmanddm_sshy.zdbz=''SSHY''','dm_sshy')
/
INSERT INTO tSYSField
(ID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLEID,TABLENAME,JOINCOND,ALIASTABLE)
VALUES
(100106,'FRDB',1,'','String','法人代表',1001,'tff_dwxx','','tff_dwxx')
/
INSERT INTO tSYSField
(ID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLEID,TABLENAME,JOINCOND,ALIASTABLE)
VALUES
(100107,'DWJBR',1,'','String','单位经办人',1001,'tff_dwxx','','tff_dwxx')
/
INSERT INTO tSYSField
(ID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLEID,TABLENAME,JOINCOND,ALIASTABLE)
VALUES
(100108,'ZH',1,'','String','帐户',1001,'tff_dwxx','','tff_dwxx')
/
INSERT INTO tSYSField
(ID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLEID,TABLENAME,JOINCOND,ALIASTABLE)
VALUES
(100109,'KHMC',1,'','String','开户行',1001,'tff_dwxx','','tff_dwxx')
/
INSERT INTO tSYSField
(ID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLEID,TABLENAME,JOINCOND,ALIASTABLE)
VALUES
(100110,'YZBM',1,'','String','邮政编码',1001,'tff_dwxx','','tff_dwxx')
/
INSERT INTO tSYSField
(ID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLEID,TABLENAME,JOINCOND,ALIASTABLE)
VALUES
(100111,'DWDZ',1,'','String','单位地址',1001,'tff_dwxx','','tff_dwxx')
/
INSERT INTO tSYSField
(ID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLEID,TABLENAME,JOINCOND,ALIASTABLE)
VALUES
(100112,'LXDH',1,'','String','联系电话',1001,'tff_dwxx','','tff_dwxx')
/
INSERT INTO tSYSField
(ID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLEID,TABLENAME,JOINCOND,ALIASTABLE)
VALUES
(100113,'SHHFFSJ',1,'','Date','社会化发放时间',1001,'tff_dwxx','','tff_dwxx')
/
INSERT INTO tSYSField
(ID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLEID,TABLENAME,JOINCOND,ALIASTABLE)
VALUES
(100201,'RYID_FF',0,'','String','人员标识',1002,'tff_ryxx','','tff_ryxx')
/
INSERT INTO tSYSField
(ID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLEID,TABLENAME,JOINCOND,ALIASTABLE)
VALUES
(100202,'DWDM',1,'','String','组代码',1002,'tff_dwxx','dw_zdm.dwid_ff=tff_ryxx.dwid_ff','dw_zdm')
/
INSERT INTO tSYSField
(ID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLEID,TABLENAME,JOINCOND,ALIASTABLE)
VALUES
(100203,'DWMC',1,'','String','单位名称',1002,'tff_dwxx','dw_dwmc.dwid_ff=tff_ryxx.ssdwid',
'dw_dwmc')
/
INSERT INTO tSYSField
(ID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLEID,TABLENAME,JOINCOND,ALIASTABLE)
VALUES
(100204,'XM',1,'','String','姓名',1002,'tff_ryxx','','tff_ryxx')
/
INSERT INTO tSYSField
(ID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLEID,TABLENAME,JOINCOND,ALIASTABLE)
VALUES
(100205,'SFZH',1,'','String','身份证号',1002,'tff_ryxx','','tff_ryxx')
/
INSERT INTO tSYSField
(ID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLEID,TABLENAME,JOINCOND,ALIASTABLE)
VALUES
(100206,'HDJE',1,'','Number','核定金额',1002,'tff_ryxx','','tff_ryxx')
/
INSERT INTO tSYSField
(ID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLEID,TABLENAME,JOINCOND,ALIASTABLE)
VALUES
(100207,'DMMC',1,'select dmmc as Value from tdmb where zdbz=''FFXS''','String','发放方式',1002,
'tDMB','tff_ryxx.fffs=dm_fffs.dm and dm_fffs.zdbz=''FFXS''','dm_fffs')
/


INSERT INTO tSYSField
(ID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLEID,TABLENAME,JOINCOND,ALIASTABLE)
VALUES
(100208,'JGMC',1,'select jgmc as Value from tff_wtffjg','String','委托发放机构',1002,
'tff_wtffjg','tff_ryxx.ffjgid=tff_wtffjg.FFJGID','tff_wtffjg')
/
INSERT INTO tSYSField
(ID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLEID,TABLENAME,JOINCOND,ALIASTABLE)
VALUES
(100209,'ZH',1,'','String','帐户',1002,'tff_ryxx','','tff_ryxx')
/
INSERT INTO tSYSField
(ID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLEID,TABLENAME,JOINCOND,ALIASTABLE)
VALUES
(100210,'KHH',1,'','String','开户行',1002,'tff_ryxx','','tff_ryxx')
/
INSERT INTO tSYSField
(ID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLEID,TABLENAME,JOINCOND,ALIASTABLE)
VALUES
(100211,'DMMC',1,'select dmmc as Value from tdmb where zdbz=''HB''','String','行别',1002,
'tDMB','tff_ryxx.hb=dm_hb.dm and dm_hb.zdbz=''HB''','dm_hb')
/
INSERT INTO tSYSField
(ID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLEID,TABLENAME,JOINCOND,ALIASTABLE)
VALUES
(100212,'SKR',1,'','String','收款人',1002,'tff_ryxx','','tff_ryxx')
/
INSERT INTO tSYSField
(ID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLEID,TABLENAME,JOINCOND,ALIASTABLE)
VALUES
(100213,'HRDD',1,'','String','汇入地点',1002,'tff_ryxx','','tff_ryxx')
/
INSERT INTO tSYSField
(ID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLEID,TABLENAME,JOINCOND,ALIASTABLE)
VALUES
(100214,'YZBM',1,'','String','邮政编码',1002,'tff_ryxx','','tff_ryxx')
/
INSERT INTO tSYSField
(ID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLEID,TABLENAME,JOINCOND,ALIASTABLE)
VALUES
(100215,'DZ',1,'','String','详细地址',1002,'tff_ryxx','','tff_ryxx')
/
INSERT INTO tSYSField
(ID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLEID,TABLENAME,JOINCOND,ALIASTABLE)
VALUES
(100216,'FFJE',1,'','Number','发放金额',1002,'tff_ryxx','','tff_ryxx')
/
INSERT INTO tSYSField
(ID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLEID,TABLENAME,JOINCOND,ALIASTABLE)
VALUES
(100217,'LJFFJE',1,'','Number','累计发放金额',1002,'tff_ryxx','','tff_ryxx')
/
INSERT INTO tSYSField
(ID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLEID,TABLENAME,JOINCOND,ALIASTABLE)
VALUES
(100218,'KSFFYF',1,'','Date','开始发放月份',1002,'tff_ryxx','','tff_ryxx')
/

INSERT INTO tSYSField
(ID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLEID,TABLENAME,JOINCOND,ALIASTABLE)
VALUES
(100219,'DMMC',1,'select dmmc as Value from tdmb where zdbz=''RYZT_FF''','String','人员状态',1002,
'tDMB','tff_ryxx.ryzt=dm_ryzt.dm and dm_ryzt.zdbz=''RYZT_FF''','dm_RYZT')