UFN_PDACCOUNTCODEMAPPING_SETUP2
Returns if any account code mappings have been defined.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_PDACCOUNTCODEMAPPING_SETUP2
(
@ID uniqueidentifier
)
returns bit
with execute as caller
as begin
declare @SETUPCOMPLETE bit;
if exists(
select v1.ID from
( select t1.ID
from
dbo.PDACCOUNTCODEMAPPING T1
join PDACCOUNTSEGMENTVALUE T2 on T1.DEBITPDACCOUNTSEGMENTVALUEID = T2.ID or T1.CREDITPDACCOUNTSEGMENTVALUEID = T2.ID
where T1.PDACCOUNTSYSTEMID = @ID
union all
select t1.ID
from
dbo.PDACCOUNTCODEMAPPING T1
join GLACCOUNT T2 on T1.CREDITGLACCOUNTID = T2.ID or T1.DEBITGLACCOUNTID = T2.ID
where T2.PDACCOUNTSYSTEMID = @ID
)V1
)
set @SETUPCOMPLETE = 1
else
set @SETUPCOMPLETE = 0
return @SETUPCOMPLETE;
end