CREATE PROCEDURE [dbo].[MssWebCreateInternationalContainer]
    @inOrdersFID int,
    @inInternationalContainerLoadTypeFID int,
    @inContainerNumber varchar(32),
    @inPieces int,
    @inGrossWeight int,
    @inTareWeight int,
    @inNetWeight int,
    @inSealNumber varchar(32),
    @inCubicFeet int,
    @inRequiredDate date,
    @inPositionedDate date,
    @inLoadedDate date,
    @inEmptyDate date,
    @inReturnedDate date,
    @inSealNumber2 varchar(32),
    @inInternationalContainerSizeTypeFID int,
    @inAutoInContainer bit
as
begin

    SET NOCOUNT ON
    
    declare @id INT
    
      insert into InternationalContainer
      (
        OrdersFID,
        InternationalContainerLoadTypeFId,
        ContainerNumber,
        Pieces,
        GrossWeight,
        TareWeight,
        NetWeight,
        SealNumber,
        CubicFeet,
        RequiredDate,
        PositionedDate,
        LoadedDate,
        EmptyDate,
        ReturnedDate,
        SealNumber2,
        InternationalContainerSizeTypeFID,
        AutoInContainer
      )
    select
        @inOrdersFID,
        @inInternationalContainerLoadTypeFId,
        @inContainerNumber,
        @inPieces,
        @inGrossWeight,
        @inTareWeight,
        @inNetWeight,
        @inSealNumber,
        @inCubicFeet,
        @inRequiredDate,
        @inPositionedDate,
        @inLoadedDate,
        @inEmptyDate,
        @inReturnedDate,
        @inSealNumber2,
        @inInternationalContainerSizeTypeFID,
        @inAutoInContainer

    set @id = SCOPE_IDENTITY()

    select @id

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