nc57新单据脚本

select * from sm_funcregister where fun_code='H5161007';

select * from pub_billtemplet where nodecode='H5161007' ;

select * from pub_billtemplet_b where pk_billtemplet in （'0001Y91Z00000001IGNH','0001A21Z00000000CGXD');

select * from pub_billtemplet_t where pk_billtemplet in （'0001Y91Z00000001IGNH','0001A21Z00000000CGXD');

select * from pub_print_template where vnodecode='H5161007';

select * from pub_print_datasource where CTEMPLATEID='0001AA1000000000SRPO';

select * from pub_print_cell where CTEMPLATEID='0001AA1000000000SRPO';

select * from pub_print_dataitem where vnodecode='H5161007';

select * from pub_query_templet where NODE_CODE='H5161007';

select * from pub_query_condition where pk_templet='0001AA1000000000SRTP' ;

select * from pub_systemplate where FUNNODE='H5161007';

select * from bd_billtype where nodecode='H5161007';

select * from pub_votable where PK_billtype='9N1Z';

select * from pub_busiclass where PK_billtype='9N1Z';

select * from pub_billaction where PK_billtype='9N1Z';

select * from pub_billcode_rule where PK_billtypecode='9N1Z';

select * from pub_billactiongroup where PK_billtype='9N1Z';

select * from pub_billactionconfig where PK_BILLACTIONGROUP in ('0001AA1p00000000QTAB','0001AA1p00000000QTAN');

 

 

select * from pub_query_templet where NODE_CODE='H5161001';

 

delete from pub_query_condition where pk_templet in （'1001Y910000000P1JU5K','1001Y910000000P1JU5K'） ;