UPDATE GREY_PURCHASE Set GSTSupplyType=T1.F2 FROM (SELECT AccCode AS F1, 'UNREGISTERED' AS F2 FROM ACCOUNT_MASTER WHERE GSTIN='' UNION SELECT AccCode AS F1, 'REGISTERED' AS F2 FROM ACCOUNT_MASTER WHERE GSTIN<>'' AND CompScheme='NO' UNION SELECT AccCode AS F1, 'COMPOSITE' AS F2 FROM ACCOUNT_MASTER WHERE GSTIN<>'' AND CompScheme='YES') AS T1 WHERE T1.F1=WeaverCode
UPDATE FINISHED_PURCHASE Set GSTSupplyType=T1.F2 FROM (SELECT AccCode AS F1, 'UNREGISTERED' AS F2 FROM ACCOUNT_MASTER WHERE GSTIN='' UNION SELECT AccCode AS F1, 'REGISTERED' AS F2 FROM ACCOUNT_MASTER WHERE GSTIN<>'' AND CompScheme='NO' UNION SELECT AccCode AS F1, 'COMPOSITE' AS F2 FROM ACCOUNT_MASTER WHERE GSTIN<>'' AND CompScheme='YES') AS T1 WHERE T1.F1=WeaverCode
UPDATE RECEIVED_FROM_JOB Set GSTSupplyType=T1.F2 FROM (SELECT AccCode AS F1, 'UNREGISTERED' AS F2 FROM ACCOUNT_MASTER WHERE GSTIN='' UNION SELECT AccCode AS F1, 'REGISTERED' AS F2 FROM ACCOUNT_MASTER WHERE GSTIN<>'' AND CompScheme='NO' UNION SELECT AccCode AS F1, 'COMPOSITE' AS F2 FROM ACCOUNT_MASTER WHERE GSTIN<>'' AND CompScheme='YES') AS T1 WHERE T1.F1=JobCode
UPDATE GP_RECEIVED_FROM_MILL Set GSTSupplyType=T1.F2 FROM (SELECT AccCode AS F1, 'UNREGISTERED' AS F2 FROM ACCOUNT_MASTER WHERE GSTIN='' UNION SELECT AccCode AS F1, 'REGISTERED' AS F2 FROM ACCOUNT_MASTER WHERE GSTIN<>'' AND CompScheme='NO' UNION SELECT AccCode AS F1, 'COMPOSITE' AS F2 FROM ACCOUNT_MASTER WHERE GSTIN<>'' AND CompScheme='YES') AS T1 WHERE T1.F1=MillCode
UPDATE GENERAL_PURCHASE Set GSTSupplyType=T1.F2 FROM (SELECT AccCode AS F1, 'UNREGISTERED' AS F2 FROM ACCOUNT_MASTER WHERE GSTIN='' UNION SELECT AccCode AS F1, 'REGISTERED' AS F2 FROM ACCOUNT_MASTER WHERE GSTIN<>'' AND CompScheme='NO' UNION SELECT AccCode AS F1, 'COMPOSITE' AS F2 FROM ACCOUNT_MASTER WHERE GSTIN<>'' AND CompScheme='YES') AS T1 WHERE T1.F1=SuppCode
UPDATE BILL_DETAIL Set GSTSupplyType=T1.F2 FROM (SELECT AccCode AS F1, 'UNREGISTERED' AS F2 FROM ACCOUNT_MASTER WHERE GSTIN='' UNION SELECT AccCode AS F1, 'REGISTERED' AS F2 FROM ACCOUNT_MASTER WHERE GSTIN<>'' AND CompScheme='NO' UNION SELECT AccCode AS F1, 'COMPOSITE' AS F2 FROM ACCOUNT_MASTER WHERE GSTIN<>'' AND CompScheme='YES') AS T1 WHERE T1.F1=CustCode
UPDATE GREY_PURCHASE_RETURN_GOODS_DETAIL Set GSTSupplyType=T1.F2 FROM (SELECT AccCode AS F1, 'UNREGISTERED' AS F2 FROM ACCOUNT_MASTER WHERE GSTIN='' UNION SELECT AccCode AS F1, 'REGISTERED' AS F2 FROM ACCOUNT_MASTER WHERE GSTIN<>'' AND CompScheme='NO' UNION SELECT AccCode AS F1, 'COMPOSITE' AS F2 FROM ACCOUNT_MASTER WHERE GSTIN<>'' AND CompScheme='YES') AS T1 WHERE T1.F1=BkAccCode
UPDATE FINISHED_PURCHASE_RETURN_GOODS_DETAIL Set GSTSupplyType=T1.F2 FROM (SELECT AccCode AS F1, 'UNREGISTERED' AS F2 FROM ACCOUNT_MASTER WHERE GSTIN='' UNION SELECT AccCode AS F1, 'REGISTERED' AS F2 FROM ACCOUNT_MASTER WHERE GSTIN<>'' AND CompScheme='NO' UNION SELECT AccCode AS F1, 'COMPOSITE' AS F2 FROM ACCOUNT_MASTER WHERE GSTIN<>'' AND CompScheme='YES') AS T1 WHERE T1.F1=BkAccCode
UPDATE RECEIVED_RETURN_GOODS_DETAIL Set GSTSupplyType=T1.F2 FROM (SELECT AccCode AS F1, 'UNREGISTERED' AS F2 FROM ACCOUNT_MASTER WHERE GSTIN='' UNION SELECT AccCode AS F1, 'REGISTERED' AS F2 FROM ACCOUNT_MASTER WHERE GSTIN<>'' AND CompScheme='NO' UNION SELECT AccCode AS F1, 'COMPOSITE' AS F2 FROM ACCOUNT_MASTER WHERE GSTIN<>'' AND CompScheme='YES') AS T1 WHERE T1.F1=BkAccCode
UPDATE MULTI_JOURNAL_DETAIL Set GSTSupplyType=T1.F2 FROM (SELECT AccCode AS F1, 'UNREGISTERED' AS F2 FROM ACCOUNT_MASTER WHERE GSTIN='' UNION SELECT AccCode AS F1, 'REGISTERED' AS F2 FROM ACCOUNT_MASTER WHERE GSTIN<>'' AND CompScheme='NO' UNION SELECT AccCode AS F1, 'COMPOSITE' AS F2 FROM ACCOUNT_MASTER WHERE GSTIN<>'' AND CompScheme='YES') AS T1 WHERE T1.F1=BkAccCode