Salespad Custom View Attribute Item

This is a modified version

http://docs.salespad.net/support/desktop-support/entry/inventory/item-attributes


USE [MTHND]
GO

/****** Object:  View [dbo].[spcvAttributeItem]    Script Date: 11/29/2017 3:51:56 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO




ALTER VIEW [dbo].[spcvAttributeItem] as
select
ia.Item_Number

,invs.xSeries
,invs.xType
,invs.xBrand
,invs.Description

,invs.xWidth
,invs.xDepth
,invs.xDoorHeight
,invs.xTotalHeight
,invs.xBaseColor
,invs.xColor
,invs.xLatch
,invs.xHandle
,invs.xHinge
,invs.xVentilation
,invs.xLegs
,invs.xStockStatus
,invs.xGroup
,invs.xProCatNum
,invs.xQSCatNum
,invs.xManufacturer


from spvItemMaster as ia with (nolock)
left join spvItemMaster as im with (nolock) on im.Item_Number=ia.Item_Number
left join spvInventorySearch as invs with (NOLOCK) on invs.Item_Number=ia.Item_Number

GO




Leave a Reply