SQL Scripts for Microsoft Dynamics GP: Unmatch and Unmark ABR Transaction Matches

This script is part of the SQL Scripts for Microsoft Dynamics GP where I will be posted the scripts I wrote against Microsoft Dynamics GP over the 19 years before I stopped working with Dynamics GP.

This script which unmatches and unmarks transactions and statement entries in the Advanced Bank Reconciliation module looks to be a variation of this one I posted in February of this year, although the one below is an older version. I think the difference is that this script also unmarks the transaction and statement items as well as removing the match.

/*
Created by Ian Grieve of azurecurve | Ramblings of an IT Professional (http://www.azurecurve.co.uk)
This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int).
*/
DECLARE @BANK VARCHAR(15) = 'CURRENT'

UPDATE
	NCABR012 --NC_Matched_GL_TRX (NCABR012)
SET
	NC_Match_Number = 0
	,NC_Matched = 0
WHERE
	BANKID = @BANK
AND
	NC_Matched > 0

UPDATE
	NCABR011 --NC Matched Statement Trx 11003k (NCABR011)
SET
	NC_Match_Number = 0
	,NC_Matched = 0
WHERE
	BANKID = @BANK
AND
	NC_Matched > 0
GO

DECLARE @BANK VARCHAR(15) = 'CURRENT'

UPDATE
	NCABR012 --NC_Matched_GL_TRX (NCABR012)
SET
	NC_Marked = 0
WHERE
	BANKID = @BANK
AND
	NC_Marked > 0

UPDATE
	NCABR011 --NC Matched Statement Trx 11003k (NCABR011)
SET
	NC_Marked = 0
WHERE
	BANKID = @BANK
AND
	NC_Marked > 0
GO