西软XMS删除过夜审的账单SQL

##################################
    #删除过夜审账单，不建议删除过很久的账单，不然试算平衡表要重新计算，进入维护模块，找到年月累计维护，重建试算平衡报表年月累计
    #account 账户或主单编号
    #billno     账单编号
    #B1811070007  C000019
    #获取指定日期试算平衡表,必须手动修改。修改试算平衡表收入
    select hotelid,date,type,code,grp1,descript,descript1,descript2,sum(day) as days from ytrial_balance where hotelid='H000001'  and date='2018-11-07'  GROUP BY if(grp1<>'',grp1,type),    code  order by if(grp1<>'',grp1,type),code
    SELECT * from ytrial_balance WHERE date='2018-11-07'

    #试算平衡表当天
    select * from ytrial_balance

    #历史主单数据
    SELECT * FROM `hmaster` WHERE accnt ='C000019' #必须删除7
    #AR数据
    select * from ar_account where crtaccnt ='C000019'
    #账单号对应表
    SELECT * FROM billno where accnt ='C000019' AND billno ='B1811070007'#必须删除2
    #夜审账务，还两个表，什么鬼东西,营业日期的夜审核
    SELECT * FROM gltemp WHERE crtaccnt ='C000019' #必须删除3
    SELECT * FROM outtemp WHERE crtaccnt ='C000019' #必须删除4
    #账务表
        SELECT * FROM account WHERE accnt ='C000019' AND billno ='B1811070007' #必须删除1
        SELECT * FROM haccount WHERE accnt ='C000019' AND billno ='B1811070007'
        SELECT * FROM haccount_a WHERE accnt ='C000019' AND billno ='B1811070007'
        SELECT * FROM haccount_c WHERE accnt ='C000019' AND billno ='B1811070007'

    #AR账务明细
        SELECT * FROM har_account WHERE crtaccnt ='C000019'
    #没有卵用，貌似是local
    #SELECT * FROM loc_account WHERE crtaccnt ='C000014'

    #储值卡消费明细
        SELECT * FROM vipcard_ar_detail WHERE  fmbillno ='B1811070007' AND fo_accnt='C000019' #必须删除5

    ###########################################
    #修改储值卡金额
    #储值卡明细,去找对应的araccnt1 ID A0000000675
    SELECT * from vipcard WHERE `NO`='2016121990'
    #储值卡主单,明细里面的araccnt1 ID,修改charge字段
    SELECT * FROM vipcard_ar_master WHERE accnt='A0000000675' #charge修改成消费金额
    #为会员卡充值,balance字段顺延修改余额 charge,credit,balance
    select * FROM vipcard_ar_detail WHERE cardno ='2016121990'

    #系统日志
    SELECT * FROM sys_lgfl WHERE descript like 'C000019%' AND newvalue like '%B1811070007%' #必须删除6
landv / landv.github.io

西软XMS删除过夜审的账单SQL #58
