V_QUERY_MERCHANDISEPRODUCTINSTANCEHISTORY
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| SOURCETYPE | nvarchar(6) | yes | |
| ACTIONTYPE | nvarchar(14) | yes | |
| ACTIONDATE | datetime | yes | |
| MERCHANDISEPRODUCTINSTANCEID | uniqueidentifier | ||
| QUANTITY | int | ||
| ONHANDQUANTITY | int | ||
| COST | decimal(20, 4) | yes | |
| AVERAGECOST | decimal(20, 4) | yes | |
| SALEPRICE | decimal(20, 4) | yes | |
| BATCHID | uniqueidentifier | yes | |
| VENDORID | uniqueidentifier | yes | |
| MERCHANDISEADJUSTMENTREASONCODEDESCRIPTION | nvarchar(100) | yes | |
| COMMENTS | nvarchar(255) | ||
| DATEADDED | datetime | ||
| DATECHANGED | datetime | ||
| TSLONG | bigint | yes | |
| ADDEDBY_APPLICATION | nvarchar(200) | yes | |
| ADDEDBY_USERNAME | nvarchar(128) | yes | |
| CHANGEDBY_APPLICATION | nvarchar(200) | yes | |
| CHANGEDBY_USERNAME | nvarchar(128) | yes | |
| RETAILPRICE | decimal(20, 4) | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 9/30/2015 12:58:38 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.153.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_MERCHANDISEPRODUCTINSTANCEHISTORY AS
select
MERCHANDISEPRODUCTINSTANCEHISTORY.ID,
MERCHANDISEPRODUCTINSTANCEHISTORY.SOURCETYPE,
MERCHANDISEPRODUCTINSTANCEHISTORY.ACTIONTYPE,
cast(MERCHANDISEPRODUCTINSTANCEHISTORY.ACTIONDATE as datetime) as ACTIONDATE,
MERCHANDISEPRODUCTINSTANCEHISTORY.MERCHANDISEPRODUCTINSTANCEID,
MERCHANDISEPRODUCTINSTANCEHISTORY.QUANTITY,
MERCHANDISEPRODUCTINSTANCEHISTORY.ONHANDQUANTITY,
MERCHANDISEPRODUCTINSTANCEHISTORY.COST,
MERCHANDISEPRODUCTINSTANCEHISTORY.AVERAGECOST,
MERCHANDISEPRODUCTINSTANCEHISTORY.SALEPRICE,
MERCHANDISEPRODUCTINSTANCEHISTORY.BATCHID,
MERCHANDISEPRODUCTINSTANCEHISTORY.VENDORID,
MERCHANDISEADJUSTMENTREASONCODE.DESCRIPTION as [MERCHANDISEADJUSTMENTREASONCODEDESCRIPTION],
MERCHANDISEPRODUCTINSTANCEHISTORY.COMMENTS,
MERCHANDISEPRODUCTINSTANCEHISTORY.DATEADDED,
MERCHANDISEPRODUCTINSTANCEHISTORY.DATECHANGED,
MERCHANDISEPRODUCTINSTANCEHISTORY.TSLONG,
ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION,
ADDEDBY.USERNAME as ADDEDBY_USERNAME,
CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION,
CHANGEDBY.USERNAME as CHANGEDBY_USERNAME,
MERCHANDISEPRODUCTINSTANCEHISTORY.SALEPRICE as RETAILPRICE
from dbo.MERCHANDISEPRODUCTINSTANCEHISTORY
left join dbo.MERCHANDISEADJUSTMENTREASONCODE on
MERCHANDISEPRODUCTINSTANCEHISTORY.MERCHANDISEADJUSTMENTREASONCODEID = MERCHANDISEADJUSTMENTREASONCODE.ID
left join dbo.CHANGEAGENT as [ADDEDBY] on
MERCHANDISEPRODUCTINSTANCEHISTORY.ADDEDBYID = [ADDEDBY].ID
left join dbo.CHANGEAGENT as [CHANGEDBY] on
MERCHANDISEPRODUCTINSTANCEHISTORY.CHANGEDBYID = [CHANGEDBY].ID