V_QUERY_BATCHMERCHANDISEINVENTORY_EXCEPTIONREPORT
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ORIGINALBATCHNUMBER | nvarchar(100) | ||
| BATCHNUMBER | nvarchar(100) | yes | |
| OWNER | nvarchar(128) | yes | |
| ID | uniqueidentifier | ||
| ACTIONTYPE | nvarchar(14) | yes | |
| ITEMDETAILS | nvarchar(150) | yes | |
| QUANTITY | int | ||
| COST | decimal(20, 4) | yes | |
| ADJUSTMENTREASON | nvarchar(100) | yes | |
| AVERAGECOST | 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_EXCEPTIONREPORT AS
select
[ORIGINAL].BATCHNUMBER as [ORIGINALBATCHNUMBER],
BATCH.BATCHNUMBER as [BATCHNUMBER],
(select USERNAME from dbo.APPUSER where APPUSER.ID = [BATCH].APPUSERID) as [OWNER],
BATCHMERCHANDISEINVENTORY.ID,
BATCHMERCHANDISEINVENTORY.ACTIONTYPE,
MERCHANDISEPRODUCTINSTANCE.ITEMDETAILS,
BATCHMERCHANDISEINVENTORY.QUANTITY,
BATCHMERCHANDISEINVENTORY.COST,
MERCHANDISEADJUSTMENTREASONCODE.DESCRIPTION as ADJUSTMENTREASON,
BATCHMERCHANDISEINVENTORY.COST as AVERAGECOST
from dbo.BATCHMERCHANDISEINVENTORY
inner join dbo.MERCHANDISEPRODUCTINSTANCE
on BATCHMERCHANDISEINVENTORY.MERCHANDISEPRODUCTINSTANCEID = MERCHANDISEPRODUCTINSTANCE.ID
left outer join dbo.CONSTITUENT
on BATCHMERCHANDISEINVENTORY.VENDORID = CONSTITUENT.ID
left outer join dbo.MERCHANDISEADJUSTMENTREASONCODE
on BATCHMERCHANDISEINVENTORY.MERCHANDISEADJUSTMENTREASONCODEID = MERCHANDISEADJUSTMENTREASONCODE.ID
inner join dbo.BATCH as [ORIGINAL]
on BATCHMERCHANDISEINVENTORY.BATCHID = [ORIGINAL].ID
left join dbo.BATCH
on BATCH.ORIGINATINGBATCHID = [ORIGINAL].ID