IF OBJECTPROPERTY (OBJECT_ID('Tmp_RECEIVED_IMAGES_DETAIL'),'ISTABLE') = 1 DROP TABLE Tmp_RECEIVED_IMAGES_DETAIL
IF OBJECTPROPERTY (OBJECT_ID('Tmp_RECEIVED_ADDLESS_DETAIL'),'ISTABLE') = 1 DROP TABLE Tmp_RECEIVED_ADDLESS_DETAIL
IF OBJECTPROPERTY (OBJECT_ID('Tmp_RECEIVED_PAYMENT_DETAIL'),'ISTABLE') = 1 DROP TABLE Tmp_RECEIVED_PAYMENT_DETAIL
IF OBJECTPROPERTY (OBJECT_ID('Tmp_RECEIVED_DETAIL'),'ISTABLE') = 1 DROP TABLE Tmp_RECEIVED_DETAIL

Create Table Tmp_RECEIVED_DETAIL (RecSrNo Varchar(15),RecCustCode Varchar(7),RecCashCheque Varchar(700),RecAmt Money,RecDate DateTime,RecChequeNo Varchar(700),RecBankName Varchar(700),RecSuppCode Varchar(7),RecRemark Varchar(255),RecGRReceived Varchar(3),RecFirmCode Varchar(7),RecFirmSrNo Varchar(6),CompCode Varchar(7),RecCurDate DateTime,RecCurTime DateTime,RecUName Varchar(255),RecBrokerPerc Money,RecBrokerAmt Money,PackChrg Money,CompSrNo Varchar(15),RecExcess Money,EntNo Varchar(20),BrokLessPerc Money,BrokLessAmt Money,NeftRtgs Varchar(1),GSTPerc Money)
Create Table Tmp_RECEIVED_ADDLESS_DETAIL(RecSrNo Varchar(15),RecBillNo Varchar(15),GRLess Money,RateDiff Money,ClaimLess Money,DiscPerc Money,DiscAmt Money,BankComm Money,PackTrans Money,OtherLess Money,AddIntPerc Money,AddIntAmt Money,OtherAdd Money,PaidAmt Money,Status Varchar(7),CompCode Varchar(7))
CREATE TABLE Tmp_RECEIVED_PAYMENT_DETAIL (RecSrNo Varchar(15),RecISrNo Numeric(6),RecCashCheque Varchar(700),RecChequeNo Varchar(700),RecDate DateTime,RecBankName Varchar(700),RecAmt Money,CompCode Varchar(7))
CREATE TABLE Tmp_RECEIVED_IMAGES_DETAIL (RecSrNo Varchar(15),RecFirmCode Varchar(7),ImgPath Varchar(700))
    
INSERT INTO Tmp_RECEIVED_DETAIL SELECT * FROM RECEIVED_DETAIL
INSERT INTO Tmp_RECEIVED_PAYMENT_DETAIL SELECT * FROM RECEIVED_PAYMENT_DETAIL
INSERT INTO Tmp_RECEIVED_ADDLESS_DETAIL SELECT * FROM RECEIVED_ADDLESS_DETAIL
INSERT INTO Tmp_RECEIVED_IMAGES_DETAIL SELECT * FROM RECEIVED_IMAGES_DETAIL

IF OBJECTPROPERTY (OBJECT_ID('RECEIVED_IMAGES_DETAIL'),'ISTABLE') = 1 DROP TABLE RECEIVED_IMAGES_DETAIL
IF OBJECTPROPERTY (OBJECT_ID('RECEIVED_ADDLESS_DETAIL'),'ISTABLE') = 1 DROP TABLE RECEIVED_ADDLESS_DETAIL
IF OBJECTPROPERTY (OBJECT_ID('RECEIVED_PAYMENT_DETAIL'),'ISTABLE') = 1 DROP TABLE RECEIVED_PAYMENT_DETAIL
IF OBJECTPROPERTY (OBJECT_ID('RECEIVED_DETAIL'),'ISTABLE') = 1 DROP TABLE RECEIVED_DETAIL

Create Table RECEIVED_DETAIL (RecSrNo Varchar(15) Primary Key,RecCustCode Varchar(7) Foreign Key References CUSTOMER_MASTER(CustCode),RecCashCheque Varchar(700),RecAmt Money,RecDate DateTime,RecChequeNo Varchar(700),RecBankName Varchar(700),RecSuppCode Varchar(7) Foreign Key References SUPPLIER_MASTER(SuppCode),RecRemark Varchar(255),RecGRReceived Varchar(3),RecFirmCode Varchar(7),RecFirmSrNo Varchar(6),CompCode Varchar(7) Foreign Key References COMPANY_DETAIL(CompCode),RecCurDate DateTime,RecCurTime DateTime,RecUName Varchar(255),RecBrokerPerc Money,RecBrokerAmt Money,PackChrg Money,CompSrNo Varchar(15),RecExcess Money,EntNo Varchar(20),BrokLessPerc Money,BrokLessAmt Money,NeftRtgs Varchar(1),GSTPerc Money)
Create Table RECEIVED_ADDLESS_DETAIL(RecSrNo Varchar(15),RecBillNo Varchar(15),GRLess Money,RateDiff Money,ClaimLess Money,DiscPerc Money,DiscAmt Money,BankComm Money,PackTrans Money,OtherLess Money,AddIntPerc Money,AddIntAmt Money,OtherAdd Money,PaidAmt Money,Status Varchar(7),CompCode Varchar(7) Foreign key References COMPANY_DETAIL (CompCode))
CREATE TABLE RECEIVED_PAYMENT_DETAIL (RecSrNo Varchar(15),RecISrNo Numeric(6),RecCashCheque Varchar(700),RecChequeNo Varchar(700),RecDate DateTime,RecBankName Varchar(700),RecAmt Money,CompCode Varchar(7) Foreign key References COMPANY_DETAIL (CompCode))
CREATE TABLE RECEIVED_IMAGES_DETAIL (RecSrNo Varchar(15),RecFirmCode Varchar(7),ImgPath Varchar(700))
            
INSERT INTO RECEIVED_DETAIL SELECT * FROM Tmp_RECEIVED_DETAIL
INSERT INTO RECEIVED_PAYMENT_DETAIL SELECT * FROM Tmp_RECEIVED_PAYMENT_DETAIL
INSERT INTO RECEIVED_ADDLESS_DETAIL SELECT * FROM Tmp_RECEIVED_ADDLESS_DETAIL
INSERT INTO RECEIVED_IMAGES_DETAIL SELECT * FROM Tmp_RECEIVED_IMAGES_DETAIL

IF OBJECTPROPERTY (OBJECT_ID('Tmp_RECEIVED_IMAGES_DETAIL'),'ISTABLE') = 1 DROP TABLE Tmp_RECEIVED_IMAGES_DETAIL
IF OBJECTPROPERTY (OBJECT_ID('Tmp_RECEIVED_ADDLESS_DETAIL'),'ISTABLE') = 1 DROP TABLE Tmp_RECEIVED_ADDLESS_DETAIL
IF OBJECTPROPERTY (OBJECT_ID('Tmp_RECEIVED_PAYMENT_DETAIL'),'ISTABLE') = 1 DROP TABLE Tmp_RECEIVED_PAYMENT_DETAIL
IF OBJECTPROPERTY (OBJECT_ID('Tmp_RECEIVED_DETAIL'),'ISTABLE') = 1 DROP TABLE Tmp_RECEIVED_DETAIL
    
IF OBJECTPROPERTY (OBJECT_ID('Tmp_CHEQUE_RETURN_DETAIL'),'ISTABLE') = 1 DROP TABLE Tmp_CHEQUE_RETURN_DETAIL
Create Table Tmp_CHEQUE_RETURN_DETAIL (PaySrNo Varchar(15),CurDate DateTime,ChqCustCode Varchar(7),ChqSuppCode Varchar(7),ChqBillNo Varchar(15),ChqNo Varchar(255),ChqBank Varchar(25),ChqAmt Money,ChqDate DateTime,ChqRemark Varchar(255),CompCode Varchar(7),ComPaid Varchar(3),FirmCode Varchar(7))
INSERT INTO Tmp_CHEQUE_RETURN_DETAIL SELECT * FROM CHEQUE_RETURN_DETAIL
IF OBJECTPROPERTY (OBJECT_ID('CHEQUE_RETURN_DETAIL'),'ISTABLE') = 1 DROP TABLE CHEQUE_RETURN_DETAIL
Create Table CHEQUE_RETURN_DETAIL (PaySrNo Varchar(15),CurDate DateTime,ChqCustCode Varchar(7) Foreign Key References CUSTOMER_MASTER(CustCode),ChqSuppCode Varchar(7) Foreign Key References SUPPLIER_MASTER(SuppCode),ChqBillNo Varchar(15),ChqNo Varchar(255),ChqBank Varchar(25),ChqAmt Money,ChqDate DateTime,ChqRemark Varchar(255),CompCode Varchar(7) Foreign Key References COMPANY_DETAIL(CompCode),ComPaid Varchar(3),FirmCode Varchar(7))
INSERT INTO CHEQUE_RETURN_DETAIL SELECT * FROM Tmp_CHEQUE_RETURN_DETAIL
IF OBJECTPROPERTY (OBJECT_ID('Tmp_CHEQUE_RETURN_DETAIL'),'ISTABLE') = 1 DROP TABLE Tmp_CHEQUE_RETURN_DETAIL
ALTER TABLE BROKERAGE_ADDLESS_DETAIL ALTER COLUMN PaySrNo Varchar(15)
ALTER TABLE RECEIVED_DETAIL ALTER COLUMN CompSrNo Varchar(15)
ALTER TABLE RECEIVED_DETAIL ALTER COLUMN RecFirmSrNo Varchar(15)
ALTER TABLE RETURN_GOODS_DETAIL ALTER COLUMN RtnFirmSrNo Varchar(15)
ALTER TABLE RETURN_GOODS_DETAIL ALTER COLUMN CompSrNo Varchar(15)