There is only one OrderID.
I don't get an error just data for last row:
GH_Office_Material_Orders :
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[GH_Office_Material_Orders](
[OrderID] [int] IDENTITY(1,1) NOT NULL,
[ReasonID] [int] NOT NULL,
[Name] [nvarchar](50) NULL,
[Partner_Created] [int] NULL,
[Date_Created] [datetime] NULL,
[Delivery_LocationID] [int] NULL,
[Partner_Approved] [int] NULL,
[Date_Approved] [datetime] NULL,
[StatusID] [int] NULL,
[StatusName] AS ([dbo].[Status_Name]([StatusID])),
[Access] [int] NULL,
[DocName] [varchar](150) NULL,
CONSTRAINT [PK_GH_Office_Material_Order] PRIMARY KEY CLUSTERED
(
[OrderID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[GH_Office_Material_Orders] WITH CHECK ADD CONSTRAINT [FK_GH_Office_Material_Orders_GH_Cost_Center1] FOREIGN KEY([Delivery_LocationID])
REFERENCES [dbo].[GH_Cost_Center] ([Cost_CenterID])
GO
ALTER TABLE [dbo].[GH_Office_Material_Orders] CHECK CONSTRAINT [FK_GH_Office_Material_Orders_GH_Cost_Center1]
GO
ALTER TABLE [dbo].[GH_Office_Material_Orders] WITH CHECK ADD CONSTRAINT [FK_GH_Office_Material_Orders_GH_Office_Material_Order_Reason] FOREIGN KEY([ReasonID])
REFERENCES [dbo].[GH_Office_Material_Order_Reason] ([ReasonID])
GO
ALTER TABLE [dbo].[GH_Office_Material_Orders] CHECK CONSTRAINT [FK_GH_Office_Material_Orders_GH_Office_Material_Order_Reason]
GO
ALTER TABLE [dbo].[GH_Office_Material_Orders] WITH CHECK ADD CONSTRAINT [FK_GH_Office_Material_Orders_GH_Office_Material_Order_Status] FOREIGN KEY([StatusID])
REFERENCES [dbo].[GH_Office_Material_Order_Status] ([StatusID])
GO
ALTER TABLE [dbo].[GH_Office_Material_Orders] CHECK CONSTRAINT [FK_GH_Office_Material_Orders_GH_Office_Material_Order_Status]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ured u koji ce se izvršiti narudžba' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'GH_Office_Material_Orders'
GO
GH_Office_Material_Order_Material
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[GH_Office_Material_Order_Material](
[Material_OrderID] [int] IDENTITY(1,1) NOT NULL,
[OrderID] [int] NOT NULL,
[MatrialID] [int] NOT NULL,
[UnitID] [int] NOT NULL,
[Quantity] [int] NOT NULL,
[Unit_Price] [float] NOT NULL,
[Price] [float] NULL,
[Partner_Created] [int] NULL,
[Date_Created] [datetime] NULL,
[MaterialName] AS ([dbo].[Material_Name]([MatrialID])),
[MaterialGroupID] [int] NULL,
[StatusID] [int] NULL,
[QuantityDelivered] [int] NULL,
[QuantityUndelivered] [int] NULL,
[SupplierName] [varchar](50) NULL,
[Description] [varchar](max) NULL,
[CatalogBr] [nvarchar](50) NULL,
[MaterialNameOld] [varchar](150) NULL,
[StatusIDOld] [int] NULL,
[PartnerName] [varchar](100) NULL,
[LastUpdated] [datetime] NULL,
CONSTRAINT [PK_GH_Office_Material_Order_Material] PRIMARY KEY CLUSTERED
(
[Material_OrderID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO