中信-货款查询

admin

//查询已处理货款金额
select sum (amount) from LJBUSAMOUNT where CLS like '%商贸货款%'
and ACCOUNTID_T='J00043100001702'  AND STATE ='处理成功' and MEMO like '配送额%'
  and createtime<'2023/11/30 23:59:59'


//查询已处理退货款金额
select sum (amount) from LJBUSAMOUNT where CLS like '%商贸货款%'
and ACCOUNTID_S='J00043100001702'  AND STATE ='处理成功' and MEMO like '退配送额%'