USE [STATION]

GO

CREATE TABLE [tbRoomTransferRequest](
	[IDNum] [varchar](10) NOT NULL,
	[OldRoomID] [varchar](8) NULL,
	[OldStationID] [varchar](8) NULL,
	[NewRoomID] [varchar](8) NULL,
	[NewStationID] [varchar](8) NULL,
	[RequestDate] [smalldatetime] NULL,
	[RequestBy] [varchar](10) NULL,
	[ProcessBy] [varchar](10) NULL,
	[ProcessDate] [smalldatetime] NULL,
	[RevokeBy] [varchar](10) NULL,
	[RevokeDate] [smalldatetime] NULL,
	[OldRoomRate] [float] NULL,
	[Reason] [varchar](250) NULL,
	[RecordStatus] [varchar](1) NULL,
	[TransID] [varchar](10) NULL
)



GO

----------------------------------------------------------------------