pub_report_model.sql

制作报表和报表模版代码 制作报表和报表模版代码

insert into pub_report_model(PK_MODEL,PK_CORP,PK_TEMPLET,COLUMN_CODE,COLUMN_USER,COLUMN_SYSTEM,COLUMN_WIDTH,REPORT_POS,ITEM_ORDER,COLUMN_TYPE,DATA_TYPE,SELECT_TYPE,IF_DEFAULT,IF_MUST,IF_NO,COL_EXPRESSIONS,GROUP_ORDER,ORDER_ORDER,ORDER_TYPE,IF_SUM,NODE_CODE,USERDEFFLAG,TS,DR) values( '0001AA10000000023U1K','@@@@','0001AA10000000023U1J','cfunid','节点主键','节点主键',80,1,-1,0,0,2,'Y','N','N',null,null,null,null,null,'102244',null,'2005-09-06 16:00:49',0) ;
insert into pub_report_model(PK_MODEL,PK_CORP,PK_TEMPLET,COLUMN_CODE,COLUMN_USER,COLUMN_SYSTEM,COLUMN_WIDTH,REPORT_POS,ITEM_ORDER,COLUMN_TYPE,DATA_TYPE,SELECT_TYPE,IF_DEFAULT,IF_MUST,IF_NO,COL_EXPRESSIONS,GROUP_ORDER,ORDER_ORDER,ORDER_TYPE,IF_SUM,NODE_CODE,USERDEFFLAG,TS,DR) values( '0001AA10000000023U1L','@@@@','0001AA10000000023U1J','cbutnid','按钮主键','按钮主键',80,1,-1,0,0,2,'Y','N','N',null,null,null,null,null,'102244',null,'2005-09-06 16:00:49',0) ;
insert into pub_report_model(PK_MODEL,PK_CORP,PK_TEMPLET,COLUMN_CODE,COLUMN_USER,COLUMN_SYSTEM,COLUMN_WIDTH,REPORT_POS,ITEM_ORDER,COLUMN_TYPE,DATA_TYPE,SELECT_TYPE,IF_DEFAULT,IF_MUST,IF_NO,COL_EXPRESSIONS,GROUP_ORDER,ORDER_ORDER,ORDER_TYPE,IF_SUM,NODE_CODE,USERDEFFLAG,TS,DR) values( '0001AA10000000023U1M','@@@@','0001AA10000000023U1J','fun_code','节点编码','节点编码',80,1,1,0,0,1,'Y','N','N',null,null,null,null,null,'102244',null,'2005-09-06 16:00:49',0) ;
insert into pub_report_model(PK_MODEL,PK_CORP,PK_TEMPLET,COLUMN_CODE,COLUMN_USER,COLUMN_SYSTEM,COLUMN_WIDTH,REPORT_POS,ITEM_ORDER,COLUMN_TYPE,DATA_TYPE,SELECT_TYPE,IF_DEFAULT,IF_MUST,IF_NO,COL_EXPRESSIONS,GROUP_ORDER,ORDER_ORDER,ORDER_TYPE,IF_SUM,NODE_CODE,USERDEFFLAG,TS,DR) values( '0001AA10000000023U1N','@@@@','0001AA10000000023U1J','fun_name','节点名称','节点名称',80,1,3,0,0,1,'Y','N','N',null,null,null,null,null,'102244',null,'2005-09-06 16:00:49',0) ;
insert into pub_report_model(PK_MODEL,PK_CORP,PK_TEMPLET,COLUMN_CODE,COLUMN_USER,COLUMN_SYSTEM,COLUMN_WIDTH,REPORT_POS,ITEM_ORDER,COLUMN_TYPE,DATA_TYPE,SELECT_TYPE,IF_DEFAULT,IF_MUST,IF_NO,COL_EXPRESSIONS,GROUP_ORDER,ORDER_ORDER,ORDER_TYPE,IF_SUM,NODE_CODE,USERDEFFLAG,TS,DR) values( '0001AA10000000023U1O','@@@@','0001AA10000000023U1J','butn_name','按钮名称','按钮名称',80,1,7,0,0,1,'Y','N','N',null,null,null,null,null,'102244',null,'2005-09-06 16:00:49',0) ;
insert into pub_report_model(PK_MODEL,PK_CORP,PK_TEMPLET,COLUMN_CODE,COLUMN_USER,COLUMN_SYSTEM,COLUMN_WIDTH,REPORT_POS,ITEM_ORDER,COLUMN_TYPE,DATA_TYPE,SELECT_TYPE,IF_DEFAULT,IF_MUST,IF_NO,COL_EXPRESSIONS,GROUP_ORDER,ORDER_ORDER,ORDER_TYPE,IF_SUM,NODE_CODE,USERDEFFLAG,TS,DR) values( '0001AA10000000023U1P','@@@@','0001AA10000000023U1J','butn_code','按钮编码','按钮编码',80,1,5,0,0,1,'Y','N','N',null,null,null,null,null,'102244',null,'2005-09-06 16:00:49',0) ;
insert into pub_report_model(PK_MODEL,PK_CORP,PK_TEMPLET,COLUMN_CODE,COLUMN_USER,COLUMN_SYSTEM,COLUMN_WIDTH,REPORT_POS,ITEM_ORDER,COLUMN_TYPE,DATA_TYPE,SELECT_TYPE,IF_DEFAULT,IF_MUST,IF_NO,COL_EXPRESSIONS,GROUP_ORDER,ORDER_ORDER,ORDER_TYPE,IF_SUM,NODE_CODE,USERDEFFLAG,TS,DR) values( '0001AA10000000023U1Q','@@@@','0001AA10000000023U1J','fun_property','功能性质','功能性质',80,1,9,0,0,1,'Y','N','N',null,null,null,null,null,'102244',null,'2005-09-06 16:00:49',0) ;
insert into pub_report_model(PK_MODEL,PK_CORP,PK_TEMPLET,COLUMN_CODE,COLUMN_USER,COLUMN_SYSTEM,COLUMN_WIDTH,REPORT_POS,ITEM_ORDER,COLUMN_TYPE,DATA_TYPE,SELECT_TYPE,IF_DEFAULT,IF_MUST,IF_NO,COL_EXPRESSIONS,GROUP_ORDER,ORDER_ORDER,ORDER_TYPE,IF_SUM,NODE_CODE,USERDEFFLAG,TS,DR) values( '0001AA10000000023U1R','@@@@','0001AA10000000023U1J','help_name','帮助文件名','帮助文件名',80,1,11,0,0,1,'Y','N','N',null,null,null,null,null,'102244',null,'2005-09-06 16:00:49',0) ;