GoldHoo/doc/调整记录/已更新正式环境/2020-11-30 15.01.sql

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