UFN_LEDGERACCOUNT_GETACCOUNTIDFROMELEMENTS

Returns the ID for the ledger account which has all the specified accounting element IDs

Return

Return Type
uniqueidentifier

Parameters

Parameter Parameter Type Mode Description
@DATAELEMENT1ID uniqueidentifier IN
@DATAELEMENT2ID uniqueidentifier IN
@DATAELEMENT3ID uniqueidentifier IN
@DATAELEMENT4ID uniqueidentifier IN
@DATAELEMENT5ID uniqueidentifier IN
@DATAELEMENT6ID uniqueidentifier IN
@DATAELEMENT7ID uniqueidentifier IN
@DATAELEMENT8ID uniqueidentifier IN
@DATAELEMENT9ID uniqueidentifier IN
@DATAELEMENT10ID uniqueidentifier IN
@DATAELEMENT11ID uniqueidentifier IN
@DATAELEMENT12ID uniqueidentifier IN
@DATAELEMENT13ID uniqueidentifier IN
@DATAELEMENT14ID uniqueidentifier IN
@DATAELEMENT15ID uniqueidentifier IN
@DATAELEMENT16ID uniqueidentifier IN
@DATAELEMENT17ID uniqueidentifier IN
@DATAELEMENT18ID uniqueidentifier IN
@DATAELEMENT19ID uniqueidentifier IN
@DATAELEMENT20ID uniqueidentifier IN
@DATAELEMENT21ID uniqueidentifier IN
@DATAELEMENT22ID uniqueidentifier IN
@DATAELEMENT23ID uniqueidentifier IN
@DATAELEMENT24ID uniqueidentifier IN
@DATAELEMENT25ID uniqueidentifier IN
@DATAELEMENT26ID uniqueidentifier IN
@DATAELEMENT27ID uniqueidentifier IN
@DATAELEMENT28ID uniqueidentifier IN
@DATAELEMENT29ID uniqueidentifier IN
@DATAELEMENT30ID uniqueidentifier IN

Definition

Copy 


CREATE function dbo.UFN_LEDGERACCOUNT_GETACCOUNTIDFROMELEMENTS(
  @DATAELEMENT1ID uniqueidentifier=null,
  @DATAELEMENT2ID uniqueidentifier=null,
  @DATAELEMENT3ID uniqueidentifier=null,
  @DATAELEMENT4ID uniqueidentifier=null,
  @DATAELEMENT5ID uniqueidentifier=null,
  @DATAELEMENT6ID uniqueidentifier=null,
  @DATAELEMENT7ID uniqueidentifier=null,
  @DATAELEMENT8ID uniqueidentifier=null,
  @DATAELEMENT9ID uniqueidentifier=null,
  @DATAELEMENT10ID uniqueidentifier=null,
  @DATAELEMENT11ID uniqueidentifier=null,
  @DATAELEMENT12ID uniqueidentifier=null,
  @DATAELEMENT13ID uniqueidentifier=null,
  @DATAELEMENT14ID uniqueidentifier=null,
  @DATAELEMENT15ID uniqueidentifier=null,
  @DATAELEMENT16ID uniqueidentifier=null,
  @DATAELEMENT17ID uniqueidentifier=null,
  @DATAELEMENT18ID uniqueidentifier=null,
  @DATAELEMENT19ID uniqueidentifier=null,
  @DATAELEMENT20ID uniqueidentifier=null,
  @DATAELEMENT21ID uniqueidentifier=null,
  @DATAELEMENT22ID uniqueidentifier=null,
  @DATAELEMENT23ID uniqueidentifier=null,
  @DATAELEMENT24ID uniqueidentifier=null,
  @DATAELEMENT25ID uniqueidentifier=null,
  @DATAELEMENT26ID uniqueidentifier=null,
  @DATAELEMENT27ID uniqueidentifier=null,
  @DATAELEMENT28ID uniqueidentifier=null,
  @DATAELEMENT29ID uniqueidentifier=null,
  @DATAELEMENT30ID uniqueidentifier=null
  )
returns uniqueidentifier
with execute as caller
as begin
  declare @ID uniqueidentifier;
  select TOP 1 @ID=ID from dbo.GLACCOUNT 
  where 
  (@DATAELEMENT1ID = DATAELEMENT1ID or DATAELEMENT1ID IS NULL) AND
  (@DATAELEMENT2ID = DATAELEMENT2ID or DATAELEMENT2ID IS NULL) AND
  (@DATAELEMENT3ID = DATAELEMENT3ID or DATAELEMENT3ID IS NULL) AND
  (@DATAELEMENT4ID = DATAELEMENT4ID or DATAELEMENT4ID IS NULL) AND
  (@DATAELEMENT5ID = DATAELEMENT5ID or DATAELEMENT5ID IS NULL) AND
  (@DATAELEMENT6ID = DATAELEMENT6ID or DATAELEMENT6ID IS NULL) AND
  (@DATAELEMENT7ID = DATAELEMENT7ID or DATAELEMENT7ID IS NULL) AND
  (@DATAELEMENT8ID = DATAELEMENT8ID or DATAELEMENT8ID IS NULL) AND
  (@DATAELEMENT9ID = DATAELEMENT9ID or DATAELEMENT9ID IS NULL) AND
  (@DATAELEMENT10ID = DATAELEMENT10ID or DATAELEMENT10ID IS NULL) AND
  (@DATAELEMENT11ID = DATAELEMENT11ID or DATAELEMENT11ID IS NULL) AND
  (@DATAELEMENT12ID = DATAELEMENT12ID or DATAELEMENT12ID IS NULL) AND
  (@DATAELEMENT13ID = DATAELEMENT13ID or DATAELEMENT13ID IS NULL) AND
  (@DATAELEMENT14ID = DATAELEMENT14ID or DATAELEMENT14ID IS NULL) AND
  (@DATAELEMENT15ID = DATAELEMENT15ID or DATAELEMENT15ID IS NULL) AND
  (@DATAELEMENT16ID = DATAELEMENT16ID or DATAELEMENT16ID IS NULL) AND
  (@DATAELEMENT17ID = DATAELEMENT17ID or DATAELEMENT17ID IS NULL) AND
  (@DATAELEMENT18ID = DATAELEMENT18ID or DATAELEMENT18ID IS NULL) AND
  (@DATAELEMENT19ID = DATAELEMENT19ID or DATAELEMENT19ID IS NULL) AND
  (@DATAELEMENT20ID = DATAELEMENT20ID or DATAELEMENT20ID IS NULL) AND
  (@DATAELEMENT21ID = DATAELEMENT21ID or DATAELEMENT21ID IS NULL) AND
  (@DATAELEMENT22ID = DATAELEMENT22ID or DATAELEMENT22ID IS NULL) AND
  (@DATAELEMENT23ID = DATAELEMENT23ID or DATAELEMENT23ID IS NULL) AND
  (@DATAELEMENT24ID = DATAELEMENT24ID or DATAELEMENT24ID IS NULL) AND
  (@DATAELEMENT25ID = DATAELEMENT25ID or DATAELEMENT25ID IS NULL) AND
  (@DATAELEMENT26ID = DATAELEMENT26ID or DATAELEMENT26ID IS NULL) AND
  (@DATAELEMENT27ID = DATAELEMENT27ID or DATAELEMENT27ID IS NULL) AND
  (@DATAELEMENT28ID = DATAELEMENT28ID or DATAELEMENT28ID IS NULL) AND
  (@DATAELEMENT29ID = DATAELEMENT29ID or DATAELEMENT29ID IS NULL) AND
  (@DATAELEMENT30ID  = DATAELEMENT30ID or DATAELEMENT30ID IS NULL)
    -- do work here and return a value

    return @ID
end