/*
   Thursday, 23 August, 200705:47:54 PM
   User: sa
   Server: notebook
   Database: DemoFnbData
   Application: 
*/

/* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vpos_Trs_AdvanceBills ADD
	PostBillNo varchar(20) NULL,
	PostTrsNo varchar(100) NULL
GO
ALTER TABLE dbo.vpos_Trs_AdvanceBillDetails ADD
	AdvStatus bit NULL,
	AdvDateTime datetime NULL
GO
ALTER TABLE dbo.Vpos_Trs_GeneralDetails ADD
	DepositPaymentYesNo bit NULL
GO
ALTER TABLE dbo.Vpos_Trs_GeneralDetails ADD CONSTRAINT
	DF_Vpos_Trs_GeneralDetails_DepositPaymentYesNo DEFAULT 0 FOR DepositPaymentYesNo
GO
ALTER TABLE dbo.Vpos_eod_GeneralDetails ADD
	DepositPaymentYesNo bit NULL
GO
ALTER TABLE dbo.Vpos_eod_GeneralDetails ADD CONSTRAINT
	DF_Vpos_eod_GeneralDetails_DepositPaymentYesNo DEFAULT 0 FOR DepositPaymentYesNo
GO
ALTER TABLE dbo.vpos_Trs_AdvanceBillDetails ADD CONSTRAINT
	DF_vpos_Trs_AdvanceBillDetails_AdvStatus DEFAULT 0 FOR AdvStatus
GO
COMMIT
select Has_Perms_By_Name(N'dbo.vpos_Trs_AdvanceBills', 'Object', 'ALTER') as ALT_Per, Has_Perms_By_Name(N'dbo.vpos_Trs_AdvanceBills', 'Object', 'VIEW DEFINITION') as View_def_Per, Has_Perms_By_Name(N'dbo.vpos_Trs_AdvanceBills', 'Object', 'CONTROL') as Contr_Per 


DELETE FROM Vs_DefaultAccess WHERE (DefaultNo=87) and DefaultType='L'
INSERT INTO Vs_DefaultAccess (DefaultName,DefaultNo,DefaultType,DisplayNo,ctype) VALUES('[L87] EOD Prompt if pickup not completed',87,'L',87,'OOXXXXXXXX')
UPDATE VPOS_MT_REPORT SET DisableReport=0 WHERE RptCode='RV003'
update vs_defaultaccess set Defaultname='[G3] Stock' WHERE Defaulttype='G' AND DefaultNo=3