ALTER TABLE dbo.Vpos_eod_Bills ADD
	UploadServerYesNo bit NULL,
	UploadServerDate datetime NULL
GO
ALTER TABLE dbo.Vpos_eod_Bills ADD CONSTRAINT
	DF_Vpos_eod_Bills_UploadServerYesNo DEFAULT 0 FOR UploadServerYesNo
GO
ALTER TABLE dbo.Vpos_eod_Billdetails ADD
	UploadServerYesNo bit NULL,
	UploadServerDate datetime NULL
GO
ALTER TABLE dbo.Vpos_eod_Billdetails ADD CONSTRAINT
	DF_Vpos_eod_Billdetails_UploadServerYesNo DEFAULT 0 FOR UploadServerYesNo
GO
ALTER TABLE dbo.Vpos_eod_generaldetails ADD
	UploadServerYesNo bit NULL,
	UploadServerDate datetime NULL
GO
ALTER TABLE dbo.Vpos_eod_GeneralDetails ADD CONSTRAINT
	DF_Vpos_eod_GeneralDetails_UploadServerYesNo DEFAULT 0 FOR UploadServerYesNo
GO
ALTER TABLE dbo.Vstk_trs_Bills ADD
	UploadServerYesNo bit NULL,
	UploadServerDate datetime NULL
GO
ALTER TABLE dbo.Vstk_trs_Bills ADD CONSTRAINT
	DF_Vstk_trs_Bills_UploadServerYesNo DEFAULT ((0)) FOR UploadServerYesNo
GO
ALTER TABLE dbo.Vstk_trs_BillDetails ADD
	UploadServerYesNo bit NULL,
	UploadServerDate datetime NULL
GO
ALTER TABLE dbo.Vstk_trs_BillDetails ADD CONSTRAINT
	DF_Vstk_trs_BillDetails_UploadServerYesNo DEFAULT ((0)) FOR UploadServerYesNo
GO
ALTER TABLE dbo.Vpos_eod_Cashier ADD
	UploadServerYesNo bit NULL,
	UploadServerDate datetime NULL
GO
ALTER TABLE dbo.Vpos_eod_Cashier ADD CONSTRAINT
	DF_Vpos_eod_Cashier_UploadServerYesNo DEFAULT ((0)) FOR UploadServerYesNo
GO
ALTER TABLE dbo.Vloy_trs_Bills ADD
	UploadServerYesNo bit NULL,
	UploadServerDate datetime NULL
GO
ALTER TABLE dbo.Vloy_trs_Bills ADD CONSTRAINT
	DF_Vloy_trs_Bills_UploadServerYesNo DEFAULT ((0)) FOR UploadServerYesNo
GO
ALTER TABLE dbo.Vloy_trs_BillDetails ADD
	UploadServerYesNo bit NULL,
	UploadServerDate datetime NULL
GO
ALTER TABLE dbo.Vloy_trs_BillDetails ADD CONSTRAINT
	DF_Vloy_trs_BillDetails_UploadServerYesNo DEFAULT ((0)) FOR UploadServerYesNo
GO
ALTER TABLE dbo.Vpos_eod_Bills ADD
	AgentCode2 varchar(20) NULL,
	AgentName2 varchar(100) NULL
GO