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

USE [befri_Goldhoo]
GO

/****** Object:  View [clearance].[V_ItemAccount]    Script Date: 2020/11/30 17:15:21 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE VIEW [Discount].[V_ItemAccount]
AS
    SELECT  i.InventoryId ,
            i.InventoryNumber ,
            i.InventoryName ,
            i.InventoryCategoryId ,
            i.Spec ,
            i.AliasName ,
            i.SearchCode ,
            i.SalesPrice * ( da.DiscountCoef / 100 ) SalesPrice ,
            i.IsClearance ,
            ISNULL(da.DiscountCoef, 0) DiscountCoef ,
            ISNULL(da.Quantity, 0) Quantity ,
            i.Description
    FROM    Discount.DiscountAcc da
            LEFT JOIN basedata.Inventory i ON i.InventoryId = da.InventoryId

GO