CREATE PROCEDURE [dbo].[MssWebUpdateInternationalLiftVan]
    @inOrdersFID int,
    @inInternationalLiftVanID int,
    @inInternationalContainerFID int,
    @inInternationalLiftVanStatusFID int,
    @inLiftVanNumber varchar(32),
    @inPieces int,
    @inGrossWeight int,
    @inTareWeight int,
    @inNetWeight int,
    @inSealNumber varchar(32),
    @inCubicFeet int,
    @inLength int,
    @inWidth int,
    @inHeight int

as
begin

    SET NOCOUNT ON
    
      update InternationalLiftVan set
        InternationalContainerFID = @inInternationalContainerFID,
        InternationalLiftVanStatusFID = @inInternationalLiftVanStatusFID,
        LiftVanNumber = @inLiftVanNumber,
        Pieces = @inPieces,
        GrossWeight = @inGrossWeight,
        TareWeight = @inTareWeight,
        NetWeight = @inNetWeight,
        SealNumber = @inSealNumber,
        CubicFeet = @inCubicFeet,
        [Length] = @inLength,
        Width = @inWidth,
        Height = @inHeight
      where OrdersFID = @inOrdersFID and InternationalLiftVanID = @inInternationalLiftVanID

end
GO
GRANT EXECUTE ON  [dbo].[MssWebUpdateInternationalLiftVan] TO [MssExec]
GO