tsysfield_new.sql

来自「行业应急系统 包括: 应急系统（待遇核发） 发放系统 开」· SQL 代码 · 共 83 行

INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100201,1002,'RYID_FF',0,'','String','人员标识','tff_ryxx','','tff_ryxx')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100202,1002,'DWDM',1,'','String','组代码','tff_dwxx','dw_zdm.dwid_ff=tff_ryxx.dwid_ff','dw_zdm')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100203,1002,'DWMC',1,'','String','单位名称','tff_dwxx','dw_dwmc.dwid_ff=tff_ryxx.ssdwid',
'dw_dwmc')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100204,1002,'XM',1,'','String','姓名','tff_ryxx','','tff_ryxx')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100205,1002,'SFZH',1,'','String','身份证号','tff_ryxx','','tff_ryxx')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100206,1002,'HDJE',1,'','Number','核定金额','tff_ryxx','','tff_ryxx')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100208,1002,'JGMC',1,'select jgmc as Value from tff_wtffjg','String','委托发放机构',
'tff_wtffjg','tff_ryxx.ffjgid=tff_wtffjg.FFJGID','tff_wtffjg')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100209,1002,'ZH',1,'','String','帐户','tff_ryxx','','tff_ryxx')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100210,1002,'KHH',1,'','String','开户行','tff_ryxx','','tff_ryxx')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100212,1002,'SKR',1,'','String','收款人','tff_ryxx','','tff_ryxx')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100213,1002,'HRDD',1,'','String','汇入地点','tff_ryxx','','tff_ryxx')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100214,1002,'YZBM',1,'','String','邮政编码','tff_ryxx','','tff_ryxx')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100215,1002,'DZ',1,'','String','详细地址','tff_ryxx','','tff_ryxx')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100216,1002,'FFJE',1,'','Number','发放金额','tff_ryxx','','tff_ryxx')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100217,1002,'LJFFJE',1,'','Number','累计发放金额','tff_ryxx','','tff_ryxx')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100218,1002,'KSFFYF',1,'','Date','开始发放月份','tff_ryxx','','tff_ryxx')
/