
SET IDENTITY_INSERT [dbo].[ImportSchematExt] ON 
GO
INSERT [dbo].[ImportSchematExt] ([Isc_Id], [Isc_Name], [Isc_Typ], [Isc_Serwer], [Isc_DB], [Isc_User], [Isc_Passwd], [Isc_LoginNt], [Isc_PreQuery], [Isc_AfterQuery], [Isc_ImpTyp], [Isc_ImpRodzaj], [Isc_ImpDDF], [Isc_ImpKnt], [Isc_ImpChangePriceProc], [Isc_ImpPrice], [Isc_ImpMag], [Isc_ImpNagQuery], [Isc_ImpElemQuery], [Isc_ImpNagCond], [Isc_ImpElemCond], [Isc_Agregate], [Isc_Default], [Isc_ImpDokCheckIn], [Isc_FileExt], [Isc_FilesSubDir], [Isc_ImpFpId], [Isc_Rodzaj], [Isc_Kierunek], [Isc_Parm1], [Isc_Parm2], [Isc_Parm3], [Isc_Parm4]) VALUES (40, N'WMS', 1, N'', N'', N'', N'', 0, N'', N'update dbo.ApiWmsDocuments set ErpId = @NewId , StateId=3, OrgDocumentNumber=@NumerPelny  where Id = @OrgId', 0, 0, 44, 0, CAST(0.0000 AS Decimal(15, 4)), 0, N'                    ', N'select * from dbo.ApiImpWmsDocs', N'select * from dbo.ApiWmsDocLines', N'', N'', 0, 0, 0, N'', N'', 0, 40, 0, N'', N'', N'', N'')
GO
INSERT [dbo].[ImportSchematExt] ([Isc_Id], [Isc_Name], [Isc_Typ], [Isc_Serwer], [Isc_DB], [Isc_User], [Isc_Passwd], [Isc_LoginNt], [Isc_PreQuery], [Isc_AfterQuery], [Isc_ImpTyp], [Isc_ImpRodzaj], [Isc_ImpDDF], [Isc_ImpKnt], [Isc_ImpChangePriceProc], [Isc_ImpPrice], [Isc_ImpMag], [Isc_ImpNagQuery], [Isc_ImpElemQuery], [Isc_ImpNagCond], [Isc_ImpElemCond], [Isc_Agregate], [Isc_Default], [Isc_ImpDokCheckIn], [Isc_FileExt], [Isc_FilesSubDir], [Isc_ImpFpId], [Isc_Rodzaj], [Isc_Kierunek], [Isc_Parm1], [Isc_Parm2], [Isc_Parm3], [Isc_Parm4]) VALUES (77, N'Zalaczniki', 1, N'', N'', N'', N'', 0, N'', N'update dbo.ApiUploadeds set ErpId = @NewId , Status=1  where Id = @OrgId', 0, 0, 0, 0, CAST(0.0000 AS Decimal(15, 4)), 0, N'                    ', N'select * from dbo.ApiImpAttachmentsView', N'', N'', N'', 0, 0, 0, N'', N'', 0, 77, 0, N'', N'', N'', N'')
GO
INSERT [dbo].[ImportSchematExt] ([Isc_Id], [Isc_Name], [Isc_Typ], [Isc_Serwer], [Isc_DB], [Isc_User], [Isc_Passwd], [Isc_LoginNt], [Isc_PreQuery], [Isc_AfterQuery], [Isc_ImpTyp], [Isc_ImpRodzaj], [Isc_ImpDDF], [Isc_ImpKnt], [Isc_ImpChangePriceProc], [Isc_ImpPrice], [Isc_ImpMag], [Isc_ImpNagQuery], [Isc_ImpElemQuery], [Isc_ImpNagCond], [Isc_ImpElemCond], [Isc_Agregate], [Isc_Default], [Isc_ImpDokCheckIn], [Isc_FileExt], [Isc_FilesSubDir], [Isc_ImpFpId], [Isc_Rodzaj], [Isc_Kierunek], [Isc_Parm1], [Isc_Parm2], [Isc_Parm3], [Isc_Parm4]) VALUES (1, N'Zadania', 1, N'', N'', N'', N'', 0, N'', N'exec [dbo].[API_TaskAfter] @SyncDbId, @OrgId, @NewId,@Sch_Id;', 0, 0, 0, 0, CAST(0.0000 AS Decimal(15, 4)), 0, N'                    ', N'SELECT * FROM [dbo].[ApiImpTaskView]', N'', N'Modified>=-1 and SaveTS > ISNULL((select MAX(ObjectSaveTS) from dbo.ApiSyncItems si JOIN dbo.ApiSynchronizations s ON s.ID = si.SyncId  and s.SyncType=1  where si.ObjectId = TaskId and si.ObjectType=1),0)', N'', 0, 0, 0, N'', N'', 0, 2, 0, N'', N'', N'', N'')
GO
INSERT [dbo].[ImportSchematExt] ([Isc_Id], [Isc_Name], [Isc_Typ], [Isc_Serwer], [Isc_DB], [Isc_User], [Isc_Passwd], [Isc_LoginNt], [Isc_PreQuery], [Isc_AfterQuery], [Isc_ImpTyp], [Isc_ImpRodzaj], [Isc_ImpDDF], [Isc_ImpKnt], [Isc_ImpChangePriceProc], [Isc_ImpPrice], [Isc_ImpMag], [Isc_ImpNagQuery], [Isc_ImpElemQuery], [Isc_ImpNagCond], [Isc_ImpElemCond], [Isc_Agregate], [Isc_Default], [Isc_ImpDokCheckIn], [Isc_FileExt], [Isc_FilesSubDir], [Isc_ImpFpId], [Isc_Rodzaj], [Isc_Kierunek], [Isc_Parm1], [Isc_Parm2], [Isc_Parm3], [Isc_Parm4]) VALUES (10, N'Dokumenty', 1, N'', N'', N'', N'', 0, N'', N'exec dbo.[API_DocumentAfter] @SyncDbId, @OrgId, @NewId,@Sch_Id;', 0, 0, 0, 0, CAST(0.0000 AS Decimal(15, 4)), 0, N'                    ', N'
	select * from dbo.ApiDocImportView ', N'SELECT * FROM [dbo].[ApiDocLinesImportView] where documentId = @TrnId', N' SaveTS > ISNULL((select MAX(ObjectSaveTS) from dbo.ApiSyncItems si JOIN dbo.ApiSynchronizations s ON s.ID = si.SyncId  and s.SyncType=1  where si.ObjectId = Trn_TrnId and si.ObjectType=0),0)', N'', 0, 0, 0, N'0', N'', 0, 1, 0, N'', N'', N'', N'')
GO
SET IDENTITY_INSERT [dbo].[ImportSchematExt] OFF
GO
