V_QUERY_BATCHMERCHANDISEINVENTORY_CONTROLREPORT
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| ACTIONTYPECODE | tinyint | ||
| ACTIONTYPE | nvarchar(14) | yes | |
| ITEMDETAILS | nvarchar(150) | yes | |
| ONHANDQUANTITY | int | ||
| QUANTITY | int | ||
| COST | decimal(20, 4) | yes | |
| AVERAGECOST | decimal(20, 4) | yes | |
| SALEPRICE | decimal(20, 4) | yes | |
| VENDOR | nvarchar(154) | yes | |
| REASON | nvarchar(100) | yes | |
| COMMENTS | nvarchar(255) | ||
| RETAILPRICE | decimal(20, 4) | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 9/30/2015 12:58:39 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.153.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_BATCHMERCHANDISEINVENTORY_CONTROLREPORT AS
select
MERCHANDISEPRODUCTINSTANCEHISTORY.ID,
MERCHANDISEPRODUCTINSTANCEHISTORY.ACTIONTYPECODE,
MERCHANDISEPRODUCTINSTANCEHISTORY.ACTIONTYPE,
MERCHANDISEPRODUCTINSTANCE.ITEMDETAILS,
MERCHANDISEPRODUCTINSTANCEHISTORY.ONHANDQUANTITY,
MERCHANDISEPRODUCTINSTANCEHISTORY.QUANTITY,
MERCHANDISEPRODUCTINSTANCEHISTORY.COST,
MERCHANDISEPRODUCTINSTANCEHISTORY.AVERAGECOST,
MERCHANDISEPRODUCTINSTANCEHISTORY.SALEPRICE,
CONSTITUENT.NAME as VENDOR,
MERCHANDISEADJUSTMENTREASONCODE.DESCRIPTION as REASON,
MERCHANDISEPRODUCTINSTANCEHISTORY.COMMENTS,
MERCHANDISEPRODUCTINSTANCEHISTORY.SALEPRICE as RETAILPRICE
from dbo.MERCHANDISEPRODUCTINSTANCEHISTORY
inner join dbo.MERCHANDISEPRODUCTINSTANCE
on MERCHANDISEPRODUCTINSTANCEHISTORY.MERCHANDISEPRODUCTINSTANCEID = MERCHANDISEPRODUCTINSTANCE.ID
left outer join dbo.CONSTITUENT
on MERCHANDISEPRODUCTINSTANCEHISTORY.VENDORID = CONSTITUENT.ID
left outer join dbo.MERCHANDISEADJUSTMENTREASONCODE
on MERCHANDISEPRODUCTINSTANCEHISTORY.MERCHANDISEADJUSTMENTREASONCODEID = MERCHANDISEADJUSTMENTREASONCODE.ID