USE [Returns]
GO
/****** Object: Table [dbo].[Exporter_Returns] Script Date: 03/06/2019 17:30:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Exporter_Returns](
[rt_id] [numeric](18, 0) NOT NULL,
[exporter_id] nchar NULL,
[company_name] nvarchar NULL,
[icd_name] nvarchar NULL,
[port_name] nvarchar NULL,
[region] nvarchar NULL,
[country_name] nvarchar NULL,
[variety_name] nvarchar NULL,
[type_name] nvarchar NULL,
[quantity] [numeric](18, 2) NULL,
[fob] [numeric](18, 2) NULL,
[unitprice] [numeric](18, 2) NULL,
[returns_month] [datetime] NULL,
[submited_date] [datetime] NULL,
[uname] nvarchar NULL
) ON [PRIMARY]
GO
INSERT [dbo].[Exporter_Returns] ([rt_id], [exporter_id], [company_name], [icd_name], [port_name], [region], [country_name], [variety_name], [type_name], [quantity], [fob], [unitprice], [returns_month], [submited_date], [uname]) VALUES (CAST(1 AS Numeric(18, 0)), N'pe-2900 ', N'SUBODH BROTHERS PVT.LTD.', NULL, NULL, NULL, NULL, NULL, NULL, CAST(0.00 AS Numeric(18, 2)), CAST(0.00 AS Numeric(18, 2)), CAST(0.00 AS Numeric(18, 2)), CAST(0x0000A24A00000000 AS DateTime), CAST(0x0000A26900000000 AS DateTime), N'manish')
INSERT [dbo].[Exporter_Returns] ([rt_id], [exporter_id], [company_name], [icd_name], [port_name], [region], [country_name], [variety_name], [type_name], [quantity], [fob], [unitprice], [returns_month], [submited_date], [uname]) VALUES (CAST(1 AS Numeric(18, 0)), N'e-5033 ', N'Plantrich Agri Tech Private Limited', NULL, NULL, NULL, NULL, NULL, NULL, CAST(0.00 AS Numeric(18, 2)), CAST(0.00 AS Numeric(18, 2)), CAST(0.00 AS Numeric(18, 2)), CAST(0x0000A24A00000000 AS DateTime), CAST(0x0000A26C00000000 AS DateTime), N'teerna')
INSERT [dbo].[Exporter_Returns] ([rt_id], [exporter_id], [company_name], [icd_name], [port_name], [region], [country_name], [variety_name], [type_name], [quantity], [fob], [unitprice], [returns_month], [submited_date], [uname]) VALUES (CAST(1 AS Numeric(18, 0)), N'pe-4112 ', N'KUSUM INTERNATIONAL', N'CALCUTTA SEA', N'CALCUTTA SEA', N'NORTH', N'GERMANY', N'C.T.C', N'Bulk Tea', CAST(50000.00 AS Numeric(18, 2)), CAST(11365606.00 AS Numeric(18, 2)), CAST(227.00 AS Numeric(18, 2)), CAST(0x0000A24A00000000 AS DateTime), CAST(0x0000A26D00000000 AS DateTime), N'teerna')
INSERT [dbo].[Exporter_Returns] ([rt_id], [exporter_id], [company_name], [icd_name], [port_name], [region], [country_name], [variety_name], [type_name], [quantity], [fob], [unitprice], [returns_month], [submited_date], [uname]) VALUES (CAST(1 AS Numeric(18, 0)), N'pe-2187 ', N'TONGANI TEA COMPANY LIMITED', NULL, NULL, NULL, NULL, NULL, NULL, CAST(0.00 AS Numeric(18, 2)), CAST(0.00 AS Numeric(18, 2)), CAST(0.00 AS Numeric(18, 2)), CAST(0x0000A24A00000000 AS DateTime), CAST(0x0000A27000000000 AS DateTime), N'teerna')
INSERT [dbo].[Exporter_Returns] ([rt_id], [exporter_id], [company_name], [icd_name], [port_name], [region], [country_name], [variety_name], [type_name], [quantity], [fob], [unitprice], [returns_month], [submited_date], [uname]) VALUES (CAST(1 AS Numeric(18, 0)), N'pe-3693 ', N'AQUARIUS MARKETING PVT.LTD.', N'', N'CALCUTTA SEA', N'NORTH', N'U.A.E', N'C.T.C', N'Bulk Tea', CAST(45923.00 AS Numeric(18, 2)), CAST(9130522.00 AS Numeric(18, 2)), CAST(198.00 AS Numeric(18, 2)), CAST(0x0000A24A00000000 AS DateTime), CAST(0x0000A27300000000 AS DateTime), N'manish')
INSERT [dbo].[Exporter_Returns] ([rt_id], [exporter_id], [company_name], [icd_name], [port_name], [region], [country_name], [variety_name], [type_name], [quantity], [fob], [unitprice], [returns_month], [submited_date], [uname]) VALUES (CAST(1 AS Numeric(18, 0)), N'pe-2103 ', N'KAIRBETTA ESTATES SYNDICATE', N'TUTICORIN', N'TUTICORIN', N'SOUTH', N'RUSSIAN FED', N'Orthodox', N'Bulk Tea', CAST(11600.00 AS Numeric(18, 2)), CAST(1792090.00 AS Numeric(18, 2)), CAST(154.00 AS Numeric(18, 2)), CAST(0x0000A24A00000000 AS DateTime), CAST(0x0000A27400000000 AS DateTime), N'teerna')
INSERT [dbo].[Exporter_Returns] ([rt_id], [exporter_id], [company_name], [icd_name], [port_name], [region], [country_name], [variety_name], [type_name], [quantity], [fob], [unitprice], [returns_month], [submited_date], [uname]) VALUES (CAST(1 AS Numeric(18, 0)), N'pe-2970 ', N'PARAG & CO.', NULL, NULL, NULL, NULL, NULL, NULL, CAST(0.00 AS Numeric(18, 2)), CAST(0.00 AS Numeric(18, 2)), CAST(0.00 AS Numeric(18, 2)), CAST(0x0000A24A00000000 AS DateTime), CAST(0x0000A27500000000 AS DateTime), N'manish')
INSERT [dbo].[Exporter_Returns] ([rt_id], [exporter_id], [company_name], [icd_name], [port_name], [region], [country_name], [variety_name], [type_name], [quantity], [fob], [unitprice], [returns_month], [submited_date], [uname]) VALUES (CAST(1 AS Numeric(18, 0)), N'pe-1821 ', N'B.R. MALHOTRA & C0. PVT. LTD.', N'', N'CALCUTTA SEA', N'NORTH', N'U.A.E', N'Orthodox', N'Bulk Tea', CAST(16500.00 AS Numeric(18, 2)), CAST(4224395.00 AS Numeric(18, 2)), CAST(256.00 AS Numeric(18, 2)), CAST(0x0000A24A00000000 AS DateTime), CAST(0x0000A27600000000 AS DateTime), N'teerna')
INSERT [dbo].[Exporter_Returns] ([rt_id], [exporter_id], [company_name], [icd_name], [port_name], [region], [country_name], [variety_name], [type_name], [quantity], [fob], [unitprice], [returns_month], [submited_date], [uname]) VALUES (CAST(1 AS Numeric(18, 0)), N'pe-3554 ', N'SAPAT INTERNATIONAL PVT.LTD.,', NULL, NULL, NULL, NULL, NULL, NULL, CAST(0.00 AS Numeric(18, 2)), CAST(0.00 AS Numeric(18, 2)), CAST(0.00 AS Numeric(18, 2)), CAST(0x0000A24A00000000 AS DateTime), CAST(0x0000A27A00000000 AS DateTime), N'teerna')
INSERT [dbo].[Exporter_Returns] ([rt_id], [exporter_id], [company_name], [icd_name], [port_name], [region], [country_name], [variety_name], [type_name], [quantity], [fob], [unitprice], [returns_month], [submited_date], [uname]) VALUES (CAST(1 AS Numeric(18, 0)), N'pe-1563 ', N'TEA PROMOTERS(INDIA) PVT LTD', NULL, NULL, NULL, NULL, NULL, NULL, CAST(0.00 AS Numeric(18, 2)), CAST(0.00 AS Numeric(18, 2)), CAST(0.00 AS Numeric(18, 2)), CAST(0x0000A24A00000000 AS DateTime), CAST(0x0000A27B00000000 AS DateTime), N'teerna')
INSERT [dbo].[Exporter_Returns] ([rt_id], [exporter_id], [company_name], [icd_name], [port_name], [region], [country_name], [variety_name], [type_name], [quantity], [fob], [unitprice], [returns_month], [submited_date], [uname]) VALUES (CAST(1 AS Numeric(18, 0)), N'pe-1859 ', N'Bokahola Tea Company Pvt. Ltd.', NULL, NULL, NULL, NULL, NULL, NULL, CAST(0.00 AS Numeric(18, 2)), CAST(0.00 AS Numeric(18, 2)), CAST(0.00 AS Numeric(18, 2)), CAST(0x0000A24A00000000 AS DateTime), CAST(0x0000A27C00000000 AS DateTime), N'teerna')
INSERT [dbo].[Exporter_Returns] ([rt_id], [exporter_id], [company_name], [icd_name], [port_name], [region], [country_name], [variety_name], [type_name], [quantity], [fob], [unitprice], [returns_month], [submited_date], [uname]) VALUES (CAST(1 AS Numeric(18, 0)), N'E-5110 ', N'Islet Coast Trading Company Pvt. Ltd.', NULL, NULL, NULL, NULL, NULL, NULL, CAST(0.00 AS Numeric(18, 2)), CAST(0.00 AS Numeric(18, 2)), CAST(0.00 AS Numeric(18, 2)), CAST(0x0000A24A00000000 AS DateTime), CAST(0x0000A27D00000000 AS DateTime), N'teerna')
INSERT [dbo].[Exporter_Returns] ([rt_id], [exporter_id], [company_name], [icd_name], [port_name], [region], [country_name], [variety_name], [type_name], [quantity], [fob], [unitprice], [returns_month], [submited_date], [uname]) VALUES (CAST(1 AS Numeric(18, 0)), N'pe-2482 ', N'RAGHUNATH EXPORTS COMPANY', NULL, NULL, NULL, NULL, NULL, NULL, CAST(0.00 AS Numeric(18, 2)), CAST(0.00 AS Numeric(18, 2)), CAST(0.00 AS Numeric(18, 2)), CAST(0x0000A24A00000000 AS DateTime), CAST(0x0000A27E00000000 AS DateTime), N'abhijit')
INSERT [dbo].[Exporter_Returns] ([rt_id], [exporter_id], [company_name], [icd_name], [port_name], [region], [country_name], [variety_name], [type_name], [quantity], [fob], [unitprice], [returns_month], [submited_date], [uname]) VALUES (CAST(1 AS Numeric(18, 0)), N'pe-1332 ', N'MCLEOD RUSSEL INDIA LIMITED', N'', N'AMINGAON(ICD)', N'NORTH', N'CANADA', N'C.T.C', N'Bulk Tea', CAST(22720.00 AS Numeric(18, 2)), CAST(5244023.00 AS Numeric(18, 2)), CAST(230.00 AS Numeric(18, 2)), CAST(0x0000A24A00000000 AS DateTime), CAST(0x0000A28100000000 AS DateTime), N'manish')
INSERT [dbo].[Exporter_Returns] ([rt_id], [exporter_id], [company_name], [icd_name], [port_name], [region], [country_name], [variety_name], [type_name], [quantity], [fob], [unitprice], [returns_month], [submited_date], [uname]) VALUES (CAST(1 AS Numeric(18, 0)), N'pe-3030 ', N'JFK INTERNATIONAL', N'', N'CALCUTTA SEA', N'NORTH', N'RUSSIAN FED', N'C.T.C', N'Bulk Tea', CAST(25500.00 AS Numeric(18, 2)), CAST(2894971.00 AS Numeric(18, 2)), CAST(113.00 AS Numeric(18, 2)), CAST(0x0000A24A00000000 AS DateTime), CAST(0x0000A28200000000 AS DateTime), N'manish')
INSERT [dbo].[Exporter_Returns] ([rt_id], [exporter_id], [company_name], [icd_name], [port_name], [region], [country_name], [variety_name], [type_name], [quantity], [fob], [unitprice], [returns_month], [submited_date], [uname]) VALUES (CAST(1 AS Numeric(18, 0)), N'pe-2059 ', N'ANDREW YULE & CO LTD.', N'', N'CALCUTTA SEA', N'NORTH', N'CANADA', N'C.T.C', N'Bulk Tea', CAST(22680.00 AS Numeric(18, 2)), CAST(4434029.00 AS Numeric(18, 2)), CAST(195.00 AS Numeric(18, 2)), CAST(0x0000A24A00000000 AS DateTime), CAST(0x0000A28300000000 AS DateTime), N'manish')
INSERT [dbo].[Exporter_Returns] ([rt_id], [exporter_id], [company_name], [icd_name], [port_name], [region], [country_name], [variety_name], [type_name], [quantity], [fob], [unitprice], [returns_month], [submited_date], [uname]) VALUES (CAST(1 AS Numeric(18, 0)), N'pe-2488 ', N'LIMTEX (INDIA)LTD.', N'', N'COCHIN SEA', N'SOUTH', N'PAKISTAN', N'C.T.C', N'Bulk Tea', CAST(363370.00 AS Numeric(18, 2)), CAST(30387145.00 AS Numeric(18, 2)), CAST(83.00 AS Numeric(18, 2)), CAST(0x0000A24A00000000 AS DateTime), CAST(0x0000A28400000000 AS DateTime), N'manish')
INSERT [dbo].[Exporter_Returns] ([rt_id], [exporter_id], [company_name], [icd_name], [port_name], [region], [country_name], [variety_name], [type_name], [quantity], [fob], [unitprice], [returns_month], [submited_date], [uname]) VALUES (CAST(1 AS Numeric(18, 0)), N'Pe-4339 ', N'JFK International Ltd.', N'', N'COCHIN SEA', N'SOUTH', N'POLAND', N'C.T.C', N'Bulk Tea', CAST(22500.00 AS Numeric(18, 2)), CAST(1919334.00 AS Numeric(18, 2)), CAST(85.00 AS Numeric(18, 2)), CAST(0x0000A24A00000000 AS DateTime), CAST(0x0000A28500000000 AS DateTime), N'teerna')
INSERT [dbo].[Exporter_Returns] ([rt_id], [exporter_id], [company_name], [icd_name], [port_name], [region], [country_name], [variety_name], [type_name], [quantity], [fob], [unitprice], [returns_month], [submited_date], [uname]) VALUES (CAST(16 AS Numeric(18, 0)), N'e-3887 ', N'Inderchand Sitaram', NULL, NULL, NULL, NULL, NULL, NULL, CAST(0.00 AS Numeric(18, 2)), CAST(0.00 AS Numeric(18, 2)), CAST(0.00 AS Numeric(18, 2)), CAST(0x0000A2E100000000 AS DateTime), CAST(0x0000A31600000000 AS DateTime), N'manish')
INSERT [dbo].[Exporter_Returns] ([rt_id], [exporter_id], [company_name], [icd_name], [port_name], [region], [country_name], [variety_name], [type_name], [quantity], [fob], [unitprice], [returns_month], [submited_date], [uname]) VALUES (CAST(47 AS Numeric(18, 0)), N'pe-3915 ', N'Lochan Tea Limited', NULL, NULL, NULL, NULL, NULL, NULL, CAST(0.00 AS Numeric(18, 2)), CAST(0.00 AS Numeric(18, 2)), CAST(0.00 AS Numeric(18, 2)), CAST(0x0000A26900000000 AS DateTime), CAST(0x0000A2B900000000 AS DateTime), N'Administrator')
Sir, around 37000 records are there, So i pasted here only 25 records for execution purpose.
Thanks