UFN_BATCHMERCHANDISEINVENTORY_GETLOOKUPITEMS

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHMERCHANDISEINVENTORYID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_BATCHMERCHANDISEINVENTORY_GETLOOKUPITEMS  
    (
        @BATCHMERCHANDISEINVENTORYID uniqueidentifier
    )
    returns table
    as
    return
    (
        select
            ID,
            LOOKUPCODE
        from
            dbo.BATCHMERCHANDISEINVENTORYLOOKUPCODE
        where
            BATCHMERCHANDISEINVENTORYID = @BATCHMERCHANDISEINVENTORYID
    );