MICROS  |  20.04.2026

Aşağıdaki sql ile sistem çalışırken silinebilir. Bdate tarihleri önemlidir. Son 90 gün bırakılarak silinmelidir. Portal gibi ürünlerde bu tablolardan aktarımlar yapılmaktadır.
 
mtr_FMUPosPayments
mtr_RecordHistory
cekdetay
mtr_check
mfd_check_dtl
mfd_check_dly_emp
mfd_check_dly_rvc
mfd_check_ttl
mtr_FiscalRefNo
mtr_chksync
if (select count(*) from sysobjects where type='U' and name='Mtr_FMUPosPayments')>0 then
BEGIN
DECLARE @rowcount BIGINT;
DELETE TOP 2500 "custom"."Mtr_FMUPosPayments" where paymentdate<'2017-09-01';
SET @rowcount = @@ROWCOUNT;
MESSAGE STRING ( @rowcount, ' rows deleted.' ) TO CLIENT;
COMMIT;
WHILE @rowcount > 0 LOOP
DELETE TOP 2500 "custom"."Mtr_FMUPosPayments" where paymentdate<'2017-09-01';
SET @rowcount = @@ROWCOUNT;
MESSAGE STRING ( @rowcount, ' rows deleted.' ) TO CLIENT;
COMMIT;
END LOOP;
MESSAGE STRING ( 'Done.' ) TO CONSOLE;
END;
end if;
if (select count(*) from sysobjects where type='U' and name='Mtr_RecordHistory')>0 then
BEGIN
DECLARE @rowcount BIGINT;
DELETE TOP 2500 "custom"."Mtr_RecordHistory" where businessdate<'2017-09-01';
SET @rowcount = @@ROWCOUNT;
MESSAGE STRING ( @rowcount, ' rows deleted.' ) TO CLIENT;
COMMIT;
WHILE @rowcount > 0 LOOP
DELETE TOP 2500 "custom"."Mtr_RecordHistory" where businessdate<'2017-09-01';
SET @rowcount = @@ROWCOUNT;
MESSAGE STRING ( @rowcount, ' rows deleted.' ) TO CLIENT;
COMMIT;
END LOOP;
MESSAGE STRING ( 'Done.' ) TO CONSOLE;
END;
end if;
if (select count(*) from sysobjects where type='U' and name='cekdetay')>0 then
BEGIN
DECLARE @rowcount BIGINT;
DELETE TOP 2500 "custom"."cekdetay" where bdate<'2017-09-01';
SET @rowcount = @@ROWCOUNT;
MESSAGE STRING ( @rowcount, ' rows deleted.' ) TO CLIENT;
COMMIT;
WHILE @rowcount > 0 LOOP
DELETE TOP 2500 "custom"."cekdetay" where bdate<'2017-09-01';
SET @rowcount = @@ROWCOUNT;
MESSAGE STRING ( @rowcount, ' rows deleted.' ) TO CLIENT;
COMMIT;
END LOOP;
MESSAGE STRING ( 'Done.' ) TO CONSOLE;
END;
end if;
if (select count(*) from sysobjects where type='U' and name='mtr_check')>0 then
BEGIN
DECLARE @rowcount BIGINT;
DELETE TOP 2500 "custom"."mtr_check" where bdate<'2017-09-01';
SET @rowcount = @@ROWCOUNT;
MESSAGE STRING ( @rowcount, ' rows deleted.' ) TO CLIENT;
COMMIT;
WHILE @rowcount > 0 LOOP
DELETE TOP 2500 "custom"."mtr_check" where bdate<'2017-09-01';
SET @rowcount = @@ROWCOUNT;
MESSAGE STRING ( @rowcount, ' rows deleted.' ) TO CLIENT;
COMMIT;
END LOOP;
MESSAGE STRING ( 'Done.' ) TO CONSOLE;
END;
end if;
if (select count(*) from sysobjects where type='U' and name='mfd_check_dtl')>0 then
BEGIN
DECLARE @rowcount BIGINT;
DELETE TOP 2500 "custom"."mfd_check_dtl" where business_date<'2017-09-01';
SET @rowcount = @@ROWCOUNT;
MESSAGE STRING ( @rowcount, ' rows deleted.' ) TO CLIENT;
COMMIT;
WHILE @rowcount > 0 LOOP
DELETE TOP 2500 "custom"."mfd_check_dtl" where business_date<'2017-09-01';
SET @rowcount = @@ROWCOUNT;
MESSAGE STRING ( @rowcount, ' rows deleted.' ) TO CLIENT;
COMMIT;
END LOOP;
MESSAGE STRING ( 'Done.' ) TO CONSOLE;
END;
end if;
if (select count(*) from sysobjects where type='U' and name='mfd_check_dly_emp')>0 then
BEGIN
DECLARE @rowcount BIGINT;
DELETE TOP 2500 "custom"."mfd_check_dly_emp" where business_date<'2017-09-01';
SET @rowcount = @@ROWCOUNT;
MESSAGE STRING ( @rowcount, ' rows deleted.' ) TO CLIENT;
COMMIT;
WHILE @rowcount > 0 LOOP
DELETE TOP 2500 "custom"."mfd_check_dly_emp" where business_date<'2017-09-01';
SET @rowcount = @@ROWCOUNT;
MESSAGE STRING ( @rowcount, ' rows deleted.' ) TO CLIENT;
COMMIT;
END LOOP;
MESSAGE STRING ( 'Done.' ) TO CONSOLE;
END;
end if;
if (select count(*) from sysobjects where type='U' and name='mfd_check_dly_rvc')>0 then
BEGIN
DECLARE @rowcount BIGINT;
DELETE TOP 2500 "custom"."mfd_check_dly_rvc" where business_date<'2017-09-01';
SET @rowcount = @@ROWCOUNT;
MESSAGE STRING ( @rowcount, ' rows deleted.' ) TO CLIENT;
COMMIT;
WHILE @rowcount > 0 LOOP
DELETE TOP 2500 "custom"."mfd_check_dly_rvc" where business_date<'2017-09-01';
SET @rowcount = @@ROWCOUNT;
MESSAGE STRING ( @rowcount, ' rows deleted.' ) TO CLIENT;
COMMIT;
END LOOP;
MESSAGE STRING ( 'Done.' ) TO CONSOLE;
END;
end if;
if (select count(*) from sysobjects where type='U' and name='mfd_check_ttl')>0 then
BEGIN
DECLARE @rowcount BIGINT;
DELETE TOP 2500 "custom"."mfd_check_ttl" where business_date<'2017-09-01';
SET @rowcount = @@ROWCOUNT;
MESSAGE STRING ( @rowcount, ' rows deleted.' ) TO CLIENT;
COMMIT;
WHILE @rowcount > 0 LOOP
DELETE TOP 2500 "custom"."mfd_check_ttl" where business_date<'2017-09-01';
SET @rowcount = @@ROWCOUNT;
MESSAGE STRING ( @rowcount, ' rows deleted.' ) TO CLIENT;
COMMIT;
END LOOP;
MESSAGE STRING ( 'Done.' ) TO CONSOLE;
END;
end if;
if (select count(*) from sysobjects where type='U' and name='mtr_chksync')>0 then
BEGIN
DECLARE @rowcount BIGINT;
DELETE TOP 2500 "custom"."mtr_chksync" where createdon<'2017-09-01';
SET @rowcount = @@ROWCOUNT;
MESSAGE STRING ( @rowcount, ' rows deleted.' ) TO CLIENT;
COMMIT;
WHILE @rowcount > 0 LOOP
DELETE TOP 2500 "custom"."mtr_chksync" where createdon<'2017-09-01';
SET @rowcount = @@ROWCOUNT;
MESSAGE STRING ( @rowcount, ' rows deleted.' ) TO CLIENT;
COMMIT;
END LOOP;
MESSAGE STRING ( 'Done.' ) TO CONSOLE;
END;
end if;
if (select count(*) from sysobjects where type='U' and name='mtr_FiscalRefNo')>0 then
BEGIN
DECLARE @rowcount BIGINT;
DELETE TOP 2500 "custom"."mtr_FiscalRefNo" where createdon<'2017-09-01';
SET @rowcount = @@ROWCOUNT;
MESSAGE STRING ( @rowcount, ' rows deleted.' ) TO CLIENT;
COMMIT;
WHILE @rowcount > 0 LOOP
DELETE TOP 2500 "custom"."mtr_FiscalRefNo" where createdon<'2017-09-01';
SET @rowcount = @@ROWCOUNT;
MESSAGE STRING ( @rowcount, ' rows deleted.' ) TO CLIENT;
COMMIT;
END LOOP;
MESSAGE STRING ( 'Done.' ) TO CONSOLE;
END;
end if;