[dbo].[GetGlAccountJoinField

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)
@inAccountingAccountId	int	4
@inGLNumber	varchar(65)	65

Type	Action	Owning Principal
Grant	Select	MssExec

SQL Script

/*
*    Creates a table function for joining constant GlAccountJoinField values to the
*    GlAccountInformation view or others that have GlAccountJoinField.
*    The GetGlAccountJoinField_Synonym will be set to use the appropriate function for the current
*    system, based upon if they have XLedger, GP, QuickBooks or no accounting system.
*/
create function [dbo].[GetGlAccountJoinField_XLedger]( @inAccountingAccountId int, @inGLNumber varchar(65) )
returns table as
    return (
        select
            GlAccountJoinField = @inAccountingAccountId
    )
GO
GRANT SELECT ON  [dbo].[GetGlAccountJoinField_XLedger] TO [MssExec]
GO