/*查询异常*/
Select * from RSM_GatheringBill
Where
    Amount<>ExtDecimalA
    and
    Code In
    (
        Select Distinct ChargeUpGatheringBillCode from RSM_SettleGatheringBillDetail Where ParentBillCode IN (Select Code From RSM_SettleGatheringBill Where IsChecked = '1')
    )

/*查询结算单记账情况*/
Select Amount,ExtDecimalA,* From RSM_GatheringBill Where Code = '结算单号'

/*查询总部记账情况以及回款销账*/
Select SettleAmount,* from RSM_SettleGatheringBillDetail Where ChargeUpGatheringBillCode = '结算单号'

Update RSM_GatheringBill Set ExtDecimalA = Amount Where Code = '结算单号'

EXEC SYS_SyncPushToShop_InsertAsSQL

门店编号,

'

Update RSM_GatheringBill Set ExtDecimalA = Amount Where Code = ''结算单号''

',

1000,

10