STOCKSALE
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| STOCKDETAILID | uniqueidentifier | ||
| SALEDATE | datetime | ||
| SALEAMOUNT | money | ||
| FEE | money | ||
| NUMBEROFUNITS | decimal(20, 3) | ||
| LOWPRICE | decimal(19, 4) | ||
| MEDIANPRICE | decimal(19, 4) | ||
| HIGHPRICE | decimal(19, 4) | ||
| SALEPOSTDATE | datetime | yes | |
| SALEPOSTSTATUSCODE | tinyint | ||
| ADDEDBYID | uniqueidentifier | ||
| CHANGEDBYID | uniqueidentifier | ||
| DATEADDED | datetime | ||
| DATECHANGED | datetime | ||
| TS | timestamp | ||
| TSLONG | bigint | yes | |
| SALEPOSTSTATUS | nvarchar(11) | yes | |
| ORGANIZATIONSALEAMOUNT | money | ||
| ORGANIZATIONFEE | money | ||
| ORGANIZATIONLOWPRICE | decimal(19, 4) | ||
| ORGANIZATIONMEDIANPRICE | decimal(19, 4) | ||
| ORGANIZATIONHIGHPRICE | decimal(19, 4) | ||
| TRANSACTIONSALEAMOUNT | money | ||
| TRANSACTIONFEE | money | ||
| TRANSACTIONLOWPRICE | decimal(19, 4) | ||
| TRANSACTIONMEDIANPRICE | decimal(19, 4) | ||
| TRANSACTIONHIGHPRICE | decimal(19, 4) | ||
| BASECURRENCYID | uniqueidentifier | yes | |
| ORGANIZATIONEXCHANGERATEID | uniqueidentifier | yes | |
| TRANSACTIONCURRENCYID | uniqueidentifier | yes | |
| BASEEXCHANGERATEID | uniqueidentifier | yes |
Definition
Copy
CREATE view dbo.STOCKSALE with schemabinding as
select
FINANCIALTRANSACTION.ID
,STOCKSALE_EXT.STOCKDETAILID
,STOCKSALE_EXT.SALEDATE
,FINANCIALTRANSACTION.BASEAMOUNT as SALEAMOUNT
,STOCKSALE_EXT.FEE
,STOCKSALE_EXT.NUMBEROFUNITS
,STOCKSALE_EXT.LOWPRICE
,STOCKSALE_EXT.MEDIANPRICE
,STOCKSALE_EXT.HIGHPRICE
,cast(FINANCIALTRANSACTION.POSTDATE as datetime) as SALEPOSTDATE
,isnull(cast(case FINANCIALTRANSACTION.POSTSTATUSCODE when 2 then 0 when 1 then 1 when 3 then 2 end as tinyint), 2) as SALEPOSTSTATUSCODE
,FINANCIALTRANSACTION.ADDEDBYID
,FINANCIALTRANSACTION.CHANGEDBYID
,FINANCIALTRANSACTION.DATEADDED
,FINANCIALTRANSACTION.DATECHANGED
,FINANCIALTRANSACTION.TS
,FINANCIALTRANSACTION.TSLONG
,cast(case FINANCIALTRANSACTION.POSTSTATUSCODE when 2 then 'Posted' when 1 then 'Not Posted' when 3 then 'Do Not Post' end as nvarchar(11))as SALEPOSTSTATUS
,FINANCIALTRANSACTION.ORGAMOUNT as ORGANIZATIONSALEAMOUNT
,STOCKSALE_EXT.ORGANIZATIONFEE
,STOCKSALE_EXT.ORGANIZATIONLOWPRICE
,STOCKSALE_EXT.ORGANIZATIONMEDIANPRICE
,STOCKSALE_EXT.ORGANIZATIONHIGHPRICE
,FINANCIALTRANSACTION.TRANSACTIONAMOUNT as TRANSACTIONSALEAMOUNT
,STOCKSALE_EXT.TRANSACTIONFEE
,STOCKSALE_EXT.TRANSACTIONLOWPRICE
,STOCKSALE_EXT.TRANSACTIONMEDIANPRICE
,STOCKSALE_EXT.TRANSACTIONHIGHPRICE
,case when FINANCIALTRANSACTION.DELETEDON is null then V.BASECURRENCYID else null end as BASECURRENCYID
,FINANCIALTRANSACTION.ORGEXCHANGERATEID as ORGANIZATIONEXCHANGERATEID
,case when FINANCIALTRANSACTION.DELETEDON is null then FINANCIALTRANSACTION.TRANSACTIONCURRENCYID else null end as TRANSACTIONCURRENCYID
,FINANCIALTRANSACTION.BASEEXCHANGERATEID
from dbo.FINANCIALTRANSACTION
inner join dbo.V_BASECURRENCYFORFINANCIALTRANSACTION_I V with (noexpand) on FINANCIALTRANSACTION.ID = V.FINANCIALTRANSACTIONID
inner join dbo.REVENUEPAYMENTMETHOD on FINANCIALTRANSACTION.PARENTID = REVENUEPAYMENTMETHOD.REVENUEID
inner join dbo.STOCKSALE_EXT on FINANCIALTRANSACTION.ID = STOCKSALE_EXT.ID
where TYPECODE = 21 and FINANCIALTRANSACTION.DELETEDON is null