USE [befri_Goldhoo]
GO

/****** Object:  Table [Discount].[DiscountRec]    Script Date: 2020/12/4 11:40:33 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [Discount].[DiscountRec](
	[DiscountRecId] [int] NOT NULL,
	[WarehouseId] [int] NOT NULL,
	[RecType] [tinyint] NOT NULL,
	[VoucherNumber] [varchar](20) NOT NULL,
	[VoucherDate] [datetime] NOT NULL,
	[Summary] [nvarchar](200) NULL,
	[BusinessDate] [datetime] NULL,
	[PreparedBy] [nvarchar](20) NOT NULL,
	[PreparedOn] [datetime] NOT NULL,
	[Approved] [bit] NOT NULL,
	[ApprovedBy] [nvarchar](20) NULL,
	[ApprovedOn] [datetime] NULL,
	[ApprovedResult] [tinyint] NULL,
	[CancelApproved] [bit] NOT NULL,
	[CancelApprovedBy] [nvarchar](20) NULL,
	[CancelApprovedOn] [datetime] NULL,
	[CancelApprovedReson] [nvarchar](100) NULL,
	[HandledBy] [nvarchar](20) NULL,
	[Status] [tinyint] NOT NULL,
	[VersionNumber] [smallint] NOT NULL,
	[CreatedBy] [nvarchar](20) NOT NULL,
	[CreatedOn] [datetime] NOT NULL,
	[ModifiedBy] [nvarchar](20) NULL,
	[ModifiedOn] [datetime] NOT NULL,
	[Description] [nvarchar](200) NULL,
 CONSTRAINT [PK_DISCOUNTREC] PRIMARY KEY CLUSTERED 
(
	[DiscountRecId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING ON
GO

ALTER TABLE [Discount].[DiscountRec] ADD  CONSTRAINT [DF__DiscountR__Appro__41DE4B8D]  DEFAULT ((0)) FOR [Approved]
GO

ALTER TABLE [Discount].[DiscountRec] ADD  CONSTRAINT [DF__DiscountR__Cance__42D26FC6]  DEFAULT ((0)) FOR [CancelApproved]
GO

ALTER TABLE [Discount].[DiscountRec] ADD  CONSTRAINT [DF__DiscountR__Versi__43C693FF]  DEFAULT ((0)) FOR [VersionNumber]
GO

ALTER TABLE [Discount].[DiscountRec] ADD  CONSTRAINT [DF__DiscountR__Creat__44BAB838]  DEFAULT (getdate()) FOR [CreatedOn]
GO

ALTER TABLE [Discount].[DiscountRec] ADD  CONSTRAINT [DF__DiscountR__Modif__45AEDC71]  DEFAULT (getdate()) FOR [ModifiedOn]
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'���������¼����' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountRec', @level2type=N'COLUMN',@level2name=N'DiscountRecId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�ֿ�����' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountRec', @level2type=N'COLUMN',@level2name=N'WarehouseId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'���������' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountRec', @level2type=N'COLUMN',@level2name=N'RecType'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'���ݺ�' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountRec', @level2type=N'COLUMN',@level2name=N'VoucherNumber'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��������' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountRec', @level2type=N'COLUMN',@level2name=N'VoucherDate'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'����ժҪ' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountRec', @level2type=N'COLUMN',@level2name=N'Summary'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'���������' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountRec', @level2type=N'COLUMN',@level2name=N'BusinessDate'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�Ƶ�������' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountRec', @level2type=N'COLUMN',@level2name=N'PreparedBy'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�Ƶ�����' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountRec', @level2type=N'COLUMN',@level2name=N'PreparedOn'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��˱��' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountRec', @level2type=N'COLUMN',@level2name=N'Approved'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'���������' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountRec', @level2type=N'COLUMN',@level2name=N'ApprovedBy'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�������' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountRec', @level2type=N'COLUMN',@level2name=N'ApprovedOn'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��˽��' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountRec', @level2type=N'COLUMN',@level2name=N'ApprovedResult'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'������' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountRec', @level2type=N'COLUMN',@level2name=N'CancelApproved'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'����������' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountRec', @level2type=N'COLUMN',@level2name=N'CancelApprovedBy'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��������' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountRec', @level2type=N'COLUMN',@level2name=N'CancelApprovedOn'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'����ԭ��' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountRec', @level2type=N'COLUMN',@level2name=N'CancelApprovedReson'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'������' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountRec', @level2type=N'COLUMN',@level2name=N'HandledBy'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'����״̬' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountRec', @level2type=N'COLUMN',@level2name=N'Status'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��¼�汾' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountRec', @level2type=N'COLUMN',@level2name=N'VersionNumber'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��¼������' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountRec', @level2type=N'COLUMN',@level2name=N'CreatedBy'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��¼����ʱ��' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountRec', @level2type=N'COLUMN',@level2name=N'CreatedOn'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��¼�޸���' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountRec', @level2type=N'COLUMN',@level2name=N'ModifiedBy'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��¼�޸�ʱ��' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountRec', @level2type=N'COLUMN',@level2name=N'ModifiedOn'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��ע' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountRec', @level2type=N'COLUMN',@level2name=N'Description'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�ۿ۹���.�ۿ۲�Ʒ������¼' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountRec'
GO