/*
   Sunday, July 06, 20141:09:29 PM
   User: sa
   Server: (local)\vpos
   Database: Datafile
   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_EOD ADD
	SubTotal numeric(22, 4) NULL,
	Tax1Amt numeric(22, 4) NULL,
	Tax2Amt numeric(22, 4) NULL,
	Svr1Amt numeric(22, 4) NULL,
	Svr2Amt numeric(22, 4) NULL,
	BillDiscAmt numeric(22, 4) NULL,
	ItemDiscAmt numeric(22, 4) NULL,
	ItemGrossAmt numeric(22, 4) NULL,
	GrossAmt numeric(22, 4) NULL,
	NettAmt numeric(22, 4) NULL,
	RoundedAdj numeric(22, 4) NULL,
	RoundedAmt numeric(22, 4) NULL,
	VoidAmt numeric(22, 4) NULL,
	ServiceTypeAmt_D numeric(22, 4) NULL,
	ServiceTypeAmt_K numeric(22, 4) NULL,
	ServiceTypeAmt_Q numeric(22, 4) NULL,
	ServiceTypeAmt_T numeric(22, 4) NULL,
	PayAmt_C numeric(22, 4) NULL,
	PayAmt_R numeric(22, 4) NULL,
	PayAmt_H numeric(22, 4) NULL,
	PayAmt_A numeric(22, 4) NULL,
	PayAmt_V numeric(22, 4) NULL,
	PayAmt_D numeric(22, 4) NULL,
	PayAmt_M numeric(22, 4) NULL,
	PayAmt_X numeric(22, 4) NULL,
	PayAmt_G numeric(22, 4) NULL,
	PayAmt_O numeric(22, 4) NULL,
	ServiceTypeBill_D int NULL,
	ServiceTypeBill_K int NULL,
	ServiceTypeBill_T int NULL,
	ServiceTypeBill_Q int NULL,
	VoidBill int NULL,
	Pax int NULL
GO
ALTER TABLE dbo.Vpos_trs_EOD ADD CONSTRAINT
	DF_Vpos_trs_EOD_SubTotal_1 DEFAULT ((0)) FOR SubTotal
GO
ALTER TABLE dbo.Vpos_trs_EOD ADD CONSTRAINT
	DF_Vpos_trs_EOD_Tax1Amt DEFAULT ((0)) FOR Tax1Amt
GO
ALTER TABLE dbo.Vpos_trs_EOD ADD CONSTRAINT
	DF_Vpos_trs_EOD_Tax2Amt DEFAULT ((0)) FOR Tax2Amt
GO
ALTER TABLE dbo.Vpos_trs_EOD ADD CONSTRAINT
	DF_Vpos_trs_EOD_Svr1Amt DEFAULT ((0)) FOR Svr1Amt
GO
ALTER TABLE dbo.Vpos_trs_EOD ADD CONSTRAINT
	DF_Vpos_trs_EOD_Svr2Amt DEFAULT ((0)) FOR Svr2Amt
GO
ALTER TABLE dbo.Vpos_trs_EOD ADD CONSTRAINT
	DF_Vpos_trs_EOD_BillDiscAmt DEFAULT ((0)) FOR BillDiscAmt
GO
ALTER TABLE dbo.Vpos_trs_EOD ADD CONSTRAINT
	DF_Vpos_trs_EOD_ItemDiscAmt DEFAULT ((0)) FOR ItemDiscAmt
GO
ALTER TABLE dbo.Vpos_trs_EOD ADD CONSTRAINT
	DF_Vpos_trs_EOD_ItemGrossAmt_1 DEFAULT ((0)) FOR ItemGrossAmt
GO
ALTER TABLE dbo.Vpos_trs_EOD ADD CONSTRAINT
	DF_Vpos_trs_EOD_GrossAmt DEFAULT ((0)) FOR GrossAmt
GO
ALTER TABLE dbo.Vpos_trs_EOD ADD CONSTRAINT
	DF_Vpos_trs_EOD_NettAmt DEFAULT ((0)) FOR NettAmt
GO
ALTER TABLE dbo.Vpos_trs_EOD ADD CONSTRAINT
	DF_Vpos_trs_EOD_RoundedAdj DEFAULT ((0)) FOR RoundedAdj
GO
ALTER TABLE dbo.Vpos_trs_EOD ADD CONSTRAINT
	DF_Vpos_trs_EOD_RoundedAmt DEFAULT ((0)) FOR RoundedAmt
GO
ALTER TABLE dbo.Vpos_trs_EOD ADD CONSTRAINT
	DF_Vpos_trs_EOD_VoidAmt DEFAULT ((0)) FOR VoidAmt
GO
ALTER TABLE dbo.Vpos_trs_EOD ADD CONSTRAINT
	DF_Vpos_trs_EOD_ServiceTypeAmt_D DEFAULT ((0)) FOR ServiceTypeAmt_D
GO
ALTER TABLE dbo.Vpos_trs_EOD ADD CONSTRAINT
	DF_Vpos_trs_EOD_ServiceTypeAmt_K DEFAULT ((0)) FOR ServiceTypeAmt_K
GO
ALTER TABLE dbo.Vpos_trs_EOD ADD CONSTRAINT
	DF_Vpos_trs_EOD_ServiceTypeAmt_Q DEFAULT ((0)) FOR ServiceTypeAmt_Q
GO
ALTER TABLE dbo.Vpos_trs_EOD ADD CONSTRAINT
	DF_Vpos_trs_EOD_ServiceTypeAmt_T DEFAULT ((0)) FOR ServiceTypeAmt_T
GO
ALTER TABLE dbo.Vpos_trs_EOD ADD CONSTRAINT
	DF_Vpos_trs_EOD_PayAmt_C_1 DEFAULT ((0)) FOR PayAmt_C
GO
ALTER TABLE dbo.Vpos_trs_EOD ADD CONSTRAINT
	DF_Vpos_trs_EOD_PayAmt_R_1 DEFAULT ((0)) FOR PayAmt_R
GO
ALTER TABLE dbo.Vpos_trs_EOD ADD CONSTRAINT
	DF_Vpos_trs_EOD_PayAmt_H_1 DEFAULT ((0)) FOR PayAmt_H
GO
ALTER TABLE dbo.Vpos_trs_EOD ADD CONSTRAINT
	DF_Vpos_trs_EOD_PayAmt_A_1 DEFAULT ((0)) FOR PayAmt_A
GO
ALTER TABLE dbo.Vpos_trs_EOD ADD CONSTRAINT
	DF_Vpos_trs_EOD_PayAmt_V_1 DEFAULT ((0)) FOR PayAmt_V
GO
ALTER TABLE dbo.Vpos_trs_EOD ADD CONSTRAINT
	DF_Vpos_trs_EOD_PayAmt_D_1 DEFAULT ((0)) FOR PayAmt_D
GO
ALTER TABLE dbo.Vpos_trs_EOD ADD CONSTRAINT
	DF_Vpos_trs_EOD_PayAmt_M_1 DEFAULT ((0)) FOR PayAmt_M
GO
ALTER TABLE dbo.Vpos_trs_EOD ADD CONSTRAINT
	DF_Vpos_trs_EOD_PayAmt_X_1 DEFAULT ((0)) FOR PayAmt_X
GO
ALTER TABLE dbo.Vpos_trs_EOD ADD CONSTRAINT
	DF_Vpos_trs_EOD_PayAmt_G_1 DEFAULT ((0)) FOR PayAmt_G
GO
ALTER TABLE dbo.Vpos_trs_EOD ADD CONSTRAINT
	DF_Vpos_trs_EOD_PayAmt_O_1 DEFAULT ((0)) FOR PayAmt_O
GO
ALTER TABLE dbo.Vpos_trs_EOD ADD CONSTRAINT
	DF_Vpos_trs_EOD_ServiceTypeBill_D DEFAULT ((0)) FOR ServiceTypeBill_D
GO
ALTER TABLE dbo.Vpos_trs_EOD ADD CONSTRAINT
	DF_Vpos_trs_EOD_ServiceTypeBill_K DEFAULT ((0)) FOR ServiceTypeBill_K
GO
ALTER TABLE dbo.Vpos_trs_EOD ADD CONSTRAINT
	DF_Vpos_trs_EOD_ServiceTypeBill_T DEFAULT ((0)) FOR ServiceTypeBill_T
GO
ALTER TABLE dbo.Vpos_trs_EOD ADD CONSTRAINT
	DF_Vpos_trs_EOD_ServiceTypeBill_Q DEFAULT ((0)) FOR ServiceTypeBill_Q
GO
ALTER TABLE dbo.Vpos_trs_EOD ADD CONSTRAINT
	DF_Vpos_trs_EOD_VoidBill DEFAULT ((0)) FOR VoidBill
GO
ALTER TABLE dbo.Vpos_trs_EOD ADD CONSTRAINT
	DF_Vpos_trs_EOD_Pax_1 DEFAULT ((0)) FOR Pax
GO
COMMIT