alter table  trans_b2beinvoice_mas add Syncflag bigint

Create table Response_ZenGst 
(
 Response_Id Bigint identity(1,1),
 Status Varchar(100),
 Message Varchar(500),
 Irn Varchar(500),
 AckDt Datetime,
 AckNo Varchar(50),
 EwbDt datetime,
 EwbNo Varchar(100),
 Status1  Varchar(50),
 Remarks Varchar(100),
 AckNoStr Varchar(100),
 InfoDtls  Varchar(100),
 EwbValidTill  Varchar(100),
 SignedQRCode Varchar(5000),
 SignedInvoice Varchar(5000),
 uuid Varchar(500),
 SignedQrCodeImgUrl Varchar(1000),
 InvoicePdfUrl Varchar(1000),
 IrnStatus  Varchar(100),
 EwbStatus Varchar(100),
 Irp Varchar(1000),
 InsertDate datetime
)


alter table Response_ZenGst add ehotelcode varchar(100)
alter table trans_b2beinvoice_mas add NotSyncflag bigint
alter table trans_b2beinvoice_mas add Reason Varchar(5000)