zhangqingyu
/
imp_yunwei
Watch 1
Star 0
Fork 0
Code Issues 0 Pull Requests 0 Releases 0 Wiki Activity
imp系统运维用到的sql文件版本仓库
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
2 Commits
1 Branch
Branch: master
Branches Tags
${ item.name }
Create branch ${ searchTerm }
from 'master'
${ noResults }
imp_yunwei/印花税查询.txt

印花税查询.txt 279B
Permalink History Raw

1234567891011 
  1. 印花税查询

  2. 

  3. select 

  4. a.foursname 我方名称 ,  a.ctName 客商名称 ,a.fno 销售合同号 , a.create_by_name  制单人 ,

  5. IFNULL(a.stampTaxAmt,0)  印花税金额 

  6. 

  7. from  salesContract a 

  8. 

  9. where ifnull(a.del_flag,0)<>1

  10. and ifnull(a.isinitDate,'')<>'是'

  11. and a.placed='2'