Stored Procedures [dbo].[MssWebGetOrderGuaranteePriceChargeCredit]
BUILD09 > MoversSuite2 > Stored Procedures > dbo.MssWebGetOrderGuaranteePriceChargeCredit
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@inOrderIdint4
Permissions
TypeActionOwning Principal
GrantExecuteMssExec
SQL Script
create procedure [dbo].[MssWebGetOrderGuaranteePriceChargeCredit]
    @inOrderId int
as
begin
    set nocount on;

    select
        Charge,
        Credit
    from GuaranteedPrice
    where OrderFID = @inOrderId;

end
GO
GRANT EXECUTE ON  [dbo].[MssWebGetOrderGuaranteePriceChargeCredit] TO [MssExec]
GO
Uses
Created 09 February 2026 07:28
Copyright  2026 - All Rights Reserved