https://ohwiki.b1fox.nl/ 2026-10-29T13:56:56+00:00 https://ohwiki.b1fox.nl/ https://ohwiki.b1fox.nl/lib/exe/fetch.php?media=wiki:dokuwiki.svg text/html 2026-10-29T13:53:18+00:00 rjeggens (rjeggens@undisclosed.example.com) https://ohwiki.b1fox.nl/doku.php?id=wiki:database_triggers&rev=1793281998&do=diff Database triggers Insert timestamp Voorziet elk record van een timestamp op moment van wegschrijven USE [PMXTOGEA] GO /****** Object: Trigger [dbo].[TR_b1f_events_GEA2ERP_InsertTimestamp] Script Date: 29-10-2026 14:50:24 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER TRIGGER [dbo].[TR_b1f_events_GEA2ERP_InsertTimestamp] ON [dbo].[b1f_events_GEA2ERP] AFTER INSERT AS BEGIN SET NOCOUNT ON; UPDATE tgt SET dtTimeStampInsert = GETDATE(), iStatus = 10 FROM… text/html 2026-10-29T13:49:35+00:00 rjeggens (rjeggens@undisclosed.example.com) https://ohwiki.b1fox.nl/doku.php?id=wiki:communicatie_statussen&rev=1793281775&do=diff Statussen iStatus waarden StatusDescription10Nieuw bericht11Op picklistAlleen voor eventtype 2112Op weegorderAlleen voor eventtype 2120Afgehandeld30Mislukt40Afgehandeld na herhaalde poging text/html 2026-10-29T13:46:22+00:00 rjeggens (rjeggens@undisclosed.example.com) https://ohwiki.b1fox.nl/doku.php?id=wiki:communicatie_events&rev=1793281582&do=diff iEventTypeID waarden EventIdBronDescriptionNote 10PMX/GEA Bulk move11 GEA Stort bevesting ingredienten17 PMX IBC op positie18GEA IBC EmptyNu request bulk (31)20 PMX ProductionOrder Start21 GEA ProductionOrder Request26 text/html 2026-10-29T13:33:33+00:00 rjeggens (rjeggens@undisclosed.example.com) https://ohwiki.b1fox.nl/doku.php?id=wiki:welcome&rev=1793280813&do=diff Oliehoorn Factory 2.0 documentatie Gebruikers documentatie Technische documentatie * Database tables * Database triggers * Events * Statussen text/html 2026-10-29T13:32:35+00:00 rjeggens (rjeggens@undisclosed.example.com) https://ohwiki.b1fox.nl/doku.php?id=wiki:database_tables&rev=1793280755&do=diff Stuurtabellen Factory 2.0 b1f_events_GEA2ERP Tabel CREATE TABLE [dbo].[b1f_events_GEA2ERP]( [iID] [int] IDENTITY(1,1) NOT NULL, [iEventTypeID] [int] NULL, [dtTimeStampInsert] [datetime] NULL CONSTRAINT DF_b1f_events_GEA2ERP_dtTimeStampInsert DEFAULT (GETDATE()), [dtTimeStampProcessed] [datetime] NULL, [iStatus] [int] NULL, [iDocEntry] [int] NULL, [iItemCode] [int] NULL, [cItemName] [nvarchar](254) NULL, [nQuantity] [numeric](19, 6) NULL, [iStorLocCode] [int] NULL, [cStorLocName] … text/html 2026-09-02T18:53:27+00:00 Anonymous (anonymous@undisclosed.example.com) https://ohwiki.b1fox.nl/doku.php?image=wiki%3Adokuwiki-128.png&ns=wiki&rev=1788375207&tab_details=history&media_do=diff&do=media <img src="https://ohwiki.b1fox.nl/lib/exe/fetch.php?w=500&amp;h=500&amp;tok=e352ca&amp;media=wiki:dokuwiki-128.png" alt="dokuwiki-128.png" loading="lazy" width="500" height="500" />