NC常用脚本-查询凭证后续业务.sql.txtVIP免费

selectpk_voucherfromgl_vouchervwherev.year='2015'andv.period='07'andv.num=12andv.pk_accountingbookin(selectpk_accountingbookfromorg_accountingbookwherecode='账簿编码')select'会计平台日志-目标系统'||a.des_system||'-单据类型'||a.des_billtypeasdescname,a.src_relationidassrcidfromfip_operatinglogawherea.src_relationidin(selectt.pk_detailfromgl_detailtwheret.pk_voucher='1002N91000000009774S')unionselect'会计平台-目标系统'||a.des_system||'-单据类型'||a.des_billtypeasdescname,a.src_relationidassrcidfromfip_relationawherea.src_relationidin(selectt.pk_detailfromgl_detailtwheret.pk_voucher='1002N91000000009774S')unionselect'协同'asdescname,pk_detailselfassrcidfromgl_reconoccursubtwheret.pk_detailselfin(selectt.pk_detailfromgl_detailtwheret.pk_voucher='1002N91000000009774S')ort.pk_detailotherin(selectt.pk_detailfromgl_detailtwheret.pk_voucher='1002N91000000009774S')unionselect'核销'asdescname,pk_detailassrcidfromgl_verify_logtwheret.pk_detailin(selectt.pk_detailfromgl_detailtwheret.pk_voucher='1002N91000000009774S')unionselect'内部交易对账'asdescname,pk_detailassrcidfromgl_contrastdatawhereiscontrasted='Y'andpk_detailin(selectt.pk_detailfromgl_detailtwheret.pk_voucher='1002N91000000009774S')unionselect'现金'asdescname,fk_detailassrcidfromgl_contrastwherefk_detailin(selectt.pk_detailfromgl_detailtwheret.pk_voucher='1002N91000000009774S');