NC快速抽脚本

单据模板、查询模板

SELECT * FROM pub_billtemplet a WHERE a.pk_billtemplet = '';

SELECT * FROM pub_billtemplet_b a WHERE a.pk_billtemplet = '';

SELECT * FROM pub_billtemplet_t a WHERE a.pk_billtemplet = '';

SELECT * FROM pub_query_templet a WHERE a.id = '';

SELECT * FROM pub_query_condition a WHERE a.pk_templet = '';

SELECT * FROM pub_systemplate_base a WHERE a.funnode = '节点编码';

单据转换规则

表：pub_vochange;--src_billtype：源单据 dest_billtype：目的单据

select a.pk_vochange from pub_vochange a where a.dest_billtype = '4625' ;--查询单据转换规则主表主键

select * from pub_vochange a WHERE a.pk_vochange =''; --单据转换规则主表

select * from pub_vochange_b a where a.pk_vochange = '';--交换规则表

select * from pub_vochange_s a where a.pk_vochange = '';--分单规则表

select * from bd_billtype a where a.pk_billtypecode = 'HFP5';--查询上游单据的单据类型，主要查询字段：forwardbilltype

select * from pub_vosplititem where billtype = 'HFP5';--分单依据注册

单据按钮注册脚本

select cfunid,s.* from sm_funcregister s where s.fun_name like '%销售返利%';

select * from sm_butnregister where parent_id='1001ZZ1000000001JCAD';

查询某个VO字段，所有的枚举

select * from md_enumvalue a where a.id = ( select b.datatype from md_property b where b.name = '字段' and b.classid = (SELECT c.id FROM md_class c WHERE c.defaulttablename = '表名'));