⬅ Back Year End Not Transfer-CR.sql
use T21L001

INSERT INTO RECEIVED_CASH_BOOK_DETAIL SELECT '90758' AS Expr1, BkAccCode, BkCashAccCode, BkCashAmt, BkCashDate, BkRemark, BkCurDate, BkCurTime, BkUName, BkTCSPerc, BkTCSAmt FROM RECEIVED_CASH_BOOK_DETAIL WHERE (BkSrNo = '00758')
INSERT INTO RECEIVED_CASH_BOOK_ADDLESS_DETAIL SELECT  '90758' AS Expr1, BkBillNo, BkDiscPerc, BkDiscPercAmt, BkRateDiff, BkClaimLess, BkBankCommission, BkAddInterestPerc, BkAddInterestPercAmt, BkBillPaidAmt, BkStatus, BkDisBal, BkRDBal, BkGRBal, BkIntBal, DisputeRemark, BkTDSAmt, BkTCSCalcOn, BkTCSPerc, BkTCSAmt FROM RECEIVED_CASH_BOOK_ADDLESS_DETAIL WHERE (BkSrNo = '00758')

DELETE FROM RECEIVED_CASH_BOOK_ADDLESS_DETAIL WHERE (BkSrNo = '00758')
DELETE FROM RECEIVED_CASH_BOOK_DETAIL WHERE (BkSrNo = '00758')