Stored Procedures [dbo].[MssWebGetContractsLookups]
BUILD09 > MoversSuite2 > Stored Procedures > dbo.MssWebGetContractsLookups
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Permissions
TypeActionOwning Principal
GrantExecuteMssExec
SQL Script
/*
*
* Module: Revenue Entry
* Description: Gets the Contract information ordered by description.  For lookups.
* Error Codes:   
*
*/
CREATE PROCEDURE [dbo].[MssWebGetContractsLookups] AS
SELECT
ContractMasterId=CMPriKey,
Description,
Inactive,
ContractName=Contract
FROM ContractMaster
ORDER BY Description
GO
GRANT EXECUTE ON  [dbo].[MssWebGetContractsLookups] TO [MssExec]
GO
Uses
Created 24 June 2025 15:32
Copyright  2025 - All Rights Reserved