V_SIMPLEDATALIST_PDACCOUNTCODEVALUES
Returns a list of account code values.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| VALUE | uniqueidentifier | ||
| LABEL | nvarchar(100) |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 4/29/2010 7:29:12 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.6.1444.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SIMPLEDATALIST_PDACCOUNTCODEVALUES AS
select
PDACCOUNTSEGMENTVALUE.ID as VALUE,
SHORTDESCRIPTION as LABEL
from dbo.PDACCOUNTSEGMENTVALUE
join dbo.PDACCOUNTSTRUCTURE on PDACCOUNTSTRUCTURE.ID = PDACCOUNTSEGMENTVALUE.PDACCOUNTSTRUCTUREID
-- inner join dbo.PDCATEGORYDEFINITION on convert(int,PDACCOUNTSEGMENTVALUE.SHORTDESCRIPTION) between convert(int,PDCATEGORYDEFINITION.FROMCODE) and convert(int,PDCATEGORYDEFINITION.TOCODE)
where PDACCOUNTSTRUCTURE.SEGMENTTYPE = 1 and PDACCOUNTSTRUCTURE.PDACCOUNTSYSTEMID = '4B121C2C-CCE6-440D-894C-EA0DEF80D50B'