SQL Scripts for Microsoft Dynamics GP: Sales Transactions (Work) Against a Specific Site

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 was created for a client who was closing some sites and wanted to get a list of all Work status sales transactions against a specific site.

/*
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 @LOCNCODE VARCHAR(10) = 'Z%'

SELECT
	SOP101.CUSTNMBR
	,SOP101.CUSTNAME
	,SOP102.SOPNUMBE, SOP102.LNITMSEQ, SOP102.LOCNCODE, SOP102.ITEMNMBR
FROM
	SOP10200 AS SOP102 -- Sales Transaction Amounts Work (SOP10200)
INNER JOIN
	SOP10100 AS SOP101 -- Sales Transaction Work (SOP10100)
		ON SOP101.SOPNUMBE = SOP102.SOPNUMBE
WHERE
	SOP102.LOCNCODE LIKE @LOCNCODE
ORDER BY
	SOP101.CUSTNAME,SOP102.SOPNUMBE