GIFTINKINDSALE
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| GIFTINKINDPAYMENTMETHODDETAILID | uniqueidentifier | ||
| SALEDATE | datetime | yes | |
| SALEAMOUNT | money | ||
| NUMBEROFUNITS | int | ||
| SALEPOSTDATE | datetime | yes | |
| SALEPOSTSTATUSCODE | tinyint | ||
| SALEPOSTSTATUS | nvarchar(11) | yes | |
| ORGANIZATIONSALEAMOUNT | money | ||
| TRANSACTIONSALEAMOUNT | money | ||
| BASECURRENCYID | uniqueidentifier | yes | |
| ORGANIZATIONEXCHANGERATEID | uniqueidentifier | yes | |
| TRANSACTIONCURRENCYID | uniqueidentifier | yes | |
| BASEEXCHANGERATEID | uniqueidentifier | yes | |
| ADDEDBYID | uniqueidentifier | ||
| CHANGEDBYID | uniqueidentifier | ||
| DATEADDED | datetime | ||
| DATECHANGED | datetime | ||
| TS | timestamp | ||
| TSLONG | bigint | yes |
Definition
Copy
CREATE view dbo.GIFTINKINDSALE with schemabinding as
select
FINANCIALTRANSACTION.ID
,GIFTINKINDSALE_EXT.GIFTINKINDPAYMENTMETHODDETAILID
,cast(FINANCIALTRANSACTION.DATE as datetime) as SALEDATE
,FINANCIALTRANSACTION.BASEAMOUNT as SALEAMOUNT
,GIFTINKINDSALE_EXT.NUMBEROFUNITS
,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
,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
,FINANCIALTRANSACTION.TRANSACTIONAMOUNT as TRANSACTIONSALEAMOUNT
,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
,FINANCIALTRANSACTION.ADDEDBYID
,FINANCIALTRANSACTION.CHANGEDBYID
,FINANCIALTRANSACTION.DATEADDED
,FINANCIALTRANSACTION.DATECHANGED
,FINANCIALTRANSACTION.TS
,FINANCIALTRANSACTION.TSLONG
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.GIFTINKINDSALE_EXT on FINANCIALTRANSACTION.ID = GIFTINKINDSALE_EXT.ID
where TYPECODE = 27 and FINANCIALTRANSACTION.DELETEDON is null