UFN_PDACCOUNT_GETCUSTOMTABLESFORSEGMENT_2

Allows additional tables to be added to the 'Calculate using' dropdown for account structure.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode
@REVENUEID	uniqueidentifier	IN
@REVENUESPLITID	uniqueidentifier	IN
@INFORMATIONSOURCECODE	tinyint	IN
@REVENUETRANSACTIONTYPECODE	tinyint	IN
@REVENUESPLITTYPECODE	tinyint	IN
@APPLICATIONCODE	tinyint	IN
@PAYMENTMETHODCODE	tinyint	IN
@DESIGNATIONID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_PDACCOUNT_GETCUSTOMTABLESFORSEGMENT_2
            (
                @REVENUEID uniqueidentifier, 
                @REVENUESPLITID uniqueidentifier, 
                @INFORMATIONSOURCECODE tinyint, -- 0 revenue tables, 1 revenue batch tables

                @REVENUETRANSACTIONTYPECODE tinyint, 
                @REVENUESPLITTYPECODE tinyint, 
                @APPLICATIONCODE tinyint, 
                @PAYMENTMETHODCODE tinyint, 
                @DESIGNATIONID uniqueidentifier,
                @CURRENTAPPUSERID uniqueidentifier = null
            )
            returns @AdditionalCalculateUsingTables table
                (
                    TableID uniqueidentifier, 
                    RowID uniqueidentifier, 
                    FunctionID int, 
                    FriendlyTableName varchar(255)
                )
            as
            begin                
                -- Determine the information source and call the correct function based on this.


                if (@INFORMATIONSOURCECODE = 0) -- Revenue table

                    insert into @AdditionalCalculateUsingTables (TableID, RowID, FunctionID, FriendlyTableName)
                    select TableID, RowID, FunctionID, FriendlyTableName
                    from dbo.UFN_PDACCOUNT_GETCUSTOMTABLESFORSEGMENT(@REVENUESPLITID, @REVENUETRANSACTIONTYPECODE, @APPLICATIONCODE, @PAYMENTMETHODCODE, @DESIGNATIONID);

                else if (@INFORMATIONSOURCECODE = 1) -- Revenue batch table

                    insert into @AdditionalCalculateUsingTables (TableID, RowID, FunctionID, FriendlyTableName)
                    select TableID, RowID, FunctionID, FriendlyTableName
                    from dbo.UFN_PDACCOUNT_GETCUSTOMTABLESFORSEGMENT_REVENUEBATCH(@REVENUEID, @REVENUESPLITID, @REVENUETRANSACTIONTYPECODE, @REVENUESPLITTYPECODE, @APPLICATIONCODE, @PAYMENTMETHODCODE, @DESIGNATIONID, @CURRENTAPPUSERID);

                return
            end