NC57开发部署涉及到的表
更新时间:2024-01-22 13:53:01 阅读量: 教育文库 文档下载
- nc57开发单据流程推荐度:
- 相关推荐
--公共参数
select * from pub_sysinittemp where initcode in ('SO100');
select * from pub_sysinit where pub_sysinit.sysinit in (select pk_sysinittemp from pub_sysinittemp where initcode in ('SO100'));
--系统注册
select * from sm_funcregister where (fun_code like '2006030102%') ; select * from PUB_SYSTEMPLATE where (funnode like '2006030102%'); select * from sm_butnregister where (fun_code like '2006030102%'); --公司建账
select * from sm_codetocode where funccode = 'yhzhwh' order by ts desc; select * from sm_createcorp where funccode = 'yhzhwh' order by ts desc;
--公司建账模块
select * from sm_codetocode where funccode = '39' ; select * from sm_createcorp where funccode = '39' ;
--delete from sm_codetocode where funccode = '39' ; --delete from sm_createcorp where funccode = '39' ;
--单据脚本
select * from pub_billtemplet where (nodecode in( '2006030102')) ;
select * from pub_billtemplet_b where pk_billtemplet in(select pk_billtemplet from pub_billtemplet where (nodecode in ('2006030102'))) ;
select * from pub_billtemplet_t where pk_billtemplet in(select pk_billtemplet from pub_billtemplet where (nodecode in ('2006030124'))); --查询脚本
select * from pub_query_templet where node_code like 'H205%' ;
select * from pub_query_condition where pk_templet in(select id from pub_query_templet where node_code like 'H205%') ;
--业务单据脚本
select * from bd_billtype where pk_billtypecode in('SKDJ'); select * from PUB_BILLACTION where pk_billtype in('SKDJ' );
select * from PUB_BILLCODE_RULE where pk_billtypecode in('SKDJ'); select * from PUB_BUSICLASS where pk_billtype in('SKDJ');
select * from dap_defitem where pk_billtype in('SKDJ');
select * from PUB_VOTABLE where pk_billtype like ('SKDJ%');
select * from DEV_VOTABLE where vtablename in('scf_endowment_b','scf_endowment'); select * from sm_busiworkflow order by ts desc ;
--打印模板根据主键ctemplateid来关联其他字表
select * from pub_print_template where vtemplatename in ('供应商订单确认');
select * from pub_print_cell where ctemplateid in (select ctemplateid from pub_print_template
where vtemplatename like '供应商订单确认');
select * from pub_print_datasource where ctemplateid in (select ctemplateid from pub_print_template where vtemplatename like '供应商订单确认');
select * from pub_print_variable where ctemplateid in (select ctemplateid from pub_print_template where vtemplatename like '供应商订单确认'); select * from pub_print_dataitem where vnodecode like 'H703%';
--select * from pub_print_region where ctemplateid in (select ctemplateid from pub_print_template where vtemplatename like '修订订单');
--select * from pub_print_line where ctemplateid in (select ctemplateid from pub_print_template where vtemplatename like '修订订单'); --业务流程
select * from bd_busitype where busicode like 'H2%';
select * from pub_billbusiness where pk_businesstype='0001AA1000000000LA7T';
select * from pub_billsource where billbusinessid='@@@@AA10000000001WO9' referbusinesstype='0001AA1000000001PLM6';
select * from pub_messagedrive where pk_businesstype='0001AA1000000000LA7T' ;
select * from pub_billtobillrefer; select * from pub_billactiongroup; select * from pub_billactionconfig; select * from pub_billaction; select * from pub_billcode_obj;
select * from bd_busitype order by ts desc select * from pub_busitrans
select * from sm_busiflow_nodes
select * from pub_wf_instance order by ts desc select * from pub_wf_def
select * from bd_billtype order by ts desc where nodecode like '4[A,B]%' select * from dap_dapsystem where funcode = 'H2'
select * from PUB_BILLACTION where pk_billtype like '4[A,B]%' order by ts desc
select * from PUB_BILLCODE_RULE where pk_billtypecode like '[H,T]9[H,Z][1,2,Q,S,]' order by ts desc
select * from PUB_BUSICLASS where pk_billtype like 'T9Z[1,2]' order by ts desc
select * from PUB_VOTABLE order by ts desc where pk_billtype like '[H,T]9[H,Z][1,2,Q,S,]' select * from DEV_VOTABLE where vtablename in('oa_mailinbox','oa_mailsent','oa_docpub_sub','oa_docpub','oa_bizhandle') order by ts desc
--预警平台 select * from PUB_ALERTTYPE where busi_plugin in('nc.bs.oa.sms.ReadMessage','nc.bs.oa.sms.SendMessagePlugin') order by ts desc
select * from PUB_ALERTTYPE_B where pk_alerttype in(select pk_alerttype from PUB_ALERTTYPE where busi_plugin in('nc.bs.oa.sms.ReadMessage','nc.bs.oa.sms.SendMessagePlugin')) order by ts desc
--自定义档案
select * from bd_defdoclist where doclistcode in('OA002') order by ts desc;
select * from bd_defdoc where pk_defdoclist in(select pk_defdoclist from bd_defdoclist where doclistcode in('OA002'));
select * from bd_refinfo where para1 in (select pk_defdoclist from bd_defdoclist where doclistcode = 'WLGS');
select * from bd_bdinfo where pk_defdef in (select pk_defdoclist from bd_defdoclist where doclistcode = 'WLGS');
--二次开发平台表
select * from dev_billinfo where vnodecode like 'H2%';
select * from dev_billbutton where pk_billinfo in (select pk_billinfo from dev_billinfo where vnodecode like 'H2%') ;
select * from dev_billdatainfo where pk_billinfo in (select pk_billinfo from dev_billinfo where vnodecode like 'H2%') ;
select * from dev_buttonreference where pk_billinfo in (select pk_billinfo from dev_billinfo where vnodecode like 'H2%') ;
select * from dev_projectinfo where root_nodecode='H2';
select * from dev_specialcheckrule where pk_billinfo in (select pk_billinfo from dev_billinfo where vnodecode like 'H2%') ;
select * from dev_uibutton order by ts desc;
select * from dev_uniquecheckrule where pk_billinfo in (select pk_billinfo from dev_billinfo where vnodecode like 'H2%') ;
select * from dev_votable where vtablename like 'scf_%';
--数据字典
select * from pub_datadict t where t.display like '%发票购入表%' or t.display like '%捐赠意向%' or t.display like '%募捐活动%'; select * from pub_datadictdetail t where t.reserved1 in ('scf_invoice','scf_disposition','scf_disposition_b','scf_endowment','scf_endowment_b');
--查询mde元数据
select * from mde_buttoninfo order by ts desc;
select * from mde_componentinfo order by ts desc;
select * from mde_funnodeuirelation order by ts desc;
select * from mde_privatebutton order by ts desc;
select * from mde_refinfo order by ts desc;
select * from mde_refinfo_cp order by ts desc;
select * from mde_refinfo_p order by ts desc;
select * from mde_specialcheckrule order by ts desc;
select * from mde_treeinfo order by ts desc;
select * from mde_resourceinfo order by ts desc;
select * from mde_uibaseinfo order by ts desc;
select * from mde_uifactoryinfo order by ts desc;
select * from mde_uiresource order by ts desc;
select * from mde_uniquecheckrule order by ts desc;
--查询md元数据
select * from md_accessorpara order by ts desc;
select * from md_association order by ts desc;
select * from md_bizitfmap order by ts desc;
select * from md_busioperation order by ts desc;
select * from md_class order by ts desc;
select * from md_column order by ts desc;
select * from md_component order by ts desc;
select * from md_db order by ts desc;
select * from md_db_relation order by ts desc;
select * from md_enumvalue order by ts desc;
select * from md_index order by ts desc;
select * from md_indexcolumn order by ts desc;
select * from md_lrs order by ts desc;
select * from md_module order by ts desc;
select * from md_operation order by ts desc;
select * from md_ormap order by ts desc;
select * from md_parameter order by ts desc;
select * from md_property order by ts desc;
select * from md_table order by ts desc;
select * from md_view order by ts desc;
select * from md_viewcolumn order by ts desc;
--查询外部系统信息设置
select * from xx_exsystem where exsystemcode='2022' and nvl(dr,0)=0; select * from xx_exsystem_b where pk_exsystem in(select pk_exsystem from xx_exsystem where exsystemcode='2022' and nvl(dr,0)=0)and nvl(dr,0)=0;
正在阅读:
NC57开发部署涉及到的表01-22
新海镇社区文化活动中心运行管理办法01-23
学校教务处工作总结8篇04-04
英语常用菜名收集04-03
VRB到PRB的映射12-28
全球医药公司排名05-17
六年级语文数学教学计划5则范文08-23
8B Unit7 Period2(Reading I)07-02
桁架钢筋混凝土叠合板叠合板方案10-20
- exercise2
- 铅锌矿详查地质设计 - 图文
- 厨余垃圾、餐厨垃圾堆肥系统设计方案
- 陈明珠开题报告
- 化工原理精选例题
- 政府形象宣传册营销案例
- 小学一至三年级语文阅读专项练习题
- 2014.民诉 期末考试 复习题
- 巅峰智业 - 做好顶层设计对建设城市的重要意义
- (三起)冀教版三年级英语上册Unit4 Lesson24练习题及答案
- 2017年实心轮胎现状及发展趋势分析(目录)
- 基于GIS的农用地定级技术研究定稿
- 2017-2022年中国医疗保健市场调查与市场前景预测报告(目录) - 图文
- 作业
- OFDM技术仿真(MATLAB代码) - 图文
- Android工程师笔试题及答案
- 生命密码联合密码
- 空间地上权若干法律问题探究
- 江苏学业水平测试《机械基础》模拟试题
- 选课走班实施方案
- 部署
- 涉及
- 开发
- NC57
- 北师大骨干教师培训心得体会
- 留守儿童委托监护责任书,一封信回执
- 区行政执法案卷评查工作总结
- 《建筑施工技术》教学大纲
- 民族理论与民族政策实践教学
- 4冲击钻成孔灌注桩作业指导书(最终)
- 观苏联亡党亡国20年祭心得体会
- 《灯光》评课
- 分析化学试卷2
- 总量可用单位1表示的分数除法问题 - 图文
- 赴吉林、黑龙江两省考察学习活动方案
- DX100使用维护说明书审定版
- 14-15学年八年级英语(牛津译林版,上册)期中试题(一)
- 南京师范大学古代文学导师作者
- 东莞市期末考试高三调研考试化学试题
- 第四章 气体动理论
- 人教版三年级数学上册教案全册
- 2013 - 2014学年高二学期赣州市十二县(市)期中联考 高二年级语文
- 农业财政资金项目申报标准文本(农产品质量安全追溯体系建设试点项目) - 图文
- 学习经验交流会新闻稿 - 图文