2025-11-21 04:49:15.045 CET [1268] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-21 04:49:15.045 CET [1268] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-21 04:49:15.456 CET [4136] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-21 04:49:15.456 CET [4136] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-21 04:52:38.115 CET [1280] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-21 04:52:38.115 CET [1280] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-21 04:55:19.632 CET [1280] ERROR:  canceling statement due to user request
2025-11-21 04:55:19.632 CET [1280] STATEMENT:  Select * From ltt.StockEvents 
	WHERE userexec LIKE 'JENDRYKES'
	--AND lgstkproc = 'STOCKCHG'
	--AND mainprocess = 'ALGEMEEN'
	--AND handlingtype = 'TU4'
	AND oldlocation LIKE 'X%'
	AND newlocation LIKE 'R%'
	ORDER BY olddt ASC;
2025-11-21 04:56:08.741 CET [572] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-21 04:56:08.741 CET [572] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-21 05:00:52.351 CET [572] ERROR:  canceling statement due to user request
2025-11-21 05:00:52.351 CET [572] STATEMENT:  Select * From ltt.StockEvents 
	WHERE userexec LIKE 'DANIEL%'
	AND lgstkproc = 'STOCKCHG'
	AND mainprocess = 'ALGEMEEN'
	--AND handlingtype = 'TU4'
	AND oldlocation LIKE 'R%'
	AND newlocation LIKE 'X%'
	ORDER BY olddt ASC;
	--LIMIT 1000
	
	
	-----   lgstkproc   -----
	-- DESPATCH
	-- INVENT
	-- NAVUL
	-- ONTVANG
	-- ORDPICK
	-- REALLOC
	-- REVPCK
	-- STOCKCHG - WERK
	-------------------------
	
	----   mainprocess  -----
	-- ALGEMEEN - WERK
	-- DESPATCH
	-- INRUIM
	-- INVENT
	-- NAVUL
	-- ORDPICK
	-- REALLOC
	--------------------------
	
	----   handlingtype  -----
	-- DL1
	-- DV1
	-- FPE
	-- LC1
	-- LP1
	-- MS1
	-- MV1
	-- OP1
	-- OP2
	-- OP5
	-- RC0
	-- RC1
	-- RS1
	-- SNP
	-- SQL
	-- TI1
	-- TO5
	-- TS2
	-- TU2
	-- TU4 - WERK
	-- WV1
	-- XC1
	-- XC2
	-- XC4
	-- XC5
	-- XL2
	-- XL4
	-- XL6
	-- XP2
	-- XP3
	-- XP4
	-- XP5
	-----------------------
	
	---- WERK ----
	-- AND lgstkproc = 'STOCKCHG'
	-- AND mainprocess = 'ALGEMEEN'
	-- AND handlingtype = 'TU4'
	-- AND oldlocation LIKE 'R%'
	-- AND newlocation LIKE 'X%'
	
	
2025-11-21 05:02:45.254 CET [1088] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-21 05:02:45.254 CET [1088] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-21 05:06:54.520 CET [1088] ERROR:  canceling statement due to user request
2025-11-21 05:06:54.520 CET [1088] STATEMENT:  Select * From ltt.StockEvents 
	WHERE userexec = 'JENDRYKES'
	AND lgstkproc = 'STOCKCHG'
	AND mainprocess = 'ALGEMEEN'
	--AND handlingtype = 'TU2'
	AND oldlocation LIKE 'R%'
	AND newlocation LIKE 'X%'
	ORDER BY olddt ASC
	
2025-11-21 05:07:07.803 CET [4612] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-21 05:07:07.803 CET [4612] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-21 05:07:10.176 CET [4612] ERROR:  syntax error at or near "ORDER" at character 211
2025-11-21 05:07:10.176 CET [4612] STATEMENT:  Select * From ltt.StockEvents 
	WHERE userexec = 'JENDRYKES'
	--AND lgstkproc = 'STOCKCHG'
	--AND mainprocess = 'ALGEMEEN'
	--AND handlingtype = 'TU2'
	AND oldlocation LIKE 'R%'
	AND newlocation LIKE 'X%'
	LIMIT 1000
	ORDER BY olddt ASC
	
2025-11-21 05:25:25.602 CET [7120] LOG:  checkpoint starting: time
2025-11-21 05:25:25.901 CET [7120] LOG:  checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.217 s, sync=0.036 s, total=0.300 s; sync files=3, longest=0.019 s, average=0.012 s; distance=12 kB, estimate=18 kB; lsn=7/AA264770, redo lsn=7/AA264718
2025-11-21 06:05:25.913 CET [7120] LOG:  checkpoint starting: time
2025-11-21 06:05:26.307 CET [7120] LOG:  checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.326 s, sync=0.024 s, total=0.395 s; sync files=3, longest=0.009 s, average=0.008 s; distance=20 kB, estimate=20 kB; lsn=7/AA2697E8, redo lsn=7/AA269790
2025-11-21 06:20:25.318 CET [7120] LOG:  checkpoint starting: time
2025-11-21 06:20:25.609 CET [7120] LOG:  checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.221 s, sync=0.024 s, total=0.292 s; sync files=3, longest=0.010 s, average=0.008 s; distance=9 kB, estimate=19 kB; lsn=7/AA26BF48, redo lsn=7/AA26BEF0
2025-11-21 06:34:19.612 CET [572] ERROR:  column "handlingtypem" does not exist at character 69
2025-11-21 06:34:19.612 CET [572] HINT:  Perhaps you meant to reference the column "stockevents.handlingtype".
2025-11-21 06:34:19.612 CET [572] STATEMENT:  Select userexec, olddt, newdt, lgstkproc, mainprocess, restypeexec, handlingtypem, oldlocation, newlocation
	From ltt.StockEvents 
	WHERE 
	userexec = 'JENDRYKES'
	AND olddt > '2025-11-10'
	AND lgstkproc = 'STOCKCHG'
	AND mainprocess = 'ALGEMEEN'
	AND restypeexec = 'HAND'
	AND oldlocation <> newlocation
	--AND handlingtype = 'XP3'
	--AND oldlocation LIKE 'R%'
	--AND newlocation LIKE 'X%'
	--ORDER BY olddt ASC
	LIMIT 1000
	
	
	-----   lgstkproc   -----
	-- DESPATCH
	-- INVENT
	-- NAVUL
	-- ONTVANG
	-- ORDPICK
	-- REALLOC
	-- REVPCK
	-- STOCKCHG - WERK
	-------------------------
	
	----   mainprocess  -----
	-- ALGEMEEN - WERK
	-- DESPATCH
	-- INRUIM
	-- INVENT
	-- NAVUL
	-- ORDPICK
	-- REALLOC
	--------------------------
	
	----   handlingtype  -----
	-- DL1
	-- DV1
	-- FPE
	-- LC1
	-- LP1
	-- MS1
	-- MV1
	-- OP1
	-- OP2
	-- OP5
	-- RC0
	-- RC1
	-- RS1
	-- SNP
	-- SQL
	-- TI1
	-- TO5
	-- TS2
	-- TU2
	-- TU4 - WERK TO PICK LOC
	-- TU5 - WERK TO STOCK LOC
	-- WV1
	-- XC1
	-- XC2
	-- XC4
	-- XC5
	-- XL2
	-- XL4
	-- XL6
	-- XP2
	-- XP3 - WERK TO STOCK LOC
	-- XP4
	-- XP5
	-----------------------
	
	---- WERK ----
	-- AND lgstkproc = 'STOCKCHG'
	-- AND mainprocess = 'ALGEMEEN'
	-- AND handlingtype = 'TU4'
	-- AND restypeexec = 'HAND'
	-- AND oldlocation LIKE 'R%'
	-- AND newlocation LIKE 'X%'
	
	
2025-11-21 06:36:30.707 CET [4324] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-21 06:36:30.707 CET [4324] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-21 07:06:47.007 CET [4136] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-21 07:07:12.161 CET [1268] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-21 08:30:25.740 CET [7120] LOG:  checkpoint starting: time
2025-11-21 08:30:29.835 CET [7120] LOG:  checkpoint complete: wrote 37 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=3.939 s, sync=0.098 s, total=4.096 s; sync files=10, longest=0.017 s, average=0.010 s; distance=225 kB, estimate=225 kB; lsn=7/AA2A4618, redo lsn=7/AA2A45C0
2025-11-21 08:36:40.863 CET [4324] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-21 08:49:37.109 CET [572] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-21 09:02:13.583 CET [4612] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-21 10:55:13.404 CET [1008] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-21 10:55:13.404 CET [1008] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-21 10:55:13.832 CET [6048] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-21 10:55:13.832 CET [6048] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-21 11:06:55.065 CET [1996] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-21 11:06:55.065 CET [1996] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-21 13:04:40.567 CET [6048] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-21 13:07:04.760 CET [1008] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-21 13:08:12.586 CET [1996] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-21 13:15:26.045 CET [7120] LOG:  checkpoint starting: time
2025-11-21 13:15:26.553 CET [7120] LOG:  checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.435 s, sync=0.025 s, total=0.509 s; sync files=3, longest=0.009 s, average=0.009 s; distance=22 kB, estimate=205 kB; lsn=7/AA2AA1F8, redo lsn=7/AA2AA1A0
2025-11-21 15:55:26.700 CET [7120] LOG:  checkpoint starting: time
2025-11-21 15:55:27.203 CET [7120] LOG:  checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.426 s, sync=0.025 s, total=0.504 s; sync files=3, longest=0.009 s, average=0.009 s; distance=25 kB, estimate=187 kB; lsn=7/AA2B08F8, redo lsn=7/AA2B08A0
2025-11-21 21:24:29.314 CET [3336] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-21 21:24:29.314 CET [3336] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-21 21:24:29.790 CET [5540] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-21 21:24:29.790 CET [5540] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-21 22:30:11.261 CET [6452] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-21 22:30:11.261 CET [6452] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-21 22:30:34.177 CET [2232] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-21 22:30:34.177 CET [2232] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-21 22:37:19.009 CET [5540] ERROR:  syntax error at or near "AND" at character 268
2025-11-21 22:37:19.009 CET [5540] STATEMENT:  Select stockeventid, userexec, olddt, newdt, lgstkproc, mainprocess, restypeexec,
	handlingtype, oldlocation, newlocation, newartnr, newqty, resourceexec, collobarcode, picklistid, conr
	From ltt.StockEvents 
	WHERE --oldlocation <> newlocation
	--userexec = 'JENDRYKES'
	AND newdt > '2025-11-17'::date
	AND newdt < '2025-11-18'::date
	
	-- Rivers odkładanie
	-- AND restypeexec = 'HAND' AND mainprocess = 'NAVUL' AND lgstkproc = 'REVPCK' AND handlingtype = 'TU4' -- AND oldlocation LIKE 'R%' AND newlocation LIKE 'X%'
	-- Rivers pikowanie
	 --AND restypeexec = 'HAND' 
	 AND oldartnr='011028' --AND mainprocess = 'NAVUL' AND lgstkproc = 'REVPCK'--  AND handlingtype = 'TS2' -- AND oldlocation LIKE 'R%' AND newlocation LIKE 'X%'
	
	
	--AND mainprocess = 'ALGEMEEN'
	--AND restypeexec = 'HAND'
	--AND oldlocation <> newlocation
	--AND handlingtype = 'TU4'
	--AND oldlocation LIKE 'R%'
	--AND newlocation LIKE 'X%'
	ORDER BY stockeventid DESC
	--LIMIT 1000 718450732
	
	
	-----   lgstkproc   -----
	-- DESPATCH
	-- INVENT
	-- NAVUL
	-- ONTVANG
	-- ORDPICK
	-- REALLOC
	-- REVPCK
	-- STOCKCHG - WERK
	-------------------------
	
	----   mainprocess  -----
	-- ALGEMEEN - WERK
	-- DESPATCH
	-- INRUIM
	-- INVENT
	-- NAVUL
	-- ORDPICK
	-- REALLOC
	--------------------------
	
	----   handlingtype  -----
	-- DL1
	-- DV1
	-- FPE
	-- LC1
	-- LP1
	-- MS1
	-- MV1
	-- OP1
	-- OP2
	-- OP5
	-- RC0
	-- RC1
	-- RS1
	-- SNP
	-- SQL
	-- TI1
	-- TO5
	-- TS2
	-- TU2
	-- TU4 - WERK TO PICK LOC
	-- TU5 - WERK TO STOCK LOC
	-- WV1
	-- XC1
	-- XC2
	-- XC4
	-- XC5
	-- XL2
	-- XL4
	-- XL6
	-- XP2
	-- XP3 - WERK TO STOCK LOC
	-- XP4
	-- XP5
	-----------------------
	
	---- WERK ----
	-- AND lgstkproc = 'STOCKCHG'
	-- AND mainprocess = 'ALGEMEEN'
	-- AND handlingtype = 'TU4'
	-- AND restypeexec = 'HAND'
	-- AND oldlocation LIKE 'R%'
	-- AND newlocation LIKE 'X%'
	
	
2025-11-21 23:03:52.558 CET [1820] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-21 23:03:52.558 CET [1820] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-21 23:03:52.800 CET [4732] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-21 23:03:52.800 CET [4732] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-21 23:03:53.241 CET [4784] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-21 23:03:53.241 CET [4784] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-21 23:03:53.354 CET [4784] ERROR:  syntax error at or near "AND" at character 63
2025-11-21 23:03:53.354 CET [4784] STATEMENT:  Select * From ltt.StockEvents 
	WHERE --userexec = 'JENDRYKES'
	AND lgstkproc = 'REVPCK'
	--AND mainprocess = 'ALGEMEEN'
	--AND handlingtype = 'TU2'
	--AND 
	--oldlocation = 'TAFEL008'
	--AND newlocation LIKE 'X%'
	--conr = 'BK817735722R1'
	ORDER BY newdt ASC
	LIMIT 1000
	
	-- stockeventid
	-- newartnr
	-- newqty
	-- resourceexec
2025-11-21 23:24:39.475 CET [3336] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-21 23:46:38.830 CET [3428] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-21 23:46:38.830 CET [3428] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-21 23:49:41.404 CET [5540] ERROR:  syntax error at or near "restypeexec" at character 1
2025-11-21 23:49:41.404 CET [5540] STATEMENT:  restypeexec
2025-11-21 23:59:21.500 CET [5540] ERROR:  syntax error at or near "newdt" at character 1044
2025-11-21 23:59:21.500 CET [5540] STATEMENT:  Select stockeventid, userexec, olddt, newdt, lgstkproc, mainprocess, restypeexec,
	handlingtype, oldlocation, newlocation, newartnr, newqty, resourceexec, collobarcode, picklistid, conr, contid
	From ltt.StockEvents 
	WHERE --oldlocation <> newlocation
	newdt > '2025-11-17'::date
	AND newdt < '2025-11-18'::date
	--userexec = 'JENDRYKES'
	-- Web picking
	AND restypeexec = 'HAND' AND mainprocess = 'ORDPICK' AND  lgstkproc = 'ORDPICK' AND handlingtype = 'OP2' AND oldlocation is null
	
	
	
	
	-- Rivers pikowanie
	-- AND restypeexec = 'HAND' AND mainprocess = 'NAVUL' AND lgstkproc = 'REVPCK'  AND handlingtype = 'TS2' AND  newlocation <> oldlocation --newlocation LIKE 'R%'
	-- Rivers odkładanie
	-- AND restypeexec = 'HAND' AND mainprocess = 'NAVUL' AND lgstkproc = 'REVPCK' AND handlingtype = 'TU4' AND newlocation LIKE 'X%' AND newlocation NOT LIKE 'XWE%'
	
	
	--AND mainprocess = 'ALGEMEEN'
	--AND restypeexec = 'HAND'
	--AND oldlocation <> newlocation
	--AND handlingtype = 'TU4'
	--AND oldlocation LIKE 'R%'
	--AND newlocation LIKE 'X%'
	ORDER BY userexec ASC newdt asc
	--LIMIT 1000 718450732
	
	
	-----   lgstkproc   -----
	-- DESPATCH
	-- INVENT
	-- NAVUL
	-- ONTVANG
	-- ORDPICK
	-- REALLOC
	-- REVPCK
	-- STOCKCHG - WERK
	-------------------------
	
	----   mainprocess  -----
	-- ALGEMEEN - WERK
	-- DESPATCH
	-- INRUIM
	-- INVENT
	-- NAVUL
	-- ORDPICK
	-- REALLOC
	--------------------------
	
	----   handlingtype  -----
	-- DL1
	-- DV1
	-- FPE
	-- LC1
	-- LP1
	-- MS1
	-- MV1
	-- OP1
	-- OP2
	-- OP5
	-- RC0
	-- RC1
	-- RS1
	-- SNP
	-- SQL
	-- TI1
	-- TO5
	-- TS2
	-- TU2
	-- TU4 - WERK TO PICK LOC
	-- TU5 - WERK TO STOCK LOC
	-- WV1
	-- XC1
	-- XC2
	-- XC4
	-- XC5
	-- XL2
	-- XL4
	-- XL6
	-- XP2
	-- XP3 - WERK TO STOCK LOC
	-- XP4
	-- XP5
	-----------------------
	
	---- WERK ----
	-- AND lgstkproc = 'STOCKCHG'
	-- AND mainprocess = 'ALGEMEEN'
	-- AND handlingtype = 'TU4'
	-- AND restypeexec = 'HAND'
	-- AND oldlocation LIKE 'R%'
	-- AND newlocation LIKE 'X%'