IF OBJECTPROPERTY (OBJECT_ID('Tmp_RETURN_GOODS_IMAGES_DETAIL'),'ISTABLE') = 1 DROP TABLE Tmp_RETURN_GOODS_IMAGES_DETAIL
IF OBJECTPROPERTY (OBJECT_ID('Tmp_RETURN_GOODS_ADDLESS_DETAIL'),'ISTABLE') = 1 DROP TABLE Tmp_RETURN_GOODS_ADDLESS_DETAIL
IF OBJECTPROPERTY (OBJECT_ID('Tmp_RETURN_GOODS_ITEM_DETAIL'),'ISTABLE') = 1 DROP TABLE Tmp_RETURN_GOODS_ITEM_DETAIL
IF OBJECTPROPERTY (OBJECT_ID('Tmp_RETURN_GOODS_DETAIL'),'ISTABLE') = 1 DROP TABLE Tmp_RETURN_GOODS_DETAIL

Create Table Tmp_RETURN_GOODS_DETAIL (RtnSrNo Varchar(15),RtnCustCode Varchar(7),RtnDate DateTime,RtnSuppCode Varchar(7),RtnRemark Varchar(255),CompCode Varchar(7),RtnCurDate DateTime,RtnCurTime DateTime,RtnFirmCode Varchar(7),RtnFirmSrNo Varchar(15),RtnUName Varchar(255),EntNo Varchar(20),DEntNo Varchar(20),AEntNo Varchar(20),CompSrNo Varchar(15))
Create Table Tmp_RETURN_GOODS_ADDLESS_DETAIL (RtnSrNo Varchar(15),RtnBillNo Varchar(15),RtnGRAmt Money,RtnLrNo Varchar(25),RtnLRDate DateTime,RtnTranName Varchar(35),Status Varchar(7),CompCode Varchar(7),RtnISrNo Numeric(6),TaxableAmt Money,GSTPerc Money, GSTAmt Money)
Create Table Tmp_RETURN_GOODS_ITEM_DETAIL (RtnSrNo Varchar(15) ,ItemName Varchar(30),ItemPcs Money,ItemCut Money,ItemMts Money,ItemPer Varchar(1),ItemRate Money,ItemAmount Money,CompCode Varchar(7),ItemGroupName Varchar(30), RtnISrNo Numeric(6),RtnBSrNo Numeric(6),ItemFold Money,ItemFMts Money)
CREATE TABLE Tmp_RETURN_GOODS_IMAGES_DETAIL (RtnSrNo Varchar(15),RtnFirmCode Varchar(7),ImgPath Varchar(700))

INSERT INTO Tmp_RETURN_GOODS_DETAIL SELECT * FROM RETURN_GOODS_DETAIL
INSERT INTO Tmp_RETURN_GOODS_ITEM_DETAIL SELECT * FROM RETURN_GOODS_ITEM_DETAIL
INSERT INTO Tmp_RETURN_GOODS_ADDLESS_DETAIL SELECT * FROM RETURN_GOODS_ADDLESS_DETAIL
INSERT INTO Tmp_RETURN_GOODS_IMAGES_DETAIL SELECT * FROM RETURN_GOODS_IMAGES_DETAIL

IF OBJECTPROPERTY (OBJECT_ID('RETURN_GOODS_IMAGES_DETAIL'),'ISTABLE') = 1 DROP TABLE RETURN_GOODS_IMAGES_DETAIL
IF OBJECTPROPERTY (OBJECT_ID('RETURN_GOODS_ADDLESS_DETAIL'),'ISTABLE') = 1 DROP TABLE RETURN_GOODS_ADDLESS_DETAIL
IF OBJECTPROPERTY (OBJECT_ID('RETURN_GOODS_ITEM_DETAIL'),'ISTABLE') = 1 DROP TABLE RETURN_GOODS_ITEM_DETAIL
IF OBJECTPROPERTY (OBJECT_ID('RETURN_GOODS_DETAIL'),'ISTABLE') = 1 DROP TABLE RETURN_GOODS_DETAIL

Create Table RETURN_GOODS_DETAIL (RtnSrNo Varchar(15) Primary Key,RtnCustCode Varchar(7) Foreign Key References CUSTOMER_MASTER(CustCode),RtnDate DateTime,RtnSuppCode Varchar(7) Foreign Key References SUPPLIER_MASTER(SuppCode),RtnRemark Varchar(255),CompCode Varchar(7) Foreign Key References COMPANY_DETAIL(CompCode),RtnCurDate DateTime,RtnCurTime DateTime,RtnFirmCode Varchar(7),RtnFirmSrNo Varchar(15),RtnUName Varchar(255),EntNo Varchar(20),DEntNo Varchar(20),AEntNo Varchar(20),CompSrNo Varchar(15))
Create Table RETURN_GOODS_ADDLESS_DETAIL (RtnSrNo Varchar(15),RtnBillNo Varchar(15),RtnGRAmt Money,RtnLrNo Varchar(25),RtnLRDate DateTime,RtnTranName Varchar(35),Status Varchar(7),CompCode Varchar(7) Foreign key References COMPANY_DETAIL (CompCode),RtnISrNo Numeric(6),TaxableAmt Money,GSTPerc Money, GSTAmt Money)
Create Table RETURN_GOODS_ITEM_DETAIL (RtnSrNo Varchar(15) ,ItemName Varchar(30),ItemPcs Money,ItemCut Money,ItemMts Money,ItemPer Varchar(1),ItemRate Money,ItemAmount Money,CompCode Varchar(7) Foreign Key References COMPANY_DETAIL(CompCode),ItemGroupName Varchar(30), RtnISrNo Numeric(6),RtnBSrNo Numeric(6),ItemFold Money,ItemFMts Money)
CREATE TABLE RETURN_GOODS_IMAGES_DETAIL (RtnSrNo Varchar(15),RtnFirmCode Varchar(7),ImgPath Varchar(700))
            
INSERT INTO RETURN_GOODS_DETAIL SELECT * FROM Tmp_RETURN_GOODS_DETAIL
INSERT INTO RETURN_GOODS_ITEM_DETAIL SELECT * FROM Tmp_RETURN_GOODS_ITEM_DETAIL
INSERT INTO RETURN_GOODS_ADDLESS_DETAIL SELECT * FROM Tmp_RETURN_GOODS_ADDLESS_DETAIL
INSERT INTO RETURN_GOODS_IMAGES_DETAIL SELECT * FROM Tmp_RETURN_GOODS_IMAGES_DETAIL

IF OBJECTPROPERTY (OBJECT_ID('Tmp_RETURN_GOODS_IMAGES_DETAIL'),'ISTABLE') = 1 DROP TABLE Tmp_RETURN_GOODS_IMAGES_DETAIL
IF OBJECTPROPERTY (OBJECT_ID('Tmp_RETURN_GOODS_ADDLESS_DETAIL'),'ISTABLE') = 1 DROP TABLE Tmp_RETURN_GOODS_ADDLESS_DETAIL
IF OBJECTPROPERTY (OBJECT_ID('Tmp_RETURN_GOODS_ITEM_DETAIL'),'ISTABLE') = 1 DROP TABLE Tmp_RETURN_GOODS_ITEM_DETAIL
IF OBJECTPROPERTY (OBJECT_ID('Tmp_RETURN_GOODS_DETAIL'),'ISTABLE') = 1 DROP TABLE Tmp_RETURN_GOODS_DETAIL