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

USE [befri_Goldhoo]
GO

/****** Object:  Table [Discount].[DiscountAccDetail]    Script Date: 2020/12/1 14:44:04 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [Discount].[DiscountAccDetail](
	[DiscountAccDetailId] [int] IDENTITY(1,1) NOT NULL,
	[TableName] [varchar](100) NOT NULL,
	[VoucherLineId] [int] NOT NULL,
	[OperationType] [tinyint] NOT NULL,
	[WarehouseId] [int] NOT NULL,
	[InventoryId] [int] NOT NULL,
	[IncreasedQty] [numeric](9, 0) NOT NULL,
	[DecreasedQty] [numeric](9, 0) NOT NULL,
	[DiscountCoef] [numeric](5, 2) NULL,
	[AccountedOn] [datetime] NOT NULL,
	[Description] [nvarchar](200) NULL,
 CONSTRAINT [PK_DISCOUNTACCDETAIL] PRIMARY KEY CLUSTERED 
(
	[DiscountAccDetailId] 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].[DiscountAccDetail] ADD  CONSTRAINT [DF__DiscountA__Incre__3D199670]  DEFAULT ((0.00)) FOR [IncreasedQty]
GO

ALTER TABLE [Discount].[DiscountAccDetail] ADD  CONSTRAINT [DF__DiscountA__Decre__3E0DBAA9]  DEFAULT ((0.00)) FOR [DecreasedQty]
GO

ALTER TABLE [Discount].[DiscountAccDetail] ADD  CONSTRAINT [DF__DiscountA__Accou__3F01DEE2]  DEFAULT (getdate()) FOR [AccountedOn]
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'折扣产品账务明细' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountAccDetail', @level2type=N'COLUMN',@level2name=N'DiscountAccDetailId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单据行数据表' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountAccDetail', @level2type=N'COLUMN',@level2name=N'TableName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单据行内码' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountAccDetail', @level2type=N'COLUMN',@level2name=N'VoucherLineId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单据操作类型' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountAccDetail', @level2type=N'COLUMN',@level2name=N'OperationType'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'仓库内码' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountAccDetail', @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'DiscountAccDetail', @level2type=N'COLUMN',@level2name=N'InventoryId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'增加数量' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountAccDetail', @level2type=N'COLUMN',@level2name=N'IncreasedQty'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'减少数量' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountAccDetail', @level2type=N'COLUMN',@level2name=N'DecreasedQty'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'折扣系数' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountAccDetail', @level2type=N'COLUMN',@level2name=N'DiscountCoef'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'记账日期' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountAccDetail', @level2type=N'COLUMN',@level2name=N'AccountedOn'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountAccDetail', @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'DiscountAccDetail'
GO