GoldHoo/doc/调整记录/已更新正式环境/2020-12-04 10.14.sql

USE [befri_Goldhoo]
GO

/****** Object:  UserDefinedTableType [Discount].[DiscountRecLineRows]    Script Date: 2020/12/4 10:12:51 ******/
CREATE TYPE [Discount].[DiscountRecLineRows] AS TABLE(
	[DiscountRecLineId] [int] NOT NULL,
	[DiscountRecId] [int] NOT NULL,
	[InventoryId] [int] NOT NULL,
	[InventoryNumber] [varchar](20) NULL,
	[InventoryName] [nvarchar](50) NULL,
	[Spec] [varchar](200) NULL,
	[BatchNumber] [varchar](20) NULL,
	[IncreasedQty] [numeric](9, 0) NOT NULL,
	[DecreasedQty] [numeric](9, 0) NOT NULL,
	[DiscountCoef] [numeric](5, 2) NULL,
	[IncreasedPrice] [money] NULL,
	[DecreasedPrice] [money] NULL,
	[IncreasedMoney] [money] NULL,
	[DecreasedMoney] [money] NULL,
	[LineStatus] [tinyint] NULL,
	[VersionNumber] [smallint] NULL,
	[Description] [nvarchar](200) NULL
)
GO