Insert [dbo].[CategoryMaster](Code,Description,Status)Values (1,N'PetFood',1)
Insert [dbo].[CategoryMaster](Code,Description,Status)Values (2,N'Veternary',1)
Insert [dbo].[CategoryMaster](Code,Description,Status)Values (3,N'Suppliment',1)
Insert [dbo].[SubCategoryMaster](Code,Description,Status,CategoryID)Values (1,N'Khadya',1,1)
Insert [dbo].[SubCategoryMaster](Code,Description,Status,CategoryID)Values (2,N'Doctor Fees',1,2)
Insert [dbo].[SubCategoryMaster](Code,Description,Status,CategoryID)Values (3,N'Sugrash',1,3)
Insert [dbo].[SubCategoryMaster](Code,Description,Status,CategoryID)Values (3,N'Khapari',1,3)
Insert [dbo].[CountryMaster](Code,Description,Status)Values (1,N'India',1)
INSERT [dbo].[StateMaster] (Code,Description,Status,CountryId)Values (1,N'MP',1,1)
INSERT [dbo].[DistrictMaster](Code,Description,Status,stateId)Values (1,N'Indore',1,1)
INSERT [dbo].[TalukaMaster](Code,Description,Status,DistrictId)Values (1,N'Depalpur',1,1)
INSERT [dbo].[CityMaster](Code,Description,Status,TalukaId)Values (1,N'Akolya',1,1)
Insert [dbo].GenderMaster(Code,Description,Status)Values (1,N'Male',1)
Insert [dbo].GenderMaster(Code,Description,Status)Values (2,N'Female',1)
Insert [dbo].[SaluationMaster](Code,Description,Status)Values (1,N'Mr.',1)
Insert [dbo].[SaluationMaster](Code,Description,Status)Values (2,N'Mrs.',1)
Insert [dbo].[SaluationMaster](Code,Description,Status)Values (3,N'Miss.',1)
INSERT [dbo].[Configuration]
(
[Saluationid],
[Genderid],
[Countryid],
[Stateid],
[Districtid],
[Talukaid],
[Cityid],
[Status],
[AddedBy],
[UpdatedBy]
)
VALUES ( 1, 1, 1, 1, 1, 1, 1, 1, 1, 1)
GO
Insert [dbo].MilkTimeMaster(Code,Description,Status)Values (1,N'Morning',1)
Insert [dbo].MilkTimeMaster(Code,Description,Status)Values (2,N'Evening',1)
Insert [dbo].[MilkTypeMaster](Code,Description,Status)Values (1,N'Cow',1)
Insert [dbo].[MilkTypeMaster](Code,Description,Status)Values (2,N'Buffalow',1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (1, N'Masters', N'Masters', 0, 1, 0)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (2, N'MilkCollection', N'MilkCollection', 0, 2, 0)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (3, N'Payment', N'Payment', 0, 3, 0)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (4, N'Reports', N'Reports', 0, 4, 0)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (5, N'Administration', N'Administration', 0, 5, 0)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (6, N'SystemManagment', N'SystemManagment', 1, 1, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (7, N'SNFMaster', N'SNFMaster', 1, 2, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (8, N'FATMaster', N'FATMaster', 1, 3, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (9, N'RateMatrix', N'RateMatrix', 1, 4, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (10, N'MIlkType', N'MIlkType', 1, 5, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (11, N'MilkTime', N'MilkTime', 1, 6, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (12, N'CateryMaster', N'CateryMaster', 1, 7, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (13, N'SubCatery', N'SubCatery', 1, 8, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (14, N'CustomerMaster', N'CustomerMaster', 1, 9, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (15, N'DailyMilkCollectionMorning', N'DailyMilkCollectionMorning', 2, 1, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (16, N'DayEndCollectionMorning', N'DayEndCollectionMorning', 2, 2, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (17, N'DailyMilkCollectionEvening', N'DailyMilkCollectionEvening', 2, 3, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (18, N'DayEndCollectionEvening', N'DayEndCollectionEvening', 2, 4, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (19, N'DMCList', N'DMCList', 2, 5, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (20, N'Advance', N'Advance', 3, 1, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (21, N'PetFoodVeternary', N'PetFoodVeternary', 3, 2, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (22, N'BillProcess', N'BillProcess', 3, 3, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (23, N'BillProcessCustomer', N'BillProcessCustomer', 3, 4, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (24, N'CustomerLedger', N'CustomerLedger', 3, 5, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (25, N'ReportsCustomerList', N'ReportsCustomerList', 4, 1, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (26, N'ReportsDailyMilkCollectionDetails', N'ReportsDailyMilkCollectionDetails', 4, 2, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (27, N'ReportsDailyMilkCollectionSummery', N'ReportsDailyMilkCollectionSummery', 4, 3, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (28, N'ReportsDatewiseMilktimewisePrint', N'ReportsDatewiseMilktimewisePrint', 4, 4, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (29, N'ReportsAdvance', N'ReportsAdvance', 4, 5, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (30, N'ReportsSuppliment', N'ReportsSuppliment', 4, 6, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (31, N'ReportsBillProcessCustomerPrint', N'ReportsBillProcessCustomerPrint', 4, 7, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (32, N'ReportsBillProcessCustomerPrintDetails', N'ReportsBillProcessCustomerPrintDetails', 4, 8, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (33, N'Configuration', N'Configuration', 5, 1, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (34, N'Cancellation', N'Cancellation', 5, 2, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (35, N'SettlementCancellation', N'SettlementCancellation', 5, 3, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (36, N'ChangePassword', N'ChangePassword', 5, 4, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (37, N'AssignRights', N'AssignRights', 5, 5, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (38, N'CountryMaster', N'CountryMaster', 6, 1, 2)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (39, N'StateMaster', N'StateMaster', 6, 2, 2)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (40, N'DistrictMaster', N'DistrictMaster', 6, 3, 2)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (41, N'TalukaMaster', N'TalukaMaster', 6, 4, 2)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (42, N'CityMaster', N'CityMaster', 6, 5, 2)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (43, N'SexMaster', N'SexMaster', 6, 6, 2)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (44, N'SaluationMaster', N'SaluationMaster', 6, 7, 2)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (45, N'DailyMilkCollectionCancellation', N'DailyMilkCollectionCancellation', 34, 1, 2)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (46, N'AdvanceCancellation', N'AdvanceCancellation', 34, 2, 2)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (47, N'SupplimentCancellation', N'SupplimentCancellation', 34, 3, 2)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (48, N'AdvanceSettlementCancellation', N'AdvanceSettlementCancellation', 35, 1, 2)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (49, N'SupplimentSettlementCancellation', N'SupplimentSettlementCancellation', 35, 2, 2)
INSERT [dbo].[UserMaster] ([UserId], [Login], [Empid], [Password], [FirstName], [MiddleName], [LastName], [LoginTime], [LogoutTime], [LoginTimeValue], [SystemName], [isactive], [Status], [AddedBy], [UpdatedBy]) VALUES (1, N'1', 1, N'Admin', N'Admin', N'A', N'Admin', CAST(N'2014-10-15T10:00:00.000' AS DateTime), CAST(N'2014-10-15T11:00:00.000' AS DateTime), 1, N'My-PC', 0, 1, 1, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (1, 1, 1, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (2, 1, 2, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (3, 1, 3, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (4, 1, 4, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (5, 1, 5, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (6, 1, 6, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (7, 1, 7, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (8, 1, 8, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (9, 1, 9, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (10, 1, 10, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (11, 1, 11, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (12, 1, 12, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (13, 1, 13, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (14, 1, 14, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (15, 1, 15, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (16, 1, 16, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (17, 1, 17, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (18, 1, 18, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (19, 1, 19, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (20, 1, 20, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (21, 1, 21, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (22, 1, 22, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (23, 1, 23, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (24, 1, 24, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (25, 1, 25, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (26, 1, 26, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (27, 1, 27, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (28, 1, 28, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (29, 1, 29, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (30, 1, 30, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (31, 1, 31, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (32, 1, 32, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (33, 1, 33, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (34, 1, 34, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (35, 1, 35, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (36, 1, 36, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (37, 1, 37, 0)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (38, 1, 38, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (39, 1, 39, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (40, 1, 40, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (41, 1, 41, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (42, 1, 42, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (43, 1, 43, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (44, 1, 44, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (45, 1, 45, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (46, 1, 46, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (47, 1, 47, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (48, 1, 48, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (49, 1, 49, 1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (1,7.50,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (2,7.60,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (3,7.70,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (4,7.80,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (5,7.90,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (6,8.00,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (7,8.10,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (8,8.20,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (9,8.30,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (10,8.40,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (11,8.50,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (12,8.60,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (13,8.70,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (14,8.80,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (15,8.90,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (16,9.00,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (17,9.10,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (18,9.20,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (19,9.30,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (20,9.40,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (21,9.50,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 1,2.00,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 2,2.10,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 3,2.20,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 4,2.30,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 5,2.40,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 6,2.50,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 7,2.60,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 8,2.70,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 9,2.80,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 10,2.90,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 11,3.00,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 12,3.10,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 13,3.20,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 14,3.30,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 15,3.40,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 16,3.50,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 17,3.60,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 18,3.70,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 19,3.80,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 20,3.90,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 21,4.00,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 22,4.10,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 23,4.20,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 24,4.30,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 25,4.40,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 26,4.50,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 27,4.60,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 28,4.70,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 29,4.80,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 30,4.90,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 31,5.00,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 32,5.10,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 33,5.20,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 34,5.30,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 35,5.40,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 36,5.50,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 37,5.60,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 38,5.70,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 39,5.80,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 40,5.90,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 41,6.00,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 42,6.10,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 43,6.20,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 44,6.30,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 45,6.40,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 46,6.50,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 47,6.60,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 48,6.70,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 49,6.80,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 50,6.90,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 51,7.00,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 52,7.10,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 53,7.20,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 54,7.30,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 55,7.40,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 56,7.50,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 57,7.60,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 58,7.70,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 59,7.80,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 60,7.90,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 61,8.00,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 62,8.10,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 63,8.20,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 64,8.30,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 65,8.40,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 66,8.50,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 67,8.60,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 68,8.70,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 69,8.80,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 70,8.90,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 71,9.00,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 72,9.10,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 73,9.20,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 74,9.30,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 75,9.40,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 76,9.50,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 77,9.60,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 78,9.70,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 79,9.80,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 80,9.90,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 81,10.00,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 82,10.10,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 83,10.20,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 84,10.30,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 85,10.40,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 86,10.50,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 87,10.60,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 88,10.70,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 89,10.80,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 90,10.90,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 91,11.00,1,1,1)
Insert [dbo].[CategoryMaster](Code,Description,Status)Values (2,N'Veternary',1)
Insert [dbo].[CategoryMaster](Code,Description,Status)Values (3,N'Suppliment',1)
Insert [dbo].[SubCategoryMaster](Code,Description,Status,CategoryID)Values (1,N'Khadya',1,1)
Insert [dbo].[SubCategoryMaster](Code,Description,Status,CategoryID)Values (2,N'Doctor Fees',1,2)
Insert [dbo].[SubCategoryMaster](Code,Description,Status,CategoryID)Values (3,N'Sugrash',1,3)
Insert [dbo].[SubCategoryMaster](Code,Description,Status,CategoryID)Values (3,N'Khapari',1,3)
Insert [dbo].[CountryMaster](Code,Description,Status)Values (1,N'India',1)
INSERT [dbo].[StateMaster] (Code,Description,Status,CountryId)Values (1,N'MP',1,1)
INSERT [dbo].[DistrictMaster](Code,Description,Status,stateId)Values (1,N'Indore',1,1)
INSERT [dbo].[TalukaMaster](Code,Description,Status,DistrictId)Values (1,N'Depalpur',1,1)
INSERT [dbo].[CityMaster](Code,Description,Status,TalukaId)Values (1,N'Akolya',1,1)
Insert [dbo].GenderMaster(Code,Description,Status)Values (1,N'Male',1)
Insert [dbo].GenderMaster(Code,Description,Status)Values (2,N'Female',1)
Insert [dbo].[SaluationMaster](Code,Description,Status)Values (1,N'Mr.',1)
Insert [dbo].[SaluationMaster](Code,Description,Status)Values (2,N'Mrs.',1)
Insert [dbo].[SaluationMaster](Code,Description,Status)Values (3,N'Miss.',1)
INSERT [dbo].[Configuration]
(
[Saluationid],
[Genderid],
[Countryid],
[Stateid],
[Districtid],
[Talukaid],
[Cityid],
[Status],
[AddedBy],
[UpdatedBy]
)
VALUES ( 1, 1, 1, 1, 1, 1, 1, 1, 1, 1)
GO
Insert [dbo].MilkTimeMaster(Code,Description,Status)Values (1,N'Morning',1)
Insert [dbo].MilkTimeMaster(Code,Description,Status)Values (2,N'Evening',1)
Insert [dbo].[MilkTypeMaster](Code,Description,Status)Values (1,N'Cow',1)
Insert [dbo].[MilkTypeMaster](Code,Description,Status)Values (2,N'Buffalow',1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (1, N'Masters', N'Masters', 0, 1, 0)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (2, N'MilkCollection', N'MilkCollection', 0, 2, 0)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (3, N'Payment', N'Payment', 0, 3, 0)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (4, N'Reports', N'Reports', 0, 4, 0)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (5, N'Administration', N'Administration', 0, 5, 0)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (6, N'SystemManagment', N'SystemManagment', 1, 1, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (7, N'SNFMaster', N'SNFMaster', 1, 2, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (8, N'FATMaster', N'FATMaster', 1, 3, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (9, N'RateMatrix', N'RateMatrix', 1, 4, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (10, N'MIlkType', N'MIlkType', 1, 5, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (11, N'MilkTime', N'MilkTime', 1, 6, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (12, N'CateryMaster', N'CateryMaster', 1, 7, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (13, N'SubCatery', N'SubCatery', 1, 8, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (14, N'CustomerMaster', N'CustomerMaster', 1, 9, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (15, N'DailyMilkCollectionMorning', N'DailyMilkCollectionMorning', 2, 1, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (16, N'DayEndCollectionMorning', N'DayEndCollectionMorning', 2, 2, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (17, N'DailyMilkCollectionEvening', N'DailyMilkCollectionEvening', 2, 3, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (18, N'DayEndCollectionEvening', N'DayEndCollectionEvening', 2, 4, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (19, N'DMCList', N'DMCList', 2, 5, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (20, N'Advance', N'Advance', 3, 1, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (21, N'PetFoodVeternary', N'PetFoodVeternary', 3, 2, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (22, N'BillProcess', N'BillProcess', 3, 3, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (23, N'BillProcessCustomer', N'BillProcessCustomer', 3, 4, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (24, N'CustomerLedger', N'CustomerLedger', 3, 5, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (25, N'ReportsCustomerList', N'ReportsCustomerList', 4, 1, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (26, N'ReportsDailyMilkCollectionDetails', N'ReportsDailyMilkCollectionDetails', 4, 2, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (27, N'ReportsDailyMilkCollectionSummery', N'ReportsDailyMilkCollectionSummery', 4, 3, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (28, N'ReportsDatewiseMilktimewisePrint', N'ReportsDatewiseMilktimewisePrint', 4, 4, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (29, N'ReportsAdvance', N'ReportsAdvance', 4, 5, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (30, N'ReportsSuppliment', N'ReportsSuppliment', 4, 6, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (31, N'ReportsBillProcessCustomerPrint', N'ReportsBillProcessCustomerPrint', 4, 7, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (32, N'ReportsBillProcessCustomerPrintDetails', N'ReportsBillProcessCustomerPrintDetails', 4, 8, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (33, N'Configuration', N'Configuration', 5, 1, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (34, N'Cancellation', N'Cancellation', 5, 2, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (35, N'SettlementCancellation', N'SettlementCancellation', 5, 3, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (36, N'ChangePassword', N'ChangePassword', 5, 4, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (37, N'AssignRights', N'AssignRights', 5, 5, 1)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (38, N'CountryMaster', N'CountryMaster', 6, 1, 2)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (39, N'StateMaster', N'StateMaster', 6, 2, 2)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (40, N'DistrictMaster', N'DistrictMaster', 6, 3, 2)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (41, N'TalukaMaster', N'TalukaMaster', 6, 4, 2)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (42, N'CityMaster', N'CityMaster', 6, 5, 2)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (43, N'SexMaster', N'SexMaster', 6, 6, 2)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (44, N'SaluationMaster', N'SaluationMaster', 6, 7, 2)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (45, N'DailyMilkCollectionCancellation', N'DailyMilkCollectionCancellation', 34, 1, 2)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (46, N'AdvanceCancellation', N'AdvanceCancellation', 34, 2, 2)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (47, N'SupplimentCancellation', N'SupplimentCancellation', 34, 3, 2)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (48, N'AdvanceSettlementCancellation', N'AdvanceSettlementCancellation', 35, 1, 2)
INSERT [dbo].[MenuMaster] ([MenuId], [MenuName], [MenuKey], [ParentId], [MenuOrder], [Level]) VALUES (49, N'SupplimentSettlementCancellation', N'SupplimentSettlementCancellation', 35, 2, 2)
INSERT [dbo].[UserMaster] ([UserId], [Login], [Empid], [Password], [FirstName], [MiddleName], [LastName], [LoginTime], [LogoutTime], [LoginTimeValue], [SystemName], [isactive], [Status], [AddedBy], [UpdatedBy]) VALUES (1, N'1', 1, N'Admin', N'Admin', N'A', N'Admin', CAST(N'2014-10-15T10:00:00.000' AS DateTime), CAST(N'2014-10-15T11:00:00.000' AS DateTime), 1, N'My-PC', 0, 1, 1, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (1, 1, 1, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (2, 1, 2, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (3, 1, 3, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (4, 1, 4, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (5, 1, 5, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (6, 1, 6, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (7, 1, 7, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (8, 1, 8, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (9, 1, 9, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (10, 1, 10, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (11, 1, 11, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (12, 1, 12, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (13, 1, 13, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (14, 1, 14, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (15, 1, 15, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (16, 1, 16, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (17, 1, 17, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (18, 1, 18, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (19, 1, 19, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (20, 1, 20, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (21, 1, 21, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (22, 1, 22, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (23, 1, 23, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (24, 1, 24, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (25, 1, 25, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (26, 1, 26, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (27, 1, 27, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (28, 1, 28, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (29, 1, 29, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (30, 1, 30, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (31, 1, 31, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (32, 1, 32, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (33, 1, 33, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (34, 1, 34, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (35, 1, 35, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (36, 1, 36, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (37, 1, 37, 0)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (38, 1, 38, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (39, 1, 39, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (40, 1, 40, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (41, 1, 41, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (42, 1, 42, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (43, 1, 43, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (44, 1, 44, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (45, 1, 45, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (46, 1, 46, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (47, 1, 47, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (48, 1, 48, 1)
INSERT [dbo].[UserMenuMaster] ([Id], [UserId], [MenuId], [RightStatus]) VALUES (49, 1, 49, 1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (1,7.50,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (2,7.60,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (3,7.70,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (4,7.80,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (5,7.90,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (6,8.00,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (7,8.10,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (8,8.20,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (9,8.30,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (10,8.40,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (11,8.50,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (12,8.60,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (13,8.70,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (14,8.80,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (15,8.90,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (16,9.00,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (17,9.10,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (18,9.20,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (19,9.30,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (20,9.40,1,1,1)
INSERT [SNFMaster] ([code], [SNF_Value], [Status], [AddedBy], [UpdatedBy]) VALUES (21,9.50,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 1,2.00,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 2,2.10,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 3,2.20,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 4,2.30,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 5,2.40,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 6,2.50,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 7,2.60,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 8,2.70,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 9,2.80,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 10,2.90,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 11,3.00,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 12,3.10,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 13,3.20,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 14,3.30,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 15,3.40,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 16,3.50,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 17,3.60,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 18,3.70,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 19,3.80,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 20,3.90,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 21,4.00,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 22,4.10,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 23,4.20,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 24,4.30,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 25,4.40,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 26,4.50,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 27,4.60,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 28,4.70,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 29,4.80,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 30,4.90,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 31,5.00,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 32,5.10,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 33,5.20,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 34,5.30,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 35,5.40,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 36,5.50,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 37,5.60,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 38,5.70,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 39,5.80,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 40,5.90,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 41,6.00,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 42,6.10,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 43,6.20,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 44,6.30,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 45,6.40,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 46,6.50,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 47,6.60,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 48,6.70,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 49,6.80,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 50,6.90,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 51,7.00,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 52,7.10,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 53,7.20,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 54,7.30,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 55,7.40,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 56,7.50,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 57,7.60,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 58,7.70,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 59,7.80,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 60,7.90,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 61,8.00,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 62,8.10,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 63,8.20,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 64,8.30,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 65,8.40,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 66,8.50,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 67,8.60,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 68,8.70,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 69,8.80,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 70,8.90,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 71,9.00,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 72,9.10,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 73,9.20,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 74,9.30,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 75,9.40,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 76,9.50,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 77,9.60,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 78,9.70,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 79,9.80,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 80,9.90,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 81,10.00,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 82,10.10,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 83,10.20,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 84,10.30,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 85,10.40,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 86,10.50,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 87,10.60,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 88,10.70,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 89,10.80,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 90,10.90,1,1,1)
INSERT [FATMaster]([code], [FAT_Value], [Status], [AddedBy], [UpdatedBy]) VALUES ( 91,11.00,1,1,1)
Comments
Post a Comment
If you have any doubt then please let me know in comment section.