Dyn GP Post Vendor TEN99TYPE = NonEmployee Compensation

/*
Post SQL Task for setting TEN99TYPE and TEN99BOXNumber in Dynamics GP PM00200 to a Non-Employee Compensation type
Note this is dependent on Source data and is set as a post SQL Document Task with eOne SmartConnect
*/

UPDATE PM00200
SET TEN99TYPE = 5
, TEN99BOXNUMBER = 1
WHERE VENDORID = '_Request_VendorID'
AND TXIDNMBR <> ''