USE T202223

INSERT INTO COMMON.DBO.STATE_MASTER SELECT StateName, 'INDIA', StateCode FROM T202223.DBO.STATE_MASTER WHERE StateName COLLATE DATABASE_DEFAULT Not IN (SELECT StateName FROM COMMON.dbo.STATE_MASTER)
INSERT INTO T23S001.DBO.STATE_MASTER SELECT StateName, 'INDIA', StateCode FROM T202223.DBO.STATE_MASTER WHERE StateName COLLATE DATABASE_DEFAULT Not IN (SELECT StateName FROM T23S001.dbo.STATE_MASTER)

INSERT INTO COMMON.DBO.CITY_MASTER SELECT CityName, StateName, STDCode FROM T202223.DBO.CITY_MASTER WHERE CityName COLLATE DATABASE_DEFAULT Not IN (SELECT CityName FROM COMMON.dbo.CITY_MASTER)
INSERT INTO T23S001.DBO.CITY_MASTER SELECT CityName, StateName, STDCode FROM T202223.DBO.CITY_MASTER WHERE CityName COLLATE DATABASE_DEFAULT Not IN (SELECT CityName FROM T23S001.dbo.CITY_MASTER)

INSERT INTO COMMON.DBO.GROUP_MASTER SELECT SuppGrpCode, SuppGrpName, SuppAdd1, SuppAdd2, SuppAdd3, SuppCityName, SuppCityPin, SuppPhone, SuppMobile, SuppFax, SuppEmail, SuppResPhone, SuppPropMan, '-DIRECT', 0, 0, 0, '' FROM T202223.DBO.SUPPLIER_GROUP_MASTER WHERE SuppGrpCode COLLATE DATABASE_DEFAULT Not IN (SELECT GrpCode FROM COMMON.dbo.GROUP_MASTER)
INSERT INTO T23S001.DBO.GROUP_MASTER SELECT SuppGrpCode, SuppGrpName, SuppAdd1, SuppAdd2, SuppAdd3, SuppCityName, SuppCityPin, SuppPhone, SuppMobile, SuppFax, SuppEmail, SuppResPhone, SuppPropMan, '-DIRECT', 0, 0, 0, '' FROM T202223.DBO.SUPPLIER_GROUP_MASTER WHERE SuppGrpCode COLLATE DATABASE_DEFAULT Not IN (SELECT GrpCode FROM T23S001.dbo.GROUP_MASTER)

INSERT INTO COMMON.DBO.ACCOUNT_MASTER SELECT SuppCode, SuppName, 'SUNDRY DEBTORS', '-DIRECT', SuppGrpCode, SuppAdd1, SuppAdd2, SuppAdd3, SuppCityName, SuppCityPin, SuppPhone, SuppMobile, SuppFax, SuppEmail, SuppResPhone, SuppGSTNo, SuppCSTNo, SuppPANNo, SuppVATNo, SuppPropMan, '', 0, 0, SuppVATNo, SuppCSTNo, 'NO', '', '', SuppDisc, SuppPcsRD, SuppMtrRD, '', Dhara, Days, '', '', '', '', '', 0, BlackListed, '', 0, '', CommPerc, 0, BankName, BankAccNo, BankIFSCCode, BankBranch, 0, PackPerPcs, 0, 0, 0, 0, 'N', SuppGSTNo, 'NO', 'TAXABLE SUPPLY', '', '', SuppPropMan, 0, '', 0, 'PAYMENT' FROM T202223.DBO.SUPPLIER_MASTER WHERE SuppCode COLLATE DATABASE_DEFAULT Not IN (SELECT AccCode FROM COMMON.dbo.ACCOUNT_MASTER)
INSERT INTO T23S001.DBO.ACCOUNT_MASTER SELECT SuppCode, SuppName, 'SUNDRY DEBTORS', '-DIRECT', SuppGrpCode, SuppAdd1, SuppAdd2, SuppAdd3, SuppCityName, SuppCityPin, SuppPhone, SuppMobile, SuppFax, SuppEmail, SuppResPhone, SuppGSTNo, SuppCSTNo, SuppPANNo, SuppVATNo, SuppPropMan, '', 0, 0, 0, 'Dr', 0, SuppVATNo, SuppCSTNo, 'NO', '', '', SuppDisc, SuppPcsRD, SuppMtrRD, '', Dhara, Days, '', '', '', '', '', 0, BlackListed, '', 0, '', CommPerc, 0, BankName, BankAccNo, BankIFSCCode, BankBranch, 0, PackPerPcs, 0, 0, 0, 0, 'N', SuppGSTNo, 'NO', 'TAXABLE SUPPLY', '', '', SuppPropMan, 0, '', 0, 'PAYMENT' FROM T202223.DBO.SUPPLIER_MASTER WHERE SuppCode COLLATE DATABASE_DEFAULT Not IN (SELECT AccCode FROM T23S001.dbo.ACCOUNT_MASTER)