UFN_PDCATEGORYDEFINITION_GETSEGMENTLENGTH

Checks category definition and account code segment are same length.

Return

Return Type
int

Definition

Copy


create function dbo.UFN_PDCATEGORYDEFINITION_GETSEGMENTLENGTH()
returns integer
with execute as caller
as begin

    return (select length from dbo.PDACCOUNTSTRUCTURE where SEGMENTTYPE = 1

end