DELETE FROM Vs_DefaultAccess WHERE (DefaultNo=76) and DefaultType='A'
INSERT INTO Vs_DefaultAccess (DefaultName,DefaultNo,DefaultType,DisplayNo,ctype) 
VALUES('[A76] Allow Stock Entry',76,'A',76,'OOXXXXXXXX')

DELETE FROM Vs_DefaultAccess WHERE (DefaultNo=77) and DefaultType='A'
INSERT INTO Vs_DefaultAccess (DefaultName,DefaultNo,DefaultType,DisplayNo,ctype) 
VALUES('[A77] Allow Custody Entry',77,'A',77,'OOXXXXXXXX')

ALTER TABLE dbo.Vpos_mt_Device ADD
	TerminalCode varchar(20) NULL
GO

ALTER TABLE dbo.Vstk_mt_Item ADD
	AgentCommType varchar(1) NULL,
	AgentCommValue numeric(18, 6) NULL,
	AgentCommQty numeric(18, 6) NULL,
	StaffCommType varchar(1) NULL,
	StaffCommValue numeric(18, 6) NULL,
	StaffCommQty numeric(18, 6) NULL
GO
ALTER TABLE dbo.Vstk_mt_Item ADD CONSTRAINT
	DF_Vstk_mt_Item_AgentCommType DEFAULT 'V' FOR AgentCommType
GO
ALTER TABLE dbo.Vstk_mt_Item ADD CONSTRAINT
	DF_Vstk_mt_Item_AgentCommValue DEFAULT 0 FOR AgentCommValue
GO
ALTER TABLE dbo.Vstk_mt_Item ADD CONSTRAINT
	DF_Vstk_mt_Item_AgentCommQty DEFAULT 1 FOR AgentCommQty
GO
ALTER TABLE dbo.Vstk_mt_Item ADD CONSTRAINT
	DF_Vstk_mt_Item_StaffCommType DEFAULT 'V' FOR StaffCommType
GO
ALTER TABLE dbo.Vstk_mt_Item ADD CONSTRAINT
	DF_Vstk_mt_Item_StaffCommValue DEFAULT 0 FOR StaffCommValue
GO
ALTER TABLE dbo.Vstk_mt_Item ADD CONSTRAINT
	DF_Vstk_mt_Item_StaffCommQty DEFAULT 1 FOR StaffCommQty
GO
ALTER TABLE dbo.Vpos_mt_Outlet ADD
	CustodyPeriod numeric(18, 0) NULL
GO
ALTER TABLE dbo.Vpos_mt_Outlet ADD CONSTRAINT
	DF_Vpos_mt_Outlet_CustodyPeriod DEFAULT 0 FOR CustodyPeriod
GO
ALTER TABLE dbo.Vstk_trs_BillDetails ADD
	CustodyExpireDate datetime NULL
GO

ALTER TABLE dbo.Vpos_trs_BillDetails ADD
	FAgentComm numeric(18, 6) NULL,
	FStaffComm numeric(18, 6) NULL
GO
ALTER TABLE dbo.Vpos_trs_BillDetails ADD CONSTRAINT
	DF_Vpos_trs_BillDetails_FAgentComm DEFAULT 0 FOR FAgentComm
GO
ALTER TABLE dbo.Vpos_trs_BillDetails ADD CONSTRAINT
	DF_Vpos_trs_BillDetails_FStaffComm DEFAULT 0 FOR FStaffComm
GO

ALTER TABLE dbo.Vpos_eod_BillDetails ADD
	FAgentComm numeric(18, 6) NULL,
	FStaffComm numeric(18, 6) NULL
GO
ALTER TABLE dbo.Vpos_eod_BillDetails ADD CONSTRAINT
	DF_Vpos_trs_BillDetails_FAgentComm DEFAULT 0 FOR FAgentComm
GO
ALTER TABLE dbo.Vpos_eod_BillDetails ADD CONSTRAINT
	DF_Vpos_trs_BillDetails_FStaffComm DEFAULT 0 FOR FStaffComm
GO

update vstk_mt_item set AgentcommValue=0 where AgentCommValue is null
update vstk_mt_item set StaffcommValue=0 where StaffCommValue is null
update vstk_mt_item set AgentcommType='V' where AgentCommType is null
update vstk_mt_item set StaffcommType='V' where StaffCommType is null
update vstk_mt_item set AgentcommQty=0 where AgentCommQty is null
update vstk_mt_item set StaffcommQty=0 where StaffCommQty is null

delete from vpos_mt_Report where RptCode='RS031'
INSERT INTO VPOS_MT_rEPORT ( RptCode, RptName, RptName1, RptName2, RptName3, RptType, ctype,ScriptUpdateYesNo)                     
values('RS031','Staff Commission','Staff Commission','Staff Commission','Staff Commission',1,'OOXXXXXXXXXX',1)


DELETE FROM Vs_DefaultAccess WHERE (DefaultNo=65) and DefaultType='B'
INSERT INTO Vs_DefaultAccess (DefaultName,DefaultNo,DefaultType,DisplayNo,ctype) 
VALUES('[B65] Check Stock Balance at Front POS',65,'B',65,'OOXXXXXXXX')

ALTER TABLE dbo.Vstk_mt_Set ADD
	HideSetItem bit NULL
GO
ALTER TABLE dbo.Vstk_mt_Set ADD CONSTRAINT
	DF_Vstk_mt_Set_HideSetItem DEFAULT 0 FOR HideSetItem
GO

ALTER TABLE dbo.Vpos_trs_BillDetails ADD
	HideSetItem bit NULL
GO
ALTER TABLE dbo.Vpos_trs_BillDetails ADD CONSTRAINT
	DF_Vpos_trs_BillDetails_HideSetItem DEFAULT 0 FOR HideSetItem
GO

ALTER TABLE dbo.Vpos_eod_BillDetails ADD
	HideSetItem bit NULL
GO
ALTER TABLE dbo.Vpos_eod_BillDetails ADD CONSTRAINT
	DF_Vpos_eod_BillDetails_HideSetItem DEFAULT 0 FOR HideSetItem
GO

update vstk_mt_set set HideSetItem=0 where HideSetItem is null
update vpos_trs_billdetails set HideSetItem=0 where HideSetItem is null
update vpos_eod_billdetails set HideSetItem=0 where HideSetItem is null