[dbo].[GetCustomerJoinField

[dbo].[GetCustomerJoinField_XLedger]

BUILD09 > MoversSuite2 > Table-valued Functions > dbo.GetCustomerJoinField_XLedger

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)
@inCustomerId	int	4
@inCustNumber	varchar(15)	15

Type	Action	Owning Principal
Grant	Select	MssExec

/*
*    Creates a table function for joining constant CustomerJoinField to other
*    views that have CustomerJoinField.
*    The GetCustomerJoinField_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].[GetCustomerJoinField_XLedger]( @inCustomerId int, @inCustNumber varchar(15) )
returns table as
    return (
        select
            CustomerJoinField = @inCustomerId
    )
GO
GRANT SELECT ON  [dbo].[GetCustomerJoinField_XLedger] TO [MssExec]
GO