CREATE PROCEDURE [dbo].[MssWebCreateInternationalLiftVan]
    @inOrdersFID 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
    
    declare @id int
    
    insert into InternationalLiftVan
    (
        OrdersFID,
        InternationalContainerFID,
        InternationalLiftVanStatusFID,
        LiftVanNumber,
        Pieces,
        GrossWeight,
        TareWeight,
        NetWeight,
        SealNumber,
        CubicFeet,
        [Length],
        Width,
        Height
    )
    select
        @inOrdersFID,
        @inInternationalContainerFID,
        @inInternationalLiftVanStatusFID,
        @inLiftVanNumber,
        @inPieces,
        @inGrossWeight,
        @inTareWeight,
        @inNetWeight,
        @inSealNumber,
        @inCubicFeet,
        @inLength,
        @inWidth,
        @inHeight

    set @id = SCOPE_IDENTITY()

    select @id

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